[HACKERS] psql's is_select_command is naive It knows that queries beginning with "select" or "values" are select commands, but it seems not to be clued in about "table" and "with". For now, we can probably get by with just adding those to the list of things it checks for. But I wonder what we'll do about this if we ever get CTEs for insert/update/delete s... 26 May 2010 22:27
exporting raw parser I think those works are essentially a refactoring of existing raw parser, and will not add performance degration nor maintenance cost. Comments? You should call it "libSQL"; who knows, other DB projects might want it. They seem to borrow our parser enough as it is. -- ... 7 Jun 2010 05:17
[HACKERS] exporting raw parser I'm thinking about exporting the raw parser and related modules as a C library. Though this will not be an immediate benefit of PostgreSQL itself, it will be a huge benefit for any PostgreSQL applications/middle ware those need to parse SQL statements. For example, pgpool-II parses queries to know if it's a read ... 26 May 2010 21:22
Distclean does not remove gram.c Gurjeet Singh <singh.gurjeet(a)gmail.com> writes: The src/backend/parser/gram.c is a generated file, so shouldn't this be removed by `make distclean`, or maybe even by `make clean`? No. It's shipped in distribution tarballs. If you want all derived files to be removed, use make maintainer-clean. regards... 27 May 2010 11:30
CIText and pattern_ops Just picking up a dropped thread, does anyone have a patch for this? http://archives.postgresql.org/pgsql-hackers/2010-04/msg01191.php Best, David -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hacker... 26 May 2010 20:17
functional call named notation clashes with SQL feature Peter Eisentraut wrote: It turns out that the SQL standard uses the function call notation foo(this AS that) for something else: <routine invocation> ::= <routine name> <SQL argument list> <routine name> ::= [ <schema name> <period> ] <qualified identifier> <SQL argument list> ::= <... 5 Jun 2010 18:01
[HACKERS] 9.0 Open Items: Code and Documentation sections Hi! I've spent some time going through all the email threads since Alpha4 was released, and have updated the 9.0 Open Items list. We have two sections of open items which need initial review by -hackers: http://wiki.postgresql.org/wiki/PostgreSQL_9.0_Open_Items#Code http://wiki.postgresql.org/wiki/PostgreSQL... 26 May 2010 18:04
ALTER TABLE...ALTER COLUMN vs inheritance --On 4. November 2009 09:57:27 -0500 Tom Lane <tgl(a)sss.pgh.pa.us> wrote: Yeah, this is a known issue. The ALTER should be rejected, but it is not, because we don't have enough infrastructure to notice that the constraint is inherited and logically can't be dropped. I think the consensus was that the... 16 Jun 2010 15:28
[HACKERS] functional call named notation clashes with SQL feature It turns out that the SQL standard uses the function call notation foo(this AS that) for something else: <routine invocation> ::= <routine name> <SQL argument list> <routine name> ::= [ <schema name> <period> ] <qualified identifier> <SQL argument list> ::= <left paren> [ <SQL argument> [ { <comma> <SQL ... 26 May 2010 16:56
[PATCH] Add _PG_init to PL language handler documentation On Tue, May 25, 2010 at 4:34 AM, Jonathan Leto <jaleto(a)gmail.com> wrote: This tiny doc patch adds _PG_init to the skeleton example code for a PL. The information is quite valuable to PL authors, who might miss it when it is described in the shared library documentation. I'm not sure it does much good to add... 9 Jun 2010 05:21 |