PgSql
in [SQL]
|
providing tokenized version of parsed SQL script -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 28/04/2010 02:20, Robert Haas wrote: On Tue, Apr 27, 2010 at 7:45 PM, Jehan-Guillaume (ioguix) de Rorthais <ioguix(a)free.fr> wrote: I thought Michael was trying to write a tokenizer based on node tree returned by raw_parser. As it seems Michael is not ev... 28 Apr 2010 05:03
Schema.Table.Col resolution seems broken in Alpha5 Josh Berkus <josh(a)agliodbs.com> writes: It appears that something broke the ability to refer to columns by full SQL path names in 9.0. That is, references to columns as schema.table.col will produce a completely bogus error which did not exist on previous versions. My fault :-(. Seems we have no regres... 27 Apr 2010 21:19
road.thepath no longer in pg_stats? Alvaro Herrera <alvherre(a)commandprompt.com> writes: I just noticed that the road.thepath column in the regression database is no longer in pg_stats for some reason after ANALYZE, so the example in section 14.2 in the docs (Statistics Used by the Planner) is now wrong. It's an old example :-( ... a quick ... 27 Apr 2010 21:19
providing tokenized version of parsed SQL script (was: nodeToString format and exporting the SQL parser) On Tue, Apr 27, 2010 at 7:45 PM, Jehan-Guillaume (ioguix) de Rorthais <ioguix(a)free.fr> wrote: I thought Michael was trying to write a tokenizer based on node tree returned by raw_parser. As it seems Michael is not even sure about what he's trying to do, I prefer refocus a bit this thread [...] Having drop... 27 Apr 2010 21:19
Add column if not exists (CINE) On Tue, Apr 27, 2010 at 6:45 PM, Kjell Rune Skaaraas <kjella79(a)yahoo.no> wrote: Hello, I've been reading the earlier threads at: http://archives.postgresql.org/pgsql-hackers/2009-05/thrd7.php#00252 http://archives.postgresql.org/pgsql-hackers/2005-10/thrd4.php#00632 and I'm not sure I have anything th... 2 May 2010 00:10
[HACKERS] road.thepath no longer in pg_stats? Hi, I just noticed that the road.thepath column in the regression database is no longer in pg_stats for some reason after ANALYZE, so the example in section 14.2 in the docs (Statistics Used by the Planner) is now wrong. What I'm trying to do is replace that exceedingly wide output with something along these ... 27 Apr 2010 20:12
[HACKERS] Schema.Table.Col resolution seems broken in Alpha5 Hackers, It appears that something broke the ability to refer to columns by full SQL path names in 9.0. That is, references to columns as schema.table.col will produce a completely bogus error which did not exist on previous versions. The following works perfectly well in 8.4: postgres=# create table test1... 27 Apr 2010 19:05
pgsql: MakeCheckRequiredParameterValues() depend upon correct Heikki Linnakangas escribi�: Tom Lane wrote: How about putting the enum {} declaration in xlog.h, and making the field in pg_control.h just be declared "int"? I tried that at first, but the problem was with pg_controldata.c. In bin/. I wanted it to print wal_mode in human-readable format, so it ... 29 Apr 2010 16:56
pgsql: Make CheckRequiredParameterValues()depend upon correct Tom Lane wrote: Heikki Linnakangas <heikki.linnakangas(a)enterprisedb.com> writes: Ok, here's a patch that includes the changes to add new wal_mode GUC (http://archives.postgresql.org/message-id/4BD581A6.60602(a)enterprisedb.com), I haven't read this in any detail, but why does it add inclusion of pg_c... 29 Apr 2010 14:40
Differential backup Simon Riggs wrote: Thinking about allowing a backup to tell which files have changed in the database since last backup. This would allow an external utility to copy away only changed files. Now there's a few ways of doing this and many will say this is already possible using file access times. ... 28 Apr 2010 15:10 |