Patch for catching incompatible types in fk constraints

Stephan Szabo <sszabo@megazone23.bigpanda.com> writes:

This patch should catch cases where the types
in referencing and referenced columns of an fk constraint
aren't comparable using '=' at constraint definition time
rather than insert/update time.

Are you intending this to go into 7.1.1 or 7.2?

It seems a bit large for a 7.1.1 patch, given the lack of testing
that we're likely to get for 7.1.1.

regards, tom lane

I was assuming 7.2, but I've been afraid
of losing it again (already had one computer
lose power supply eating my last version of
the patch) so I figured I'd send it.

On Sun, 15 Apr 2001, Tom Lane wrote:

I was assuming 7.2, but I've been afraid
of losing it again (already had one computer
lose power supply eating my last version of
the patch) so I figured I'd send it.

I will put it on the outstanding patches page. Can't get lost there.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Applied. Thanks.

This patch should catch cases where the types
in referencing and referenced columns of an fk constraint
aren't comparable using '=' at constraint definition time
rather than insert/update time.

Content-Description:

[ Attachment, skipping... ]

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

http://www.postgresql.org/search.mpl

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026