Re: Use of Serial Datatype and Sequence Issue - Mailing list pgsql-general

From Tom Lane
Subject Re: Use of Serial Datatype and Sequence Issue
Date
Msg-id 17182.1005072849@sss.pgh.pa.us
Whole thread Raw
In response to Re: Use of Serial Datatype and Sequence Issue  (Keary Suska <hierophant@pcisys.net>)
Responses Re: Use of Serial Datatype and Sequence Issue  (Keary Suska <hierophant@pcisys.net>)
List pgsql-general
Keary Suska <hierophant@pcisys.net> writes:
> The bug is that CREATE staements are issued as well as SELECT nextval()
> which readies the sequence.

What version are you running?  I see no such behavior in either 7.1.3 or
current sources: pg_dump -a produces only

SELECT setval ('"foo_f2_seq"', 2, 't');

No sign of a CREATE SEQUENCE.

            regards, tom lane

pgsql-general by date:

Previous
From: "Culley Harrelson"
Date:
Subject: Re: Drop column and multiple db query
Next
From: Jason Earl
Date:
Subject: Re: data integrity