From: | David Fetter <david(at)fetter(dot)org> |
---|---|
To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
Cc: | PostgreSQL Patches <pgsql-patches(at)postgresql(dot)org> |
Subject: | Re: [HACKERS] Best practices: MERGE |
Date: | 2005-10-04 16:41:03 |
Message-ID: | 20051004164103.GC11397@fetter.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
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 david(at)fetter(dot)org 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(at)candle(dot)pha(dot)pa(dot)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 david(at)fetter(dot)org http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778
Remember to vote!
From | Date | Subject | |
---|---|---|---|
Next Message | mark | 2005-10-04 17:02:53 | Re: [PERFORM] A Better External Sort? |
Previous Message | Zeugswetter Andreas DAZ SD | 2005-10-04 16:16:21 | Re: Inherited indexes. |
From | Date | Subject | |
---|---|---|---|
Next Message | Jim C. Nasby | 2005-10-04 16:42:52 | Re: BUG #1927: incorrect timestamp returned |
Previous Message | Bruce Momjian | 2005-10-04 15:47:37 | Re: BUG #1927: incorrect timestamp returned |