Re: [GENERAL] Re: Inserts in triggers Follow Up - Mailing list pgsql-sql

From Jan Wieck
Subject Re: [GENERAL] Re: Inserts in triggers Follow Up
Date
Msg-id 200107301426.f6UEQpM06972@jupiter.us.greatbridge.com
Whole thread Raw
In response to Re: Inserts in triggers Follow Up  (Morgan Curley <mcurley@e4media.com>)
List 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@Yahoo.com #



_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com


pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Date Time Functions - ANSI SQL ?
Next
From: "Chris Ruprecht"
Date:
Subject: Big table - using wrong index - why?