Re: Acessing columns of parent tables with PL/pgSQL

On Thu, 27 Jun 2002 18:38:10 +0200, Hans-Juergen Schoenig
<hs@cybertec.at> wrote:
>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';
>
>An error is displayed:
>ERROR:  function myinsert already exists with same argument types

Hans, you are still running an old version of your function
myinsert().  Better use
    CREATE OR REPLACE FUNCTION myinsert() ...

Servus
 Manfred