Re: pg_dump + serial + sequence problem

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" <luiz(at)planit(dot)com(dot)br> 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.