Re: [BUGS] BUG #8469: Xpath behaviour unintuitive / arguably wrong

2013-10-04 Thread Stefan Kaltenbrunner
On 10/02/2013 06:19 PM, Bruce Momjian wrote: > On Tue, Sep 24, 2013 at 06:43:19PM +, dennis.noord...@helsinki.fi wrote: >> The following bug has been logged on the website: >> >> Bug reference: 8469 >> Logged by: Dennis >> Email address: dennis.noord...@helsinki.fi >> Postgre

Re: [BUGS] BUG #7762: problem on bytea field data reading

2012-12-20 Thread Stefan Kaltenbrunner
On 12/20/2012 11:17 AM, achyutkuma...@gmail.com wrote: > The following bug has been logged on the website: > > Bug reference: 7762 > Logged by: Achyut kumar Dwivedi > Email address: achyutkuma...@gmail.com > PostgreSQL version: 9.0.0 > Operating system: Windows > Description:

Re: [BUGS] pgcrypto decrypt_iv() issue

2012-01-27 Thread Stefan Kaltenbrunner
On 01/27/2012 07:06 PM, Marko Kreen wrote: > On Fri, Jan 27, 2012 at 8:00 PM, Magnus Hagander wrote: >> On Fri, Jan 27, 2012 at 18:54, Marko Kreen wrote: >>> On Fri, Jan 27, 2012 at 7:34 PM, Stefan Kaltenbrunner >>> wrote: >>>> On 01/27/2012 04:20 PM,

Re: [BUGS] pgcrypto decrypt_iv() issue

2012-01-27 Thread Stefan Kaltenbrunner
On 01/27/2012 04:20 PM, Marko Kreen wrote: > On Fri, Jan 27, 2012 at 01:37:11AM -0500, Tom Lane wrote: >> Stefan Kaltenbrunner writes: >>> from some looking at the code in pgcrypto.c it seems to me that the >>> coding pattern in most functions there only

Re: [BUGS] pgcrypto decrypt_iv() issue

2012-01-24 Thread Stefan Kaltenbrunner
On 01/23/2012 08:40 PM, Stefan Kaltenbrunner wrote: > We are using the raw decryption features of contrib/pgcrypto here to > decode certain AES128 encrypted data. However depending on the data to > decode and what statements have been executed in the same session before > we are seei

[BUGS] pgcrypto decrypt_iv() issue

2012-01-23 Thread Stefan Kaltenbrunner
We are using the raw decryption features of contrib/pgcrypto here to decode certain AES128 encrypted data. However depending on the data to decode and what statements have been executed in the same session before we are seeing different (and sometimes completely wrong) answers this is 9.1.2 on Deb

Re: [BUGS] *.sql contrib files contain unresolvable MODULE_PATHNAME

2011-10-12 Thread Stefan Kaltenbrunner
On 10/12/2011 09:53 AM, Martin Pitt wrote: > Hello all, > > In https://launchpad.net/bugs/835502 it was reported that the 9.1.1 > contrib *.sql files contain the token "MODULE_PATHNAME", which is > unknown: > > psql test < /usr/share/postgresql/9.1/extension/intarray--1.0.sql > > This fails wi

Re: [BUGS] BUG #6247: Freeswitch will crash after 2-3 days within odbc connection

2011-10-11 Thread Stefan Kaltenbrunner
On 10/12/2011 08:40 AM, STIEG Heimo wrote: > Hello, > > > > do you need any further Information to solve that issue? Or do you have > any hints how to solve it by myself? well this list is for PostgreSQL bugs, we don't maintain unixODBC nor do we maintain the postgresql odbc driver - to quote

Re: [BUGS] psql doesn't reuse -p after backend fail

2011-09-05 Thread Stefan Kaltenbrunner
On 09/05/2011 08:27 PM, Tom Lane wrote: > hubert depesz lubaczewski writes: >> ran psql with specyfying port: >> psql -p 4329 -U postgres -d some_database > >> then I run query which breaks backend: > >> =# select * from categories limit 1; >> The connection to the server was lost. Attempting re

Re: [BUGS] BUG #6086: Segmentation fault

2011-07-25 Thread Stefan Kaltenbrunner
On 07/25/2011 05:57 PM, Alvaro Herrera wrote: > Excerpts from Robert Haas's message of lun jul 25 11:20:55 -0400 2011: >> On Sun, Jul 24, 2011 at 5:06 PM, noordsij wrote: Any idea what query triggered this? >>> >>> Only up to which stored procedure (which itself contains multiple >>> statemen

Re: [BUGS] BUG #5735: pg_upgrade thinks that it did not start the old server

2010-11-09 Thread Stefan Kaltenbrunner
Robert Haas wrote: On Sat, Oct 30, 2010 at 9:30 PM, Arturas Mazeika wrote: Thanks for the info, this explains a lot. Yes, I am upgrading from the 32bit version to the 64bit one. We have pretty large databases (some over 1 trillion of rows, and some containing large documents in blobs.) Givin

Re: [BUGS] BUG #5620: PostgreSQL won't accept the word "user" as a valid column name

2010-08-14 Thread Stefan Kaltenbrunner
On 08/14/2010 02:14 AM, Samuel Marinov wrote: The following bug has been logged online: Bug reference: 5620 Logged by: Samuel Marinov Email address: samuel.mari...@gmail.com PostgreSQL version: 9.0b4 Operating system: Ubuntu Linux 10.04 64-bit Description:PostgreSQL

Re: [BUGS] BUG #5585: SSL problems with long COPYs

2010-08-01 Thread Stefan Kaltenbrunner
On 08/01/2010 08:33 AM, Karl Denninger wrote: Alex Hunsaker wrote: On Sun, Aug 1, 2010 at 00:08, Karl Denninger wrote: The following bug has been logged online: Bug reference: 5585 Logged by: Karl Denninger Email address:k...@denninger.net PostgreSQL version: 8.4.4 Operating sy

Re: [BUGS] BUG #5567: will not install

2010-07-23 Thread Stefan Kaltenbrunner
On 07/23/2010 07:24 PM, Stefan Kaltenbrunner wrote: On 07/22/2010 07:51 PM, Denise Kanyuh wrote: Alex, Yes -- I am aware that we are on an old release -- any plans to upgrade? when you say - my hunch is they do not ship binaries for AIX (7.1). what binaries are you taking about --- we

Re: [BUGS] BUG #5567: will not install

2010-07-23 Thread Stefan Kaltenbrunner
On 07/22/2010 07:51 PM, Denise Kanyuh wrote: Alex, Yes -- I am aware that we are on an old release -- any plans to upgrade? when you say - my hunch is they do not ship binaries for AIX (7.1). what binaries are you taking about --- we use the same installer and files on AIX 6.1 and it works

Re: [BUGS] BUG #5488: pg_dump does not quote column names -> pg_restore may fail when upgrading

2010-06-10 Thread Stefan Kaltenbrunner
Tom Lane wrote: Heikki Linnakangas writes: On 10/06/10 16:21, Robert Haas wrote: I do agree that the human readability of pg_dump is an asset in many situations - I have often dumped out the DDL for particular objects just to look at it, for example. However, I emphatically do NOT agree that

Re: [BUGS] BUG #5488: pg_dump does not quote column names -> pg_restore may fail when upgrading

2010-06-10 Thread Stefan Kaltenbrunner
Stephen Frost wrote: * Magnus Hagander (mag...@hagander.net) wrote: On Thu, Jun 10, 2010 at 15:35, Stefan Kaltenbrunner wrote: that will pretty much defeat the purpose for most use cases i guess because people will dump with the defaults and only discover the problem after the fact. Well, if

Re: [BUGS] BUG #5488: pg_dump does not quote column names -> pg_restore may fail when upgrading

2010-06-10 Thread Stefan Kaltenbrunner
Robert Haas wrote: On Thu, Jun 10, 2010 at 9:35 AM, Stefan Kaltenbrunner wrote: I do agree that the human readability of pg_dump is an asset in many situations - I have often dumped out the DDL for particular objects just to look at it, for example. However, I emphatically do NOT agree that

Re: [BUGS] BUG #5488: pg_dump does not quote column names -> pg_restore may fail when upgrading

2010-06-10 Thread Stefan Kaltenbrunner
Robert Haas wrote: On Thu, Jun 10, 2010 at 9:02 AM, Stefan Kaltenbrunner wrote: I for myself would be rather annoyed if we started quoting all column names in our dumps. This is seriously hampering readability and while it is already annoying that pg_dump output is slightly different from the

Re: [BUGS] BUG #5488: pg_dump does not quote column names -> pg_restore may fail when upgrading

2010-06-10 Thread Stefan Kaltenbrunner
Hartmut Goebel wrote: Am 07.06.2010 02:32, schrieb Robert Haas: But we will likely add more keywords at some point in the future, and while providing an output format that quotes everything won't fix every potential problem, it might make life easier for some people. +10 Exactly my point: M

Re: [BUGS] psql or pgbouncer bug?

2010-05-21 Thread Stefan Kaltenbrunner
On 05/21/2010 01:32 PM, Tom Lane wrote: > Jakub Ouhrabka writes: >> Tom: Looks like the disconnect was because pgbouncer restarted. If that wasn't supposed to happen then you should take it up with the pgbouncer folk. > >> The restart of pgbouncer was intentional, although made by

Re: [BUGS] psql or pgbouncer bug?

2010-05-21 Thread Stefan Kaltenbrunner
On 05/21/2010 12:13 PM, Jakub Ouhrabka wrote: >> hmm yeah that is indeed a tad weird - are you actually using as >> pool_mode and server_reset_query? > > pool_mode = session > > server_reset_query = RESET ALL; SET SESSION AUTHORIZATION DEFAULT; > UNLISTEN *; hmm - and you are really sure that th

Re: [BUGS] psql or pgbouncer bug?

2010-05-21 Thread Stefan Kaltenbrunner
On 05/21/2010 12:03 PM, Jakub Ouhrabka wrote: > Hi Stefan, > > thanks - but I don't understand how could the BEGIN; UPDATE xxx; be > committed to database without explicit COMMIT and how could psql report > "UPDATE 153" after message "The connection was reset". This puzzles me... hmm yeah that is

Re: [BUGS] psql or pgbouncer bug?

2010-05-21 Thread Stefan Kaltenbrunner
On 05/21/2010 11:19 AM, Jakub Ouhrabka wrote: > Hi, > > can anyone tell me how this could happen, please? > > database=# begin; update table set col = 100; > server closed the connection unexpectedly >This probably means the server terminated abnormally >before or while processing

Re: [BUGS] bugs that have not been replied-to on list

2010-04-19 Thread Stefan Kaltenbrunner
Robert Haas wrote: On Sun, Apr 18, 2010 at 5:29 PM, Magnus Hagander wrote: On Sun, Apr 18, 2010 at 23:14, Tom Lane wrote: Jaime Casanova writes: On Sun, Apr 18, 2010 at 3:59 PM, Robert Haas wrote: On Sun, Apr 18, 2010 at 3:47 PM, Greg Sabino Mullane wrote: Bugzilla is the worst form of

Re: [BUGS] bugs that have not been replied-to on list

2010-04-19 Thread Stefan Kaltenbrunner
Tom Lane wrote: Jaime Casanova writes: On Sun, Apr 18, 2010 at 3:59 PM, Robert Haas wrote: On Sun, Apr 18, 2010 at 3:47 PM, Greg Sabino Mullane wrote: Bugzilla is the worst form of bug tracking out there, except for all the others. One of these days, I am going to write a @$#! bug tracker.

Re: [BUGS] bugs that have not been replied-to on list

2010-04-19 Thread Stefan Kaltenbrunner
Robert Haas wrote: On Sun, Apr 11, 2010 at 7:14 AM, Stefan Kaltenbrunner wrote: Jasen Betts wrote: On 2010-04-10, Stefan Kaltenbrunner wrote: Craig Ringer wrote: Dave Page wrote: This basically indicates that we need an issue tracker. There, look - now see what you made me do :-( Please

Re: [BUGS] bugs that have not been replied-to on list

2010-04-11 Thread Stefan Kaltenbrunner
Jasen Betts wrote: On 2010-04-10, Stefan Kaltenbrunner wrote: Craig Ringer wrote: Dave Page wrote: This basically indicates that we need an issue tracker. There, look - now see what you made me do :-( Please?!? I wonder, if EDB just went ahead and set one up, would people start using it

Re: [BUGS] bugs that have not been replied-to on list

2010-04-10 Thread Stefan Kaltenbrunner
Craig Ringer wrote: Dave Page wrote: This basically indicates that we need an issue tracker. There, look - now see what you made me do :-( Please?!? I wonder, if EDB just went ahead and set one up, would people start using it? I've been tempted to do it myself, but I'm not confident I can ha

Re: [BUGS] Known Issues Page

2010-03-29 Thread Stefan Kaltenbrunner
Tharakan, George (GE Healthcare) wrote: Hi, I have been using PostGreSQL as a part of our healthcare product. As an important part of releasing a stable product it is important to also document the known issues found in a PostGRE release. I would be grateful if someone could forward me to th

Re: [BUGS] BUG #5242: ODBC driver v8.4.1 crashed

2009-12-16 Thread Stefan Kaltenbrunner
Robert Haas wrote: On Tue, Dec 15, 2009 at 2:42 PM, Alvaro Herrera wrote: "This bug report form can be used for reporting bugs and problems with the PostgreSQL database, for problems with database connectors such as ODBC and JDBC, graphical administration tools such as pgAdmin or other external

Re: [BUGS] BUG #5242: ODBC driver v8.4.1 crashed

2009-12-15 Thread Stefan Kaltenbrunner
Alvaro Herrera wrote: Stefan Kaltenbrunner escribió: hmm - not sure that is too clear especially because I don't think ther is only JDBC/ODBC or pgadmin (nor do I think you names match up with how they are really called). what about doing it the other way round like: "This bug repor

Re: [BUGS] BUG #5242: ODBC driver v8.4.1 crashed

2009-12-15 Thread Stefan Kaltenbrunner
Robert Haas wrote: On Tue, Dec 15, 2009 at 12:22 PM, Magnus Hagander wrote: And to the list: can we PLEASE, PRETTY PLEASE add a note about this on the bug submission page? I asked for this before and Tom concurred, but I'm not aware that anything has been done about it. What do I have to do t

Re: [BUGS] BUG #5235: Segmentation fault under high load through JDBC

2009-12-09 Thread Stefan Kaltenbrunner
Andrew Gierth wrote: "Robert" == Robert Haas writes: Robert> How about (3) getrlimit(RLIMIT_STACK) lies through its teeth, Robert> by ignoring the existence of another and lower limit imposed Robert> elsewhere? Robert> A little Googling seems to reveal that FreeBSD has a Robert> paramete

Re: [BUGS] BUG #5159: 8.4.1 Segmentation fault

2009-11-02 Thread Stefan Kaltenbrunner
Sergey Konoplev wrote: On Mon, Nov 2, 2009 at 8:25 PM, Stefan Kaltenbrunner wrote: Sergey Konoplev wrote: Thanx, Tom. So I just need to checkout REL8_4_STABLE and install it to fix my problem, right? that should work if it is indeed the same issue. What if I apply this patch to 8.4.1

Re: [BUGS] BUG #5159: 8.4.1 Segmentation fault

2009-11-02 Thread Stefan Kaltenbrunner
Sergey Konoplev wrote: Thanx, Tom. So I just need to checkout REL8_4_STABLE and install it to fix my problem, right? that should work if it is indeed the same issue. Stefan -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postg

Re: [BUGS] BUG #5145: Complex query with lots of LEFT JOIN causes segfault

2009-10-30 Thread Stefan Kaltenbrunner
Greg Stark wrote: On Fri, Oct 30, 2009 at 11:22 AM, Stefan Kaltenbrunner wrote: ok I now see why you (and I) failed to reproduce the problem - it only causes clusters/databases to crash that were actually generated using the upthread mentioned script. it does NOT fail using a dump generated by

Re: [BUGS] BUG #5145: Complex query with lots of LEFT JOIN causes segfault

2009-10-30 Thread Stefan Kaltenbrunner
Stefan Kaltenbrunner wrote: Tom Lane wrote: Stefan Kaltenbrunner writes: this is 8.5a2 configured with ./configure --enable-cassert --enable-debug and just default settings(ie plain initdb with default settings). The OS is Debian Lenny/AMD64. Huh. That should not be noticeably different

Re: [BUGS] BUG #5145: Complex query with lots of LEFT JOIN causes segfault

2009-10-30 Thread Stefan Kaltenbrunner
Tom Lane wrote: Stefan Kaltenbrunner writes: this is 8.5a2 configured with ./configure --enable-cassert --enable-debug and just default settings(ie plain initdb with default settings). The OS is Debian Lenny/AMD64. Huh. That should not be noticeably different from my F11/Xeon64 machine

Re: [BUGS] BUG #5148: Email to pgsql-bugs@postgresql.org bounces:

2009-10-30 Thread Stefan Kaltenbrunner
Jonathan Hayward wrote: The following bug has been logged online: Bug reference: 5148 Logged by: Jonathan Hayward Email address: jonathan.hayw...@pobox.com PostgreSQL version: 8.1.x Operating system: Gentoo Description:Email to pgsql-bugs@postgresql.org bounces: Deta

Re: [BUGS] BUG #5145: Complex query with lots of LEFT JOIN causes segfault

2009-10-30 Thread Stefan Kaltenbrunner
Tom Lane wrote: Stefan Kaltenbrunner writes: uploaded a dump of the dataset here: http://www.kaltenbrunner.cc/files/rand_gen_data.sql and the query that causes the segfault: http://www.kaltenbrunner.cc/files/rand_gen_query.sql [ scratches head... ] Still no crash here, and I tried it on a

Re: [BUGS] BUG #5145: Complex query with lots of LEFT JOIN causes segfault

2009-10-29 Thread Stefan Kaltenbrunner
Tom Lane wrote: Stefan Kaltenbrunner writes: I can easily reproduce the segfault on 8.4 and 8.5a2: Doesn't crash here ... could we see the specific test data being used, please? uploaded a dump of the dataset here: http://www.kaltenbrunner.cc/files/rand_gen_data.sql and the query

Re: [BUGS] BUG #5145: Complex query with lots of LEFT JOIN causes segfault

2009-10-29 Thread Stefan Kaltenbrunner
Bernt M. Johnsen wrote: Euler Taveira de Oliveira wrote (2009-10-29 12:17:36): Bernt Marius Johnsen escreveu: The below query generated by the Random Query Generator (https://launchpad.net/randgen) causes a segfault. It was caused running Checkout the latest RQG from launchpad and run ./gent

Re: [BUGS] BUG #5040: Latest version of PostgreSQL's JDBC driver is not available in Maven's central repository

2009-09-06 Thread Stefan Kaltenbrunner
Clemens Fuchslocher wrote: The following bug has been logged online: Bug reference: 5040 Logged by: Clemens Fuchslocher Email address: fuchsloc...@users.sourceforge.net PostgreSQL version: 8.4 Operating system: Debian GNU/Linux 5.0 Description:Latest version of Postg

Re: [BUGS] ERROR: XLogFlush: request AF/5703EDC8 is not satisfied --- flushed only to AF/50F15ABC

2009-08-10 Thread Stefan Kaltenbrunner
utsav wrote: Dear All, I am using postgres 7.3 version on RHEL 4.0. 7.3 is not a supported release any more you really need to look into getting something non-prehistoric - and what version of 7.3 exactly? My database has been restored. "restored" - how exactly? From a file system backup

Re: [BUGS] BUG #4841: like and trim queries

2009-06-06 Thread Stefan Kaltenbrunner
jeewan wrote: The following bug has been logged online: Bug reference: 4841 Logged by: jeewan Email address: ccoew...@gmail.com PostgreSQL version: 8.3.6 Operating system: windows/fedora Description:like and trim queries Details: 1.Queries having some combination

Re: [BUGS] Bug (8.4beta): FailedAssertion("!(bms_is_subset(relids, qualscope))", File: "initsplan.c", Line: 915)

2009-05-06 Thread Stefan Kaltenbrunner
Tom Lane wrote: Stefan Kaltenbrunner writes: Tom Lane wrote: Thank you for the report, but I do not see any problem when trying the test case here. Do you have any nondefault planner parameter settings? hmm weird - the testcase crashes for me as well on 8.4B1: I was trying it on HEAD

Re: [BUGS] Bug (8.4beta): FailedAssertion("!(bms_is_subset(relids, qualscope))", File: "initsplan.c", Line: 915)

2009-05-06 Thread Stefan Kaltenbrunner
Tom Lane wrote: Stefan Huehner writes: I noticed the following bug when testing an application (openbravo 2.40) on postgresql 8.4: Thank you for the report, but I do not see any problem when trying the test case here. Do you have any nondefault planner parameter settings? hmm weird - the

Re: [BUGS] BUG #4793: Segmentation fault when doing vacuum analyze

2009-05-05 Thread Stefan Kaltenbrunner
Tom Lane wrote: "Dennis Noordsij" writes: (gdb) bt #0 0x004eecf7 in compute_scalar_stats (stats=0x1abd878, fetchfunc=0x4f0f30 , samplerows=, totalrows=4154315) at analyze.c:2321 #1 0x004efbf5 in analyze_rel (relid=16484, vacstmt=0x1aaf140, bstrategy=, update_reltup

Re: [BUGS] building Postgresql in Windows XP

2009-02-18 Thread Stefan Kaltenbrunner
Md. Abdur Rahman wrote: Dear Sir, I am trying to build PostGreSql from http://www.postgresql.org/ftp/source/v8.3.6/. However, I am unable to find any complete step by step document how to build it in windows xp. I would be grateful to you if you could point me any URL that can guide me toward

Re: [BUGS] BUG #4637: FATAL: sorry, too many clients already

2009-02-03 Thread Stefan Kaltenbrunner
chetan wrote: The following bug has been logged online: Bug reference: 4637 Logged by: chetan Email address: cheth...@inat.in PostgreSQL version: plus 8.3 Operating system: windows xp Description:FATAL: sorry, too many clients already Details: 2009-02-03 12:41:58,1

[BUGS] backend crash on CREATE OR REPLACE of a C-function on Linux

2009-02-01 Thread Stefan Kaltenbrunner
Hi all! While hacking on some C-level functions I noticed that everytime I replaced the .so file and used CREATE OR REPLACE FUNCTION the backend immediatly crashed. To test that it was not caused by something my function does (or one of the libaries it links in) I created the following testc

Re: [BUGS] UUIDs generated using ossp-uuid on windows not unique

2008-06-16 Thread Stefan Kaltenbrunner
Tom Lane wrote: Meetesh Karia <[EMAIL PROTECTED]> writes: As best as I can tell, the problem is caused because generation of v1 UUIDs uses GetSystemTimeAsFileTime which is stated to have a resolution of 100 nanoseconds but in practice has a resolution of around 15ms (http://www.ddj.com/showArt

Re: [BUGS] BUG #4122: ./postres 'restart' does not start server with same options as 'start' does

2008-04-22 Thread Stefan Kaltenbrunner
[EMAIL PROTECTED] wrote: I have just installed Postgres 8.3.1. And /usr/local/etc/rc.d/postgresql and /contrib/start-scripts/freebsd scripts are different BUG in installator? the one in /usr/local/etc/rc.d/postgresql is likely the on that freebsd supplies if you install from the porttree so

Re: [BUGS] BUG #4096: PG 8.3.1. confused about remaining disk space

2008-04-07 Thread Stefan Kaltenbrunner
J6M wrote: OK. So why did this not occur when I was running 8.2.6 ? I would advise to install some very detailed monitoring on your diskspace usage and look for spikes that correlate with your database errors -. I have seen this issue with bad queries that are resulting in enormous on-disk

Re: [BUGS] Supported platforms for PostgreSQL

2008-01-31 Thread Stefan Kaltenbrunner
Alvaro Herrera wrote: yogini sagade wrote: Hi ALL, Can anyone please let me know what are the latest platforms supported by PostgreSQL for following :- 1. Windows 2. Solaris 3. HPUX 4. AIX. See the buildfarm status table: http://buildfarm.postgresql.org/cgi-bin/show_status.pl there is

Re: [BUGS] BUG #3865: ERROR: failed to build any 8-way joins

2008-01-09 Thread Stefan Kaltenbrunner
[RESENDING because the attachments seems to have caused the mail to disappear] Oleg Kharin wrote: Hi, Stefan Hi Oleg! I have readded the list and the testcases to the CC so that others can participate in the discussion too ... init826.sql builds necessary tables and indexes. The test quer

Re: [BUGS] BUG #3865: ERROR: failed to build any 8-way joins

2008-01-09 Thread Stefan Kaltenbrunner
Oleg Kharin wrote: The following bug has been logged online: Bug reference: 3865 Logged by: Oleg Kharin Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.6 Operating system: CentOS 5.1 x86 64-bit Description:ERROR: failed to build any 8-way joins Details: A

Re: [BUGS] BUG #3864: jdbc files

2008-01-09 Thread Stefan Kaltenbrunner
Ted wrote: The following bug has been logged online: Bug reference: 3864 Logged by: Ted Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.6 Operating system: os x Description:jdbc files Details: Sorry... I don't know where to go to find the jdbc jars.. it se

[BUGS] ALTER INDEX/ALTER TABLE on indexes can cause unrestorable dumps

2008-01-07 Thread Stefan Kaltenbrunner
Andy just reported on IRC that renaming indexes can lead to unrestorable dumps under certain circumstances. A simple example(8.2 but at least 8.1 and 8.3 seem to behave exactly the same) for that is: test=# CREATE TABLE foo(bar int PRIMARY KEY); NOTICE: CREATE TABLE / PRIMARY KEY will create i

Re: [BUGS] BUG #3850: Incompatibility among pg_dump / pg_restore.

2008-01-07 Thread Stefan Kaltenbrunner
Diego Spano wrote: Stefan / List, these are the steps: 1- pg_dump sicoba|gzip>/home/backups/pg_backup/backup.pg 2- createdb sicoba6 3- psql -d sicoba6 < backup.pg And thats all. Errors appear when trying to add rows to first table, and so on... Find attached backup.pg. ok just took a l

Re: [BUGS] BUG #3850: Incompatibility among pg_dump / pg_restore.

2008-01-04 Thread Stefan Kaltenbrunner
Diego Spano wrote: Hi Stefan, Hi Diego! Please keep the list CC'd so that other people can participate in the discussion - I have readded it now ... I test all possibilities, schema and data togheter, separated files, tar files, plain text, from command line, from PG_Admin. But allways is

Re: [BUGS] BUG #3850: Incompatibility among pg_dump / pg_restore.

2008-01-04 Thread Stefan Kaltenbrunner
Diego Spano wrote: The following bug has been logged online: Bug reference: 3850 Logged by: Diego Spano Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.9 Operating system: Debian Etch 4.0 Description:Incompatibility among pg_dump / pg_restore. Details: I

Re: [BUGS] BUG #3798: Add fuzzy string search in TSearch2

2007-12-04 Thread Stefan Kaltenbrunner
Rikardo Tinauer wrote: > The following bug has been logged online: > > Bug reference: 3798 > Logged by: Rikardo Tinauer > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.3 > Operating system: All > Description:Add fuzzy string search in TSearch2 > Details: >

Re: [BUGS] not sorted clustered index (8.2)

2007-11-05 Thread Stefan Kaltenbrunner
Adriaan van Kekem wrote: hi, As part of the definition of a clustered index, the default sort of a table is based on the clustered index. In our application sometimes we see that the sort is invalid. Our table is like: iid identity (clustered primary key) data varchar if we do a query like: s

Re: [BUGS] IPv6 Support in 8.0.3

2007-10-15 Thread Stefan Kaltenbrunner
Kevin Kuhner wrote: > > Hello - > > Hope this is an appropriate mailing list for this question. Has anyone > gotten IPv6 support to work in version 8.0.3 for Windows? > > I've tried the 8.2.4 binaries and they do work, so I know that the > problem has been addressed somewhere along the line,

Re: [BUGS] autovacuum starting for no apparent reason

2007-09-17 Thread Stefan Kaltenbrunner
hubert depesz lubaczewski wrote: > 1. postgresql 8.2.4 > 2. system is 8-way xeon, 64bit with 32gram. > 3. autovacuum is (and was) turned off in configuration. > 4. today in peak hours autovacuum started. no mention of it in logs. it > just showed. started to vacuum the largest table in main databas

Re: [SPAM] Re: [BUGS] BUG #3484: Missing pg_clog file / corrupt index

2007-08-24 Thread Stefan Kaltenbrunner
Feng Chen wrote: > VERSION = PostgreSQL 8.1.2 this could be http://archives.postgresql.org/pgsql-committers/2006-01/msg00287.php which is fixed in 8.1.3 and later - so you really should look into upgrading to 8.1.9 as soon as possible ,,, Stefan ---(end of broadcast)---

Re: [BUGS] BUG #3484: Missing pg_clog file / corrupt index

2007-08-24 Thread Stefan Kaltenbrunner
Feng Chen wrote: > We also have the same exact problem - every 5 to 10 days when the data > get to some size, PostgreSQL complains about missing pg_clog files, and > invalid page headers during either vacuum or reindex operations. > > The problem happens on different customer sites with Linux 2.6.

Re: [BUGS] Help on clarification of supported platform for Postgres 8.2

2007-07-27 Thread Stefan Kaltenbrunner
Siraj Khan wrote: Dear Team, I am working for small firm in Mumbai, India. We are interested in running Postgres 8.2 database on IBM unix platform (Power5 processor). Need your help in confirmation whether Postgres 8.2 runs on * AIX 5.3 OS on Power5 cpu this is a platform that is both

Re: [BUGS] BUG #3309: The limitation for number of connection with ODBC driver

2007-06-04 Thread Stefan Kaltenbrunner
[adding -bugs back again] Dmitry Dmitriev wrote: Stefan, We have checked the new ODBC driver V08.02.04.02 with expanded number of connection. But now we have got the new problem. The PostgreSQL server unexpected crashes when number of opened connections reach about 160. We checked it through

Re: [BUGS] BUG #3309: The limitation for number of connection with ODBC driver

2007-05-28 Thread Stefan Kaltenbrunner
[added -bugs back to the CC] Dmitry Dmitriev wrote: > Stefan, > > Thank you for quick response. > I guess that this problem with ODBC driver. > The following file fragment psqlodbc.h from official PostgreSQL web site: > http://wwwmaster.postgresql.org/download/mirrors-ftp?file=%2Fodbc%2Fversion

Re: [BUGS] BUG #3309: The limitation for number of connection with ODBC driver

2007-05-26 Thread Stefan Kaltenbrunner
Dmitry Dmitriev wrote: > The following bug has been logged online: > > Bug reference: 3309 > Logged by: Dmitry Dmitriev > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.2.3.-1 > Operating system: Windows XP > Description:The limitation for number of connectio

Re: [BUGS] Database Server Remote connection failed

2007-05-20 Thread Stefan Kaltenbrunner
Íõ·å wrote: > Hi, > I can't establish a connection to PostgreSQL(version postgresql-8.2.4) > Server. I'am sure what i config is right. > > Following are what i do to enable remote connection: > > 1. edit /usr/local/pgsql/data/postgresql.conf > enable remote tcp/ip connection: > listen_addresses

Re: [BUGS] BUG #3279: insert or update

2007-05-14 Thread Stefan Kaltenbrunner
[EMAIL PROTECTED] wrote: > The following bug has been logged online: > > Bug reference: 3279 > Logged by: > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.1 > Operating system: macosx > Description:insert or update > Details: > > I sort of want to begin th

Re: [BUGS] BUG #3267: Relfilenode

2007-05-11 Thread Stefan Kaltenbrunner
Shyam Sunder Rai wrote: The following bug has been logged online: Bug reference: 3267 Logged by: Shyam Sunder Rai Email address: [EMAIL PROTECTED] PostgreSQL version: GreenplumDB if you are using greenplumDB you should ask the greenplum support for help ... Operating sys

Re: [BUGS] BUG #3229: Incorrect temp table work

2007-04-16 Thread Stefan Kaltenbrunner
ALEXEY PARSHIN wrote: > The following bug has been logged online: > > Bug reference: 3229 > Logged by: ALEXEY PARSHIN > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.1.8 > Operating system: Gentoo Linux > Description:Incorrect temp table work > Details: >

[BUGS] BUG #3223: Testbugreport for new wwwmaster

2007-04-13 Thread Stefan Kaltenbrunner
The following bug has been logged online: Bug reference: 3223 Logged by: Stefan Kaltenbrunner Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.8 Operating system: FreeBSD 6.2STABLE Description:Testbugreport for new wwwmaster Details: testing the bugreport

Re: [BUGS] BUG #2927: Trigger execution hides foreign key error

2007-01-24 Thread Stefan Kaltenbrunner
Jaume Catarineu wrote: > The following bug has been logged online: > > Bug reference: 2927 > Logged by: Jaume Catarineu > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.2.1 > Operating system: Linux srvca01 2.6.11.4-20a-smp #1 SMP Wed Mar 23 > 21:52:37 UTC 2005 i686

Re: [BUGS] BUG #2929: Error opening 5432 port

2007-01-24 Thread Stefan Kaltenbrunner
James Becerra wrote: > The following bug has been logged online: > > Bug reference: 2929 > Logged by: James Becerra > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.1 > Operating system: Windows 2003 Server > Description:Error opening 5432 port > Details: >

Re: [BUGS] BUG #2877: Caused by: org.postgresql.util.PSQLException:

2007-01-10 Thread Stefan Kaltenbrunner
Ravalison Frederyk wrote: > The following bug has been logged online: > > Bug reference: 2877 > Logged by: Ravalison Frederyk > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.1 > Operating system: win 2003 > Description:Caused by: org.postgresql.util.PSQLExce

Re: [BUGS] Bugreport

2007-01-10 Thread Stefan Kaltenbrunner
Marco Behnke wrote: > I am compiling postgres on a intel mac machine > > ../../../../src/include/storage/s_lock.h:543:2: error: #error PostgreSQL > does not have native spinlock support on this platform. To continue the > compilation, rerun configure using --disable-spinlocks. However, > performan

Re: [BUGS] BUG #2854: can't log out database system

2006-12-21 Thread Stefan Kaltenbrunner
Jessica wrote: > The following bug has been logged online: > > Bug reference: 2854 > Logged by: Jessica > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.2 > Operating system: Solaris > Description:can't log out database system > Details: > > I log into data

Re: [BUGS] BUG #2855: SEGV on PL/PGSQL function

2006-12-21 Thread Stefan Kaltenbrunner
Mike wrote: > The following bug has been logged online: > > Bug reference: 2855 > Logged by: Mike > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.2 > Operating system: RHEL AS 4.3 x86_64 > Description:SEGV on PL/PGSQL function > Details: > > (retyping this

Re: [BUGS] postgresql 8.2.0 -- LIMIT NULL crashes server

2006-12-21 Thread Stefan Kaltenbrunner
Norman Yamada wrote: Running postgresql 8.2.0 on Debian testing, Linux kernel 2.6.12, Dual Xeon 2.80GHz motherboard, gcc 4.0.3. If I run a statement like this: select * from [table] limit null; it crashes the server. thanks for the report - this is already fixed in REL8_2_STABLE and will a

Re: [BUGS] BUG #2821: xid cannot be casted to a different type

2006-12-10 Thread Stefan Kaltenbrunner
Tom Lane wrote: > Edwin Groothuis <[EMAIL PROTECTED]> writes: >> On Sun, Dec 10, 2006 at 03:20:50PM -0500, Tom Lane wrote: >>> "Edwin Groothuis" <[EMAIL PROTECTED]> writes: This worked fine on 8.0.x. >>> Really? > >> Hmm... We used this script on 8.0.0 to 8.0.6 (which is the current >> databa

Re: [BUGS] BUG #2719: configure script does not accept --enable-locale

2006-10-26 Thread Stefan Kaltenbrunner
Mareks Malnacs wrote: > The following bug has been logged online: > > Bug reference: 2719 > Logged by: Mareks Malnacs > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.2 beta 2 > Operating system: macos x and solaris x86 > Description:configure script does not

Re: [BUGS] BUG #2721: configuration issue

2006-10-26 Thread Stefan Kaltenbrunner
Githogori Nyangara-Murage wrote: > The following bug has been logged online: > > Bug reference: 2721 > Logged by: Githogori Nyangara-Murage > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.2beta1 > Operating system: Linux > Description:configuration issue > D

Re: [BUGS] Unexpected chunk number

2006-09-12 Thread Stefan Kaltenbrunner
Chris Purcell wrote: Hi, On running pg_dump, I am consistently getting the following errors: pg_dump: ERROR: unexpected chunk number 2 (expected 0) for toast value 223327 pg_dump: SQL command to dump the contents of table "pagecache" failed: PQendcopy() failed. pg_dump: Error message from se

Re: [BUGS] BUG #2600: dblink compile with SSL missing libraries

2006-08-30 Thread Stefan Kaltenbrunner
Joe Conway wrote: > Christopher Browne wrote: >> The following bug has been logged online: > >> >> If I try to build dblink when PG is configured "--with-openssl", the >> build >> of the contrib module dblink breaks as follows: > >> If I add, to the GCC command line, requests for libssl and libcr

Re: [BUGS] BUG #2585: Please provide pkg-config support

2006-08-21 Thread Stefan Kaltenbrunner
[EMAIL PROTECTED] wrote: > The following bug has been logged online: > > Bug reference: 2585 > Logged by: > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.1.4 > Operating system: GNU/Linux > Description:Please provide pkg-config support > Details: > > I ha

Re: [BUGS] BUG #2579: initcap should not capitalize letter

2006-08-19 Thread Stefan Kaltenbrunner
Bruce Momjian wrote: > Dan Franklin wrote: >> Good point. It is probably not possible to get >> it perfect. But I think that possessives and >> contractions occur more often in a typical body >> of text than Irish names. So it would be right >> more often, even if it is still wrong some of t