Postgres Pro
Downloads
Home   >   mailing lists

Re: Can't query the sequence table of a serial primary key. - Mailing list pgsql-admin

From Kevin Grittner
Subject Re: Can't query the sequence table of a serial primary key.
Date
Msg-id 4F4640810200002500045AD6@gw.wicourts.gov
Whole thread Raw
In response to Can't query the sequence table of a serial primary key.  ("Fred Parkinson" <FredP@abag.ca.gov>)
Responses Re: Can't query the sequence table of a serial primary key.
List pgsql-admin
Tree view 
"Fred Parkinson" <FredP@abag.ca.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

pgsql-admin by date:

Previous
From: "Fred Parkinson"
Date:
Subject: Can't query the sequence table of a serial primary key.
Next
From: Tom Lane
Date:
Subject: Re: Can't query the sequence table of a serial primary key.