"Fred Parkinson" <FredP@xxxxxxxxxxx> writes: > We have moved some databases from 7.x to 8.4 > Previously I could query the sequencing table of a 'serial primary key' by simply running > select * from mytable_id_seq; > where mytable has id as a serial primary key and mytable_id_seq is the postgresql relation which manages the key. That naming relationship isn't guaranteed, and AFAIR it wasn't guaranteed in 7.4 either; in case of name collision you'd get something like mytable_id_seq1 instead. > When I do \d I see the table and the sequencer under 'List of relations'. > But when I run select * from mytable_id_seq; postgresql responds with: > relation 'mytable_id_seq' does not exist. Maybe the sequence is in a schema that's not in your search_path. regards, tom lane -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
