"Dave Held" <dave(dot)held(at)arrayservicesgrp(dot)com> writes:
> I am interested in hacking COPY TO such that one can specify that
> rows are copied in a certain index order. I got as far as=20
> src/backend/commands/copy.c:CopyTo(), and it looks like I would need
> to modify the call to heap_beginscan() so that it uses a key.
Actually you'd need to change it to be an index_beginscan call.
Offhand I don't think you need a scan key; the point of a scan key is to
filter the returned rows, and it doesn't sound like that's what you
want. So it should work to do
scandesc = index_beginscan(rel, idx, mySnapshot, 0, NULL);
(plus appropriate changes to the usage of the scandesc)
which leaves only the problem of opening the proper index.
regards, tom lane
In response to
pgsql-hackers by date
|Next:||From: Stephen Frost||Date: 2005-02-25 23:03:39|
|Subject: Re: Modifying COPY TO|
|Previous:||From: Dave Held||Date: 2005-02-25 22:19:09|
|Subject: Modifying COPY TO|