Thanks everyone for your replies.
In my original post I failed to EXACTLY reproduce the problem, in that capital
letters were involved which I left out of the description.
For example, the id had been set up as "ID" serial primary key, and the
sequencer was consequently named 'mytable_ID_seq' n
"Fred Parkinson" 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 whi
"Fred Parkinson" wrote:
> 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.
It works for me. Can you provide a small self-contained test case
which d
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.
Has something si
