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