Обсуждение: Patch for catching incompatible types in fk constraints
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.
Вложения
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: > 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.
> > 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