Re: [BUGS] BUG #1350: Backslash ecape charcter violates ISO/ANSI spec

2004-12-16 Thread Bruce Momjian
PostgreSQL Bugs List wrote: > Description:Backslash ecape charcter violates ISO/ANSI spec and is > hazardous > > Details: > > I can't find any option to run the server in a more standard mode for string > escaping rules, of only needing to escape single quotes. The current > backslas

[BUGS] BUG #1350: Backslash ecape charcter violates ISO/ANSI spec and is hazardous

2004-12-16 Thread PostgreSQL Bugs List
The following bug has been logged online: Bug reference: 1350 Logged by: Ken Johanson Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0 Beta Operating system: Any Description:Backslash ecape charcter violates ISO/ANSI spec and is hazardous Details: I c

Re: [BUGS] timestamp arithmetic

2004-12-16 Thread Tom Lane
"Ed L." <[EMAIL PROTECTED]> writes: > Note the queries below generate the same result regardless of the timezone > input: This isn't a bug. Per documentation: : For timestamp [without time zone], any explicit time zone specified in : the input is silently ignored. That is, the resulting date/ti

[BUGS] timestamp arithmetic

2004-12-16 Thread Ed L.
Note the queries below generate the same result regardless of the timezone input: % env | grep TZ PGTZ=CST6CDT TZ=CST6CDT % psql -t -c "select version()" PostgreSQL 8.0.0beta3 on i686-pc-linux-gnu, compiled by GCC 2.96 % psql -t -c "select '1970-01-01 00:00:00+09'::timestamp + '1089352800 sec

Re: [BUGS] Checkpoints occur too frequently

2004-12-16 Thread Tom Lane
Tom Lane <[EMAIL PROTECTED]> writes: > Simon Riggs <[EMAIL PROTECTED]> writes: >> I'd say no code changes for 8.0, now we know what's causing it. A doc >> patch to show the limit is probably just going to annoy the translators >> at this stage also. > We could adjust guc.c to limit checkpoint_segm

Re: [BUGS] BUG #1349: Gap in documentation - pg_dump

2004-12-16 Thread Bruno Wolff III
On Thu, Dec 16, 2004 at 20:21:48 +0100, Piotr Likus <[EMAIL PROTECTED]> wrote: > > Yes, maybe it is insecure, but sometimes "quick and dirty" solutions > are better than no solution at all. > After all you can add "not recommended" note to this tip. The official documentation isn't likely to be

Re: [BUGS] BUG #1349: Gap in documentation - pg_dump

2004-12-16 Thread Bruno Wolff III
On Thu, Dec 16, 2004 at 08:16:56 +, PostgreSQL Bugs List <[EMAIL PROTECTED]> wrote: > > I'm sorry, but I didn't found a better place to report that: > > There is no information how to specify user's password in pg_dump > documentation. I have spent half of day searching for that (pg_hba.co

[BUGS] BUG #1349: Gap in documentation - pg_dump

2004-12-16 Thread PostgreSQL Bugs List
The following bug has been logged online: Bug reference: 1349 Logged by: PiotrL Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4.6 Operating system: Windows Description:Gap in documentation - pg_dump Details: I'm sorry, but I didn't found a better place