Re: 9.3 Beta1 status report - Mailing list pgsql-hackers

From Jov
Subject Re: 9.3 Beta1 status report
Date
Msg-id CADyrUxOcgkMz_WdOCWBuUSEpZECgT9d+1F_W8nWcBCesSty9vw@mail.gmail.com
Whole thread Raw
In response to Re: 9.3 Beta1 status report  (Dean Rasheed <dean.a.rasheed@gmail.com>)
Responses Re: 9.3 Beta1 status report
List pgsql-hackers

E.1.3.1.4:

Improve performance of the CREATE TABLE ... ON COMMIT DELETE ROWS clause by only issuing delete if the temporary table was accessed (Heikki Linnakangas)

should be:
             CREATE TEMP TABLE ... ON COMMIT DELETE ROWS
or
           CREATE { TEMPORARY | TEMP } TABLE ... ON COMMIT DELETE ROWS

because there is no syntax for CREATE TABLE ... ON COMMIT DELETE ROWS


2013/4/23 Dean Rasheed <dean.a.rasheed@gmail.com>
On 21 April 2013 06:02, Bruce Momjian <bruce@momjian.us> wrote:
> I am not sure if Tom shared yet, but we are planning to package 9.3
> beta1 on April 29, with a release on May 2.  Those dates might change,
> but that is the current plan.  I have completed a draft 9.3 release
> notes, which you can view here:
>
>         http://momjian.us/pgsql_docs/release-9-3.html
>
> I will be working on polishing them for the next ten days, so any
> feedback, patches, or commits are welcome.  I still need to add lots of
> SGML markup.
>

E.1.3.4.4. VIEWs:

* Make simple views auto-updatable (Dean Rasheed)

  INSTEAD rules are still available for complex views.


I think this should refer to INSTEAD OF triggers for complex views,
since that is now the recommended way to implement updatable views.

I think it should also expand a little on what "simple" means in this
context, without going into all the gory details, and mention that
there is a behaviour change. So perhaps something like this for the
second paragraph:

        Simple views that select some or all columns from a single base table
        are now updatable by default. More complex views can be made updatable
        using INSTEAD OF triggers or INSTEAD rules.

Regards,
Dean


--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers




--
Jov

pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: Couple of issues with pg_xlogdump
Next
From: Ants Aasma
Date:
Subject: Re: Substituting Checksum Algorithm (was: Enabling Checksums)