Re: Can't query the sequence table of a serial primary key.

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' not 'mytable_id_seq' (he was stabbed to death by details!)
When I ran the select statement I DID reproduce the capital letters as they existed, but got the error I described.

In the effort to create a test sample I left out all caps and made everything lower case.

Viola! The problem disappeared! Sanity restored (for now).

That's it, no more caps for me!

Thanks again for everyone's efforts to help.

Fred

>>> "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> 02/23/2012 11:34 AM >>>
"Fred Parkinson" <FredP(at)abag(dot)ca(dot)gov> 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 demonstrates the problem?

Hopefully you are aware of these functions, which might be easier:

http://www.postgresql.org/docs/8.4/interactive/functions-sequence.html

-Kevin