Re: Re: pg_dump and LOs (another proposal)

At 13:06 5/07/00 -0400, Tom Lane wrote:
>
>    UPDATE userTable SET oidcolumn = tmptable.newLOoid WHERE
>        oidcolumn = tmptable.oldLOoid;
>

It's actually nastier than this since there could be multiple oid columns,
implying, potentially, multiple scans of the table.

I suppose

update userTable setoidCol1 = Coalesce( (Select newLOoid from oidxref where oldLOoid = oidCol1
), oidCol1 ),oidCol2 = Coalesce( (Select newLOoid from oidxref where oldLOoid = oidCol2
), oidCol2 ),...

would work, or at least only update each row once, but it looks slow.






----------------------------------------------------------------
Philip Warner                    |     __---_____
Albatross Consulting Pty. Ltd.   |----/       -  \
(A.C.N. 008 659 498)             |          /(@)   ______---_
Tel: (+61) 0500 83 82 81         |                 _________  \
Fax: (+61) 0500 83 82 82         |                 ___________ |
Http://www.rhyme.com.au          |                /           \|                                |    --________--
PGP key available upon request,  |  /
and from pgp5.ai.mit.edu:11371   |/