[Postgres-xl-developers] Issues with "VIEW" composite types on datanodes

Nikhil Sontakke nikhils at translattice.com
Fri Oct 17 03:45:15 PDT 2014


Hi,

So, I was taking a look at:

https://sourceforge.net/p/postgres-xl/tickets/2/

The basic issue is that views are not created on datanodes and hence the
corresponding composite type also does not exist there.

So any query which tries to access such a composite type errors out on the
datanode. For example:

create table gh(g int primary key, h int);
create view view_gh as select * from gh;
select * from view_gh ;
g | h
----+----
1 | 2

select view_gh from view_gh ;
ERROR: cache lookup failed for type 0
One way to solve this could be to allow VIEW creation on datanodes as well.
If we do that the corresponding composite type will be available there as
well.

The view will get re-written at the coordinator and presence of the view on
the datanodes will mostly be for the composite type usage. It's possible
that someone might do an "EXECUTE DIRECT" to one of the datanodes, but then
in that case it will also get re-written appropriately, hopefully. Any
other issues foreseen?

Thoughts?

Regards,
Nikhils

-- 
TransLattice - http://www.translattice.com
Distributed and Clustered Database Solutions
Postgres-XL Support
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.postgres-xl.org/private.cgi/postgres-xl-developers-postgres-xl.org/attachments/20141017/5a929eac/attachment.htm>


More information about the Postgres-xl-developers mailing list