

> -----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.

Mon, 20 Jan 2003 17:04:41 -0000
"Dave Page" <dpage@vale-housing.co.uk>
Re: Foreign key wierdness