Zoltan Boszormenyi <zb@cybertec.at> writes:
> Tom Lane �rta:
>>> The latter would treat GENERATED BY DEFAULT AS IDENTITY
>>> the same as SERIAL.
>> Is there any good reason to distinguish the two?
> Yes. Plain SERIALs can be updated with given values
> whereas IDENTITY columns cannot.
Really? How is pg_dump going to deal with that?
regards, tom lane
