Re: Acessing columns of parent tables with PL/pgSQL

On Thursday 27 June 2002 15:38, Hans-Juergen Schoenig wrote:
> I wonder if there is a way to access columns in a parent table when
> running a PL/pgSQL trigger.
>
> Here is an example:
>
>
> CREATE TABLE a (
>          one     text
> );
>
> CREATE TABLE b (
>          two     text
> ) INHERITS (a);
>
> CREATE FUNCTION myinsert() RETURNS opaque AS '
>          BEGIN
>                  RAISE NOTICE ''1 - NEW: %\n'', NEW.one;
>                  RAISE NOTICE ''2 - NEW: %\n'', NEW.two;
>                  RETURN NEW;
>          END;
> ' LANGUAGE 'plpgsql';
>
> CREATE TRIGGER mytrig BEFORE INSERT ON b
>           FOR EACH ROW EXECUTE PROCEDURE myinsert();
>
> INSERT INTO b VALUES ('a1', 'b2');
>
>
> An error is displayed:
>
>
> CREATE
> CREATE
> ERROR:  function myinsert already exists with same argument types

Create function fails, you have function with same name and arguments !