pgsql-bugs@postgresql.org discussions for October 2005

33	BUG #1993: Adding/subtracting negative time intervals changes time zone of result

The following bug has been logged online: Bug reference: 1993 Logged by: Nicholas Email address: [email protected] PostgreSQL version: 8.0.3,8.0.4,8.1 Operating system: Gentoo Linux Description: ...

Nicholas
Oct 24, 2005 at 12:38 am
Oct 27, 2005 at 2:53 am

32	BUG #1931: ILIKE and LIKE fails on Turkish locale

The following bug has been logged online: Bug reference: 1931 Logged by: Devrim GUNDUZ Email address: [email protected] PostgreSQL version: 8.1beta2 Operating system: Linux (RHEL 4, Debian 3.1) ...

Devrim Gündüz
Oct 1, 2005 at 3:40 pm
Oct 2, 2006 at 9:35 pm

23	BUG #1947: Enhancement Request - CONCAT() function

The following bug has been logged online: Bug reference: 1947 Logged by: Tony Marston Email address: [email protected] PostgreSQL version: 8.0.3 Operating system: Windows XP Description: ...

Tony Marston
Oct 8, 2005 at 11:44 am
Oct 20, 2005 at 5:16 pm

19	BUG #1937: Parts of information_schema only accessible to owner

The following bug has been logged online: Bug reference: 1937 Logged by: Tony Marston Email address: [email protected] PostgreSQL version: 8.0.3 Operating system: Windows XP Description: ...

Tony Marston
Oct 4, 2005 at 1:40 pm
Jun 14, 2006 at 9:56 pm

15	Problem with COPY in 8.0.3

Pg 8.0.3 (Debian package) on AMD64, linux 2.6.12 I am importing a table using COPY. The data is tab-delimited. COPY seems to be putting the data for one field into the preceding field, which should ...

Oliver Elphick
Oct 12, 2005 at 8:08 am
Oct 18, 2005 at 8:01 am

14	BUG #1956: Plpgsql top-level DECLARE does not share scope with CREATE FUNCTION

The following bug has been logged online: Bug reference: 1956 Logged by: Karl O. Pinc Email address: [email protected] PostgreSQL version: 8.0.3 Operating system: Linux Description: Plpgsql top-level ...

Karl O. Pinc
Oct 11, 2005 at 4:30 pm
Oct 17, 2005 at 12:39 am

8	BUG #1962: ECPG and VARCHAR

The following bug has been logged online: Bug reference: 1962 Logged by: Charles Wegrzyn Email address: [email protected] PostgreSQL version: 8.0.4 Operating system: Linux : 2.6.13-r4 ...

Charles Wegrzyn
Oct 13, 2005 at 1:35 pm
Oct 20, 2005 at 2:11 pm

7	BUG #1953: trigger action on delete

The following bug has been logged online: Bug reference: 1953 Logged by: incheol yang Email address: [email protected] PostgreSQL version: 8.0.4 Operating system: fedora core 4 Description: trigger ...

Incheol yang
Oct 11, 2005 at 12:26 pm
Oct 13, 2005 at 4:04 am

7	Possibly corrupted shared memory, PostgreSQL 8.1 beta2, Windows 2000

Hi, I've installed PostgreSQL 8.1 beta2 five days ago and it crashed 3 times since then. Here is what's been logged for the last crash 2005-10-04 11:00:19 FATAL: could not read block 121 of relation ...

Jean-Pierre Pelletier
Oct 4, 2005 at 4:24 pm
Oct 11, 2005 at 12:36 pm

6	BUG #2000: psql does not prompt for password

The following bug has been logged online: Bug reference: 2000 Logged by: Todd Email address: [email protected] PostgreSQL version: 8.1 Beta 4 Operating system: Windows Xp home Description: psql ...

Todd
Oct 26, 2005 at 2:40 am
Jan 19, 2006 at 9:59 pm

6	BUG #2001: Signal 11 after concurrent inserts + updates

The following bug has been logged online: Bug reference: 2001 Logged by: Telin Lin Email address: [email protected] PostgreSQL version: 8.0.4 Operating system: Red Hat Linux 3.2.3-47 Description: ...

Telin Lin
Oct 26, 2005 at 8:39 am
Oct 27, 2005 at 4:39 pm

6	Index name different from constraint name

Greetings, Not entirely sure if this would be considered a 'bug' but it's certainly annoying and creates some confusion. Basically, it's like this: test= create table a ( test( b int primary key ...

Stephen Frost
Oct 26, 2005 at 2:26 pm
Oct 27, 2005 at 2:16 pm

5	BUG #1970: Existing /etc/pam.d/postgresql clobbered by RPM install

The following bug has been logged online: Bug reference: 1970 Logged by: Mark Gibson Email address: [email protected] PostgreSQL version: 8.0.4 Operating system: Redhat Enterprise Linux 4 ...

Mark Gibson
Oct 17, 2005 at 7:58 am
Oct 29, 2005 at 9:50 pm

5	BUG #1986: Please include ONE BIG .txt and .HTML file in docs.tar.gz

The following bug has been logged online: Bug reference: 1986 Logged by: Jari Aalto Email address: [email protected] PostgreSQL version: 8.0.4 Operating system: Windows 2000 sp 5 Description: ...

Jari Aalto
Oct 21, 2005 at 3:43 pm
Oct 24, 2005 at 9:34 am

4	BUG #1963: SSL certificate permission check is too strict

The following bug has been logged online: Bug reference: 1963 Logged by: Martin Pitt Email address: [email protected] PostgreSQL version: 8.1beta3 Operating system: Debian Description: SSL certificate ...

Martin Pitt
Oct 13, 2005 at 4:38 pm
Oct 16, 2005 at 9:45 am

4	building Postgresql 7.3.10 on Mac OS X 10.4

Hello I am trying to build Postgresql 7.3.10 on Mac OS X 10.4 and am getting a couple errors related to bootstrap libraries. These are occuring during make -C bootstrap all. Here is the output: make ...

Peter Bazeley
Oct 12, 2005 at 7:40 pm
Oct 13, 2005 at 4:36 pm

3	pg_dump bud with functions

Hello, PostgreSQL 8.0.x, 8.1beta3, WinXP Pro SP2 When I create a function in sql or plpgsql languages, their body text is stored in the database files with 0D 0A line ends (I checked it in a hex ...

Ivan
Oct 27, 2005 at 2:26 pm
Oct 31, 2005 at 9:25 am

3	BUG #1999: contrib/spi doesn't receive the configured CFLAGS

The following bug has been logged online: Bug reference: 1999 Logged by: Seneca Cunningham Email address: [email protected] PostgreSQL version: 8.1beta4 Operating system: AIX 5.3 Description: ...

Seneca Cunningham
Oct 25, 2005 at 10:13 pm
Oct 26, 2005 at 3:23 pm

3	RIGHT JOIN is only supported with merge-joinable join conditions, PostgreSQL 8.1 beta3

Hi, I have a query that throws error "RIGHT JOIN is only supported with merge-joinable join conditions". This should allow it to be reproduce. create table table1 (t1id integer not null, extension ...

Jean-Pierre Pelletier
Oct 25, 2005 at 4:03 pm
Oct 25, 2005 at 9:05 pm

3	BUG #1985: cannot insert Chinese character into a table encoded with UTF8

The following bug has been logged online: Bug reference: 1985 Logged by: Jeff Tong Email address: [email protected] PostgreSQL version: 8.1beta3 Operating system: Windows XP Description: cannot insert ...

Jeff Tong
Oct 21, 2005 at 2:58 pm
Oct 25, 2005 at 3:24 am

3	BUG #1972: index error with space character

The following bug has been logged online: Bug reference: 1972 Logged by: Eduardo Soares Email address: [email protected] PostgreSQL version: 8.0.3 Operating system: Linux Fedora 4 Description: index ...

Eduardo Soares
Oct 17, 2005 at 5:11 pm
Oct 19, 2005 at 2:16 am

3	.pgpass does not work for createlang

It seems that for v8.0.4 the createlang will not take .pgpass inputs and always prompts for password. Is this broken for the new version? Well, now I have to type in the password for my database ...

John Shin
Oct 11, 2005 at 1:26 am
Oct 11, 2005 at 9:41 pm

3	Unreliable pg_stat_activity, Windows 2000, PostgreSQL 8.1 beta2

Hi, pg_stat_activity sometimes list no connections or a number of connections much smaller than the number of postgres.exe processes. We also have these messages in our PostgreSQL log approximately ...

Jean-Pierre Pelletier
Oct 3, 2005 at 3:17 pm
Oct 3, 2005 at 10:12 pm

2	My investigations of the postmaster Bus error

Hi PostgreSQL developers! There have already been some reports about the mysterious Bus error that postmaster dies with on some architectures. Since that bites pretty hard, I did some investigations ...

Martin Pitt
Oct 11, 2005 at 7:13 pm
Dec 22, 2005 at 1:56 pm

2	BUG #2009: Unqouted dashes in manpages

The following bug has been logged online: Bug reference: 2009 Logged by: Martin Pitt Email address: [email protected] PostgreSQL version: 8.0.4 Operating system: Linux Description: Unqouted dashes in ...

Martin Pitt
Oct 29, 2005 at 12:48 am
Oct 30, 2005 at 1:21 am

2	BUG #2006: queryoptimizer and comparing a primary key of biginteger and a literal

The following bug has been logged online: Bug reference: 2006 Logged by: Atanas Hristov Email address: [email protected] PostgreSQL version: 8.1 Beta 3 Operating system: FreeBSD 5 ...

Atanas Hristov
Oct 28, 2005 at 7:04 am
Oct 28, 2005 at 4:30 pm

2	BUG #1996: DISTINCT fails with national character varying

The following bug has been logged online: Bug reference: 1996 Logged by: Ludmil Tinkov Email address: [email protected] PostgreSQL version: 7.3.2 Operating system: RedHat 9.0 Description: DISTINCT ...

Ludmil Tinkov
Oct 24, 2005 at 9:33 pm
Oct 26, 2005 at 12:47 pm

2	BUG #1988: keygen not implemented

The following bug has been logged online: Bug reference: 1988 Logged by: Mike Clements Email address: [email protected] PostgreSQL version: 8.0.3 Operating system: WinXP Description: keygen not ...

Mike Clements
Oct 22, 2005 at 8:45 pm
Oct 23, 2005 at 9:55 pm

2	BUG #1976: steps to reproduce BUG #1438: Non UTF-8 client encoding problem

The following bug has been logged online: Bug reference: 1976 Logged by: Stanislav Sukholet Email address: [email protected] PostgreSQL version: 7.4.8.1.FC3.1 Operating system: 2.6.12-1.1378_FC3 ...

Stanislav Sukholet
Oct 19, 2005 at 2:42 am
Oct 22, 2005 at 7:23 am

2	BUG #1982: pgAdmin 1.2.2 crash when refreshing objects

The following bug has been logged online: Bug reference: 1982 Logged by: edward Email address: [email protected] PostgreSQL version: 8.0.3 Operating system: Win2000 WS Description: pgAdmin ...

Edward
Oct 21, 2005 at 9:51 am
Oct 21, 2005 at 4:27 pm

2	BUG #1983: Installation fails when Windows user principal is member of local Administrators group

The following bug has been logged online: Bug reference: 1983 Logged by: Jochen Sauter Email address: [email protected] PostgreSQL version: 8.0.3 Operating system: Windows 2000 / XP ...

Jochen Sauter
Oct 21, 2005 at 12:48 pm
Oct 21, 2005 at 2:08 pm

2	BUG #1978: connection sinks

The following bug has been logged online: Bug reference: 1978 Logged by: mouse Email address: [email protected] PostgreSQL version: 8.0.3 Operating system: Gentoo Linux 2.6.11-r9 Description: ...

Mouse
Oct 20, 2005 at 1:57 am
Oct 21, 2005 at 7:13 am

2

union bug

Hello, PostgreSQL 8.1beta3 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.4.2 (mingw-special) Windows XP SP2 The following query CREATE DOMAIN test_domain AS varchar(64) NOT NULL; CREATE TYPE ...

Ivan
Oct 19, 2005 at 2:12 pm
Oct 20, 2005 at 7:41 am

2	BUG #1974: UTF-8 french postmaster messages corrupted

The following bug has been logged online: Bug reference: 1974 Logged by: Thomas Reiss Email address: [email protected] PostgreSQL version: 8.0.4 Operating system: Linux Fedora Core 1 ...

Thomas Reiss
Oct 18, 2005 at 1:47 pm
Oct 18, 2005 at 2:43 pm

2	BUG #1971: Start Transaction is giving Errors !!!

The following bug has been logged online: Bug reference: 1971 Logged by: Yogaraj. C Email address: [email protected] PostgreSQL version: 7.4.8 Operating system: Linux - Red Hat 9 Description: ...

Yogaraj. C
Oct 17, 2005 at 12:01 pm
Oct 18, 2005 at 2:32 pm

2	Re: [GENERAL] Postgres logs to syslog LOCAL0

[ redirecting to a more appropriate list ] [email protected] writes: I've thought of a theory about this: if the first write_syslog() call occurs before guc.c has read the config file and ...

Tom Lane
Oct 14, 2005 at 5:06 pm
Oct 17, 2005 at 5:19 pm

2	Bug#333854: pg_group file update problems

Package: postgresql-8.0 Version: 8.0.3-13 Severity: important Tags: patch, upstream Here's the problem: db=# CREATE GROUP g1; CREATE GROUP db=# CREATE USER u1 IN GROUP g1; (1) CREATE USER # cat ...

Dennis Vshivkov
Oct 14, 2005 at 6:33 am
Oct 14, 2005 at 3:29 pm

2	BUG #1964: Role membership error

The following bug has been logged online: Bug reference: 1964 Logged by: Kevin Walker Email address: [email protected] PostgreSQL version: 8.1 beta 3 Operating system: Windows XP Description: ...

Kevin Walker
Oct 13, 2005 at 5:47 pm
Oct 14, 2005 at 3:13 pm

2	BUG #1959: readline error exiting psql

The following bug has been logged online: Bug reference: 1959 Logged by: David Wheeler Email address: [email protected] PostgreSQL version: 8.1b3 Operating system: Mac OS X 10.4 "Tiger" ...

David Wheeler
Oct 13, 2005 at 5:50 am
Oct 13, 2005 at 5:45 pm

2	BUG #1958: Postmaster doesn't close open file handles on startup

The following bug has been logged online: Bug reference: 1958 Logged by: Menno Smits Email address: [email protected] PostgreSQL version: 8.0.3 Operating system: Linux (Fedora Core 3) Description: ...

Menno Smits
Oct 13, 2005 at 12:31 am
Oct 13, 2005 at 2:42 pm

2	Two small patches to improve dbf2pg

Hi PostgreSQL developers! A long time ago some Debian user sent me two patches to improve the dbf2pg conversion tool (in contrib). These are applied in the Debian packages for quite a while now ...

Martin Pitt
Oct 6, 2005 at 6:35 pm
Oct 6, 2005 at 11:07 pm

2	BUG #1938: pg_dump mis-intreprets "default now()";

The following bug has been logged online: Bug reference: 1938 Logged by: Jeff MacDonald Email address: [email protected] PostgreSQL version: 8.0.3 Operating system: FreeBSD 5.2.1 Description: ...

Jeff MacDonald
Oct 4, 2005 at 7:34 pm
Oct 6, 2005 at 12:30 pm

2	PostgreSQL Database export from Linux to Windows

Dear All Kindly guid us to export PostgreSQL Database from linux to windows. Regards Nitin

Nitin Tarkar
Oct 4, 2005 at 9:18 am
Oct 4, 2005 at 2:25 pm

2	BUG #1932: initdb.log

The following bug has been logged online: Bug reference: 1932 Logged by: zhangsijing Email address: [email protected] PostgreSQL version: 8.1-beta2 Operating system: WindowsXP Description: initdb.log ...

Zhangsijing
Oct 2, 2005 at 2:54 am
Oct 2, 2005 at 3:11 pm

1	BUG #2010: COPY command does not recognise UTF-8 text files with leading BOM

The following bug has been logged online: Bug reference: 2010 Logged by: Roddi Walker Email address: [email protected] PostgreSQL version: 8.1 beta 4 Operating system: Win 2000 Professional ...

Roddi Walker
Oct 31, 2005 at 2:45 am
Nov 2, 2005 at 1:21 am

1	BUG #2012: SPI_fnumber sigsegv when compiled with 7.4.8

The following bug has been logged online: Bug reference: 2012 Logged by: Michael Enke Email address: [email protected] PostgreSQL version: 8.0.3 Operating system: Linux SuSE 10 ...

Michael Enke
Oct 31, 2005 at 7:17 pm
Nov 1, 2005 at 2:29 pm

1	Re: concurrent drop table with fkeys corrupt pg_trigger

There might be something to this. I'm running in the neighborhood of ~200 writing transactions per second 24/7 on Postgresql 8.1 beta4 at the moment, and getting some related symptoms. There is a ...

Brandon Black
Oct 31, 2005 at 5:09 pm
Nov 1, 2005 at 2:27 pm

1	importing from 8.0.3 unicode problem

I don't know if this is a bug or my not understanding something. I installed 8.1beta4 on a machine (mac os x 10.4.2). I have my pg_dump file from my running 8.0.3 server in the office (os x 10.3.9). ...

Theodore Petrosky
Oct 30, 2005 at 8:23 pm
Oct 31, 2005 at 4:43 am

1	Fwd: Bug#325114: Postgres Rolling back for no reason

Hi PostgreSQL developers! In Debian we recently received the bug report below, but since I don't know the guts of PostgreSQL so well, could someone please take a look at it? Thanks in advance! Martin ...

Martin Pitt
Oct 30, 2005 at 12:16 pm
Oct 30, 2005 at 4:01 pm

1	i'm unable to download psql servel

hello, How can i get PostgreSQL 7.4.6.. please send reply -- RaghuNath.N 9886534507

RaghuNath
Oct 21, 2005 at 7:28 am
Oct 29, 2005 at 5:13 pm

group	pgsql-bugs @
categories	postgresql
discussions	107
posts	381
users	119
website	postgresql.org
irc	#postgresql

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

PostgreSQL > pgsql-bugs > October 2005

Search Discussions

107 discussions - 381 posts

119 users for October 2005

Content

People

Support

Translate