"Jeroen Ruigrok/asmodai" <asmodai@wxs.nl> wrote:
> -On [20030911 15:43], Tom Lane (tgl@sss.pgh.pa.us) wrote:
> >We can't ALTER a table that's already in use when the first ALTER
> >starts, either --- its attempt to exclusive-lock the table will fail.
> >But once you get the exclusive lock, you can (in Postgres) perform
> >a series of operations without fear that subsequently-started
> >transactions will be able to see the incompletely changed state of the
> >table. Evidently Oracle can't handle that. That's why they need to
> >invent combination operations like MODIFY CONSTRAINT.
>
> As my colleague says:
>
> it is indeed a lazy choice, but super safe and that's the goal.
Does your colleague know the Aesops's Fables: "The fox and the Grapes" ?
Regards
Gaetano Mendola