Converting bytea to LargeObject

From: "Satish Burnwal (sburnwal)" <sburnwal(at)cisco(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Cc: <sam(at)samason(dot)me(dot)uk>
Subject: Converting bytea to LargeObject
Date: 2010-02-17 09:48:59
Message-ID: 3A8C969225424C4D8E6BEE65ED8552DAB166BC@XMB-BGL-41C.cisco.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I am also having the problem as mentioned in
http://archives.postgresql.org/pgsql-general/2009-01/msg00771.php.

However, the sql statement:

UPDATE tbl SET newoid = (

SELECT oid FROM (

SELECT oid, lowrite(lo_open(oid, 131072), byteafield)

FROM lo_create(0) o(oid)) x);

This is not working for me:

- it is putting same newoid for all the records in the table whereas
what is needed is separate oid for each record. Lo_create(0) seems to be
taken for all the records.

- can you pls explain the syntax o(oid) ? I do not see any documentation
for this.

Thanks

Satish

Browse pgsql-general by date

  From Date Subject
Next Message Devrim GÜNDÜZ 2010-02-17 10:16:57 Re: Source RPMs for PostgreSQL 7.4.27 on RHEL4
Previous Message Takahiro Itagaki 2010-02-17 08:18:24 Re: [GENERAL] possible bug with inheritance?