| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Zoltan Boszormenyi <zb(at)cybertec(dot)at> |
| Cc: | Bruce Momjian <bruce(at)momjian(dot)us>, pgsql-patches(at)postgresql(dot)org |
| Subject: | Re: IDENTITY/GENERATED v36 Re: Final version of IDENTITY/GENERATED patch |
| Date: | 2007-04-05 04:39:22 |
| Message-ID: | 18616.1175747962@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-patches |
Zoltan Boszormenyi <zb(at)cybertec(dot)at> writes:
> Tom Lane rta:
>> Zoltan Boszormenyi <zb(at)cybertec(dot)at> 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2007-04-05 05:16:38 | Re: Modifying TOAST thresholds |
| Previous Message | Zoltan Boszormenyi | 2007-04-05 04:20:00 | Re: IDENTITY/GENERATED v36 Re: Final version of IDENTITY/GENERATED patch |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Martijn van Oosterhout | 2007-04-05 08:10:29 | Re: Auto Partitioning |
| Previous Message | Zoltan Boszormenyi | 2007-04-05 04:20:00 | Re: IDENTITY/GENERATED v36 Re: Final version of IDENTITY/GENERATED patch |