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