Skip site navigation (1) Skip section navigation (2)

Re: Hello

From: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
To: Jed Nicolau Filho <jed(at)prouser(dot)com(dot)br>
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: Hello
Date: 2004-09-22 07:57:33
Message-ID: 4151306D.1080906@pse-consulting.de (view raw or flat)
Thread:
Lists: 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

In response to

  • Hello at 2004-09-22 00:53:47 from Jed Nicolau Filho

pgadmin-support by date

Next:From: Andreas PflugDate: 2004-09-22 07:59:25
Subject: Re: Users can see each others' databases?
Previous:From: Dave PageDate: 2004-09-22 07:25:52
Subject: Re: Error adding columns to existing tables

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group