Hi, Tom
Thanks for reply
I understood, that this isn't so critical, but may causes surprises, so
I reported for someone pay atention that this can occur.
By the way I try to drop the sequence, but I can't because they still
owned by the column. So I can't be able to remove this
reference without drop de column and recreate it.
Tom Lane wrote:
"Luiz K. Matsumura" <[EMAIL PROTECTED]> writes:
CREATE TABLE teste
(
id serial,
...
ALTER TABLE teste ALTER COLUMN id DROP DEFAULT;
This isn't supported before 8.2, since as you found out pg_dump is
unable to reproduce the situation in the database --- the sequence is
still marked as "owned by" the column even though there's no default
anymore. We aren't going to try to fix that behavior in the older
branches.
regards, tom lane
--
Luiz K. Matsumura
Plan IT Tecnologia Informática Ltda.
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
