On Mon, Apr 18, 2005 at 11:55:44PM -0400, Bruce Momjian wrote: > > Thanks, fixed.
Could you apply this to the 8.0 docs, too? The exception handling works in 8.0, and I know at least two places where it's in production :) Cheers, D > > --------------------------------------------------------------------------- > > Christopher Kings-Lynne wrote: > > Is that broken? > > > > http://momjian.postgresql.org/main/writings/pgsql/sgml/build.html > > > > Chris > > > > Bruce Momjian wrote: > > > Patch applied. Thanks. Sorry for the delay in applying. > > > > > > --------------------------------------------------------------------------- > > > > > > > > > David Fetter wrote: > > > > > >>On Tue, Mar 08, 2005 at 12:27:21PM +0800, Christopher Kings-Lynne wrote: > > >> > > >>>>Luckily, PG 8 is available for this. Do you have a short example? > > >>> > > >>>No, and I think it should be in the manual as an example. > > >>> > > >>>You will need to enter a loop that uses exception handling to detect > > >>>unique_violation. > > >> > > >>Pursuant to an IRC discussion to which Dennis Bjorklund and > > >>Christopher Kings-Lynne made most of the contributions, please find > > >>enclosed an example patch demonstrating an UPSERT-like capability. > > >> > > >>Cheers, > > >>D > > >>-- > > >>David Fetter [EMAIL PROTECTED] http://fetter.org/ > > >>phone: +1 510 893 6100 mobile: +1 415 235 3778 > > >> > > >>Remember to vote! > > > > > > > > > [ Attachment, skipping... ] > > > > > > > > >>---------------------------(end of broadcast)--------------------------- > > >>TIP 9: the planner will ignore your desire to choose an index scan if your > > >> joining column's datatypes do not match > > > > > > > > > > -- > Bruce Momjian | http://candle.pha.pa.us > pgman@candle.pha.pa.us | (610) 359-1001 > + If your life is a hard drive, | 13 Roberts Road > + Christ can be your backup. | Newtown Square, Pennsylvania 19073 > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778 Remember to vote! ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster