Re: Use of Serial Datatype and Sequence Issue

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Keary Suska <hierophant(at)pcisys(dot)net>
Cc: Mart=?ISO-8859-1?B?7W4gTWFycXXp?=s <martin(at)bugs(dot)unl(dot)edu(dot)ar>, pgsql-general(at)postgresql(dot)org
Subject: Re: Use of Serial Datatype and Sequence Issue
Date: 2001-11-06 18:54:09
Message-ID: 17182.1005072849@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers pgsql-general

Keary Suska <hierophant(at)pcisys(dot)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

In response to

Responses

Browse pgadmin-hackers by date

  From Date Subject
Next Message Keary Suska 2001-11-06 21:01:14 Re: Use of Serial Datatype and Sequence Issue
Previous Message Dave Page 2001-11-06 08:17:05 Re: [GENERAL] Use of Serial Datatype and Sequen

Browse pgsql-general by date

  From Date Subject
Next Message Jason Earl 2001-11-06 18:55:30 Re: data integrity
Previous Message Culley Harrelson 2001-11-06 18:51:46 Re: Drop column and multiple db query