[BUGS] Re: BUG #7971: Xml special symbols are not unescaped when gettting value of Xml via xpath

2013-06-18 Thread Вилен Тамбовцев
Is there any status/progress about this bug? Looks like this bug is not very difficult to fix, but it is really annoying. -- Вилен Тамбовцев -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www

[BUGS] BUG #8237: CASE Expression - Order of expression processing

2013-06-18 Thread andrea
The following bug has been logged on the website: Bug reference: 8237 Logged by: Andrea Lombardoni Email address: and...@lombardoni.ch PostgreSQL version: 9.0.4 Operating system: Linux Description: I observed the following behaviour (I tested the following statements

Re: [BUGS] BUG #8237: CASE Expression - Order of expression processing

2013-06-18 Thread Andres Freund
On 2013-06-18 13:17:14 +, and...@lombardoni.ch wrote: > template1=# SELECT CASE WHEN 1=0 THEN 0 ELSE 1/0 END; > ERROR: division by zero > > > In this case the CASE behaves as expected. > > > But in the following expression: > > > template1=# SELECT CASE WHEN (SELECT 0)=0 THEN 0 ELSE 1/0

Re: [BUGS] BUG #8237: CASE Expression - Order of expression processing

2013-06-18 Thread Pavel Stehule
2013/6/18 Andres Freund : > On 2013-06-18 13:17:14 +, and...@lombardoni.ch wrote: >> template1=# SELECT CASE WHEN 1=0 THEN 0 ELSE 1/0 END; >> ERROR: division by zero >> >> >> In this case the CASE behaves as expected. >> >> >> But in the following expression: >> >> >> template1=# SELECT CASE W

[BUGS] BUG #8236: wal_sync_method open_datasync unavailable

2013-06-18 Thread akifo
The following bug has been logged on the website: Bug reference: 8236 Logged by: Ivan Email address: ak...@akifo.net PostgreSQL version: 8.4.4 Operating system: CEntOS 5.4 Description: Sync method ":open_datasync" daclared as supported ( http://www.postgresql.org/docs

Re: [BUGS] BUG #8236: wal_sync_method open_datasync unavailable

2013-06-18 Thread Hari Babu
On Tuesday, June 18, 2013 10:55 AM Ivan wrote >Sync method ":open_datasync" daclared as supported ( >http://www.postgresql.org/docs/8.4/static/runtime-config-wal.html ) >But after changing this parameter I've got the following error: >FATAL: invalid value for parameter "wal_sync_method": "open_d

[BUGS] BUG #8238: duplicate of bug #6372 on panffs

2013-06-18 Thread james . e . hughes
The following bug has been logged on the website: Bug reference: 8238 Logged by: Jim Hughes Email address: james.e.hug...@boeing.com PostgreSQL version: 9.1.4 Operating system: SLES 11 Description: Upon creating a database on a panfs (Panasas proprietary fs) directory

[BUGS] BUG #8239: postgresql cannot run after install with apt-get because of permisions

2013-06-18 Thread niflheim123
The following bug has been logged on the website: Bug reference: 8239 Logged by: Niflheim123 Email address: niflheim...@gmail.com PostgreSQL version: 9.1.0 Operating system: Kali Linux ARM Chroot Android Description: If I run apt-get install postgresql in an chroot e

Re: [BUGS] BUG #8237: CASE Expression - Order of expression processing

2013-06-18 Thread Tom Lane
Andres Freund writes: > On 2013-06-18 13:17:14 +, and...@lombardoni.ch wrote: >> template1=# SELECT CASE WHEN (SELECT 0)=0 THEN 0 ELSE 1/0 END; >> ERROR: division by zero > Hrmpf. This is rather annoying. Annoying, maybe. Bug, no. The manual is pretty clear that you don't have a lot of co