:46 PM
To: Hyatt, Gordon
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] plpgsql question/problem
On 8/13/07, Hyatt, Gordon [EMAIL PROTECTED] wrote:
I'm not sure if this is the correct list for this question, but I'll give it
a shot anyway. (If this is not the correct list, please suggest
I've found the problem - I didn't see a misplaced/extra quote_literal.
My bad!
Thanks for the help.
Gord
-Original Message-
From: Hyatt, Gordon
Sent: Tuesday, August 14, 2007 9:18 AM
To: pgsql-admin@postgresql.org
Subject: RE: [ADMIN] plpgsql question/problem
Scott and Tom,
Thanks
On 8/14/07, Hyatt, Gordon [EMAIL PROTECTED] wrote:
Scott and Tom,
Thanks for your replies. Yes, the missing select keyword was simply a typo
on my part.
The code that I sent was simplified (I didn't include all the fields, most of
which are character varying). I've spent all day
I'm not sure if this is the correct list for this question, but I'll give it a
shot anyway. (If this is not the correct list, please suggest the correct one.)
I've written a number of plpgsql functions to convert a database from MS Access
into Postgres (v8.2.4 on Windows 2000 SP4) and have
Scott Marlowe [EMAIL PROTECTED] writes:
On 8/13/07, Hyatt, Gordon [EMAIL PROTECTED] wrote:
When I attempt to run insert_a_and_b, insert_b fails with a foreign key
violation.
I ran your exact same code and it worked fine. Note that I changed one line:
Works for me too (with Scott's