Re: NULL value without indicator in line 250.

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Nigel Horne <njh(at)bandsman(dot)co(dot)uk>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: NULL value without indicator in line 250.
Date: 2005-08-10 21:40:19
Message-ID: 20050810214019.GA47967@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Aug 10, 2005 at 04:43:50PM +0100, Nigel Horne wrote:
> Has anyone got any pointers to how to define an null indicator
> variable to get over the above cryptic message?

Without more information we can only guess. The only place in the
PostgreSQL source code that contains the string "NULL value without
indicator" is in the ECPG code, so I'll guess that you're using
ECPG and doing something like this:

EXEC SQL SELECT somecolumn INTO :foo FROM sometable WHERE id = 1234;

If that's the case, then see "Indicators" in the ECPG documentation.
Here's a link to the latest version:

http://www.postgresql.org/docs/8.0/static/ecpg-variables.html#AEN25258

If that's not what you're doing, then please provide more information.

--
Michael Fuhr

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tony Caduto 2005-08-10 21:48:29 What's up with EnterpriseDB?
Previous Message Bruce Momjian 2005-08-10 21:38:26 Re: 5 new entries for FAQ