Re: plpythonu and return void - Mailing list pgsql-general

From Tom Lane
Subject Re: plpythonu and return void
Date
Msg-id 11643.1123556537@sss.pgh.pa.us
Whole thread Raw
In response to plpythonu and return void  (Adrian Klaver <aklaver@comcast.net>)
Responses Re: plpythonu and return void  (Adrian Klaver <aklaver@comcast.net>)
List pgsql-general
Adrian Klaver <aklaver@comcast.net> writes:
> I recently migrated a database from Postgres 7.4.1 to Postgres 8.03. The only
> problem I have run into is that a plpythonu function that returns void will
> not run under 8.03. The error message states that a plpython function cannot
> return void. I got around it by having it return text and not actually
> returning anything. I have searched for an explanation and can't seem to
> locate one.

The explanation is doubtless here:

2004-09-19 19:38  tgl

    * src/pl/plpython/plpython.c: Add defenses against plpython
    functions being declared to take or return pseudotypes.  Not sure
    why I neglected to add these checks at the same time I added them
    to the other PLs, but it seems I did.

It's certainly possible to weaken this test to allow "void" again,
but shouldn't there be corresponding changes elsewhere to ensure that
the behavior is actually sensible?

            regards, tom lane

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: plpythonu and return void
Next
From: Ben
Date:
Subject: Adjacency List & total item counts