Re: Possible pl/pgsql bug - Mailing list pgsql-general

From Jan Wieck
Subject Re: Possible pl/pgsql bug
Date
Msg-id 200204222023.g3MKNS909976@saturn.janwieck.net
Whole thread Raw
In response to Possible pl/pgsql bug  ("Peter Darley" <pdarley@kinesis-cem.com>)
Responses Re: Possible pl/pgsql bug  ("Peter Darley" <pdarley@kinesis-cem.com>)
List pgsql-general
Peter Darley wrote:
> Friends,
>    I don't know if this is a bug or not, but it does seem a bit weird.
>
>    When I have a pl/pgsql trigger function it seems to cache the data types of

    Indeed, it does.

    While  it  sometimes  does make sense to use one and the same
    function for multiple triggers, I don't see it in this  case.

    And IMHO it's a bit bogus anyway if attributes with different
    meaning and datatype in two tables have the same name.  Could
    be irritating at least.

    I suggest writing separate trigger functions.


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #



pgsql-general by date:

Previous
From: Lamar Owen
Date:
Subject: Re: Which OS better for postgresql? FreeBSD or Linux?
Next
From: "Peter Darley"
Date:
Subject: Re: Possible pl/pgsql bug