Re: [BUGS] Known issues for PostgreSQL server 8.1.19

Dashputre, Anurag (GE Healthcare) wrote on 20.09.2013 08:39: Thanks for your reply. We can't upgrade to newer version as of now. We just want to know list of known issues on 8.1.19. We will just note them down and do some impact analysis. You will need to go through the release notes for every

Re: [BUGS] Cant start PostgreSQL Using command prompt

John R Pierce, 11.09.2013 19:19: > btw, afaik Windows command prompt has no idea what & means. No, that's not true. See here for example: -- Sent via pgsql-bugs mailing list

Re: [BUGS] BUG #8394: SQL command REINDEX doesn't work

yzh...@trinityusa.com wrote on 23.08.2013 18:00: The following bug has been logged on the website: Bug reference: 8394 Logged by: Yz Primus Email address: yzh...@trinityusa.com PostgreSQL version: 9.1.3 Operating system: Windows 7 64-bit Description: I always received error

Re: [BUGS] Inconsistency between TO_CHAR() and TO_NUMBER()

Tom Lane wrote on 10.05.2013 17:49: I looked into this, and find that the reason it misbehaves is that NUM_numpart_from_char() will treat a '.' as being a decimal point *without any regard to locale considerations*. So even if we have a locale-dependent format string and a locale that says '.' i

[BUGS] Re: BUG #8132: Not Null column should set default value when inserting or setting null

h...@lemcke.com wrote on 02.05.2013 10:18: I would like to have the default value replace a given null value if the column is specified with not null and default. The SQL specification only requires to set the default value when the column is omitted on insert or update. I think this is a flaw

Re: [BUGS] BUG #7967: Wrong week number in extract function

no...@noose.pl wrote on 18.03.2013 09:23: The following bug has been logged on the website: Bug reference: 7967 Logged by: Pawel Kobylak Email address: no...@noose.pl PostgreSQL version: 9.1.3 Operating system: Debian Description: Hi, I'm running that query and result is ..

[BUGS] Re: BUG #7851: Installer crash with message: An error occured executing the Microsoft VC++ runtimeinstaller

Ivano Luberti wrote on 06.02.2013 18:17: Unfortunately the fix doesn't work because it seems the registry key is protected even form administrator user modifications. Even if you run regedit from a command prompt started as Administrator? yes :-( Probably the security settings for the corre

[BUGS] Re: BUG #7748: "drop owned by" fails with error message: "unrecognized object class: 1262"

Tom Lane wrote on 09.12.2012 17:43: spam_ea...@gmx.net writes: postgres=# create user testuser with password 'secret'; CREATE ROLE postgres=# create database testdb owner testuser; CREATE DATABASE testdb=> drop owned by testuser; ERROR: unrecognized object class: 1262 I can reproduce this in

[BUGS] Re: BUG #7748: "drop owned by" fails with error message: "unrecognized object class: 1262"

Tom Lane wrote on 09.12.2012 17:43: spam_ea...@gmx.net writes: postgres=# create user testuser with password 'secret'; CREATE ROLE postgres=# create database testdb owner testuser; CREATE DATABASE testdb=> drop owned by testuser; ERROR: unrecognized object class: 1262 I can reproduce this in

Re: [BUGS] BUG #7505: Backslash escaping not necessary

ovad...@gmail.com wrote on 24.08.2012 21:59: The following bug has been logged on the website: Bug reference: 7505 Logged by: Jeff Ovadya Email address: ovad...@gmail.com PostgreSQL version: 9.1.4 Operating system: PostgreSQL 9.1.4, compiled by Visual C++ build 150 Descripti

[BUGS] Re: BUG #6742: pg_dump doesn't convert encoding of DB object names to OS encoding

exclus...@gmail.com, 18.07.2012 09:17: The following bug has been logged on the website: Bug reference: 6742 Logged by: Alexander LAW Email address: exclus...@gmail.com PostgreSQL version: 9.1.4 Operating system: Windows Description: When I try to dump database with UTF-8 e

[BUGS] Documentation bug regarding collations

in the description of the ORDER BY clause (http://www.postgresql.org/docs/current/static/sql-select.html#SQL-ORDERBY) it says: "Character-string data is sorted according to the locale-specific collation order that was established when the database was created." Which is no longer true with 9.

Re: [BUGS] Weird message when creating PK constraint named like table

Kevin Grittner, 11.01.2012 21:16: When I do this CREATE TABLE "*T1*" ( "T1_ID" bigint NOT NULL, CONSTRAINT "*T1*" PRIMARY KEY ("T1_ID" ) ); I get the following message: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "T1" for table "T1" ERROR: relation "T1" already exist

Re: [BUGS] char(0)

Susanne Ebrecht, 17.10.2011 09:31: Hello, I couldn't find that somebody already mentioned it. PostgreSQL isn't supporting CHAR(0). An empty string has a length of 0. CHAR(0) can have two values: NULL and empty string. In MySQL it is very common to simulate not null boolean by using CHAR(0).

Re: [BUGS] [GENERAL] One-click installer, Windows 7 32-bit, and icacls.exe

Dave Page, 04.10.2011 21:46: We updated our build system to use BitRock 7 today (for unrelated reasons) which has new features for ACL management. We're going to investigate replacing cacls/icacls with those features tomorrow and will create some test builds ASAP. If you can provide the test bu

Re: [BUGS] [GENERAL] One-click installer, Windows 7 32-bit, and icacls.exe

Dave Page wrote on 03.10.2011 10:11: Karl; can you please provide precise details of your Windows version, and anything unusual about your disk configuration? I know this doesn't happen on any of the installations of Windows 7 that we use for testing (which tend to be the MSDN builds, running on

Re: [BUGS] BUG #5348: Postgres crashes with index on xpath_string

. --- Thomas Kellerer wrote: The following bug has been logged online: Bug reference: 5348 Logged by: Thomas Kellerer Email address: tho...@kellerer.name PostgreSQL version: 8.4.2 Operating system: Windows XP Description:Postgres crashes with index on xpath_string

[BUGS] BUG #5348: Postgres crashes with index on xpath_string

The following bug has been logged online: Bug reference: 5348 Logged by: Thomas Kellerer Email address: tho...@kellerer.name PostgreSQL version: 8.4.2 Operating system: Windows XP Description:Postgres crashes with index on xpath_string Details: With the contrib