PgSql

Pretty printed trigger in psql
Takahiro Itagaki <itagaki.takahiro(a)oss.ntt.co.jp> writes: The attached patch eliminates unneeded parentheses by using pg_get_triggerdef(pretty = true) in psql. Is this patch reversed? It seems so but the listed file timestamps don't match that idea ... regards, tom lane -- Sent via pgsql-hackers m... 19 Jan 2010 01:25

improving log management
Euler Taveira de Oliveira <euler(a)timbira.com> writes: I want to propose a new command to be execute after the log file is rotated. (1) Windows compatibility? (2) What happens if the command takes a significant amount of time to execute? We can't afford to have the log collector blocked. (3) What do you... 14 Jan 2010 07:56

Odd cruft in .psql_history in HEAD
Jim Nasby <decibel(a)decibel.org> writes: I noticed odd stuff showing up when I fired up an 8.3 psql after using psql in HEAD. It shows up in .psql_history as well: Platform? readline version? regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org) To make changes to you... 10 Feb 2010 22:28

[HACKERS] Odd cruft in .psql_history in HEAD
I noticed odd stuff showing up when I fired up an 8.3 psql after using psql in HEAD. It shows up in .psql_history as well: decibel(a)platter.1[20:32]~:5%tail -n 2 .psql_history \134df+\040tools.raise_exception \df+ tools.raise_exception decibel(a)platter.1[20:35]~:6% (last entry is from the 8.3 psql) -- Jim C. N... 13 Jan 2010 22:13

per-user pg_service.conf
Peter Eisentraut <peter_e(a)gmx.net> writes: I was surprised/annoyed to find out that there is no way to have per-user pg_service.conf, something like ~/.pg_service.conf (well, except by export PGSYSCONFDIR). That would be easy to add. Comments? +1. I'll use it the day it exists. -- dim -- Sent v... 20 Jan 2010 16:18

[HACKERS] per-user pg_service.conf
I was surprised/annoyed to find out that there is no way to have per-user pg_service.conf, something like ~/.pg_service.conf (well, except by export PGSYSCONFDIR). That would be easy to add. Comments? -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org) To make changes to your subscription:... 13 Jan 2010 17:46

[HACKERS] segmentation fault in function
I am realizing gist index and get a bug, that crashes DB. I' debugged my program as Robert(thanks !) advised me and I know which procedure crashed. *Datum gist_mov_consistent(PG_FUNCTION_ARGS)* *{* * GISTENTRY *entry = (GISTENTRY *)PG_GETARG_POINTER(0);* * BOX *query = PG_GETARG_BOX_P(1);* * StrategyNu... 13 Jan 2010 16:36

[HACKERS] Add utility functions to plperl [PATCH]
This is the first of the patches to be split out from the former 'plperl feature patch 1'. Changes in this patch: - Added utility functions: quote_literal, quote_nullable, quote_ident, encode_bytea, decode_bytea, looks_like_number, encode_array_literal, encode_array_constructor. - Stored procedure s... 13 Jan 2010 16:36

TPR-tree crash WAS: NEED HELP !
Sergej, I can not understand why DB is restarting ? It is restarting when SQL begins use index :((( Can anybody help me , I would by appretiate every people who downloads my sources, try to deploy index and maybe solve where is the problem. It would help if you gave people a link. Also, if you are R... 13 Jan 2010 14:20

[HACKERS] PgEast CFP (second call)
January 13, 2010 PostgreSQL Conference East, The PostgreSQL Conference for Decision Makers, End Users and Developers, is being held at the Radisson Plaza, Warwick Hotel in Philadelphia on March 25th through 28th. This is the second call for papers for this conference. You can review the skeletal agenda here: ... 13 Jan 2010 14:20