Re: [GENERAL] Postgres mystery

2005-03-30 Thread Berend Tober
Michael Fuhr wrote: On Wed, Mar 30, 2005 at 09:11:09AM +0200, Shaun Clements wrote: 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. EXECUTE ''INSERT INTO tab

Re: [GENERAL] Postgres mystery

2005-03-30 Thread Shaun Clements
Hi Guys   Thanks again for your responses. You were all RIGHT .. again! a null column was returned, which bombed out the stored procedure. This was resolved using ur advice.   Kind Regards,Shaun Clements B.Com (Hons) IST Software Developer Relyant Group ITBusiness ConneXion (Pty) LtdAs

Re: [GENERAL] Postgres mystery

2005-03-29 Thread Michael Fuhr
On Wed, Mar 30, 2005 at 09:11:09AM +0200, Shaun Clements wrote: > 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. > > EXECUTE ''INSERT INTO table (column1

Re: [GENERAL] Postgres mystery

2005-03-29 Thread Richard Huxton
Shaun Clements wrote: 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. EXECUTE ''INSERT INTO table (column1, column2, column3, ''||quote_ident(column4)||'') val

Re: [GENERAL] Postgres mystery

2005-03-29 Thread Klint Gore
On Wed, 30 Mar 2005 09:11:09 +0200, Shaun Clements <[EMAIL PROTECTED]> wrote: > 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. > > > EXECUTE ''INSERT IN