Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

Re: very frustrating feature-bug


  • 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: Wed, 17 Feb 2010 17:33:09 +0200
  • Message-id: <201002171733.10544.achill@matrix.gatewaynet.com> <text/plain>

Στις 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



Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group