Re: partitioning using dblink

> Exactly, because inheritance/constraint exclusion wont work with views.

Ok, so there should be something written in the docs about it...
From:

"the information about a view in the     PostgreSQL
system catalogs is exactly the same as it is for a table. So for the
parser, there is absolutely no difference between a table and a view"

I got that there should be no difference... plus, I don't get any errors, it's only that data in the view doesn't show
upwhen I query the master table. 

> >  2) Why am I supposed to use unions in the view?
>
> So that query evaluator can exclude unnecessary partitions.

Ok: that would be another way of having partitions, right?

> >  3) I know that I am doing select * from tbl in the remote db; that is
> something I can work on later.
> >  At least I would like to see it working, since there is nothing in the docs
> that says it shouldn't be working...
> >  4) I am not able to rewrite my queries.
>
> Have fun then.


Yeah I know...


Thank you






      ___________________________________
L'email della prossima generazione? Puoi averla con la nuova Yahoo! Mail:
http://it.docs.yahoo.com/nowyoucan.html