On Wed, 6 Aug 2003, Tom Lane wrote:

> Sebastien Lemieux <[EMAIL PROTECTED]> writes:
> > All the time is taken at the commit of both transaction.
> Sounds like the culprit is foreign-key checks.
> One obvious question is whether you have your foreign keys set up
> efficiently in the first place.  As a rule, the referenced and
> referencing columns should have identical datatypes and both should
> be indexed.  (PG will often let you create foreign key constraints
> that don't meet these rules ... but performance will suffer.)

Is this one of those things that should spit out a NOTICE when it happens? 
I.e. when a table is created with a references and uses a different type 
than the parent, would it be a good idea to issue a "NOTICE: parent and 
child fields are not of the same type"

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?


Reply via email to