Re: [GENERAL] Remote tables infrastructure.

2006-11-09 Thread Dawid Kuroczko
On 11/10/06, Tom Lane <[EMAIL PROTECTED]> wrote: "Dawid Kuroczko" <[EMAIL PROTECTED]> writes:> Methinks it would be good idea to discuss a more general approach,> i.e.  don't "create" links using existing infrastructure but rather > provide something conceptually similar to CREATE AGGREGATE stateme

Re: [GENERAL] Remote tables infrastructure.

2006-11-09 Thread Tom Lane
"Dawid Kuroczko" <[EMAIL PROTECTED]> writes: > Methinks it would be good idea to discuss a more general approach, > i.e. don't "create" links using existing infrastructure but rather > provide something conceptually similar to CREATE AGGREGATE statements. > In other words, make a remote link a fir

[GENERAL] Remote tables infrastructure.

2006-11-09 Thread Dawid Kuroczko
Hello. One nice feature of PostgreSQL's CREATE FUNCTION/RULE/VIEW system is ability to create objects which "may appear closer than they really are". Hence, all the dbi-link-like modules. The usual method is to create a view on a set returning function (if reasonable), create RULEs for managing