Re: FDW state from plan time - Mailing list pgsql-hackers

From Heikki Linnakangas
Subject Re: FDW state from plan time
Date
Msg-id 4D98B707.4060501@enterprisedb.com
Whole thread Raw
In response to Re: FDW state from plan time  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: FDW state from plan time  (Dave Page <dpage@pgadmin.org>)
List pgsql-hackers
On 03.04.2011 19:38, Tom Lane wrote:
> Dave Page<dpage@pgadmin.org>  writes:
>> I can't help thinking I must be missing something obvious here, but is
>> there any way to persist some data from PlanForeignScan to at least
>> BeginForeignScan in an FDW? I'm aware of fdwplan->fdw_private, but at
>> that needs to be copyObject compatible, it's not much use to me.

If you have to, you can encapsulate arbitrary data in a bytea const.

> Or you could use a hash of some other identifying information (perhaps
> the OID of the foreign server would be sufficient ID for a connection?).

Foreign server + user id, probably. That's what I would recommend in 
this case.

--   Heikki Linnakangas  EnterpriseDB   http://www.enterprisedb.com


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: GUC assign hooks (was Re: wal_buffers = -1 and SIGHUP)
Next
From: emanov
Date:
Subject: PG 9.0.3. How to select rows from xml