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

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

From
grupos
Date:
I need to use large objects BUT I am having problemns... I instaled
PostgreSQL 8.0.3 windows version with lo module.

first, I created the table below:
CREATE TABLE test
(
  description varchar(20),
  picture lo
)
WITHOUT OIDS;

After trying to make one insert without value for the lo I get the error
below:

INSERT INTO test VALUES (1);

ERROR:  invalid input syntax for integer: ""

Which value I can put on the default of the lo to solve this ? I alreday
tryed -1, 0, 1, null but nothing works...

Why this problem?

Regards,

Rodrigo Carvalhaes



--
Esta mensagem foi verificada pelo sistema de antivírus e
 acredita-se estar livre de perigo.


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

From
Adam Witney
Date:
On 6/6/05 4:58 am, "grupos" <grupos@carvalhaes.net> wrote:

> I need to use large objects BUT I am having problemns... I instaled
> PostgreSQL 8.0.3 windows version with lo module.
>
> first, I created the table below:
> CREATE TABLE test
> (
> description varchar(20),
> picture lo
> )
> WITHOUT OIDS;
>
> After trying to make one insert without value for the lo I get the error
> below:
>
> INSERT INTO test VALUES (1);
>
> ERROR:  invalid input syntax for integer: ""
>
> Which value I can put on the default of the lo to solve this ? I alreday
> tryed -1, 0, 1, null but nothing works...
>
> Why this problem?

I think the problem is nothing to do with lo, you are trying to insert an
integer into a varchar field, try

INSERT INTO test VALUES ('1');

HTH

adam


--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.


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

From
Douglas McNaught
Date:
grupos <grupos@carvalhaes.net> writes:

> I need to use large objects BUT I am having problemns... I instaled
> PostgreSQL 8.0.3 windows version with lo module.
>
> first, I created the table below:
> CREATE TABLE test
> (
>   description varchar(20),
>   picture lo
> )
> WITHOUT OIDS;
>
> After trying to make one insert without value for the lo I get the
> error below:
>
> INSERT INTO test VALUES (1);
>
> ERROR:  invalid input syntax for integer: ""

This means you're trying to insert an integer value into the
"description" column, which is text.  It has nothing to do with large
objects.

To insert an LO into a database, you do the following:

BEGIN a transaction
Call lo_create() to make a new large object.  The return value is the
  OID of the LO, which you will need later.
Call lo_write() and lo_close() to put data into the LO
Insert the OID you got from lo_create() in the referencing column
  ("picture", in your case)
COMMIT the transaction

It's a little annoying but that's how it works.

-Doug

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

From
grupos
Date:
Hi Adam,

I am sorry for the misunderstanding, when I compose the e-mail I forgot
the '  '  on the 1 BUT the error is the same, I made:
INSERT INTO test VALUES ('1')

and I get the error:
ERROR:  invalid input syntax for integer: ""

I am sure that there is some problem with LO.

Regards,

Rodrigo Carvalhaes
Adam Witney wrote:

>On 6/6/05 4:58 am, "grupos" <grupos@carvalhaes.net> wrote:
>
>
>
>>I need to use large objects BUT I am having problemns... I instaled
>>PostgreSQL 8.0.3 windows version with lo module.
>>
>>first, I created the table below:
>>CREATE TABLE test
>>(
>>description varchar(20),
>>picture lo
>>)
>>WITHOUT OIDS;
>>
>>After trying to make one insert without value for the lo I get the error
>>below:
>>
>>INSERT INTO test VALUES (1);
>>
>>ERROR:  invalid input syntax for integer: ""
>>
>>Which value I can put on the default of the lo to solve this ? I alreday
>>tryed -1, 0, 1, null but nothing works...
>>
>>Why this problem?
>>
>>
>
>I think the problem is nothing to do with lo, you are trying to insert an
>integer into a varchar field, try
>
>INSERT INTO test VALUES ('1');
>
>HTH
>
>adam
>
>
>
>


--
Esta mensagem foi verificada pelo sistema de antivírus e
 acredita-se estar livre de perigo.


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

From
grupos
Date:
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...

Regards,

Rodrigo Carvalhaes

Douglas McNaught wrote:

>grupos <grupos@carvalhaes.net> writes:
>
>
>
>>I need to use large objects BUT I am having problemns... I instaled
>>PostgreSQL 8.0.3 windows version with lo module.
>>
>>first, I created the table below:
>>CREATE TABLE test
>>(
>>  description varchar(20),
>>  picture lo
>>)
>>WITHOUT OIDS;
>>
>>After trying to make one insert without value for the lo I get the
>>error below:
>>
>>INSERT INTO test VALUES (1);
>>
>>ERROR:  invalid input syntax for integer: ""
>>
>>
>
>This means you're trying to insert an integer value into the
>"description" column, which is text.  It has nothing to do with large
>objects.
>
>To insert an LO into a database, you do the following:
>
>BEGIN a transaction
>Call lo_create() to make a new large object.  The return value is the
>  OID of the LO, which you will need later.
>Call lo_write() and lo_close() to put data into the LO
>Insert the OID you got from lo_create() in the referencing column
>  ("picture", in your case)
>COMMIT the transaction
>
>It's a little annoying but that's how it works.
>
>-Doug
>
>
>

--
Esta mensagem foi verificada pelo sistema de antivírus e
 acredita-se estar livre de perigo.


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

From
Douglas McNaught
Date:
grupos <grupos@carvalhaes.net> writes:

> Hi Adam,
>
> I am sorry for the misunderstanding, when I compose the e-mail I
> forgot the '  '  on the 1 BUT the error is the same, I made:
> INSERT INTO test VALUES ('1')
>
> and I get the error:
> ERROR:  invalid input syntax for integer: ""
>
> I am sure that there is some problem with LO.

Try inserting an explicit NULL:

INSERT INTO test VALUES ('1', NULL);

-Doug

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

From
Douglas McNaught
Date:
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

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

From
grupos
Date:
Hi Douglas,

Thanks for your promptly answer. Here is the "step by step":

CREATE TABLE test
(
  description varchar(20),
  picture lo
)
WITHOUT OIDS;


INSERT INTO test (description) VALUES ('1');

And then, the error : INSERT INTO test (description) VALUES ('1')

What I am trying to do is insert data only on the column description,
leaving the column picture null (because for this tuple there is no image).

Regards,

Rodrigo Carvalhaes

Douglas McNaught wrote:

>grupos <grupos@carvalhaes.net> writes:
>
>
>
>>I need to use large objects BUT I am having problemns... I instaled
>>PostgreSQL 8.0.3 windows version with lo module.
>>
>>first, I created the table below:
>>CREATE TABLE test
>>(
>>  description varchar(20),
>>  picture lo
>>)
>>WITHOUT OIDS;
>>
>>After trying to make one insert without value for the lo I get the
>>error below:
>>
>>INSERT INTO test VALUES (1);
>>
>>ERROR:  invalid input syntax for integer: ""
>>
>>
>
>This means you're trying to insert an integer value into the
>"description" column, which is text.  It has nothing to do with large
>objects.
>
>To insert an LO into a database, you do the following:
>
>BEGIN a transaction
>Call lo_create() to make a new large object.  The return value is the
>  OID of the LO, which you will need later.
>Call lo_write() and lo_close() to put data into the LO
>Insert the OID you got from lo_create() in the referencing column
>  ("picture", in your case)
>COMMIT the transaction
>
>It's a little annoying but that's how it works.
>
>-Doug
>
>---------------------------(end of broadcast)---------------------------
>TIP 3: if posting/reading through Usenet, please send an appropriate
>      subscribe-nomail command to majordomo@postgresql.org so that your
>      message can get through to the mailing list cleanly
>
>
>

--
Esta mensagem foi verificada pelo sistema de antivírus e
 acredita-se estar livre de perigo.


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

From
"FERREIRA, William (COFRAMI)"
Date:
do you really need to use lo module ?
try this ...

CREATE TABLE test
(
  description varchar(20),
  picture oid
)
WITHOUT OIDS;

if you want to import a BLOB :
insert into test values ("toto", lo_import('mypicture'))

and if you want no value
insert into test values ("toto", 0)

-----Message d'origine-----
De : pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org]De la part de grupos
Envoy� : lundi 6 juin 2005 15:28
� : Douglas McNaught
Cc : pgsql-general@postgresql.org
Objet : Re: [GENERAL] Large Object => invalid input syntax for integer:
""


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...

Regards,

Rodrigo Carvalhaes

Douglas McNaught wrote:

>grupos <grupos@carvalhaes.net> writes:
>
>
>
>>I need to use large objects BUT I am having problemns... I instaled
>>PostgreSQL 8.0.3 windows version with lo module.
>>
>>first, I created the table below:
>>CREATE TABLE test
>>(
>>  description varchar(20),
>>  picture lo
>>)
>>WITHOUT OIDS;
>>
>>After trying to make one insert without value for the lo I get the
>>error below:
>>
>>INSERT INTO test VALUES (1);
>>
>>ERROR:  invalid input syntax for integer: ""
>>
>>
>
>This means you're trying to insert an integer value into the
>"description" column, which is text.  It has nothing to do with large
>objects.
>
>To insert an LO into a database, you do the following:
>
>BEGIN a transaction
>Call lo_create() to make a new large object.  The return value is the
>  OID of the LO, which you will need later.
>Call lo_write() and lo_close() to put data into the LO
>Insert the OID you got from lo_create() in the referencing column
>  ("picture", in your case)
>COMMIT the transaction
>
>It's a little annoying but that's how it works.
>
>-Doug
>
>
>

--
Esta mensagem foi verificada pelo sistema de antiv�rus e
 acredita-se estar livre de perigo.


---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

This mail has originated outside your organization,
either from an external partner or the Global Internet.
Keep this in mind if you answer this message.

This e-mail is intended only for the above addressee. It may contain
privileged information. If you are not the addressee you must not copy,
distribute, disclose or use any of the information in it. If you have
received it in error please delete it and immediately notify the sender.
Security Notice: all e-mail, sent to or from this address, may be
accessed by someone other than the recipient, for system management and
security reasons. This access is controlled under Regulation of
Investigatory Powers Act 2000, Lawful Business Practises.

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

From
Tom Lane
Date:
grupos <grupos@carvalhaes.net> writes:
> I need to use large objects BUT I am having problemns... I instaled
> PostgreSQL 8.0.3 windows version with lo module.

> first, I created the table below:
> CREATE TABLE test
> (
>   description varchar(20),
>   picture lo
> )
> WITHOUT OIDS;

> After trying to make one insert without value for the lo I get the error
> below:

> INSERT INTO test VALUES (1);

> ERROR:  invalid input syntax for integer: ""

This example works fine for me.  What's more, that error message doesn't
seem to have anything to do with LO columns --- it implies you were
trying to insert into an integer column.  (The error message could not
be triggered by insertion into a varchar column either, contrary to some
claims made elsewhere in this thread...)

Are you sure that you are inserting into the table you think you are?
I'm wondering about multiple tables named "test" in different schemas,
for instance ...

            regards, tom lane

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

From
Richard Huxton
Date:
grupos wrote:
> Hi Adam,
>
> I am sorry for the misunderstanding, when I compose the e-mail I forgot
> the '  '  on the 1 BUT the error is the same, I made:
> INSERT INTO test VALUES ('1')
>
> and I get the error:
> ERROR:  invalid input syntax for integer: ""
>
> I am sure that there is some problem with LO.

Hmm - works here (Linux, 7.4.7)

CREATE TABLE lotest4 (description varchar, picture lo) WITHOUT OIDS;
INSERT INTO lotest4 (description) VALUES ('1');
SELECT * FROM lotest4;
  description | picture
-------------+---------
  1           |

Are you sure table "test" looks like that?
--
   Richard Huxton
   Archonet Ltd

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

From
"Sean Davis"
Date:
----- Original Message -----
From: "Adam Witney" <awitney@sgul.ac.uk>
To: "grupos" <grupos@carvalhaes.net>; "pgsql-general"
<pgsql-general@postgresql.org>
Sent: Monday, June 06, 2005 8:17 AM
Subject: Re: [GENERAL] Large Object => invalid input syntax for integer: ""


> On 6/6/05 4:58 am, "grupos" <grupos@carvalhaes.net> wrote:
>
>> I need to use large objects BUT I am having problemns... I instaled
>> PostgreSQL 8.0.3 windows version with lo module.
>>
>> first, I created the table below:
>> CREATE TABLE test
>> (
>> description varchar(20),
>> picture lo
>> )
>> WITHOUT OIDS;
>>
>> After trying to make one insert without value for the lo I get the error
>> below:
>>
>> INSERT INTO test VALUES (1);
>>
>> ERROR:  invalid input syntax for integer: ""
>>
>> Which value I can put on the default of the lo to solve this ? I alreday
>> tryed -1, 0, 1, null but nothing works...
>>
>> Why this problem?
>
> I think the problem is nothing to do with lo, you are trying to insert an
> integer into a varchar field, try
>
> INSERT INTO test VALUES ('1');
>

And do you need:

INSERT INTO test (description) VALUES ('1');

Sean