[BUGS] BUG #5217: (new) error with VB 6.0 SP 6 and psqlODBC 8.4.1

2009-11-27 Thread Martin
The following bug has been logged online: Bug reference: 5217 Logged by: Martin Email address: searepo...@aol.at PostgreSQL version: 8.4.1 Operating system: M$ Vista (but does not matter) same on XP, ... Description:(new) error with VB 6.0 SP 6 and psqlODBC 8.4.1

[BUGS] BUG #2673: run-time error '429'

2006-10-04 Thread Martin
The following bug has been logged online: Bug reference: 2673 Logged by: Martin Email address: [EMAIL PROTECTED] PostgreSQL version: Sebastian Operating system: windows 98 Description:run-time error '429' Details: run-time error '4'29' Ativ

[BUGS] BUG #2396: SELECT to_number('6500', '999,999.99') != 650

2006-04-15 Thread Martin
The following bug has been logged online: Bug reference: 2396 Logged by: Martin Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.3 Operating system: Win XP SP 2 German Description:SELECT to_number('6500', '999,999.99') != 650 Details: 1

[BUGS] Incorrect cursor behaviour with gist index

2008-09-11 Thread Martin Schäfer
last row in the cursor. As far as I understand, the ENABLE_SEQSCAN = OFF forces the query to use the gist index, which would otherwise not be used. However, if the cursor would select a suitably sized subset of a large enough table, then the gist index would be used regardless of the setting of

[BUGS] Problem with the pg_dumpall file format

2008-10-19 Thread Martin Gregorie
Guys, I apologise for sending a bug report this way, but the bug reporting server seems to be out to lunch at present. Firefox reports being able to contact it but its bug submission wasn't accepted. To avoid loss of the bug report, here it is: Name: Martin Gregorie e

[BUGS] Fall back to alternative tsearch dictionary directory

2008-12-01 Thread Martin Pitt
that, I'd like to collect some opinions about the general idea, and whether you prefer autoconf option or postgresql.conf, or whether you wouldn't accept it at all? Thanks a lot in advance! Martin -- Martin Pitt| http://www.piware.de Ubuntu Developer (www.ubuntu

Re: [BUGS] Fall back to alternative tsearch dictionary directory

2008-12-01 Thread Martin Pitt
the system defaults. The other way around would mean that the admin couldn't do local overriding any more. Thanks, Martin -- Martin Pitt| http://www.piware.de Ubuntu Developer (www.ubuntu.com) | Debian Developer (www.debian.org) signature.asc Description: Digital signature

Re: [BUGS] Fall back to alternative tsearch dictionary directory

2008-12-02 Thread Martin Pitt
en the 8.3, 8.4, and any future version. (In Debian/Ubuntu you can install different 8.x versions in parallel) But that can easily be achieved in the distro packaging by adding symlinks, so if you prefer just looking for ${sharedir}/tsearch_data/system_ll_cc.affix, that would still work

Re: [BUGS] Fall back to alternative tsearch dictionary directory

2008-12-05 Thread Martin Pitt
Martin Pitt [2008-12-02 5:29 -0800]: > Tom Lane [2008-12-01 19:51 -0500]: > > I can't see any reason whatever to not put them into > > ${sharepath}/tsearch_data/. It's not like you're expecting to be > > able to share them with other applications. > &g

[BUGS] Debian Bug#506196: postgresql: consume too much power when idle (>10 wakeups/second)

2009-01-04 Thread Martin Pitt
. (I have no problem with closing the bug as wontfix, but I'd like to give a rationale). Thank you! Martin - Forwarded message from Xavier Bestel - Subject: Bug#506196: postgresql: consume too much power when idle (>10 wakeups/second) Reply-To: Xavier Bestel , 506...@bugs.de

Re: [BUGS] Debian Bug#506196: postgresql: consume too much power when idle (>10 wakeups/second)

2009-01-04 Thread Martin Pitt
Hi Alvaro, Alvaro Herrera [2009-01-04 18:05 -0300]: > How many databases are there? It's a freshly created instance, thus just "template[01]" and "postgres". Standard 8.3 autovacuum is enabled. Thanks, Martin -- Martin Pitt| http://ww

Re: Bug#506196: [BUGS] Debian Bug#506196: postgresql: consume too much power when idle (>10 wakeups/second)

2009-01-05 Thread Martin Pitt
"does not behave as intended". Purely a wishlist thingy. Thanks for your investigations, Martin -- Martin Pitt| http://www.piware.de Ubuntu Developer (www.ubuntu.com) | Debian Developer (www.debian.org) -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresq

Re: Bug#506196: [BUGS] Debian Bug#506196: postgresql: consume too much power when idle (>10 wakeups/second)

2009-01-05 Thread Martin Pitt
Hi Simon, Simon Riggs [2009-01-05 10:57 +]: > Is this 11 per minute, or 11 per second? Per second. Martin -- Martin Pitt| http://www.piware.de Ubuntu Developer (www.ubuntu.com) | Debian Developer (www.debian.org) -- Sent via pgsql-bugs mailing list (pgsql-b

Re: [BUGS] Fall back to alternative tsearch dictionary directory

2009-01-24 Thread Martin Pitt
ate automatically (system_) from the ones that we should not touch (without system_ prefix). Martin -- Martin Pitt| http://www.piware.de Ubuntu Developer (www.ubuntu.com) | Debian Developer (www.debian.org) -- Sent via pgsql-bugs mailing list (pgsql-bugs@pos

[BUGS] BUG #4629: PL/pgSQL issue

2009-01-30 Thread Martin Blazek
The following bug has been logged online: Bug reference: 4629 Logged by: Martin Blazek Email address: mbla...@8bc.com PostgreSQL version: 8.3.5 Operating system: Windows XP Description:PL/pgSQL issue Details: I try to create the following rule. It doesn't

[BUGS] BUG #4724: Array index out of bounds

2009-03-22 Thread Ett Martin
The following bug has been logged online: Bug reference: 4724 Logged by: Ett Martin Email address: ettl.mar...@gmx.de PostgreSQL version: 8.3.7 Operating system: Linux Description:Array index out of bounds Details: I have checked the sources with a static code

[BUGS] shared_buffers/SHMMAX defaults?

2009-03-30 Thread Martin Pitt
(3) Change SHMMAX in postgresql's init script if necessary + Always works - Unexpected, works behind admin's back. Currently I tend towards (2), but I'd like to hear some more opinions about it. Does anyone else have seen this problem as well? Thanks, Martin [1] https://launchp

Re: [BUGS] shared_buffers/SHMMAX defaults?

2009-03-31 Thread Martin Pitt
Tom Lane [2009-03-30 20:29 -0400]: > Consider > (4) Lobby your kernel packagers to install saner SHMMAX/SHMALL > defaults. Sounds good. :-) Those are the current defaults: kernel.shmmax = 33554432 kernel.shmall = 2097152 kernel.shmmni = 4096 Thanks, Martin -- Ma

[BUGS] libpq 8.4 beta1: $PGHOST complains about missing root.crt

2009-04-09 Thread Martin Pitt
file "/home/martin/.postgresql/root.crt" does not exist Thank you! Martin -- Martin Pitt| http://www.piware.de Ubuntu Developer (www.ubuntu.com) | Debian Developer (www.debian.org) signature.asc Description: Digital signature

Re: [BUGS] libpq 8.4 beta1: $PGHOST complains about missing root.crt

2009-04-09 Thread Martin Pitt
Tom Lane [2009-04-10 1:15 -0400]: > Martin Pitt writesyuqhom#3: > > The test suite detected one regression in libpq, though: Setting > > $PGHOST now complains about a missing root.crt, although this is only > > relevant on the server side (or did I misunderstood thi

Re: [BUGS] libpq 8.4 beta1: $PGHOST complains about missing root.crt

2009-04-10 Thread Martin Pitt
an SSL-enabled server *if* I have a root.crt which doesn't match. But why fail if I don't have one? Thanks for considering, Martin -- Martin Pitt| http://www.piware.de Ubuntu Developer (www.ubuntu.com) | Debian Developer (www.debian.org) signature.asc Description: Digital signature

Re: [BUGS] libpq 8.4 beta1: $PGHOST complains about missing root.crt

2009-04-10 Thread Martin Pitt
, etc. trusted by simply replacing that central certificate. You can still configure individual services to use a different one. Martin -- Martin Pitt| http://www.piware.de Ubuntu Developer (www.ubuntu.com) | Debian Developer (www.debian.org) -- Sent via pgsql-bugs

Re: [BUGS] libpq 8.4 beta1: $PGHOST complains about missing root.crt

2009-04-10 Thread Martin Pitt
tes? That would be strange. I had thought it checks whether the user has the server signing certificate of the server installed on his client home directory (which, BTW, seems like a strange place to default to, and thus keep it). Martin -- Martin Pitt| http://www.piware.

Re: [BUGS] libpq 8.4 beta1: $PGHOST complains about missing root.crt

2009-04-10 Thread Martin Pitt
n. Initially I thought it was just a subtle regression. Since it doesn't seem to be, I'll just adapt my test suite if this is going to stay like it is right now. I'm still concerned about the potential confusion, though. Thanks, Martin -- Martin Pitt| http:

Re: [BUGS] libpq 8.4 beta1: $PGHOST complains about missing root.crt

2009-04-10 Thread Martin Pitt
e. I don't see a reason why an admin would replace a self-signed cert with another self-signed cert? Thanks, Martin -- Martin Pitt| http://www.piware.de Ubuntu Developer (www.ubuntu.com) | Debian Developer (www.debian.org) -- Sent via pgsql-bugs mailing list (pgs

Re: [BUGS] libpq 8.4 beta1: $PGHOST complains about missing root.crt

2009-04-14 Thread Martin Pitt
#x27;s > encrypted). For the record, I don't agree. SSL certificate validation is good, and should be done as long as you have a cert installed. Encryption without authentication is not worth a lot, after all. Martin -- Martin Pitt| http://www.piware.de Ubuntu

Re: [BUGS] libpq 8.4 beta1: $PGHOST complains about missing root.crt

2009-04-14 Thread Martin Pitt
guration files, so adding something like this will need some careful design. Thanks, Martin -- Martin Pitt| http://www.piware.de Ubuntu Developer (www.ubuntu.com) | Debian Developer (www.debian.org) -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make

Re: [BUGS] libpq 8.4 beta1: $PGHOST complains about missing root.crt

2009-04-14 Thread Martin Pitt
t be read because of permission or syntax errors. That's exactly how the server side behaves as well, and IMHO it's the right thing to do. Martin -- Martin Pitt| http://www.piware.de Ubuntu Developer (www.ubuntu.com) | Debian Developer (www.debian.org) --

Re: [BUGS] libpq 8.4 beta1: $PGHOST complains about missing root.crt

2009-04-14 Thread Martin Pitt
called "try", though, maybe "cert" should have above semantics, and "force" should have the currently implemented one (i. e. fail if not present)? But that gets us dangerously close to bikeshedding now... Martin -- Martin Pitt| http://www.piware

Re: [BUGS] libpq 8.4 beta1: $PGHOST complains about missing root.crt

2009-04-14 Thread Martin Pitt
Stephen Frost [2009-04-14 9:09 -0400]: > I disagree, and you *can* do authentication without SSL! I know. But then you do have authentication as well, which was exactly my point. Also, I said "not a lot better", not "totally useless". Martin -- Martin Pitt

Re: [BUGS] libpq 8.4 beta1: $PGHOST complains about missing root.crt

2009-04-14 Thread Martin Pitt
Stephen Frost [2009-04-14 9:18 -0400]: > * Martin Pitt (mp...@debian.org) wrote: > > We couldn't set this up by default, of course, since each installed > > machine will have a different snakeoil cert (it gets generated during > > installation). > > It's

[BUGS] 8.4 dropped Russian server translations

2009-09-06 Thread Martin Pitt
Hello all, is there any reason why 8.4 dropped src/backend/po/ru.po? It was still present in 8.3, and still works. It might perhaps not be entirely up to date, but 90% coverage is certainly better than 0? Or were there any other problems with it? Thanks in advance, Martin -- Martin Pitt

Re: [BUGS] 8.4 dropped Russian server translations

2009-09-06 Thread Martin Pitt
Tom Lane [2009-09-06 10:24 -0400]: > According to > http://babel.postgresql.org/ > it's more like 38%. Ah, thanks for the link! Makes sense then. Martin -- Martin Pitt| http://www.piware.de Ubuntu Developer (www.ubuntu.com) | Debian Developer (www.debian.

Re: [BUGS] BUG #5041: Changing data_directory problem

2009-09-06 Thread Martin Pitt
e give us the output of "pg_lsclusters". Thanks, Martin -- Martin Pitt| http://www.piware.de Ubuntu Developer (www.ubuntu.com) | Debian Developer (www.debian.org) -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to

[BUGS] BUG #5043: Stored procedure returning different results for same arguments

2009-09-08 Thread Martin Edlman
The following bug has been logged online: Bug reference: 5043 Logged by: Martin Edlman Email address: edl...@fortech.cz PostgreSQL version: 8.2.0 Operating system: Linux (RHEL 4.4) Description:Stored procedure returning different results for same arguments Details

Re: [BUGS] BUG #5043: Stored procedure returning different results for same arguments

2009-09-09 Thread Martin Edlman
ect result '2008-11-01'. But xfunc() then fails and the trigger operation is rolled back and I see the '2009-09-01' record again... Sorry guys for bothering you and taking your time. Regards, - -- Martin Edlman Fortech, spol. s r.o, Ropkova 51, 57001 Litomyšl Public GPG key: htt

[BUGS] BUG #5055: Invalid page header error

2009-09-14 Thread john martin
The following bug has been logged online: Bug reference: 5055 Logged by: john martin Email address: postgres_...@live.com PostgreSQL version: 8.3.6 Operating system: Centos 5.2 32 bit Description:Invalid page header error Details: All of a sudden we started seeing

[BUGS] Small syntax error in fmgr.h

2009-10-29 Thread Martin Pitt
rom a quick scan it looks as though there may also be a similar problem with PG_FUNCTION_INFO_V1 also on line 329. " Thanks, Martin -- Martin Pitt| http://www.piware.de Ubuntu Developer (www.ubuntu.com) | Debian Developer (www.debian.org) -- Sent via pgsql-bu

[BUGS] BUG #5204: ODBC connection NOT working

2009-11-20 Thread Alan Martin
The following bug has been logged online: Bug reference: 5204 Logged by: Alan Martin Email address: alan.mar...@mightyautoparts.com PostgreSQL version: 08.04.0100 Operating system: Windows 7 64-bit Description:ODBC connection NOT working Details: Good morning

[BUGS] UTF-8 encoding failure

2010-03-25 Thread Martin Schäfer
see the character in question has the following encodings: SJIS: 8c b4 UTF-16: 9f 53 UTF-8: e5 8e 9f Any chance this problem could be fixed soon? Bye, Martin Schäfer Principal Software Engineer Cadcorp Computer Aided Development Corporation Ltd. 1 Heathcock Court, London, WC2

Re: [BUGS] UTF-8 encoding failure

2010-03-26 Thread Martin Schäfer
why doesn't it work on my machine? Regards, Martin Schäfer Principal Software Engineer Cadcorp Computer Aided Development Corporation Ltd. 1 Heathcock Court, London, WC2R 0NT martin.schae...@cadcorp.com www.cadcorp.com > -Original Message- > From: Takahiro Itagaki [mailto:ita

Re: [BUGS] UTF-8 encoding failure

2010-03-26 Thread Martin Schäfer
difference. It still fails on my machine. Regards, Martin > -Original Message- > From: Hiroshi Saito [mailto:z-sa...@guitar.ocn.ne.jp] > Sent: Friday, March 26, 2010 2:58 PM > To: Martin Schäfer; 'Takahiro Itagaki' > Cc: pgsql-bugs@postgresql.org > Subject: Re: [

Re: [BUGS] UTF-8 encoding failure

2010-03-26 Thread Martin Schäfer
Hi, This worked fine, as you can see in the attached result. However, I can see that my database has a different locale (English_United Kingdom.1252) from yours (C). Can this cause the problem? Regards, Martin > -Original Message- > From: Hiroshi Saito [mailt

Re: [BUGS] UTF-8 encoding failure

2010-03-26 Thread Martin Schäfer
Can you copy libpq.dll to the same destination please? I linked libpq as a static library into my project. Martin > -Original Message- > From: Hiroshi Saito [mailto:z-sa...@guitar.ocn.ne.jp] > Sent: Friday, March 26, 2010 4:35 PM > To: Martin Schäfer; 'Takahiro Ita

Re: [BUGS] UTF-8 encoding failure

2010-03-29 Thread Martin Schäfer
e combination of UK English operating system with Japanese locale. Maybe someone else could test this combination? Regards, Martin > -Original Message----- > From: Hiroshi Saito [mailto:z-sa...@guitar.ocn.ne.jp] > Sent: Friday, March 26, 2010 5:54 PM > To: Martin Schäfer; 'Takahi

Re: [BUGS] UTF-8 encoding failure

2010-04-07 Thread Martin Schäfer
Hi Hiroshi-san, Now I'm convinced that my installation is messed up somehow and that this is not a bug in PostgreSQL. Thank you very much for taking the time trying to reproduce my problem. Regards, Martin -Original Message- From: Hiroshi Saito [mailto:z-sa...@guitar.ocn.ne.jp]

[BUGS] [9.0beta5/cvs head] build failure due to unchecked results

2010-04-30 Thread Martin Pitt
t git head) to check the results of those. For src/bin/psql/common.c this is really just an "ignore the result", but in src/bin/psql/prompt.c it actually fixes a potential crash. Thank you for considering! Martin -- Martin Pitt| http://www.piware.de Ubuntu Developer

Re: [BUGS] [9.0beta5/cvs head] build failure due to unchecked results

2010-04-30 Thread Martin Pitt
day or two and wait for beta1. Sure, thank you! Martin -- Martin Pitt| http://www.piware.de Ubuntu Developer (www.ubuntu.com) | Debian Developer (www.debian.org) signature.asc Description: Digital signature

Re: [BUGS] [9.0beta5/cvs head] build failure due to unchecked results

2010-05-01 Thread Martin Pitt
out --enable-cassert (where the entire Assert() was thrown away), and it didn't complain about the unchecked result any more. I guess that heuristics gets it only so far.. Thanks, Martin -- Martin Pitt| http://www.piware.de Ubuntu Developer (www.ubuntu.com) | Debian D

[BUGS] bug report

2000-04-27 Thread Martin Renters
POSTGRESQL BUG REPORT TEMPLATE Your name : Martin Renters Your email address : [EMAIL

[BUGS] Number of tuples in pg_class - bug or misunderstanding?

2000-05-11 Thread Martin Neumann
ts'; reltuples --- 188 (1 row) irc=# SELECT COUNT(*) FROM events; count --- 195 (1 row) This annoys me a little bit as I can do SELECT reltuples FROM pg_class WHERE relname = $1; from plpgsql, but not SELECT COUNT(*) FROM $1; -- Martin Neumann Appartement 201, Emil-Figge-Str. 9, 442

[BUGS] CLUSTER makes table vanish :(

2000-08-10 Thread Brian Martin
Hi everybody, I don't seem to have a copy of the bug template, so here goes. In the process of trying to optimize some queries I'm doing, I tried a CLUSTER command: cluster track_instance_idx2 on track_instance; It failed with this error: ERROR: temp_258c0 is an index relation Now I wasn't

Re: [BUGS] Error with union in sub-selects

2000-09-06 Thread Martin Neimeier
want to use another rdbms ... i want to use PostgreSQL :-) If somebody has a workaround, then i am the happiest person for the day. cu Martin -- Martin Neimeier Ingenieur-Buero Neimeier Schwarzach / Germany mailto:[EMAIL PROTECTED] / http://www.ibn.de (under heavy reconstruction) Tel:+49

[BUGS] 7.1 released on 2000-09-01?

2001-01-23 Thread Edwin Martin
e for your self: http://www.postgresql.org/docs/admin/release.htm I guess you better correct this (of explain it). Bye, Edwin Martin. --- Surf Edwin Martin's brainwaves: http://www.bitstorm.org/edwin/

[BUGS] Comment bug in psql

2001-04-09 Thread Martin Olsson
ments aren't recognized. The rest, 4-8, will be interpreted incorrectly. /Martin Olsson Sentor AB "There is at least one incorrect statement in this text, but it may be this one!" ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[BUGS] triggers

2001-08-14 Thread Martin Kuria
s but the table with the >foreign key should first check in the other table before any action is >taken, Which is the simplest sql or C language script can I use to enforce >triggers within my tables, please demonstrate a simple scenerio thanks Martin Wainaina Kuria Programmer/Data

[BUGS] postgres crash

2001-10-25 Thread Martin Würtele
ult.Flush.xrecoff); break; because otherwise postgres wouldn't even start. my question: how can i either get a dump of my data or a running database back. i did a backup of /var/lib/postgresql/data before removing indexes so i still have the version after the crash.

[BUGS] problems after server crash

2001-10-25 Thread Martin Würtele
kup of /var/lib/postgresql/data before removing indexes so i still have the version after the crash. tia martin -- factline Krisper Fabro Harnoncourt OEG (www.factline.com) ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

[BUGS] help!

2002-04-23 Thread martin tan
I would just want to ask if what is the default password of postgresql after installing it... coz when i type su postgres it ask me a password which i dont know what? Thnx -- ___ Sign-up for your own FREE Personalized E

[BUGS] stopping server does not remove external_pid_file

2006-06-05 Thread Martin Pitt
Hi PostgreSQL developers, I just played around with external_pid_file in 8.1.4. I noticed that the file is created and filled properly, but it is not removed again when the server is stopped. Thank you, Martin -- Martin Pitthttp://www.piware.de Ubuntu Developer http://www.ubuntu.com

[BUGS] Fwd: Bug#372115: Last security update of postgresql-contrib breaks database replication with DBMirror.pl

2006-06-10 Thread Martin Pitt
style. Thank you in advance for any idea, Martin - Forwarded message from Olivier Bornet <[EMAIL PROTECTED]> - Subject: Bug#372115: Last security update of postgresql-contrib breaks database replication with DBMirror.pl Reply-To: Olivier Bornet <[EMAIL PROTECTED]>, [EMAIL PROTECT

Re: [BUGS] Bug#372115: Last security update of postgresql-contrib breaks database replication with DBMirror.pl

2006-06-27 Thread Martin Pitt
Hi PostgreSQL gurus, hi Olivier, Martin Pitt [2006-06-16 0:15 +0200]: > Upstream confirmed my reply in the last mail in [1]: the complete > escaping logic in DBMirror.pl is seriously screwew. > > [1] http://archives.postgresql.org/pgsql-bugs/2006-06/msg00065.php I finally found

[BUGS] Fwd: Bug#380047: libpq-dev: no declaration for pg_encoding_to_char

2006-07-29 Thread Martin Pitt
-fe.h (or pg_wchar.h included into the postgresql client development package), or is this function obsolete? Thank you! Martin [1] http://bugs.debian.org/18858 - Forwarded message from Matej Vela <[EMAIL PROTECTED]> - Subject: Bug#380047: libpq-dev: no declarati

Re: [BUGS] Fwd: Bug#380047: libpq-dev: no declaration for pg_encoding_to_char

2006-07-30 Thread Martin Pitt
lated to the topic at hand: > > http://bugs.debian.org/318858 Erm, yes, yay for my typos. :/ /me looks on the floor for a dropped '3'. Have a nice Sunday, Martin -- Martin Pitt http://www.piware.de Ubuntu Developer http://www.ubuntulinux.org Debian Deve

[BUGS] Fwd: Bug#390730: postgresql-8.1: segfaults on huge litteral IN clauses

2006-10-07 Thread Martin Pitt
ue, it might be worth fixing in 8.1 (even if it's just a small test for an upper bound for IN clauses?) Thank you in advance, Martin - Forwarded message from Benoît Dejean <[EMAIL PROTECTED]> - Subject: Bug#390730: postgresql-8.1: segfaults on huge litteral IN clauses Reply

Re: [BUGS] BUG #2830: Wrong results for prepared statements while clustering target table

2006-12-17 Thread Martin Pihlak
pshot. Ok, makes sense. The same reasoning probably applies to INSERT and UPDATE as well. Still the problem remains - how to cluster a table on a busy system without losing data or getting wrong results. Perhaps the issue should be documented, although a fix would be preferrable ;) Martin --

[BUGS] BUG #2971: 8.1.7/8.2.2 break constraint checking for 'update'

2007-02-05 Thread Martin Pitt
The following bug has been logged online: Bug reference: 2971 Logged by: Martin Pitt Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.2 Operating system: Linux Description:8.1.7/8.2.2 break constraint checking for 'update' Details: Originally r

Re: [BUGS] Strange "Table has type character varying, but query expects character varying" errors

2007-02-06 Thread Martin Pitt
gt; They were running PostgreSQL 8.1.4 on Ubuntu Dapper, dual-core Intel > Machines. Right, that is the same issue I already reported to this list, and is already reported in Launchpad, too: https://launchpad.net/bugs/83505 Martin -- Martin Pitthttp://www.piware.de Ubuntu Developer http

Re: [BUGS] BUG #2971: 8.1.7/8.2.2 break constraint checking for 'update'

2007-02-06 Thread Martin Pitt
Hi Tom, Tom Lane [2007-02-06 11:25 -0500]: > "Martin Pitt" <[EMAIL PROTECTED]> writes: > > db> create table foo (bar VARCHAR(20) NOT NULL check (bar in > > ('FOO','BAR'))); > > CREATE TABLE > > > db> insert into foo (

Re: [BUGS] Strange "Table has type character varying, but query expects character varying" errors

2007-02-06 Thread Martin Pitt
gt; They were running PostgreSQL 8.1.4 on Ubuntu Dapper, dual-core Intel > Machines. Right, that is the same issue I already reported to this list, and is already reported in Launchpad, too: https://launchpad.net/bugs/83505 Martin -- Martin Pitthttp://www.piware.de Ubuntu Developer http

[BUGS] postmaster 8.2 eternally hangs in sempaphore lock acquiring

2007-03-29 Thread Martin Pitt
involved. At this point I am not sure which further information I could provide. Mark would be happy provide more information and/or directly talk with you. Thanks in advance, Martin -- Martin Pitthttp://www.piware.de Ubuntu Developer http://www.ubuntu.com Debian Developer http

Re: [BUGS] postmaster 8.2 eternally hangs in sempaphore lock acquiring

2007-03-29 Thread Martin Pitt
Hi Tom, hi Mark, Tom, thank you for having a look into this! Tom Lane [2007-03-29 13:49 -0400]: > Martin Pitt <[EMAIL PROTECTED]> writes: > > https://launchpad.net/bugs/93042 has symbolic gdb backtraces of all > > three processes that are involved. > > Are the

Re: [BUGS] postmaster 8.2 eternally hangs in sempaphore lock acquiring

2007-03-30 Thread Martin Pitt
Hi Heikki, Heikki Linnakangas [2007-03-30 8:57 +0100]: > Martin: Would it be possible for you to reproduce the problem with a > patched version? I cannot reproduce the problem myself, but I can easily build a package with this patch, hand it to Mark, and ask him to test it. Thanks

[BUGS] Fwd: Bug#425125: postgresql-8.1: localhost does not work for unix sockets in ~/.pgpass

2007-05-20 Thread Martin Pitt
Hello PostgreSQL developers, I just got the bug report below from a Debian user. The comment on http://www.postgresql.org/docs/8.1/interactive/libpq-pgpass.html confirms this, it describes the exact same problem. Thank you, Martin - Forwarded message from David <[EMAIL PROTECTED]> --

[BUGS] psql CLI: warn about ongoing transaction on exit

2007-09-16 Thread Martin Pitt
stands, it just rolls back the transaction." Does this stand a chance to get implemented/accepted? I'm happy to look into this and craft a patch if you would adopt it upstream. Thanks, Martin [1] http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=439943 -- Martin Pitthttp:/

Re: [BUGS] psql CLI: warn about ongoing transaction on exit

2007-09-17 Thread Martin Pitt
I'm not sure whether that would help this use case so much. What do you think about displaying a different prompt when a transaction is pending, like showing the number of open transactions in parentheses or so? '(2 transactions pending) mydb$' is way too long, and '(T2) mydb$&#

[BUGS] Provide a way to not ask for a password in psql

2007-10-09 Thread Martin Pitt
is to use the dodgy patch in (3), but I'd prefer to use an official upstream sanctioned method. Thank you! Martin -- Martin Pitthttp://www.piware.de Ubuntu Developer http://www.ubuntu.com Debian Developer http://www.debian.org signature.asc Description: Digital signature

[BUGS] libpq crash fix [was: Provide a way to not ask for a password in psql]

2007-10-09 Thread Martin Pitt
Hi again, Martin Pitt [2007-10-09 15:56 +0200]: > (2) PGPASSFILE=/dev/null psql -l > >With /dev/null I get a segfault (I'll probably send a patch for >that later). Ah, it tried to free(pgpassfile) in PasswordFromFile(), but that is a local stack variable. Can you

Re: [BUGS] libpq5 8.3 breaks 8.2 compatibility with encodings

2007-10-12 Thread Martin Pitt
s not exported by libpq. Sounds convincing. The hard part is that this then also a bug in 8.2's initdb, which cannot be changed, so at least for this case we'll need a workaround. Martin -- Martin Pitthttp://www.piware.de Ubuntu Developer http://www.ubuntu.co

Re: [BUGS] libpq5 8.3 breaks 8.2 compatibility with encodings

2007-10-12 Thread Martin Pitt
top exporting pg_char_to_encoding and so on from libpq, > though I wonder if that would break any clients. Hm, at least that sounds like a good method to find out what other parts of the code use this array directly. Thanks, Martin -- Martin Pitthttp://www.piware.de Ubuntu

Re: [BUGS] libpq5 8.3 breaks 8.2 compatibility with encodings

2007-10-12 Thread Martin Pitt
Hi, Martin Pitt [2007-10-12 16:33 +0200]: > I'm currently hunting down the last postgresql-common test case > failure that I see with 8.3beta1. It seems the 8.3 version of libpq > changes some internal encoding lists? Ah, got it. The ordering in pg_enc2name_tbl[] changed, which mak

[BUGS] libpq5 8.3 breaks 8.2 compatibility with encodings

2007-10-12 Thread Martin Pitt
r/lib/postgresql/8.2/bin/initdb --encoding UTF8 -D /tmp/x [...] The database cluster will be initialized with locale en_US.UTF-8. [...] $ /usr/lib/postgresql/8.2/bin/postgres -D /tmp/x -k /tmp & $ /usr/lib/postgresql/8.2/bin/psql -Alth /tmp postgres|martin|UTF8 template0|martin|UTF8

Re: [BUGS] libpq5 8.3 breaks 8.2 compatibility with encodings

2007-10-12 Thread Martin Pitt
Hi, Tom Lane [2007-10-12 11:50 -0400]: > Martin Pitt <[EMAIL PROTECTED]> writes: > > Ah, got it. The ordering in pg_enc2name_tbl[] changed, which makes the > > indices jump around. > > Sorry, you don't get to put JOHAB back into the portion of the list that > i

[BUGS] Test suite fails on alpha architecture

2007-11-03 Thread Martin Pitt
log including diffs and initdb/postmaster logs is on http://experimental.ftbfs.de/fetch.php?&pkg=postgresql-8.3&ver=8.3%7Ebeta2-1&arch=alpha&stamp=1193991806&file=log&as=raw Thank you! Martin -- Martin Pitt http://www.piware.de Ubuntu Developer http://www.ubu

Re: [BUGS] Test suite fails on alpha architecture

2007-11-03 Thread Martin Pitt
Hi, Tom Lane [2007-11-03 14:27 -0400]: > Martin Pitt <[EMAIL PROTECTED]> writes: > > The testsuite of 8.3 beta 2 fails on the Alpha architecture (versions > > up to 8.2 worked fine). > > We redid some of the float error handling for 8.3, in hopes of getting > closer

Re: [BUGS] Test suite fails on alpha architecture

2007-11-07 Thread Martin Pitt
Hi Tom, Tom Lane [2007-11-07 13:49 -0500]: > Bottom line is that I see nothing here that the Postgres project can > fix --- these are library and compiler bugs. Thank you for your detailled analysis! I'll file bugs to the appropriate places then. Thanks, Martin -- Martin Pitt

Re: [BUGS] Test suite fails on alpha architecture

2007-12-04 Thread Martin Pitt
Hi, Tom Lane [2007-11-07 13:49 -0500]: > All the other diffs that Martin showed are divide-by-zero failures, > and I do not see any of them on Gentoo's machine. I think that this > must be a compiler bug. The first example in his diffs is just > "select 1/0"

Re: [BUGS] Test suite fails on alpha architecture

2007-12-04 Thread Martin Pitt
Martin Pitt [2007-12-04 23:43 +0100]: > So I tried to approach it from the other side: Building postgresql > with CFLAGS="-O0 -g" or "-O1 -g" works correctly, but with "-O2 -g" I > get above bug. Just FAOD, building with gcc 4.1 and -O2 works fine. I guess

Re: [BUGS] BUG #3809: SSL "unsafe" private key permissions bug

2007-12-09 Thread Martin Pitt
with any configuration files.) I already proposed this patch two times, but it has been rejected so far unfortunately. But maybe it's useful for you. Martin -- Martin Pitthttp://www.piware.de Ubuntu Developer http://www.ubuntu.com Debian Developer http://www.debian.org diff -Nu

[BUGS] pg_dump produces invalid SQL for "group by cast(null as numeric)"

2008-01-05 Thread Martin Pitt
uld be handled by pg_dump, or it is invalid and should not be accepted in the first place. Thank you! Martin [1] https://bugs.launchpad.net/bugs/177382 -- Martin Pitthttp://www.piware.de Ubuntu Developer http://www.ubuntu.com Debian Developer http://www.debian.org signature.asc Description: Digital signature

[BUGS] BUG #3907: Deadlock while "vacuum verbose analyze" runs...

2008-01-28 Thread Martin Fandel
The following bug has been logged online: Bug reference: 3907 Logged by: Martin Fandel Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.5 Operating system: Suse Linux Enterprise 10 Description:Deadlock while "vacuum verbose analyze" runs... Details:

Re: [BUGS] BUG #4040: psql should provide option to not prompt for password

2008-03-17 Thread Martin Pitt
ks pretty well. I already proposed that some months ago [1], but didn't get very far. Martin [1] http://www.mail-archive.com/pgsql-bugs@postgresql.org/msg18440.html -- Martin Pitt| http://www.piware.de Ubuntu Developer (www.ubuntu.com) | Debian Developer (www.debi

Re: [BUGS] BUG #4040: psql should provide option to not prompt for password

2008-03-17 Thread Martin Pitt
Tom Lane [2008-03-17 10:48 -0400]: > Martin Pitt <[EMAIL PROTECTED]> writes: > > if (PQstatus(pset.db) == CONNECTION_BAD && > > PQconnectionNeedsPassword(pset.db) && > > - password == NULL &&

[BUGS] BUG #4054: Text containing ';' upsets db restores

2008-03-24 Thread Martin Gregorie
The following bug has been logged online: Bug reference: 4054 Logged by: Martin Gregorie Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.6 Operating system: Linux (Redhat Fedora 8 Description:Text containing ';' upsets db restores Details:

[BUGS] Recommended approach for upgrading DBs with nonmatching encodings

2008-03-30 Thread Martin Pitt
around, so the upgrade should fail if it encounters an UTF-8 character which cannot be encoded into an. e. g. LATIN1 character. Thank you all for any suggestion, Martin [1] http://www.nabble.com/BUG--3924:-Create-Database-with-another-encoding-as-the-encoding-from-postgres-td15246051.html [2] ht

Re: [BUGS] Recommended approach for upgrading DBs with nonmatching encodings

2008-03-30 Thread Martin Pitt
Hi again, Martin Pitt [2008-03-30 20:40 +0200]: > My current pg_upgradecluster uses pg_dumpall to copy the schema, and a > per-db pg_dump to copy the DB table contents. Will calling pg_dump > with --encoding= always DTRT and is > it meant to solve this problem? One problem with

Re: [BUGS] Recommended approach for upgrading DBs with nonmatching encodings

2008-03-30 Thread Martin Pitt
Tom Lane [2008-03-30 16:43 -0400]: > Martin Pitt <[EMAIL PROTECTED]> writes: > > One problem with this is that while pg_dump -E UTF8 works (with SQL > > output), -E does not seem to have any effect when using -Fc. > > Huh? Please provide a test case. Ah, I got it. Th

Re: [BUGS] Recommended approach for upgrading DBs with nonmatching encodings

2008-03-30 Thread Martin Pitt
he upgrade script do if it encounters an 8.[12] server running under C? Thanks, Martin -- Martin Pitt| http://www.piware.de Ubuntu Developer (www.ubuntu.com) | Debian Developer (www.debian.org) -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make ch

Re: [BUGS] reproducible database crash with simple sql command

2008-05-09 Thread Martin Pitt
eSQL 8.3.1 on Ubuntu 8.04, also under a German installation/locale. After the ALTER I get martin=> \d regions Tabelle »public.regions« Spalte |Typ| Attribute +---+-- id |

[BUGS] BUG #4187: function to_tsvector not immutable

2008-05-23 Thread Martin Sullivan
The following bug has been logged online: Bug reference: 4187 Logged by: Martin Sullivan Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3 Operating system: Fedora Core 9 Description:function to_tsvector not immutable Details: Postgres 8.3 now supports

  1   2   3   >