Zoltan Boszormenyi <[EMAIL PROTECTED]> writes: > Tom Lane írta: >> Zoltan Boszormenyi <[EMAIL PROTECTED]> writes: >>> Yes. Plain SERIALs can be updated with given values >>> whereas IDENTITY columns cannot. >> >> Really? How is pg_dump going to deal with that?
> It emits ALTER TABLE ... SET GENERATED AS IDENTITY > after ALTER SEQUENCE OWNED BY and if any of the > columns is IDENTITY or GENERATED then it emits > COPY OVERRIDING SYSTEM VALUE in my patch already. And you fail to see the irony in that? You might as well just admit that it's OK to update an identity column. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly