Re: [BUGS] Bug with Tsearch and tsvector

2010-05-01 Thread Jasen Betts
On 2010-04-29, Tom Lane wrote: > Jasen Betts writes: >> \ is popular in URIs on some platfroms, or is URI a different beast > > I hope not, because \ is explicitly disallowed by both the older and > newer versions of that RFC. I should have known better than to assume that Microsoft was using a

[BUGS] CVS build problem - make world target

2010-05-01 Thread Vladimir Kokovic
Hi, System Configuration: -- Architecture : 2 x Intel(R) Pentium(R) 4 CPU 3.20GHz, MMX SSE SSE2 Operating System : DISTRIB_ID=Ubuntu, DISTRIB_RELEASE=10.04, DISTRIB_CODENAME=lucid,DISTRIB_DESCRIPTION="Ubuntu 10.04 LTS" Linux vlD-kuci 2.6.32-2

[BUGS] PostgreSQL 8.4 - dumping database connection privileges

2010-05-01 Thread Russell Smith
Hi, I've recently upgraded to PostgreSQL 8.4 as Redhat had begun supporting it. I have tried to dump database grants, but have only found an obscure way to do it. I would expect; postgres$ pg_dump -Fc database_name > backup.pgdump would include all of the GRANT CONNECT on database_name TO "Rol

Re: [BUGS] BUG #5444: Database Backup Restore - Out of memory problem

2010-05-01 Thread Robert Haas
On Fri, Apr 30, 2010 at 4:37 AM, Chaminda Jayawardana wrote: > The following bug has been logged online: > > Bug reference:      5444 > Logged by:          Chaminda Jayawardana > Email address:      wpgchami...@gmail.com > PostgreSQL version: 8.3 > Operating system:   Windows Server 2003 > Descrip

Re: [BUGS] PostgreSQL 8.4 - dumping database connection privileges

2010-05-01 Thread Tom Lane
Russell Smith writes: > Is this considered a bug that the only way to do a dump/restore with > database privileges is to use pg_dumpall? No, that's the intended place for them given the current division of labor between pg_dump and pg_dumpall. There have been complaints before about this, but no

Re: [BUGS] [9.0beta5/cvs head] build failure due to unchecked results

2010-05-01 Thread Martin Pitt
Tom Lane [2010-04-30 12:51 -0400]: > I concur, those two changes look worthwhile. The proposed Assert() > additions are right out, though, as they would turn write failures > into database crashes. Right, that might be too strong. > The current code doesn't even think that such a failure is wort

Re: [BUGS] plpython memory leak uppon empty resultsets in all versions

2010-05-01 Thread Tom Lane
Andres Freund writes: > The one I measured was 9.0 only: > diff --git a/src/pl/plpython/plpython.c b/src/pl/plpython/plpython.c > index 6063628..a6dd9d0 100644 > *** a/src/pl/plpython/plpython.c > --- b/src/pl/plpython/plpython.c > *** plpython_inline_handler(PG_FUNCTION_ARGS >

Re: [BUGS] CVS build problem - make world target

2010-05-01 Thread Tom Lane
Vladimir Kokovic writes: > make[3]: Circular postgres.xml <- postgres.sgml dependency dropped. [ followed by havoc as make passes the wrong $< file to osx ] I can reproduce this when doing "make all" in doc/src/sgml in a VPATH build, but not when doing it in the regular source tree. I'm not sure

Re: [BUGS] CVS build problem - make world target

2010-05-01 Thread Tom Lane
I wrote: > Vladimir Kokovic writes: >> make[3]: Circular postgres.xml <- postgres.sgml dependency dropped. > [ followed by havoc as make passes the wrong $< file to osx ] > I can reproduce this when doing "make all" in doc/src/sgml in a > VPATH build, but not when doing it in the regular source

Re: [BUGS] PostgreSQL 8.4 - dumping database connection privileges

2010-05-01 Thread Russell Smith
On 02/05/10 01:36, Tom Lane wrote: > Russell Smith writes: > >> Is this considered a bug that the only way to do a dump/restore with >> database privileges is to use pg_dumpall? >> > No, that's the intended place for them given the current division of > labor between pg_dump and pg_dumpall