From: | Jan Wieck <JanWieck(at)Yahoo(dot)com> |
---|---|
To: | Morgan Curley <mcurley(at)e4media(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Re: Inserts in triggers Follow Up |
Date: | 2001-07-30 14:26:51 |
Message-ID: | 200107301426.f6UEQpM06972@jupiter.us.greatbridge.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-sql |
Morgan Curley wrote:
> Well, I couldn't figure out why my INSERT INTO wasn't working so I went
> with using EXECUTE and concat'ing everything together.
The problem was that your local variable names where
identical to column names used in the tables. That confuses
the PL/pgSQL query engine. Tom pointed that out already,
maybe not clear enough.
Jan
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck(at)Yahoo(dot)com #
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
From | Date | Subject | |
---|---|---|---|
Next Message | Kapil Tilwani | 2001-07-30 14:30:58 | |
Previous Message | tony | 2001-07-30 14:23:24 | referential integrity violation |
From | Date | Subject | |
---|---|---|---|
Next Message | Chris Ruprecht | 2001-07-30 16:20:51 | Big table - using wrong index - why? |
Previous Message | Tom Lane | 2001-07-30 05:39:25 | Re: Date Time Functions - ANSI SQL ? |