Skip site navigation (1) Skip section navigation (2)

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

From: "Fred Parkinson" <FredP(at)abag(dot)ca(dot)gov>
To: <pgsql-admin(at)postgresql(dot)org>, "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
Subject: Re: Can't query the sequence table of a serial primary key.
Date: 2012-02-23 20:22:52
Message-ID: 4F462F9C020000A70001B6C7@gwia1.abag.ca.gov (view raw or flat)
Thread:
Lists: pgsql-admin
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

In response to

pgsql-admin by date

Next:From: Lutz SteinbornDate: 2012-02-24 13:54:57
Subject: logfile per DataBase
Previous:From: Tom LaneDate: 2012-02-23 19:35:23
Subject: Re: Can't query the sequence table of a serial primary key.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group