Re: [BUGS] BUG #4027: backslash escaping not disabled in plpgsql

2008-12-15 Thread Bruce Momjian
Peter Eisentraut wrote: > Tom Lane wrote: > > plpgsql does not consider standard_conforming_strings --- it still uses > > backslash escaping in its function bodies regardless. Since the > > language itself is not standardized, I see no particular reason that > > standard_conforming_strings should

Re: [BUGS] BUG #4582: Renaming sequences and default value

2008-12-15 Thread Tom Lane
"Jan-Peter Seifert" writes: > there's a problem with renaming sequences in our databases. I don't think there's really a problem here. You've apparently got some obsolete syntax in your CREATE commands: > id integer NOT NULL DEFAULT nextval(('public.t2_id_seq'::text)::regclass) This specific

Re: [BUGS] BUG #4575: All page cache in shared_buffers pinned (duplicated by OS, always)

2008-12-15 Thread Scott Carey
Thanks Tom, Gregory, and Pavan, I have looked into this on a few other sysstems and what I first thought was a Linux issue, then thought was Postgres related, looks more like Linux again. There is a combination of more memory than expected not being able to drop from the OS page cache, and som

[BUGS] BUG #4582: Renaming sequences and default value

2008-12-15 Thread Jan-Peter Seifert
The following bug has been logged online: Bug reference: 4582 Logged by: Jan-Peter Seifert Email address: jan-peter.seif...@gmx.de PostgreSQL version: 8.3.5 Operating system: Windows xp Description:Renaming sequences and default value Details: Hello PostgreSQL-Team,

[BUGS] BUG #4576: Postgres Windows service crashes

2008-12-15 Thread Karsten Silz
The following bug has been logged online: Bug reference: 4576 Logged by: Karsten Silz Email address: ks...@seldonsystems.com PostgreSQL version: 8.3.5.2 Operating system: German XP Pro SP 3 Description:Postgres Windows service crashes Details: I downloaded the one-c

Re: [BUGS] BUG #4581: Difficult uninstall

2008-12-15 Thread Henrik . Svensson
Thanks Dave for your quick reply. So, as I understand it, the registry entries are left to simplify e.g. at reinstallation enabling skip of some steps in the wizard. The reason I was asking, is that I tried an application I have made on a number of persons, and that some of them forgot the passw

Re: [BUGS] BUG #4581: Difficult uninstall

2008-12-15 Thread Dave Page
On Mon, Dec 15, 2008 at 4:40 PM, wrote: > Thanks Dave for your quick reply. > > So, as I understand it, the registry entries are left to simplify e.g. at > reinstallation enabling skip of some steps in the wizard. > The reason I was asking, is that I tried an application I have made on a > numbe

Re: [BUGS] BUG #4581: Difficult uninstall

2008-12-15 Thread Dave Page
On Mon, Dec 15, 2008 at 3:41 PM, Henrik Svensson wrote: > > The following bug has been logged online: > > Bug reference: 4581 > Logged by: Henrik Svensson > Email address: henrik.svens...@mydata.se > PostgreSQL version: 8.3.1 > Operating system: Windows XP SP2 > Description:

[BUGS] BUG #4581: Difficult uninstall

2008-12-15 Thread Henrik Svensson
The following bug has been logged online: Bug reference: 4581 Logged by: Henrik Svensson Email address: henrik.svens...@mydata.se PostgreSQL version: 8.3.1 Operating system: Windows XP SP2 Description:Difficult uninstall Details: To remove PostgreSQL so you can rein

Re: [BUGS] BUG #4568: sporadic error doing COUNT(*) on empty table

2008-12-15 Thread Alvaro Herrera
Sameer Mahajan escribió: > How do I follow up on such bugs (helping narrowing down the issue, > getting a fix etc.)? Reply via email just like you're doing, making sure pgsql-bugs is on Cc: -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - C

Re: [BUGS] BUG #4580: select substring ('a' from '(b)?(a)') returns null

2008-12-15 Thread Tom Lane
"substring and regular expresssion" writes: > substring ('a' from '(b)?(a)') returns 'a' in version 8.2.x, > but null with 8.3.5. Comparing this to the bug entry > http://archives.postgresql.org/pgsql-bugs/2008-11/msg00112.php I guess this > is not considered as a bug No, the old behavior was a

[BUGS] BUG #4580: select substring ('a' from '(b)?(a)') returns null

2008-12-15 Thread substring and regular expresssion
The following bug has been logged online: Bug reference: 4580 Logged by: substring and regular expresssion Email address: m.ma...@intershop.de PostgreSQL version: 8.3.5 Operating system: Linux Description:select substring ('a' from '(b)?(a)') returns null Details: H

Re: [BUGS] BUG #4568: sporadic error doing COUNT(*) on empty table

2008-12-15 Thread Sameer Mahajan
How do I follow up on such bugs (helping narrowing down the issue, getting a fix etc.)? This is the first time I am reporting a bug on this alias. Thanks, Sameer -Original Message- From: John R Pierce [mailto:pie...@hogranch.com] Sent: Sunday, December 14, 2008 11:31 PM To: Gurjeet Sin