From: | Michael Glaesemann <grzm(at)seespotcode(dot)net> |
---|---|
To: | Josh Kupershmidt <schmiddy(at)gmail(dot)com> |
Cc: | Rebecca Cooper <rebecca(dot)cooper(at)newforestnpa(dot)gov(dot)uk>, pgsql-novice(at)postgresql(dot)org |
Subject: | Re: NonNullValue() error in 8.4 |
Date: | 2010-10-12 16:57:26 |
Message-ID: | 12764303-F2E8-44FC-8203-4E0FD8E45927@seespotcode.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On Oct 12, 2010, at 12:53 , Josh Kupershmidt wrote:
> On Tue, Oct 12, 2010 at 11:28 AM, Rebecca Cooper
> <rebecca(dot)cooper(at)newforestnpa(dot)gov(dot)uk> wrote:
>> We have recently upgraded to 8.4 from 8.3 and are experiencing problems with
>> a client application. The log files record multiple entries of -
>>
>> SELECT NonNullValue(attname) AS has_oid FROM pg_attribute
>>
>> ERROR: function nonnullvalue(name) does not exist at character 664
>>
>
> to use a CASE statement like so:
>
> SELECT (CASE WHEN attname IS NULL THEN true ELSE false END) AS
> has_oid FROM pg_attribute;
>
> which should work fine on 8.4.
Or just "SELECT attname IS NULL AS has_oid"
Michael Glaesemann
grzm seespotcode net
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2010-10-12 19:20:43 | Re: NonNullValue() error in 8.4 |
Previous Message | Josh Kupershmidt | 2010-10-12 16:53:02 | Re: NonNullValue() error in 8.4 |