Re: [PATCHES] create or replace language

2008-05-15 Thread Andreas 'ads' Scherbaum
On Sat, 10 May 2008 09:36:26 +0200 Andreas 'ads' Scherbaum wrote: On Sat, 3 May 2008 21:12:51 +0200 Andreas 'ads' Scherbaum wrote: On Sat, 03 May 2008 13:34:05 -0400 Tom Lane wrote: So maybe the right thing is that CREATE OR REPLACE LANGUAGE can change inessential properties

Re: [PATCHES] create or replace language

2008-05-15 Thread Andreas 'ads' Scherbaum
On Thu, 15 May 2008 12:29:11 +0100 Heikki Linnakangas wrote: Andreas 'ads' Scherbaum wrote: Attached is another version of the patch (still missing documentation), which changes the language owner on update (the owner can still be changed in pg_pltemplate). The other CREATE OR REPLACE

Re: [PATCHES] create or replace language

2008-05-10 Thread Andreas 'ads' Scherbaum
On Sat, 3 May 2008 21:12:51 +0200 Andreas 'ads' Scherbaum wrote: On Sat, 03 May 2008 13:34:05 -0400 Tom Lane wrote: So maybe the right thing is that CREATE OR REPLACE LANGUAGE can change inessential properties of an existing language, but not the core properties --- which might only

Re: [PATCHES] configure option for XLOG_BLCKSZ

2008-05-05 Thread Andreas 'ads' Scherbaum
On Mon, 5 May 2008 11:09:32 -0400 Alvaro Herrera wrote: Andreas 'ads' Scherbaum wrote: On Sat, 03 May 2008 13:14:35 -0400 Tom Lane wrote: Simon Riggs [EMAIL PROTECTED] writes: Not seen any gains from varying the WAL file size since then... I think the use-case for varying

Re: [PATCHES] create or replace language

2008-05-03 Thread Andreas 'ads' Scherbaum
-- Andreas 'ads' Scherbaum German PostgreSQL User Group diff -x CVS -ruN pgsql.orig/src/backend/commands/proclang.c pgsql/src/backend/commands/proclang.c --- pgsql.orig/src/backend/commands/proclang.c 2008-04-29 23:59:02.0 +0200 +++ pgsql/src/backend

Re: [PATCHES] configure option for XLOG_BLCKSZ

2008-05-03 Thread Andreas 'ads' Scherbaum
would save a noticeable amount of bandwith (and cpu cycles for compression). Kind regards -- Andreas 'ads' Scherbaum German PostgreSQL User Group -- Sent via pgsql-patches mailing list (pgsql-patches@postgresql.org) To make changes to your subscription: http

Re: [PATCHES] create or replace language

2008-05-03 Thread Andreas 'ads' Scherbaum
opinion i would prefer not to change the trust flag - some functions may depend on this. The name cannot be changed at all so only the owner and maybe the validator is left ... Did i miss something? Kind regards -- Andreas 'ads' Scherbaum German PostgreSQL User Group

[PATCHES] Documentation: ALTER ROLE - no password

2008-04-29 Thread Andreas 'ads' Scherbaum
Hello, i've seen the question how to remove a password now several times in the last weeks. Attached is a small patch which add a new example for the ALTER ROLE documentation. Kind regards -- Andreas 'ads' Scherbaum German PostgreSQL User Group

Re: [PATCHES] create language ... if not exists

2008-03-30 Thread Andreas 'ads' Scherbaum
. -- Andreas 'ads' Scherbaum German PostgreSQL User Group -- Sent via pgsql-patches mailing list (pgsql-patches@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-patches

Re: [PATCHES] create language ... if not exists

2008-03-30 Thread Andreas 'ads' Scherbaum
and as example is using another handler, the new handler should replace the old one. Correct? So i will change my small patch and reimplement this extension with CREATE OR REPLACE. Thanks all for your useful answers. -- Andreas 'ads' Scherbaum German PostgreSQL

[PATCHES] create language ... if not exists

2008-03-28 Thread Andreas 'ads' Scherbaum
-- Andreas 'ads' Scherbaum German PostgreSQL User Group Index: src/backend/commands/proclang.c === RCS file: /projects/cvsroot/pgsql/src/backend/commands/proclang.c,v retrieving revision 1.77 diff -u -3