[PATCHES] default timezone in postgresql.conf

Changes the doc's to reflect what the user will find as default. -- Robert Treat Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL Index: runtime.sgml === RCS file: /projects/cvsroot/pgsql/doc/src/sgml/runtime.sgml,v re

Re: [PATCHES] pg_resetxlog as root

On Sun, 2004-12-12 at 23:59 +, Dave Page wrote: > Sounds reasonable to me. Attached is a patch that implements this. src/port/backend/win32/security.c is moved to src/port/win32_security.c, and conditionally added to LIBOBJS. Note that I don't have much experience with the build system, and le

Re: [PATCHES] pt_BR FAQ update

Patch applied. Thanks. --- Euler Taveira de Oliveira wrote: > Hi, > > This little patch change my e-mail address in the FAQ. If it's possible > yet, please apply it to HEAD. > > > > = > Euler Taveira de Oliveira >

Re: [PATCHES] Optional REFERENCES Feature in CREATE TRIGGER Command

[EMAIL PROTECTED] writes: > The attached patch adds the optional REFERENCES syntax in CREATE TRIGGER > statement to make an automatic alias for OLD/NEW record during trigger > setup. The implementation of this new feature makes CREATE TRIGGER > command more compatible to SQL standard, and allows t

Re: [PATCHES] Optional REFERENCES Feature in CREATE TRIGGER Command

This has been saved for the 8.1 release: http:/momjian.postgresql.org/cgi-bin/pgpatches2 --- [EMAIL PROTECTED] wrote: > Hi, > > The attached patch adds the optional REFERENCES syntax in CREATE TRIGGER > statement t

[PATCHES] Optional REFERENCES Feature in CREATE TRIGGER Command

Hi, The attached patch adds the optional REFERENCES syntax in CREATE TRIGGER statement to make an automatic alias for OLD/NEW record during trigger setup. The implementation of this new feature makes CREATE TRIGGER command more compatible to SQL standard, and allows the future implementation of e

Re: [PATCHES] pg_get_viewdef returns one paren too much

Andreas Pflug <[EMAIL PROTECTED]> writes: > [EMAIL PROTECTED] noticed a problem with pg_get_viewdef > in prettyprint mode. Applied in HEAD and 7.4 branches. regards, tom lane ---(end of broadcast)--- TIP 1: subscribe and un

Re: [PATCHES] pg_resetxlog as root

> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Neil Conway > Sent: 12 December 2004 22:57 > To: pgsql-patches > Subject: [PATCHES] pg_resetxlog as root > > I suppose a similar fix is needed for Win32? If so, > pgwin32_is_admin() would be the na

[PATCHES] pg_resetxlog as root

We should prevent pg_resetxlog from being run as root: it writes new files to $PGDATA, so running the tool as root will result in those files being owned by root, which makes the data directory unusable. Attached is a trivial patch that makes this change for Unix. I suppose a similar fix is needed

Re: [PATCHES] [HACKERS] regression script/makefile exit failure

Andrew Dunstan wrote: > Attached patch has been tested on Cygwin and found to work as > expected when initdb fails during make check - I don't have access to > a FreeBSD machine to do a test buildfarm run. Patch installed. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---

[PATCHES] (8.1) to_timestamp correction (epoch to timestamptz)

TC\' ) at time zone \'UTC\' '; Michael Glaesemann grzm myrealbox com to_timestamp-20041212.diff Description: application/text ---(end of broadcast)--- TIP 8: explain analyze is your friend