Re: [PATCHES] [BUGS] BUG #4007: chr(0) doesn't work anymore

2008-03-03 Thread Bruce Momjian
Tom Lane wrote: > Steve Clark <[EMAIL PROTECTED]> writes: > > I'm not sure I understand what you mean about TEXT being null-safe. > > What are the issues, and why was > > it supported for years and now abruptly changed. > > It never was supported, we are simply plugging a hole that let you > crea

Re: [PATCHES] CopyReadAttributesCSV optimization

2008-03-03 Thread Bruce Momjian
Your patch has been added to the PostgreSQL unapplied patches list at: http://momjian.postgresql.org/cgi-bin/pgpatches It will be applied as soon as one of the PostgreSQL committers reviews and approves it. --- He

Re: [PATCHES] Remove FATAL from pg_lzdecompress

2008-03-03 Thread Bruce Momjian
Your patch has been added to the PostgreSQL unapplied patches list at: http://momjian.postgresql.org/cgi-bin/pgpatches It will be applied as soon as one of the PostgreSQL committers reviews and approves it. --- Zd

Re: [PATCHES] sinval.c / sinvaladt.c restructuring

2008-03-03 Thread Bruce Momjian
Your patch has been added to the PostgreSQL unapplied patches list at: http://momjian.postgresql.org/cgi-bin/pgpatches It will be applied as soon as one of the PostgreSQL committers reviews and approves it. --- Al

Re: [PATCHES] [BUGS] BUG #4007: chr(0) doesn't work anymore

2008-03-03 Thread Andrew Dunstan
Bruce Momjian wrote: Tom Lane wrote: Steve Clark <[EMAIL PROTECTED]> writes: I'm not sure I understand what you mean about TEXT being null-safe. What are the issues, and why was it supported for years and now abruptly changed. It never was supported, we are simply plugging a

Re: [PATCHES] [BUGS] BUG #4007: chr(0) doesn't work anymore

2008-03-03 Thread Bruce Momjian
BAndrew Dunstan wrote: > > > Bruce Momjian wrote: > > Tom Lane wrote: > > > >> Steve Clark <[EMAIL PROTECTED]> writes: > >> > >>> I'm not sure I understand what you mean about TEXT being null-safe. > >>> What are the issues, and why was > >>> it supported for years and now abruptly chang

Re: [PATCHES] Logging conflicted queries on deadlocks

2008-03-03 Thread Bruce Momjian
Your patch has been added to the PostgreSQL unapplied patches list at: http://momjian.postgresql.org/cgi-bin/pgpatches It will be applied as soon as one of the PostgreSQL committers reviews and approves it. --- IT

Re: [PATCHES] [BUGS] BUG #3973: pg_dump using inherited tables do not always restore

2008-03-03 Thread Alex Hunsaker
On Wed, Feb 20, 2008 at 3:55 PM, Tom Lane <[EMAIL PROTECTED]> wrote: > "Alex Hunsaker" <[EMAIL PROTECTED]> writes: > > create table junk (val integer not null, val2 integer); > > create table junk_child () inherits (junk_1); > > alter table junk_child alter column val drop not null; > > insert

Re: [PATCHES] [HACKERS] new warning message

2008-03-03 Thread Bruce Momjian
Tom Lane wrote: > Jeff Davis <[EMAIL PROTECTED]> writes: > > Would it be reasonable to throw a warning if you revoke a privilege from > > some role, and that role inherits the privilege from some other role (or > > PUBLIC)? > > This has been suggested and rejected before --- the consensus is it'd

Re: [PATCHES] CopyReadLineText optimization

2008-03-03 Thread Bruce Momjian
Your patch has been added to the PostgreSQL unapplied patches list at: http://momjian.postgresql.org/cgi-bin/pgpatches It will be applied as soon as one of the PostgreSQL committers reviews and approves it. --- He

Re: [PATCHES] Bulk Insert tuning

2008-03-03 Thread Bruce Momjian
Added to TODO: o Consider using a ring buffer for COPY FROM http://archives.postgresql.org/pgsql-patches/2008-02/msg00140.php --- Simon Riggs wrote: > On Tue, 2008-02-26 at 15:12 -0500, Tom Lane wrote: >

Re: [PATCHES] Reference by output in : \d

2008-03-03 Thread Bruce Momjian
Your patch has been added to the PostgreSQL unapplied patches list at: http://momjian.postgresql.org/cgi-bin/pgpatches It will be applied as soon as one of the PostgreSQL committers reviews and approves it. --- ke

Re: [PATCHES] [BUGS] Incomplete docs for restore_command for hot standby

2008-03-03 Thread Bruce Momjian
Your patch has been added to the PostgreSQL unapplied patches list at: http://momjian.postgresql.org/cgi-bin/pgpatches It will be applied as soon as one of the PostgreSQL committers reviews and approves it. --- Ma

Re: [PATCHES] [BUGS] BUG #3973: pg_dump using inherited tables do not always restore

2008-03-03 Thread Tom Lane
"Alex Hunsaker" <[EMAIL PROTECTED]> writes: > On Wed, Feb 20, 2008 at 3:55 PM, Tom Lane <[EMAIL PROTECTED]> wrote: >> Actually the bug is that ALTER TABLE allows you to do that. It should >> not be possible to drop an inherited constraint, but right now there's >> not enough information in the sys

Re: [PATCHES] [GENERAL] Empty arrays with ARRAY[]

2008-03-03 Thread Brendan Jurd
A quick recap: I submitted a patch for empty ARRAY[] syntax back in November, and as far as I can see it never made it to the patches list. Gregory suggested a different way of approaching the problem (quoted below), but nobody commented further about how it might be made to work. I'd like to RFC

Re: [PATCHES] [GENERAL] ts_headline

2008-03-03 Thread Bruce Momjian
I have applied the attached documentation patch to show ts_headline() using a configuration name. --- Oleg Bartunov wrote: > On Sat, 23 Feb 2008, Stephen Davies wrote: > > > As it turns out, all I needed was in the doco but

[PATCHES] Re: [BUGS] Incomplete docs for restore_command for hot standby

2008-03-03 Thread Bruce Momjian
Your patch has been added to the PostgreSQL unapplied patches list at: http://momjian.postgresql.org/cgi-bin/pgpatches It will be applied as soon as one of the PostgreSQL committers reviews and approves it. --- Ma