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