From: | Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, silly sad <sad(at)bankir(dot)ru> |
Subject: | Re: very frustrating feature-bug |
Date: | 2010-02-17 15:33:09 |
Message-ID: | 201002171733.10544.achill@matrix.gatewaynet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Στις Wednesday 17 February 2010 17:27:11 ο/η Tom Lane έγραψε:
> silly sad <sad(at)bankir(dot)ru> writes:
> > may i ask? when this feature will be fixed?
> > (now i am using 8.3.9)
>
> The example works fine for me in 8.4.
Same for me,
postgres(at)smadevnew:~>
postgres(at)smadevnew:~> psql
psql (8.4.1)
Type "help" for help.
dynacom=# CREATE OR REPLACE FUNCTION add_user (TEXT, TEXT, TEXT, TEXT)
dynacom-# RETURNS usr AS $$
dynacom$# INSERT INTO usr (login,pass,name,email) VALUES ($1,$2,$3,$4)
dynacom$# RETURNING usr.*;
dynacom$# $$ LANGUAGE sql SECURITY DEFINER;
CREATE FUNCTION
dynacom=#
dynacom=#
>
> regards, tom lane
>
--
Achilleas Mantzios
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Huxton | 2010-02-18 09:23:16 | Re: Referencing external table in update/insert triggers |
Previous Message | Tom Lane | 2010-02-17 15:27:11 | Re: very frustrating feature-bug |