Re: query fine in psql/pgAdmin III but error message when within plpgsql function

From: Jan-Peter(dot)Seifert(at)gmx(dot)de
To: "Jan-Peter Seifert" <Jan-Peter(dot)Seifert(at)gmx(dot)de>, pgsql-admin(at)postgresql(dot)org
Subject: Re: query fine in psql/pgAdmin III but error message when within plpgsql function
Date: 2010-08-20 09:27:18
Message-ID: 20100820092718.243470@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Ouch. My mistake. :(

The copy had of course duplicate data sets, because I trapped errors during its creation and because of the missing 'WHERE 1=0'.

Sorry,

Peter
--
GMX DSL SOMMER-SPECIAL: Surf & Phone Flat 16.000 für nur 19,99 ¿/mtl.!*
http://portal.gmx.net/de/go/dsl

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Lou Picciano 2010-08-20 12:46:42 Couple of admin Qs
Previous Message Jan-Peter Seifert 2010-08-20 08:44:33 query fine in psql/pgAdmin III but error message when within plpgsql function