Fwd: Stalled post to pgsql-bugs - Mailing list pgsql-bugs

From Ciprian Dorin Craciun
Subject Fwd: Stalled post to pgsql-bugs
Date
Msg-id 8e04b5820710182347p40f481a5uff10bbac7f7a45d3@mail.gmail.com
Whole thread Raw
List pgsql-bugs
Hello all!

    Almost two months ago I have posted a bug on the bug reporting
form that is available on the web page... (I forward here the email I
got in response.) It was related about the RETURNING feature available
for INSERT, UPDATE and DELETE, and the fact that I can not use it as
last statement is PL/SQL functions.

    But until now I saw no activity on this bug... How can I track it?
Has some one looked at it? Is it already fixed?

    I've monitored the release notes of every release from 8.2.5 and
saw nothing related to the issue.

    Could some one point me into the right direction? Or I could try
to fix it my self if someone could tell me where to start...

    Thank you all,
    Ciprian.


---------- Forwarded message ----------
From: pgsql-bugs-owner@postgresql.org <pgsql-bugs-owner@postgresql.org>
Date: Sep 3, 2007 8:13 PM
Subject: Stalled post to pgsql-bugs
To: Ciprian Dorin Craciun <ciprian.craciun@gmail.com>


Your message to pgsql-bugs has been delayed, and requires the approval
of the moderators, for the following reason(s):

The author ("Ciprian Dorin Craciun" <ciprian.craciun@gmail.com>)
  is not a member of any of the restrict_post groups.

If you do not wish the message to be posted, or have other concerns,
please send a message to the list owners at the following address:
  pgsql-bugs-owner@postgresql.org


---------- Forwarded message ----------
From: "Ciprian Dorin Craciun" <ciprian.craciun@gmail.com>
To: pgsql-bugs@postgresql.org
Date: Mon, 3 Sep 2007 17:13:40 GMT
Subject: BUG #3596: "insert ... returning *" not usable as last
statement in a function...

The following bug has been logged online:

Bug reference:      3596
Logged by:          Ciprian Dorin Craciun
Email address:      ciprian.craciun@gmail.com
PostgreSQL version: 8.2.4
Operating system:   Debian Etch (4.0)
Description:        "insert ... returning *" not usable as last statement in
a function...
Details:

I think the best explanation is the example just above...

The idea is that in 8.2 insert statement was modified by adding an returning
option, that modifies insert to behave also as a select statement by
returning all the rows inserted. But unfortunately this option can not be
used inside functions that return something as a last statement...

create table table1 ( field int );

create function function1 ( int ) returns table1 as $$
        insert into table1 values ($1) returning *;
$$ language sql;

pgsql-bugs by date:

Previous
From: Kris Jurka
Date:
Subject: Re: creating a table with a serial column sets currval
Next
From: Tom Lane
Date:
Subject: Re: creating a table with a serial column sets currval