pg_get_serial_sequence() does dequoting/downcasing on its relation-name argument, but not on its column-name argument.
regression=# create table "FOO" ("Ff1" serial);
NOTICE: CREATE TABLE will create implicit sequence "FOO_Ff1_seq" for serial column "FOO.Ff1"
CREATE TABLE
regression=# select pg_get_serial_sequence('FOO','Ff1');
ERROR: column "Ff1" of relation "foo" does not exist
regression=# select pg_get_serial_sequence('"FOO"','Ff1');
pg_get_serial_sequence ------------------------
public."FOO_Ff1_seq"
(1 row)
I presume the reason for that is that the first paramater can be qualified:
select pg_get_serial_sequence('"public"."FOO"', 'Ff1');Chris
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
