"Joshua D. Drake" <jd(at)commandprompt(dot)com> writes:
> However if you do the following:

> create table foo (foo serial not null, bar text);
> create sequence foo_seq;
> alter table foo alter column foo set default nextval('foo_seq');

This is flat out pilot error: you do not get to mess with the default
expression of a SERIAL column, because it's part of the internal
implementation of the SERIAL pseudo-type.  If I were going to do
anything about it, I'd patch ALTER TABLE to refuse the above command.

			regards, tom lane

In response to

• pg_dump bug in 7.3.9 with sequences at 2005-02-02 20:01:11 from Joshua D. Drake

Responses

• Re: pg_dump bug in 7.3.9 with sequences at 2005-02-02 21:54:48 from Joshua D. Drake

pgsql-hackers by date

Next:	From: Merlin Moncure	Date: 2005-02-02 21:30:52
	Subject: Re: [NOVICE] Last ID Problem
Previous:	From: G u i d o B a r o s i o	Date: 2005-02-02 21:18:40
	Subject: fatal: cache id 30 (or alike)