> -----Original Message-----
> From: Hannu Krosing [mailto:hannu@tm.ee]
> Sent: 20 January 2003 18:05
> To: Dave Page
> Cc: Tom Lane; PostgreSQL Hackers Mailing List; Didier Moens
> Subject: Re: [HACKERS] Foreign key wierdness
>
>
> > I've been looking at his for some time now (couple of weeks
> or more),
> > and the only thing I can find is the SELECT ... FOR UPDATE in the
> > PostgreSQL logs that I quoted.
>
> does this SELECT ... FOR UPDATE occur only when schemas are used ?
No, in both case, just significantly more slowly with schema
qualification. Note that the qualification is added to the ALTER TABLE
statement though - PostgreSQL's qualifying the name in the SELECT for
every case.
Regards, Dave.