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

Re: NonNullValue() error in 8.4

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 (view raw or flat)
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




In response to

Responses

pgsql-novice by date

Next:From: Tom LaneDate: 2010-10-12 19:20:43
Subject: Re: NonNullValue() error in 8.4
Previous:From: Josh KupershmidtDate: 2010-10-12 16:53:02
Subject: Re: NonNullValue() error in 8.4

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group