Thread: Updated CHECK failed message patch

Updated CHECK failed message patch

From
Christopher Kings-Lynne
Date:
Please use this patch instead of my previously submitted one.

It is just remerged against HEAD for new alter_table.out stuff.

Another reason this patch is useful for _interactive_ users: imagine a
view based on a many way join.  Imagine creating a complicated insert rule
that inserts into all the joined tables and when you insert you get a
check failure, but you need to know which actual table the constraint was
on that failed!

Chris


Attachment

Re: Updated CHECK failed message patch

From
Bruce Momjian
Date:
Your patch has been added to the PostgreSQL unapplied patches list at:

    http://candle.pha.pa.us/cgi-bin/pgpatches

I will try to apply it within the next 48 hours.

---------------------------------------------------------------------------


Christopher Kings-Lynne wrote:
> Please use this patch instead of my previously submitted one.
>
> It is just remerged against HEAD for new alter_table.out stuff.
>
> Another reason this patch is useful for _interactive_ users: imagine a
> view based on a many way join.  Imagine creating a complicated insert rule
> that inserts into all the joined tables and when you insert you get a
> check failure, but you need to know which actual table the constraint was
> on that failed!
>
> Chris
>

Content-Description:

[ Attachment, skipping... ]

>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org

--
  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: Updated CHECK failed message patch

From
Bruce Momjian
Date:
[ Previous one reversed out.]

Patch applied.  Thanks.

---------------------------------------------------------------------------


Christopher Kings-Lynne wrote:
> Please use this patch instead of my previously submitted one.
>
> It is just remerged against HEAD for new alter_table.out stuff.
>
> Another reason this patch is useful for _interactive_ users: imagine a
> view based on a many way join.  Imagine creating a complicated insert rule
> that inserts into all the joined tables and when you insert you get a
> check failure, but you need to know which actual table the constraint was
> on that failed!
>
> Chris
>

Content-Description:

[ Attachment, skipping... ]

>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org

--
  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