[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
for me. 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 your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

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
ng special, but it still does more then 10 wakeups/second on that system, uselessly. If idle, it shouldn't even appear in powertop's profile. Thanks, Xav - End forwarded message - -- Martin Pitt| http://www.piware.de Ubuntu Developer (www.ubu

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] 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] 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] [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] 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
patch is not the DBMirror.pl, but the "recordchange" procedure called by the trigger on each data change. Reverting postgresql-contrib to version 7.4.7-6sarge1 correct the problem only if you have nothing in the Pending table. Thanks for your attention, and have a nice day.

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
Matej - End forwarded message - -- Martin Pitthttp://www.piware.de Ubuntu Developer http://www.ubuntu.com Debian Developer http://www.debian.org In a world without walls and fences, who needs Windows and Gates? signature.asc Description: Digital signature

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
PostgreSQL C client library ii libssl0.9.8 0.9.8c-2SSL shared libraries ii postgresql-client-8.18.1.4-7 front-end programs for PostgreSQL ii postgresql-common 63 manager for PostgreSQL database cl postgresql-8.1 recommends no packages. --

[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
a lot! Martin -- Martin Pitthttp://www.piware.de Ubuntu Developer http://www.ubuntu.com Debian Developer http://www.debian.org signature.asc Description: Digital signature

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

2007-05-20 Thread Martin Pitt
/bin/sh linked to /bin/bash -- no debconf information - End forwarded message - -- Martin Pitthttp://www.piware.de Ubuntu Developer http://www.ubuntu.com Debian Developer http://www.debian.org ---(end of broadcast)--- TIP 9: In vers

[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
x27; is not intuitive. Hmm.. Thanks, Martin -- Martin Pitthttp://www.piware.de Ubuntu Developer http://www.ubuntu.com Debian Developer http://www.debian.org ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send a

[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
ABI compatibility without announcing it in the SONAME. From the previous discussion it is quite clear that a soname bump is a pain, so could this be changed somehow to accomodate new encodings while remaining binary compatibility with earlier releases? Thanks, Martin -- Martin Pitthttp://www

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
side: Building postgresql with CFLAGS="-O0 -g" or "-O1 -g" works correctly, but with "-O2 -g" I get above bug. So I guess I'll build with -O1 for the time being on sparc and alpha to get correct binaries until this is sorted out. Any idea what els

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

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] Recommended approach for upgrading DBs with nonmatching encodings

2008-03-30 Thread Martin Pitt
tp://bugs.debian.org/472930 [3] http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=472930#10 [4] https://bugs.launchpad.net/207779 -- Martin Pitt| http://www.piware.de Ubuntu Developer (www.ubuntu.com) | Debian Developer (www.debian.org) signature.asc Description: Digital signature

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
integer | name | character varying | default 'bavaria'::character varying which looks alright to me. Might be a windows specific bug? Martin -- Martin Pitt| http://www.piware.de Ubuntu Developer (www.ubuntu.com) | Debian Developer (www.de

[BUGS] Fwd: Bug#224716: postgresql-client: createuser fails

2004-01-08 Thread Martin Pitt
h fixes this by just ignoring -E when -P is not given. The patch should work against your current CVS; it is already included in the Debian package CVS. Thanks and have a nice day! Martin -- Martin Pitt Debian GNU/Linux Developer [EMAIL PROTECTED] [EMAIL PROTECT

[BUGS] Fwd: Default pg_autovacuum config glitches

2004-03-25 Thread Martin Pitt
ed bad behaviour on the part of a long-running daemon. (If you feel this is pg_autovacuum's fault rather than the init script's, please reassign to postgresql-contrib.) Thanks! - End forwarded message - -- Martin Pitt Debian GNU/Linux Developer [EMAIL PROTECT

[BUGS] Fwd: Infinite recursion in function causes DoS

2004-03-25 Thread Martin Pitt
ql/peer-to-ident: true postgresql/missing_conf: true * postgresql/purge_data_too: false * postgresql/settings/encoding: UNICODE * postgresql/settings/date_style: ISO ----- End forwarded message - -- Martin Pitt Debian GNU/Linux Developer [EMAIL PROTECTED]

Re: [BUGS] Fwd: Bug#247306: odbc-postgresql: SIGSEGV with long inputs (> 10000 bytes)

2004-05-11 Thread Martin Pitt
Hi! On 2004-05-12 1:31 +0200, Peter Eisentraut wrote: > Martin Pitt wrote: > > A week ago we at Debian received the bug report below: due to a > > buffer overflow in psqlodbc it is possible to crash (and possibly > > exploit) apache. I already sent this mail to the psqlo

[BUGS] Fwd: Bug#247306: odbc-postgresql: SIGSEGV with long inputs (> 10000 bytes)

2004-05-11 Thread Martin Pitt
i odbcinst1 2.2.4-9 Support library and helper program -- no debconf information - End forwarded message - -- Martin Pitt Debian GNU/Linux Developer [EMAIL PROTECTED] [EMAIL PROTECTED] http://www.piware.de ht

Re: [BUGS] Fix for buffer overflow ready [was: Fwd: Bug#247306: odbc-postgresql: SIGSEGV with long inputs (> 10000 bytes)]

2004-05-13 Thread Martin Pitt
doing this is far beyond the scope of a security patch (especially for Debian stable). One question: which mailing list is the better place to discuss this? -odbc or -bugs? Thanks and have a nice day! Martin -- Martin Pitt Debian GNU/Linux Developer [EMAIL PROTECTED]

[BUGS] Fwd: Bug#249036: postgresql: zero bytes cannot be entered in string literal, not even with \000 notation

2004-05-17 Thread Martin Pitt
Object-relational SQL database, ... ii postgresql-cli 7.4.2-4Front-end programs for PostgreSQL thx, Peter Schueller -- System Information: Debian Release: testing/unstable APT prefers unstable APT policy: (500, 'unstable') Architecture: i386 (i686) Kernel: Linux 2.6.6 Locale:

[BUGS] Patch for not going beyond NOFILE system limit

2004-05-17 Thread Martin Pitt
! Martin -- Martin Pitt Debian GNU/Linux Developer [EMAIL PROTECTED] [EMAIL PROTECTED] http://www.piware.de http://www.debian.org diff -ruN postgresql-7.4.2-old/src/backend/storage/file/fd.c postgresql-7.4.2/src/backend/storage/file/fd.c --- postgresql

Re: [BUGS] Fwd: Bug#249036: postgresql: zero bytes cannot be entered in string literal, not even with \000 notation

2004-05-17 Thread Martin Pitt
Hi! On 2004-05-17 8:37 -0400, Bruce Momjian wrote: > The issue is that bytea needs double-backslashes because single > backslashes are processed by the parser into strings: Indeed. Thank you for this! Martin -- Martin Pitt Debian GNU/Linux Developer [EMAIL PRO

[BUGS] Fix for buffer overflow ready [was: Fwd: Bug#247306: odbc-postgresql: SIGSEGV with long inputs (> 10000 bytes)]

2004-05-17 Thread Martin Pitt
Hi again! Sorry for crossposting, but I sent the initial post also to -bugs, because I did not get an answer on -odbc. On 2004-05-11 12:03 +0200, Martin Pitt wrote: > I noticed Apache segfaulting when I feed a simple form with long inputs: > > [Tue May 4 11:32:10 2004] [notice]

[BUGS] Fwd: Bug#249083: postgresql: Postgres SIGSEGV if wins in nsswitch.conf

2004-05-25 Thread Martin Pitt
ns.so.2 ... #35 0x4028efce in __errno_location () from /lib/libc.so.6 Winbind name lookup works fine normally, still I wouldn't be too much surprised if this was in fact a winbind bug. - End forwarded message - -- Martin Pitt Debian GNU/Linux Developer [EMAIL PROT

Re: [BUGS] Fwd: Bug#249083: postgresql: Postgres SIGSEGV if wins in nsswitch.conf

2004-05-27 Thread Martin Pitt
. Thank you for this patch. I applied it and prepared an inofficial package for the original submitter to test. I hoped to get a quick answer from him, but up to now I didn't. I will report back when I have any news. Have a nice day! Martin -- Martin Pitt Debian GNU/Linux

Re: [BUGS] Fwd: Bug#249083: postgresql: Postgres SIGSEGV if wins in nsswitch.conf

2004-06-07 Thread Martin Pitt
the command line, as user postgres and got, instead: 98e3 ed40 9101 e340 These garbage strings are repeatable. In either case, I did get the seg fault. Does that say anything to anybody? Thanks and have a nice day! Martin -- Martin Pit

Re: [BUGS] Fwd: Bug#249083: postgresql: Postgres SIGSEGV if wins in nsswitch.conf

2004-06-08 Thread Martin Pitt
n P.S. No need to CC me, I'm subscribed (see Mail-Followup-To). -- Martin Pitt Debian GNU/Linux Developer [EMAIL PROTECTED] [EMAIL PROTECTED] http://www.piware.de http://www.debian.org tokens.tar.gz Description: Binary data -

Re: [BUGS] Fwd: Bug#249083: postgresql: Postgres SIGSEGV if wins in nsswitch.conf

2004-06-08 Thread Martin Pitt
d the whole source tree for an invocation of next_token[_expand] and found nothing. Where the heck this is called from? Looking at the stacktrace it seems to be kind of a callback from libnss_wins, but somewhere this must be set!? So who calls next_token and who sets the file, buffer and bufsz p

[BUGS] Fwd: Bug#253295: postgresql: VACUUM FULL produce warnings

2004-06-23 Thread Martin Pitt
te REINDEX DATABASE OE> Is it the case that this problem keeps recurring? i can't say when problem appear, but i see it every day on working database. what may be problem source? how can i find it? - i found now AUTOVACUUM=yes in postmaster.conf, but postgesql-contrib don't in

Re: [BUGS] [Fwd: Bug#255208: postgresql - ignores SIGPIPE]

2004-06-23 Thread Martin Pitt
not documented and the daemon is able to abort queries in > this state. > > It makes systems unusable by stuck server processes which aren't > abortable without admin intervention. > > Bastian Thanks and have a nice day, Martin -- Martin Pitt

Re: [BUGS] Fwd: Bug#253295: postgresql: VACUUM FULL produce warnings

2004-07-08 Thread Martin Pitt
Hi Tom! On 2004-06-23 11:09 -0400, Tom Lane wrote: > Martin Pitt <[EMAIL PROTECTED]> writes: > > Recently we got the following bug report about VACUUM FULL. Can > > anybody comment on this? > > This was reported to the PG lists already. We asked for a test case >

[BUGS] Fwd: postgresql-autodoc - missinterprets "version"

2004-07-08 Thread Martin Pitt
ifferent field types and got the same results. However if the field name isn't "version" there are no problem at all. I hope it helps. -- Tommaso Moroni [EMAIL PROTECTED] - End forwarded message - -- Martin Pitt Debian GNU/Linux Developer [EMAIL PROTECTED] [EMAIL PROTECTED] http://www.piware.de http://www.debian.org signature.asc Description: Digital signature

Re: [BUGS] Fwd: postgresql-autodoc - missinterprets "version"

2004-07-08 Thread Martin Pitt
identifier is safe or not... so be safe not sorry. This makes sense, thank you. I reassigned this bug to postgresql-autodoc. Just ignoring the quotes cannot be that difficult... Thanks and have a nice day! Martin -- Martin Pitt Debian GNU/Linux Developer [EMAIL PROTECTE

[BUGS] psql: set \encoding according to the current locale

2004-10-31 Thread Martin Pitt
nment variables instead of the database encoding. It would also be nice to call "set \encoding" to match the locale psql was called under, at least when it is called interactively. Thanks and have a nice day! Martin -- Martin Pitt http://www.piware.de U

[BUGS] Some patches to enhance the contrib build

2004-10-31 Thread Martin Pitt
PostgreSQL's TEXT field Do you consider adopting them in the official version? Thanks a lot and have a nice day! Martin -- Martin Pitt http://www.piware.de Ubuntu Developerhttp://www.ubuntulinux.org Debian GNU/Linux Developer http://www.debian.org

Re: [BUGS] Some patches to enhance the contrib build

2004-11-01 Thread Martin Pitt
Hi again! Martin Pitt [2004-11-01 9:04 +0100]: > Neil Conway [2004-11-01 14:06 +1100]: > > 20pg_dump_datestyle seems redundant (we already set DateStyle to ISO in > > pg_dump). I will look at this and remove it if appropriate. Thanks for the hint. > > ISTM the right fix

Re: [BUGS] Some patches to enhance the contrib build

2004-11-01 Thread Martin Pitt
ly in arch head: http://arch.debian.org/arch/pkg-postgresql/postgresql/ The three 25contrib* were split out of the 25contrib patch currently in 7.4.6-2. The dbf2pg patches were added by me yesterday. I will probably make a new upload soon, though. Thanks for considering and have a nice day! Martin -- Martin Pitt http://www.piware.de Ubuntu Developerhttp://www.ubuntulinux.org Debian GNU/Linux Developer http://www.debian.org signature.asc Description: Digital signature

[BUGS] Insecure temporary file usage in developer/build tools

2005-01-24 Thread Martin Pitt
only used on PostgreSQL developer's machines, so it might be a good idea to fix then eventually. Thanks for considering and for your great work and have a nice day! Martin -- Martin Pitt http://www.piware.de Ubuntu Developerhttp://www.ubuntulinux.o

[BUGS] Fwd: Bug#308535: postgresql-client: [psql] manual page does not document ~/.pgpass file

2005-05-13 Thread Martin Pitt
rg/docs/7.4/static/libpq-pgpass.html I have no idea why it is there, where nobidy is looking - End forwarded message - -- Martin Pitt http://www.piware.de Ubuntu Developer http://www.ubuntulinux.org Debian Developerhttp://www.debian.org signature.asc Description: Digital signature

[BUGS] Fwd: Bug#308513: postgresql-client: [manual] createuser(1) Add example '...WITH PASSWORD'

2005-05-13 Thread Martin Pitt
the underlying command: $ createuser -p 5000 -h eden -D -A -e joe -CREATE USER "joe" NOCREATEDB NOCREATEUSER +CREATE USER joe NOCREATEDB NOCREATEUSER +CREATE USER + + + + +To create the joe user with a password: + +$ createuser -e joe -P -d -a +CREATE USER joe PASSWORD 'secr

Re: [BUGS] Fwd: Bug#308535: postgresql-client: [psql] manual page does not document ~/.pgpass file

2005-05-16 Thread Martin Pitt
Hi! Tom Lane [2005-05-13 9:49 -0400]: > Martin Pitt <[EMAIL PROTECTED]> writes: > > We recently got the bug report below. Do you agree that documenting > > ~/.pgpass in psql(1) is a good idea? > > On that theory we'd have to replicate large parts of the libpq >

[BUGS] More graceful handling of invalid log_*_stats conf in 7.4

2005-06-02 Thread Martin Pitt
.4 docs. Can this case be handled more gracefully in 7.4? Maybe the check from 8.0 can be ported to 7.4? Thanks and have a nice day! Martin -- Martin Pitt http://www.piware.de Ubuntu Developer http://www.ubuntulinux.org Debian Developerhttp://www.debian.org psql_bug_cacheid.sh

Re: [BUGS] More graceful handling of invalid log_*_stats conf in 7.4

2005-06-02 Thread Martin Pitt
Hi! Tom Lane [2005-06-02 11:46 -0400]: > Martin Pitt <[EMAIL PROTECTED]> writes: > > I found out that activating > > > log_parser_stats = true > > log_planner_stats = true > > log_executor_stats = true > > log_statement_stats = true > > >

Re: [BUGS] Bug#311533: Invalid timestamp returned because of timezone

2005-06-10 Thread Martin Pitt
fix integer timestamps, or if that is not possible, at least support selecting integer or float time stamps at runtime (maybe as a postmaster option). Can this be done in any way? Thanks in advance for any thought and have a nice day! Martin [1] http://bugs.debian.org/311533 -- Martin Pitt

Re: [BUGS] Bug#311533: Invalid timestamp returned because of timezone

2005-06-11 Thread Martin Pitt
Hi! Andrew - Supernews [2005-06-10 23:29 -]: > On 2005-06-10, Martin Pitt <[EMAIL PROTECTED]> wrote: > >> As per conversation in #postgresql in freenode, it has been found that > >> this seems to manifest on pgsql compiled using integer-datetime; > >> float

  1   2   >