Re: [GENERAL] Re: Inserts in triggers Follow Up

Поиск
Список
Период
Сортировка
От Jan Wieck
Тема Re: [GENERAL] Re: Inserts in triggers Follow Up
Дата
Msg-id 200107301426.f6UEQpM06972@jupiter.us.greatbridge.com
обсуждение исходный текст
Ответ на Re: Inserts in triggers Follow Up  (Morgan Curley <mcurley@e4media.com>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Date Time Functions - ANSI SQL ?
Следующее
От: "Chris Ruprecht"
Дата:
Сообщение: Big table - using wrong index - why?