Обсуждение: Patch for catching incompatible types in fk constraints

Поиск
Список
Период
Сортировка

Patch for catching incompatible types in fk constraints

От
Stephan Szabo
Дата:
    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.

Вложения

Re: Patch for catching incompatible types in fk constraints

От
Tom Lane
Дата:
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

Re: Patch for catching incompatible types in fk constraints

От
Stephan Szabo
Дата:
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.


Re: Patch for catching incompatible types in fk constraints

От
Bruce Momjian
Дата:
>
> 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

Re: Patch for catching incompatible types in fk constraints

От
Bruce Momjian
Дата:
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