Here is a patch regarding ALTER TABLE ... OWNER and the sequences that
were created by a SERIAL column.
It uses pg_depend to find SERIAL sequences, and recurses the ChangeOwner
to them. Additionally, it forbids directly changing the owner of a
SERIAL sequence (the error message of this last action needs to be
I also added some regression tests for ALTER TABLE ... OWNER, because
previously there wasn't any.
According to my testing, this fixes the issue with pg_dump not restoring
the ownership of SERIAL sequences and the annoyance of having to alter
the sequence manually (the principle of least surprise indicates that
the sequence should be altered automatically).
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"Now I have my system running, not a byte was off the shelf;
It rarely breaks and when it does I fix the code myself.
It's stable, clean and elegant, and lightning fast as well,
And it doesn't cost a nickel, so Bill Gates can go to hell."
pgsql-patches by date
|Next:||From: Andrew Dunstan||Date: 2004-09-22 21:38:48|
|Subject: Re: pg_hba.conf additional comment re local line|
|Previous:||From: Tom Lane||Date: 2004-09-22 19:00:35|
|Subject: Re: [PERFORM] 7.4 vs 7.3 ( hash join issue ) |