Re: [COMMITTERS] pgsql: Add CREATE RECURSIVE VIEW syntax

2013-02-28 Thread Thom Brown
On 1 February 2013 03:33, Peter Eisentraut wrote: > Add CREATE RECURSIVE VIEW syntax > > This is specified in the SQL standard. The CREATE RECURSIVE VIEW > specification is transformed into a normal CREATE VIEW statement with a > WITH RECURSIVE clause. Recursive views aren't updatable, but the e

Re: [COMMITTERS] pgsql: Add support for piping COPY to/from an external program.

2013-02-28 Thread Alvaro Herrera
Heikki Linnakangas wrote: > This creates a new function in pgport, wait_result_to_str(), which can > be used to convert the exit status of a process, as returned by wait(3), > to a human-readable string. You have this: +#ifndef FRONTEND + result = pstrdup(str); +#else + result = strdup(str);

Re: [COMMITTERS] pgsql: Blind attempt at fixing the non-MSVC Windows builds

2013-02-28 Thread Andres Freund
On 2013-02-22 14:55:06 +, Alvaro Herrera wrote: > Blind attempt at fixing the non-MSVC Windows builds > > Apparently, they need -DBUILDING_DLL for the Assert() declarations to > work correctly. More specifically, they need that do access any PGDLLIMPORT symbols. Of which extern PGDLLIMPORT bo

[COMMITTERS] pgsql: Improve pg_upgrade commentary on multixact change

2013-02-28 Thread Alvaro Herrera
Improve pg_upgrade commentary on multixact change Per gripe from Andres Freund Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/cd7d00ad65fab11496ad9990cfc145c06c6ee53d Modified Files -- contrib/pg_upgrade/controldata.c |6 -- contrib/pg_upgrade/pg

Re: [COMMITTERS] pgsql: Add CREATE RECURSIVE VIEW syntax

2013-02-28 Thread Peter Eisentraut
On Thu, 2013-02-28 at 14:38 +, Thom Brown wrote: > Recursive views aren't updatable, but the error message may be > considered a bit confusing to those who don't realise that recursive > views are converted to recursive CTEs. > > postgres=# UPDATE vpeople SET last_person = last_person || ' tes