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@fetter.org http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778

Remember to vote!


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

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@fetter.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@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 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Is that broken?

http://momjian.postgresql.org/main/w...gml/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@fetter.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
>
>

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

Thanks, fixed.

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

Christopher Kings-Lynne wrote:
> Is that broken?
>
> http://momjian.postgresql.org/main/w...gml/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@fetter.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@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

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/w...gml/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@fetter.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@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 david@fetter.org 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

On Tue, 2005-04-10 at 09:41 -0700, David Fetter wrote:
> Could you apply this to the 8.0 docs, too?

Applied, with fixes.

-Neil



---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly