Re: Large Object => invalid input syntax for integer: "" - Mailing list pgsql-general

From Douglas McNaught
Subject Re: Large Object => invalid input syntax for integer: ""
Date
Msg-id m2r7ff393d.fsf@Douglas-McNaughts-Powerbook.local
Whole thread Raw
In response to Re: Large Object => invalid input syntax for integer: ""  (grupos <grupos@carvalhaes.net>)
List pgsql-general
grupos <grupos@carvalhaes.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

pgsql-general by date:

Previous
From: Douglas McNaught
Date:
Subject: Re: Large Object => invalid input syntax for integer: ""
Next
From: grupos
Date:
Subject: Re: Large Object => invalid input syntax for integer: ""