Re: Re: Inserts in triggers Follow Up

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

In response to

Browse pgsql-general by date

  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

Browse pgsql-sql by date

  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 ?