Re: Hello - Mailing list pgadmin-support

From Andreas Pflug
Subject Re: Hello
Date
Msg-id 4151306D.1080906@pse-consulting.de
Whole thread Raw
In response to Hello  ("Jed Nicolau Filho" <jed@prouser.com.br>)
List pgadmin-support
Jed Nicolau Filho wrote:
> Hi there
>  
> I was testing pgAdmin III and I found a strange behavior with Blob:
>  
> For this table:
> CREATE TABLE lo_test (  id serial NOT NULL,  image lo ) WITH OIDS;
>  
> When I try insert a record only with "id" value wihout image raise this 
> error message:
>  
> "ERROR: Invalid input syntax for Integer: ""  "
>  
> How to fix it ?

Can't tell, probably not a pgadmin issue.
I'd use the much more convenient type bytea.

Regards,
Andreas


pgadmin-support by date:

Previous
From: "Dave Page"
Date:
Subject: Re: Error adding columns to existing tables
Next
From: Andreas Pflug
Date:
Subject: Re: Users can see each others' databases?