[PATCHES] plperl - put schema-name in $_TD

2006-05-24 Thread Adam Sjøgren
Hi. Enclosed is a tiny patch for plperl that puts the schema-name of the current table in $_TD, so triggers can access tables using schemaname.tablename, for instance like so: my $query='INSERT INTO ' . $_TD->{nspname} . '.' . $_TD->{relname} . '_archive (' . $fieldnames . ') VALUES(' . $val

[PATCHES] Allow commenting of variables in postgresql.conf to restore them to defaults

2006-05-24 Thread Zdenek Kotala
There is path implements following item from todo list: "Allow commenting of variables in postgresql.conf to restore them to defaults". Main idea is: General config structure is extend with default_val attribute to keep really default value. (There is small conflict - for string boot_val has sa

Re: [PATCHES] Allow commenting of variables in postgresql.conf to

2006-05-24 Thread Andrew Dunstan
Zdenek Kotala wrote: There is path implements following item from todo list: "Allow commenting of variables in postgresql.conf to restore them to defaults". Main idea is: General config structure is extend with default_val attribute to keep really default value. (There is small conflict - for

Re: [PATCHES] plperl - put schema-name in $_TD

2006-05-24 Thread Andrew Dunstan
Adam Sjøgren wrote: Hi. Enclosed is a tiny patch for plperl that puts the schema-name of the current table in $_TD, so triggers can access tables using schemaname.tablename, for instance like so: my $query='INSERT INTO ' . $_TD->{nspname} . '.' . $_TD->{relname} . '_archive (' . $fieldname

Re: [PATCHES] Allow commenting of variables in postgresql.conf to

2006-05-24 Thread Zdenek Kotala
Andrew Dunstan wrote: Zdenek Kotala wrote: There is path implements following item from todo list: "Allow commenting of variables in postgresql.conf to restore them to defaults". Main idea is: General config structure is extend with default_val attribute to keep really default value. (There i

Re: [PATCHES] Allow commenting of variables in postgresql.conf to

2006-05-24 Thread Alvaro Herrera
Zdenek Kotala wrote: > Andrew Dunstan wrote: > >Zdenek Kotala wrote: > >>There is path implements following item from todo list: "Allow > >>commenting of variables in postgresql.conf to restore them to defaults". > >>Main idea is: > >> > >>General config structure is extend with default_val attrib

Re: [PATCHES] Allow commenting of variables in postgresql.conf to

2006-05-24 Thread Zdenek Kotala
Alvaro Herrera wrote: Zdenek Kotala wrote: Zdenek Kotala wrote: There is path implements following item from todo list: "Allow commenting of variables in postgresql.conf to restore them to defaults". Main idea is: General config structure is extend with default_val attribute to keep

Re: [PATCHES] plperl - put schema-name in $_TD

2006-05-24 Thread Tom Lane
Andrew Dunstan <[EMAIL PROTECTED]> writes: > Adam Sjøgren wrote: >> Enclosed is a tiny patch for plperl that puts the schema-name of the >> current table in $_TD, so triggers can access tables using >> schemaname.tablename, for instance like so: > This seems like a good idea, but we should probabl