pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Simon Riggs <simon@2ndquadrant.com>
Cc: Stephan Szabo <sszabo@megazone.bigpanda.com>
Cc: Karim Nassar <karim.nassar@NAU.EDU>
Cc: Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Cc: pgsql-performance@postgresql.org
Subject: Re: Delete query takes exorbitant amount of time
Date: Fri, 25 Mar 2005 13:47:22 -0500
Message-ID: <28057.1111776442@sss.pgh.pa.us> (raw)
In-Reply-To: <1111775050.11750.790.camel@localhost.localdomain>
References: <1111709457.9085.127.camel@k2.cet.nau.edu>
	<2630.1111711927@sss.pgh.pa.us>
	<1111715131.9085.174.camel@k2.cet.nau.edu>
	<3750.1111715318@sss.pgh.pa.us>
	<4243879B.10200@familyhealth.com.au>
	<20845.1111733900@sss.pgh.pa.us>
	<1111763448.11750.730.camel@localhost.localdomain>
	<23515.1111763837@sss.pgh.pa.us>
	<1111766478.11750.762.camel@localhost.localdomain>
	<20050325082101.G4358@megazone.bigpanda.com>
	<1111775050.11750.790.camel@localhost.localdomain>

Simon Riggs <simon@2ndquadrant.com> writes:
> On Fri, 2005-03-25 at 10:17 -0500, Tom Lane wrote:
>>> Other than spec compliance, you mean?  SQL99 says
>>> 
>>> ... The declared type of each referencing column shall be
>>> comparable to the declared type of the corresponding referenced
>>> column.

> Tom had said SQL99 required this; I have pointed out SQL:2003, which
> supercedes the SQL99 standard, does not require this.

You're reading the wrong part of SQL:2003.  11.8 <referential constraint
definition> syntax rule 9 still has the text I quoted.

> Leading us back to my original point - what is the benefit of continuing
> with having a WARNING when that leads people into trouble later?

Accepting spec-compliant schemas.

			regards, tom lane

view thread (60+ messages)  latest in thread

Message-ID: <28057.1111776442@sss.pgh.pa.us>
Permalink:  ../28057.1111776442@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/28057.1111776442@sss.pgh.pa.us

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: tgl@sss.pgh.pa.us, simon@2ndquadrant.com, sszabo@megazone.bigpanda.com, karim.nassar@NAU.EDU, chriskl@familyhealth.com.au
  Subject: Re: Delete query takes exorbitant amount of time
  In-Reply-To: <28057.1111776442@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox