Re: [HACKERS] SHOW TABLES

2010-07-16 Thread Tim Landscheidt
Simon Riggs si...@2ndquadrant.com wrote: [...] Light switches are usually at shoulder height next to a door. Our light switches are 2 metres up, on the far side of the room. People are sick of banging their knees on furniture while trying to grope for the light. The light switch isn't so

Re: [HACKERS] SHOW TABLES

2010-07-16 Thread Tim Landscheidt
Kevin Grittner kevin.gritt...@wicourts.gov wrote: postgres=# SHOW ME THE MONEY; WARNING: THE MONEY is deprecated in this version of Postgres and may be discarded in a future version HINT: Use SHOW ME THE NUMERIC with the desired precision instead. Funny, but no longer true:

Re: [HACKERS] cvs to git migration - keywords

2010-07-07 Thread Tim Landscheidt
Tom Lane t...@sss.pgh.pa.us wrote: 1) We can migrate the repository with the keywords, and then make one big commit just after (or before, that doesn't make a difference) removing them. In this case, backbranches and tags look exactly like they do now, but it also means if you do git diff

[HACKERS] Extraneous newlines in logfile from vacuumdb

2009-10-27 Thread Tim Landscheidt
Hi, log file entries from running vacuumdb are double-spaced, as vacuumdb ends the commands with ;\n (cf. attached mini- patch). Is there a deeper meaning in that, or could it be trimmed? TIA, Tim Index: vacuumdb.c === RCS file:

[HACKERS] Feature Request: generate_series(DATE, DATE) and generate_series(DATE, DATE, INT)

2009-10-12 Thread Tim Landscheidt
Hi, as discussed on -general, I'd like to propose that Post- greSQL provides generate_series(DATE, DATE) and generate_series(DATE, DATE, INT) functions by default. They are merely syntactic sugar for generate_series($1::TIMESTAMP, $2::TIMESTAMP[, '$3 days'::INTERVAL])::DATE and can be used