ALTER SEQUENCE OWNED BY worked!
Thanks folks.
jeff.
On 26-Nov-08, at 1:04 PM, Alvaro Herrera wrote:
Jeff MacDonald wrote:
Hi Tom, so far as I know the table "owns" the serial in so much as
when i
do a \d of the table it says this
status_id | integer | not null default
nextval('status_status_id_seq'::regclass)
How else can I check?
He means ALTER SEQUENCE ... OWNED BY
I don't know how you can ensure that it is, short of
begin;
drop table status;
\d status_status_id_seq
-- verify that the sequence exists; if owned, it should have been
dropped too
rollback;
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
