Index: openacs-4/packages/acs-kernel/sql/postgresql/utilities-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/utilities-create.sql,v diff -u -r1.13.2.4 -r1.13.2.5 --- openacs-4/packages/acs-kernel/sql/postgresql/utilities-create.sql 23 Feb 2022 18:24:53 -0000 1.13.2.4 +++ openacs-4/packages/acs-kernel/sql/postgresql/utilities-create.sql 20 Aug 2024 13:38:16 -0000 1.13.2.5 @@ -339,13 +339,13 @@ -- select define_function_args('util__get_primary_keys','table_name'); -CREATE OR REPLACE FUNCTION util__get_primary_keys(text) +CREATE OR REPLACE FUNCTION util__get_primary_keys(table_name text) RETURNS SETOF pg_attribute.attname%TYPE AS $$ SELECT a.attname FROM pg_index i JOIN pg_attribute a ON a.attrelid = i.indrelid AND a.attnum = ANY(i.indkey) - WHERE i.indrelid = $1::regclass + WHERE i.indrelid = table_name::regclass AND i.indisprimary; $$ LANGUAGE sql;