Postgres mystery

From: Shaun Clements <ShaunC(at)relyant(dot)co(dot)za>
To: pgsql-general(at)postgresql(dot)org
Subject: Postgres mystery
Date: 2005-03-30 07:11:09
Message-ID: 100F78F2B203444BB161BBA7077FF6131CD9A4@srldbexc003.relyant.co.za
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Can anyone tell me what the problem is here:
I am inserting into a table via a stored procedure, to a few columns within
the table and postgres is throwing a
CANNOT EXECUTE NULL QUERY.

<code snip>
EXECUTE ''INSERT INTO table (column1, column2, column3,
''||quote_ident(column4)||'') values
(''||quote_literal(RECORDNAME.column1)||'',''||quote_literal(RECORDNAME.colu
mn2)||'',''''stringvalue'''',''||quote_literal(RECORDNAME.column2)||'')'';
</code snip>

Is this a bug, as I am ensuring that the NOT NULL columns are supplied, as
well as one other.

Kind Regards,
Shaun Clements

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2005-03-30 07:30:57 Re: Zombie processes
Previous Message Sim Zacks 2005-03-30 06:42:20 Re: How to return a record and sets of record in plpython