About Views

[tmendesilva]

Can I make schema.json using a VIEW as "table", or there some schema generator to make this JSON analyzing tables used on my VIEW query?

[toluaina]

Views are currently not supported yet. Some work has been done but its still WIP.

[tmendesilva]

Congrats for your job, i'm using to replace materialized views. I will try simulate views on schema, tnks.

[toluaina]

Thanks I will look at this shortly. Don't have an ETA yet sorry.

[yangyaofei]

@toluaina hi, are you still working with this? I have a table with tree-like struct and I want get a path for every item for searching. Since there is no such method for recursive retrieving I create a recursive view to achieve that.

But , I found view cannot be synced when change the data.

Can you tell me how to make view work? I can implement it if I can.

[toluaina]

I haven't made much progress on this sorry.
One caveat about views is that they need to be refreshed manually.

[yangyaofei]

@toluaina yes, i have try it a little, as far as I upderstand because of there is no such thing like permarary key, so they cannot make the trigger run.

In My case, I create a trigger to make that view as a real table.

Thank you for your reply.

[toluaina]

Sorry for the long wait. Support for views is detailed here

[toluaina]

view are finally supported.

[Cognitus-Stuti]

Are only materialized views supported? I still am getting the issue of it looking for the xmin column