Thread: Re: [HACKERS] Best practices: MERGE
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
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
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@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 > >
Thanks, fixed. --------------------------------------------------------------------------- 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@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
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@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!
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