Forgot your password?
typodupeerror
Databases

PostgreSQL 9.3 Will Feature UPDATEable Views 68

Posted by Unknown Lamer
from the long-overdue-features dept.
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 @01: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 @02: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!

We warn the reader in advance that the proof presented here depends on a clever but highly unmotivated trick. -- Howard Anton, "Elementary Linear Algebra"

Working...