Become a fan of Slashdot on Facebook


Forgot your password?

PostgreSQL 9.3 Will Feature UPDATEable Views 68

Picking up work abandoned around Postgres 8.2, a patch recently hit the PostgreSQL 9.3 branch that adds SQL-92 automatically updatable views. For many common cases, you will no longer have to write hairy triggers to fake UPDATE support (e.g. if you have a view that hides a few internal columns). Limitations currently include only supporting views with at most one table in the FROM clause. This complements the under-advertised INSTEAD OF trigger support added in 9.1.
This discussion has been archived. No new comments can be posted.

PostgreSQL 9.3 Will Feature UPDATEable Views

Comments Filter:
  • by KavyBoy ( 35619 ) on Wednesday December 12, 2012 @12:59PM (#42262921)

    If we follow the trend of other products, I would expect to see this in the 9.4 release notes:
    * Removed "DISTINCT" and "GROUP BY". Usability studies show that most queries do not use them and new users find them confusing.
    * "SELECT *" queries now return additional entries from Amazon.
    * SQL language extensions to integrate Facebook and Twitter.
    * Column order, if not specified in "ORDER BY", is heuristically determined from previous queries.

    It's just great to see a release of anything that is actually better than the what it is replacing.

  • by Anonymous Coward on Wednesday December 12, 2012 @01:34PM (#42263325)

    i dont know what all this talk about postgresql is i dont post anything in my web site i use mysql its a professional platform because the data is mine combined with php i can use mysql_real_escape_string because the php developers are really really good im off to stackoverflow to get help for my recursive mysql menu system i think recursive queries also work not sure ooohhh pokemon is on see you all soon!

Men occasionally stumble over the truth, but most of them pick themselves up and hurry off as if nothing had happened. -- Winston Churchill