Re: partitioning using dblink

I can't get views to participate in the hierarchy...

create table outings1 as select * from outings_root limit 0;

alter table outings1 inherit outings_root;
SELECT *
   FROM dblink('host=myhost dbname=tacche port=5433 user=postgres password=postgres'::text,
        'SELECT * from outings1'::text)  as
    (id integer, date date, spot_id integer, notes text);


Selects to outings_root won't show data from host "myhost". Selects from outings1 will work as expected.

This is not what I got from the docs:

"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"



Am I doing something wrong?

If it worked I would have a very basic (but working!) form of horizontal partitioning....





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