pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedMoving text columns, when it actually is large
2+ messages / 2 participants
[nested] [flat]
* Moving text columns, when it actually is large
@ 2009-07-08 21:19 Rob Sargent <robjsargent@gmail.com>
0 siblings, 1 reply; 2+ messages in thread
From: Rob Sargent @ 2009-07-08 21:19 UTC (permalink / raw)
To: pgsql-sql
I have to restructure some tables, coalescing common elements from three
tables (sub-classes) into a single table (super-class). Each source
table has a text field which actually gets stuffed with a largish (1Mb+)
blob of xml.
Is there any way to simply, um, er, transplant the pointer rather than
actually copy the data?
Ever hopeful,
rjs
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Moving text columns, when it actually is large
@ 2009-07-09 08:09 Richard Huxton <dev@archonet.com>
parent: Rob Sargent <robjsargent@gmail.com>
0 siblings, 0 replies; 2+ messages in thread
From: Richard Huxton @ 2009-07-09 08:09 UTC (permalink / raw)
To: Rob Sargent <robjsargent@gmail.com>; +Cc: pgsql-sql
Rob Sargent wrote:
> I have to restructure some tables, coalescing common elements from three
> tables (sub-classes) into a single table (super-class). Each source
> table has a text field which actually gets stuffed with a largish (1Mb+)
> blob of xml.
>
> Is there any way to simply, um, er, transplant the pointer rather than
> actually copy the data?
If they are large-objects (stored via the lo_xxx interface) yes. If not,
no. I take it the large blob of xml is one of the fields that you are
classifying as common?
--
Richard Huxton
Archonet Ltd
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2009-07-09 08:09 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2009-07-08 21:19 Moving text columns, when it actually is large Rob Sargent <robjsargent@gmail.com>
2009-07-09 08:09 ` Richard Huxton <dev@archonet.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox