pgsql-bugs@postgresql.org discussions for March 2012

36	BUG #6510: A simple prompt is displayed using wrong charset

The following bug has been logged on the website: Bug reference: 6510 Logged by: Alexander LAW Email address: exclusion@gmail.com PostgreSQL version: 9.1.3 Operating system: Windows Description: I'm ...

Exclusion
Mar 3, 2012 at 6:44 pm
Oct 18, 2012 at 3:46 pm

11	BUG #6528: pglesslog still referenced in docs, but no 9.1 support

The following bug has been logged on the website: Bug reference: 6528 Logged by: Stuart Bishop Email address: stuart.bishop@canonical.com PostgreSQL version: 9.1.3 Operating system: Ubuntu ...

Stuart Bishop
Mar 13, 2012 at 9:00 am
Sep 4, 2012 at 6:01 pm

11	Extension tracking temp table and causing update failure

Running Postgres 9.1.3. As far as I can tell, when you do an 'alter table' and add a new column with a new default value a temp table is created and tracked by the extension as a new object, but when ...

Phil Sorber
Mar 6, 2012 at 8:09 pm
Mar 8, 2012 at 10:41 pm

10	BUG #6535: LEFT JOIN on large table is altering data

The following bug has been logged on the website: Bug reference: 6535 Logged by: Aren Cambre Email address: aren@arencambre.com PostgreSQL version: 9.1.3 Operating system: Windows 7 x64 Description: ...

Aren
Mar 16, 2012 at 3:03 pm
Mar 19, 2012 at 9:43 pm

9	Re: [GENERAL] Altering a table with a rowtype column

aha! that's not what you posted last time. you appended 'not null default false'; which inexplicably breaks the ALTER. try this: ALTER TABLE a ADD COLUMN even_more_stuff text not null; ALTER TABLE a ...

Merlin Moncure
Mar 7, 2012 at 5:52 pm
Mar 21, 2012 at 7:58 pm

6	BUG #6534: Passing numeric Bind variables to ODBC driver convers to "Double precision"

The following bug has been logged on the website: Bug reference: 6534 Logged by: Barry Bell Email address: barry_bell@harte-hanks.com PostgreSQL version: 9.1.2 Operating system: Windows Server 2003 ...

Barry_bell
Mar 15, 2012 at 7:05 pm
Apr 12, 2012 at 6:26 am

6	BUG #6511: calling spi_exec_query from non-main package, results in: couldn't fetch $_TD

The following bug has been logged on the website: Bug reference: 6511 Logged by: Mark Murawski Email address: marko@kobaz.net PostgreSQL version: 9.1.3 Operating system: Linux - Debian Squeeze ...

Marko
Mar 3, 2012 at 7:20 pm
Mar 21, 2012 at 6:16 pm

6	BUG #6517: Volatile function erroneously optimized, does not consider change in schema path

The following bug has been logged on the website: Bug reference: 6517 Logged by: Rene van Paassen Email address: rene.vanpaassen@gmail.com PostgreSQL version: 9.1.2 Operating system: Fedora 16 ...

Rene Vanpaassen
Mar 5, 2012 at 11:52 am
Mar 14, 2012 at 8:22 am

5	Download not found for postgreSQL 9.1 for both SUSE and Red Hat on IBM Power (ppc)

Hi, Referring to the document for PostgreSQL 9.1 supported platforms http://www.postgresql.org/docs/9.1/static/supported-platforms.html, it is mentioned that 1. In general, PostgreSQL can be expected ...

Eye Gee
Mar 28, 2012 at 8:03 am
Apr 2, 2012 at 7:07 pm

4	BUG #6522: PostgreSQL does not start

The following bug has been logged on the website: Bug reference: 6522 Logged by: Tatiana Email address: tatypr18@gmail.com PostgreSQL version: 8.3.0 Operating system: Windows Server 2008 R2 Standard ...

Tatypr18
Mar 7, 2012 at 12:42 am
Apr 6, 2012 at 1:25 am

4	check_locale() and the empty string

The following SQL succeeds: create database foodb with template = template0 encoding = 'UTF8' lc_collate='' lc_ctype=''; (any other template fails because it actually checks for a match against the ...

Jeff Davis
Mar 11, 2012 at 6:20 pm
Mar 25, 2012 at 9:07 pm

4	Regression from 8.4 to 9.1.2/9.1.3: Optimizing filters on constants in unions

Hi, not sure if this bug is already known, so sorry if it is ;) Filtering a Union on constant custom type: ------------------------------------------------------------------------------- DROP VIEW v; ...

Claus Stadler
Mar 3, 2012 at 12:59 am
Mar 19, 2012 at 10:42 am

4	BUG #6532: pg_upgrade fails on Python stored procedures

The following bug has been logged on the website: Bug reference: 6532 Logged by: Stuart Bishop Email address: stuart@stuartbishop.net PostgreSQL version: 9.1.3 Operating system: Ubuntu Description: ...

Stuart
Mar 15, 2012 at 1:13 pm
Mar 15, 2012 at 10:09 pm

3	BUG #6530: intarray documentation could do with a warning about operators

The following bug has been logged on the website: Bug reference: 6530 Logged by: Kasper Sandberg Email address: kontakt@sandberg-consult.dk PostgreSQL version: 9.1.3 Operating system: Debian squeeze ...

Kontakt
Mar 13, 2012 at 5:12 pm
Apr 9, 2012 at 4:22 pm

3	BUG #6556: earthdistance module has lacking documentation

The following bug has been logged on the website: Bug reference: 6556 Logged by: Kasper Sandberg Email address: kontakt@sandberg-consult.dk PostgreSQL version: 9.1.3 Operating system: - Description ...

Kontakt
Mar 26, 2012 at 12:00 am
Mar 29, 2012 at 9:55 am

3	BUG #6551: PL/pgSQL: GET DIAGNOSTICS not working for first OUT parameter

The following bug has been logged on the website: Bug reference: 6551 Logged by: Adam Buraczewski Email address: aburacze@gmail.com PostgreSQL version: 9.1.3 Operating system: Linux (Fedora 16) ...

Aburacze
Mar 22, 2012 at 5:38 pm
Mar 22, 2012 at 7:17 pm

3	Fw: Bug in postgresql 8.1

Below error occurs only when i restart postgre 8.1 service when applicaion is running. Otherwise it works fine, but while application is running and i restart postgre 8.1 service. Application ...

Prem tolani
Mar 18, 2012 at 5:13 am
Mar 18, 2012 at 4:11 pm

3	BUG #6513: explain (analyze, buffers) and toasted fields

The following bug has been logged on the website: Bug reference: 6513 Logged by: Maxim Boguk Email address: maxim.boguk@gmail.com PostgreSQL version: 9.0.7 Operating system: Linux Description: I got ...

Maxim Boguk
Mar 5, 2012 at 4:23 am
Mar 12, 2012 at 7:42 pm

3	table row type and query-specified row type do not match

Hello, Perhaps this issue has been resolved in higher sub-versions or in 9.1? In summary, the issue revolves around the data type of a column being changed, but the data type in a dependent rule on ...

Bill MacArthur
Mar 8, 2012 at 7:40 pm
Mar 11, 2012 at 10:16 pm

2	BUG #6565: GEQO documentation discrepancy after 9.0 change?

The following bug has been logged on the website: Bug reference: 6565 Logged by: Guillaume Cottenceau Email address: gcottenc@gmail.com PostgreSQL version: 9.1.3 Operating system: not relevant ...

Gcottenc
Mar 29, 2012 at 7:36 am
Apr 10, 2012 at 12:52 am

2	BUG #6545: le telechargement ne s acheve pas

The following bug has been logged on the website: Bug reference: 6545 Logged by: AYACHI ABDELAKDER Email address: kadas@hotmail.fr PostgreSQL version: 8.3.15 Operating system: poker traker 3 ...

Kadas
Mar 20, 2012 at 6:59 am
Apr 9, 2012 at 4:16 pm

2	Re: BUG #6334: initdb not working

Hi Alvaro, I just compiled version 9.1.3 and got quite the same error. I still do not have any clue what to change, as the compile runs successfully without any error. Regards Wilfried ...

Weiss, Wilfried
Mar 7, 2012 at 10:33 am
Mar 27, 2012 at 10:07 am

2	Subquery with toplevel reference used to work in pg 8.4

I agree the query is a little odd, but I like backwards compatibility! Postgres 8.4.1 ---------------------- CREATE VIEW v_members AS SELECT 1 as member_id, 100 as tenant_id, 3732 as conference_id, ...

Mark Murawski
Mar 24, 2012 at 4:05 am
Mar 24, 2012 at 4:35 pm

2	BUG #6548: NOWAIT does not work in Select statement if table is locked using "Lock " command

The following bug has been logged on the website: Bug reference: 6548 Logged by: Neeraj Punmiya Email address: neeraj.punmiya@securetogether.com PostgreSQL version: 9.1.3 Operating system: CentOS 6.2 ...

Neeraj Punmiya
Mar 21, 2012 at 9:37 am
Mar 21, 2012 at 3:48 pm

2	BUG #6512: Bug with prepared statement and timestamp + interval

The following bug has been logged on the website: Bug reference: 6512 Logged by: Stefano Baccianella Email address: stefano.baccianella@gmail.com PostgreSQL version: 9.1.1 Operating system: Windows 7 ...

Stefano Baccianella
Mar 4, 2012 at 12:48 am
Mar 12, 2012 at 5:38 pm

2	postgresql 9.1 replicaiton query ( GNU/Linux replicate to Windows)

Hi Team, I am doing postgresql 9.1 replication , the Master database is on GNU/Linux operation system , the Slave database is on Windows 32 bit system. But when I copy the Master database from Linux ...

Nie, Guocong
Mar 12, 2012 at 9:32 am
Mar 12, 2012 at 1:48 pm

2	plpgsql doesn't check a number of expressions and number of target variables correctly

Hello I found a plpgsql bug: create or replace function fx() returns void as $$ declare a int; b int; begin select 10,20 into a; end; $$ language plpgsql; this is bug, or minimally potential source ...

Pavel Stehule
Mar 5, 2012 at 7:13 pm
Mar 5, 2012 at 8:09 pm

2	BUG #6518: archive_command stderr not in log if log_destination=syslog

The following bug has been logged on the website: Bug reference: 6518 Logged by: Janning Vygen Email address: vygen@kicktipp.de PostgreSQL version: 9.1.2 Operating system: Linux / Debian Description: ...

Vygen
Mar 5, 2012 at 12:14 pm
Mar 5, 2012 at 7:16 pm

2	BUG #6502: Missing Link at Version Tracker

The following bug has been logged on the website: Bug reference: 6502 Logged by: Ronald Hofmann Email address: prolog@jumbosoft.de PostgreSQL version: Unsupported/Unknown Operating system: MacOSX ...

Prolog
Mar 2, 2012 at 5:41 am
Mar 4, 2012 at 1:13 pm

2	BUG #6500: Installer does not honour --serverport

The following bug has been logged on the website: Bug reference: 6500 Logged by: Thomas Pasch Email address: thomas.pasch@nuclos.de PostgreSQL version: 9.1.3 Operating system: Linux 64 (Ubuntu ...

Thomas Pasch
Mar 1, 2012 at 4:09 pm
Mar 2, 2012 at 7:43 am

2	BUG #6501: postgresql-9.1.3-1-linux.run does not install on 64bit system

The following bug has been logged on the website: Bug reference: 6501 Logged by: Thomas Pasch Email address: thomas.pasch@nuclos.de PostgreSQL version: 9.1.3 Operating system: Linux 64 (Ubuntu ...

Thomas Pasch
Mar 1, 2012 at 6:51 pm
Mar 1, 2012 at 8:49 pm

1	corrupted table postgresql 8.3

Hi people! I have a pg 8.3. Today I issued in a database that comand: =# ALTER TABLE cliente ADD COLUMN pwd_expired boolean DEFAULT FALSE; WARNING: unexpected attrdef record found for attr 22 of rel ...

Matteo Sgalaberni
Mar 6, 2012 at 3:12 pm
Apr 9, 2012 at 2:18 pm

1	BUG #6521: cannot make connection due to "getsockname() failed: Invalid argument"

The following bug has been logged on the website: Bug reference: 6521 Logged by: Jeongho Jeon Email address: maczniak@gmail.com PostgreSQL version: 9.1.1 Operating system: Windows 7 Description: Hi! ...

Maczniak
Mar 6, 2012 at 5:46 am
Apr 9, 2012 at 2:15 pm

1	BUG #6542: installation error

The following bug has been logged on the website: Bug reference: 6542 Logged by: DELCROIX Frédéric Email address: f.delcroix@rdvnet.fr PostgreSQL version: 9.0.7 Operating system: windows ...

F Delcroix
Mar 19, 2012 at 5:16 pm
Apr 9, 2012 at 2:01 pm

1	BUG #6557: post gre sql odbc connection issue

The following bug has been logged on the website: Bug reference: 6557 Logged by: vikas a Email address: vikas.arora@rbs.com PostgreSQL version: 9.0.1 Operating system: Linux and Windows Description ...

Vikas Arora
Mar 26, 2012 at 5:41 am
Apr 9, 2012 at 1:57 pm

1	BUG #6558: installation clusters problems

The following bug has been logged on the website: Bug reference: 6558 Logged by: Sergi Panadero Email address: sergipanadero@digalix.com PostgreSQL version: 9.1.3 Operating system: win XP 32b SP3 ...

Sergipanadero
Mar 26, 2012 at 1:18 pm
Mar 28, 2012 at 9:18 pm

1	possible bug in COPY ... FROM ... NULL '\0'

The documentation says: "The specified null string is sent by COPY TO without adding any backslashes; conversely, COPY FROM matches the input against the null string before removing backslashes." -- ...

Jeff Davis
Mar 25, 2012 at 11:55 pm
Mar 26, 2012 at 12:37 am

1	BUG #6549: Wrong $PATH setting after installation

The following bug has been logged on the website: Bug reference: 6549 Logged by: Jelle Frans van der Woude Email address: jf.vanderwoude@gmail.com PostgreSQL version: 9.1.2 Operating system: OS X ...

Jf Vanderwoude
Mar 21, 2012 at 5:13 pm
Mar 22, 2012 at 11:47 pm

1	BUG #6550: Querry failed while using throung php program.

The following bug has been logged on the website: Bug reference: 6550 Logged by: M K Krishnan Email address: mkkrish@hotmail.com PostgreSQL version: 9.0.4 Operating system: Windows 7 Description ...

Mkkrish
Mar 22, 2012 at 6:00 am
Mar 22, 2012 at 9:23 pm

1	BUG #6529: Invalid numeric input syntax for 'select into' queries

The following bug has been logged on the website: Bug reference: 6529 Logged by: Maxim Turchin Email address: nehxby@gmail.com PostgreSQL version: 9.1.3 Operating system: Ubuntu 11.10 Description: ...

Nehxby
Mar 13, 2012 at 2:19 pm
Mar 22, 2012 at 3:11 am

1	BUG #6543: pgadmin III - Error defining filter.

The following bug has been logged on the website: Bug reference: 6543 Logged by: Cleberson Email address: kebe.1969@gmail.com PostgreSQL version: 9.1.3 Operating system: Windows 7 Description: When ...

Kebe 1969
Mar 19, 2012 at 5:47 pm
Mar 19, 2012 at 9:29 pm

1	Applicatin crashing with on postgresql 8.1 service restart

I running an applicatio in java with postgresql 8.1. When I restart the postgre service the application crashes while it it running. I get this error in windows evenviewer. I am using windows 7. PG ...

Prem tolani
Mar 18, 2012 at 12:45 pm
Mar 19, 2012 at 1:48 pm

1	BUG #6533: postgre server crashes by create function (create table as)

The following bug has been logged on the website: Bug reference: 6533 Logged by: Alex Sanin Email address: vozhdb@gmail.com PostgreSQL version: 9.0.4 Operating system: Windows XP sp3 Description: ...

Vozhdb
Mar 15, 2012 at 2:33 pm
Mar 16, 2012 at 1:55 am

1	BUG #6531: integrity constraint failure

The following bug has been logged on the website: Bug reference: 6531 Logged by: Claudio Oliveira Email address: claudiomsi@hotmail.com PostgreSQL version: 9.1.3 Operating system: windows 7 ...

Claudiomsi
Mar 14, 2012 at 4:07 pm
Mar 14, 2012 at 4:21 pm

1	BUG #6527: Error in COPY documentation syntax

The following bug has been logged on the website: Bug reference: 6527 Logged by: Samuel Gilbert Email address: samuel.gilbert@ec.gc.ca PostgreSQL version: 9.0.4 Operating system: Linux Description: ...

Samuel Gilbert
Mar 12, 2012 at 7:34 pm
Mar 13, 2012 at 7:55 am

1	BUG #6520: BRT FATAL: COULD NOT CREATE ANY TCP/IP SOCKETS

The following bug has been logged on the website: Bug reference: 6520 Logged by: André Luis Kuhn Email address: andrre1402@msn.com PostgreSQL version: 8.3.3 Operating system: Windows XP Description: ...

Andrre1402
Mar 5, 2012 at 4:44 pm
Mar 12, 2012 at 4:03 pm

1	BUG #6526: Intermittent connect issue

The following bug has been logged on the website: Bug reference: 6526 Logged by: Adam Robertson Email address: adam.robertson@arvixe.com PostgreSQL version: 8.3.7 Operating system: Windows Server ...

Adam Robertson
Mar 11, 2012 at 8:46 pm
Mar 11, 2012 at 9:02 pm

1	BUG #6525: t_infomask2 is uint16, not int16

The following bug has been logged on the website: Bug reference: 6525 Logged by: KOIZUMI Satoru Email address: koizumistr@minos.ocn.ne.jp PostgreSQL version: 9.1.3 Operating system: Mac OS X ...

Koizumistr
Mar 11, 2012 at 5:42 am
Mar 11, 2012 at 8:54 pm

1	BUG #6524: lpermission denied to create extension "ltree". Must be superuser to create this extension.

The following bug has been logged on the website: Bug reference: 6524 Logged by: naox Email address: spamik@yum.pl PostgreSQL version: 9.1.3 Operating system: linux Description: CREATE EXTENSION ...

Spamik
Mar 10, 2012 at 3:50 am
Mar 11, 2012 at 7:15 pm

1	BUG #6523: Problems with dbpool()

The following bug has been logged on the website: Bug reference: 6523 Logged by: pradeep Email address: pradeep.vishwakarma@routesms.com PostgreSQL version: 9.1.2 Operating system: Window xp ...

Pradeep Vishwakarma
Mar 7, 2012 at 12:56 pm
Mar 7, 2012 at 3:34 pm

group	pgsql-bugs @
categories	postgresql
discussions	59
posts	188
users	76
website	postgresql.org
irc	#postgresql

summaries	on	Hotkey: s
users list	on	Hotkey: d
user style	avatars	Hotkey: a

PostgreSQL > pgsql-bugs > March 2012

Search Discussions

59 discussions - 188 posts

76 users for March 2012

Content

People

Support

Translate