Re: [HACKERS] sql_drop Event Trigger

2013-03-02 Thread Dimitri Fontaine
Alvaro Herrera alvhe...@2ndquadrant.com writes: Dimitri Fontaine escribió: The good news is that the patch to do that has already been sent on this list, and got reviewed in details by Álvaro who did offer incremental changes. Version 3 of that patch is to be found in:

Re: [HACKERS] Materialized views WIP patch

2013-03-02 Thread Greg Stark
On Fri, Mar 1, 2013 at 3:01 PM, Ants Aasma a...@cybertec.at wrote: . To give another example of potential future update semantics, if we were to allow users manually maintaining materialized view contents using DML commands, one would expect TRUNCATE to mean make this matview empty, not make

Re: [HACKERS] Materialized views WIP patch

2013-03-02 Thread Kevin Grittner
Greg Stark st...@mit.edu wrote: Ants Aasma a...@cybertec.at wrote: To give another example of potential future update semantics, if we were to allow users manually maintaining materialized view contents using DML commands, one would expect TRUNCATE to mean make this matview empty, not make

Re: [HACKERS] scanner/parser minimization

2013-03-02 Thread Greg Stark
Regarding yytransition I think the problem is we're using flex to implement keyword recognition which is usually not what it's used for. Usually people use flex to handle syntax things like quoting and numeric formats. All identifiers are handled by flex as equivalent. Then the last step in the

Re: [HACKERS] scanner/parser minimization

2013-03-02 Thread Tom Lane
Greg Stark st...@mit.edu writes: Regarding yytransition I think the problem is we're using flex to implement keyword recognition which is usually not what it's used for. Usually people use flex to handle syntax things like quoting and numeric formats. All identifiers are handled by flex as

Re: [HACKERS] scanner/parser minimization

2013-03-02 Thread Robert Haas
On Thu, Feb 28, 2013 at 4:09 PM, Tom Lane t...@sss.pgh.pa.us wrote: I believe however that it's possible to extract an idea of which tokens the parser believes it can see next at any given parse state. (I've seen code for this somewhere on the net, but am too lazy to go searching for it again

Re: [HACKERS] scanner/parser minimization

2013-03-02 Thread Tom Lane
Robert Haas robertmh...@gmail.com writes: On Thu, Feb 28, 2013 at 4:09 PM, Tom Lane t...@sss.pgh.pa.us wrote: I believe however that it's possible to extract an idea of which tokens the parser believes it can see next at any given parse state. (I've seen code for this somewhere on the net, but

Re: [HACKERS] scanner/parser minimization

2013-03-02 Thread Heikki Linnakangas
On 02.03.2013 17:09, Tom Lane wrote: Greg Starkst...@mit.edu writes: Regarding yytransition I think the problem is we're using flex to implement keyword recognition which is usually not what it's used for. Usually people use flex to handle syntax things like quoting and numeric formats. All

[HACKERS] Fix pgstattuple/pgstatindex to use regclass-type as the argument

2013-03-02 Thread Satoshi Nagayasu
Hi, As I wrote before, I'd like to clean up pgstattuple functions to allow the same expressions. Re: [HACKERS] [RFC] pgstattuple/pgstatindex enhancement http://www.postgresql.org/message-id/511ee19b.5010...@uptime.jp My goal is to allow specifying a relation/index with several expressions,