Re: Large Object => invalid input syntax for integer: ""

From: Douglas McNaught <doug(at)mcnaught(dot)org>
To: grupos <grupos(at)carvalhaes(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Large Object => invalid input syntax for integer: ""
Date: 2005-06-06 13:31:34
Message-ID: m2r7ff393d.fsf@Douglas-McNaughts-Powerbook.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

grupos <grupos(at)carvalhaes(dot)net> writes:

> Hi Doug!
>
> Thanks for your e-mail BUT the point is how I insert data on a table
> when the column lo have no value ( NULL), to insert the lo I have no
> problem BUT the problem is when the column should have no value...

If the "lo" field isn't NOT NULL than you should have no problem.
The error message in your previous email came from trying to insert an
integer into a text column.

If you are still having problems please post your table definitions
and the exact query that is causing trouble.

-Doug

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Douglas McNaught 2005-06-06 13:37:32 Re: Large Object => invalid input syntax for integer: ""
Previous Message grupos 2005-06-06 13:27:41 Re: Large Object => invalid input syntax for integer: ""