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
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
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
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
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
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
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
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
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
. (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
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
"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
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
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
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
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
(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
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
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
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
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
,
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
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.
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:
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
#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
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
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)
--
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
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
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
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
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.
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
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
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
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
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
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
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
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
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: [
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
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
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
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]
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
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
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
POSTGRESQL BUG REPORT TEMPLATE
Your name : Martin Renters
Your email address : [EMAIL
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
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
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
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/
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
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
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.
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])
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
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
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
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
-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
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
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
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
--
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
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
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 (
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
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
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
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
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]> --
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:/
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$
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
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
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
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
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
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
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
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
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
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
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"
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
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
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
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:
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
Tom Lane [2008-03-17 10:48 -0400]:
> Martin Pitt <[EMAIL PROTECTED]> writes:
> > if (PQstatus(pset.db) == CONNECTION_BAD &&
> > PQconnectionNeedsPassword(pset.db) &&
> > - password == NULL &&
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:
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
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
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
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
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 |
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 - 100 of 254 matches
Mail list logo