Postgres Pro
Downloads
Home   >   mailing lists

Re: PL/pgSQL NOT NULL variables - Mailing list pgsql-general

From Tom Lane
Subject Re: PL/pgSQL NOT NULL variables
Date
Msg-id 15847.978745584@sss.pgh.pa.us
Whole thread Raw
In response to PL/pgSQL NOT NULL variables  (Richard Poole <richard.poole@vi.net>)
List pgsql-general
Tree view 
Richard Poole <richard.poole@vi.net> writes:
> I can't get NOT NULL variables to work at all in PL/pgSQL.

Doesn't look like they've ever worked :-(.  If you need a patch for
7.0.*, line 1907 of src/pl/plpgsql/src/pl_exec.c should read

            if (*isNull && var->notnull)

not

            if (isNull && var->notnull)


            regards, tom lane

pgsql-general by date:

Previous
From: Alex Pilosov
Date:
Subject: Re: SHM ids (was running pgsql 7 under Jail'ed virtual machine on FreeBSD 4.2)
Next
From: "Dave VanAuken"
Date:
Subject: RE: SHM ids (was running pgsql 7 under Jail'ed virtual machine on FreeBSD 4.2)