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
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
