Re: very frustrating feature-bug - Mailing list pgsql-sql

From Achilleas Mantzios
Subject Re: very frustrating feature-bug
Date
Msg-id 201002171733.10544.achill@matrix.gatewaynet.com
Whole thread Raw
In response to Re: very frustrating feature-bug  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Στις Wednesday 17 February 2010 17:27:11 ο/η Tom Lane έγραψε:
> silly sad <sad@bankir.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@smadevnew:~>
postgres@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


pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: very frustrating feature-bug
Next
From: Richard Huxton
Date:
Subject: Re: Referencing external table in update/insert triggers