PgSql

recovery_connections cannot start
Tom Lane <tgl(a)sss.pgh.pa.us> writes: The only workable alternative I can see to keeping archive_mode is to tell people to set archive_command to something like /usr/bin/true ... which is not simpler, especially not on Windows. Would it be possible to have "internal" commands there, as for example cd i... 27 Apr 2010 11:02

standbycheck was:(Re: [HACKERS] testing hot standby
On Wed, Apr 14, 2010 at 9:16 AM, Jaime Casanova <jcasanov(a)systemguards.com.ec> wrote: On Sat, Apr 10, 2010 at 12:23 AM, Jaime Casanova <jcasanov(a)systemguards.com.ec> wrote: On Fri, Apr 9, 2010 at 3:39 PM, Jaime Casanova <jcasanov(a)systemguards.com.ec> wrote: i think "make standbycheck" needs ... 2 May 2010 10:56

[HACKERS] improve plpgsql's EXECUTE 'select into' message with a hint
Hi, while TFM says that we can use EXECUTE 'select ' INTO instead of the non implemented EXECUTE 'select ... into ', the message in plpgsql fails to say the same thing... seems like a HINT to me -- Atentamente, Jaime Casanova Soporte y capacitación de PostgreSQL Asesoría y desarrollo de sistemas Guayaqu... 26 Apr 2010 02:37

including PID or backend ID in relpath of temp rels
On Sun, Apr 25, 2010 at 8:07 PM, Robert Haas <robertmhaas(a)gmail.com> wrote: 1. We could move the responsibility for removing the files associated with temp rels from the background writer to the owning backend.  I think the reason why we initially truncate the files and only later remove them is because... 4 Jun 2010 20:17

[HACKERS] including PID or backend ID in relpath of temp rels
Time for a new thread specific to this subject. For previous discussion, see here: http://archives.postgresql.org/pgsql-hackers/2010-04/msg01140.php http://archives.postgresql.org/pgsql-hackers/2010-04/msg01152.php I attempted to implement this by adding an isTemp argument to relpath, but ran into problems. ... 25 Apr 2010 21:12

proposal - structured funcid and lineno as new fields in error message
On Mar 29, 2010, at 11:47 AM, Pavel Stehule wrote: 2010/3/29 Tom Lane <tgl(a)sss.pgh.pa.us>: Pavel Stehule <pavel.stehule(a)gmail.com> writes: can we add well structured information about function id and lineno to ErrorData? The idea that I was toying with was to report the function OID and line ... 25 Apr 2010 15:35

pgsql: Add missing optimizer hooks for function cost and number of rows.
Simon Riggs <simon(a)2ndQuadrant.com> writes: We can override table stats but not functions stats. I noticed that hole in the previous implementation, and rectified it with the intention of helping users with what I saw as a small, low risk patch that exactly followed existing code. It would seem I did that t... 24 Apr 2010 13:53

pgsql: Add missing optimizer hooksfor function cost and number of rows.
On Sat, 2010-04-24 at 11:17 -0400, Tom Lane wrote: Robert Haas <robertmhaas(a)gmail.com> writes: On Sat, Apr 24, 2010 at 3:31 AM, Simon Riggs <simon(a)2ndquadrant.com> wrote: Existing hooks were not fully complete in their coverage. That has happened before, and we have discussed that before on hackers,... 24 Apr 2010 12:47

[HACKERS] psql: Add setting to make '+' on \d implicit
I asked on IRC if there was any way to make \d behave like \d+ by default, and davidfetter said no but suggest it here. endpoint_david pointed out you could use \d- to get the old behavior if you wanted to temporarily negate the setting. So the proposal would be: \d+ does as it has always done, no change \d- ... 24 Apr 2010 09:25

Issue with ReRaise in PG
Piyush Newe <piyush.newe(a)enterprisedb.com> writes: Please consider the following test case CREATE OR REPLACE FUNCTION raisetest() returns void AS $$ BEGIN BEGIN RAISE syntax_error; EXCEPTION WHEN syntax_error THEN BEGIN raise notice 'exception ... 24 Apr 2010 09:25