fault mode (which I assume will use
one transaction by row)? Is that a safe thing to do, or could one run
into out-of-memory conditions?
http://people.canonical.com/~pitti/tmp/pg_upgradecluster is a version
with these two changes: pg_restore --single-transaction and using the
tar
tps://launchpad.net/~pitti/+archive/postgresql or
http://pgapt.debian.net/ (but be aware that neither are officially
supported).
Martin
--
Martin Pitt| http://www.piware.de
Ubuntu Developer (www.ubuntu.com) | Debian Developer (www.debian.org)
--
Sent via
est.dump" (i. e. a full dump), you see
SELECT pg_catalog.setval('odd10', 3, true);
in the dump, but it is not present in the output of
"pg_restore --data-only /tmp/test.dump". However, when I use the 9.1
version, it works:
$ /usr/lib/postgresql/9.1/bin/pg_res
is at 9.1.3 in Ubuntu 11.10 since Tuesday. So
you can just use the packaged version.
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
the risk of using an inappropriate choice of lock width.
OK, fair enough. New patch attached, which does exactly this now.
Third time is the charm!
Thanks,
Martin
--
Martin Pitt| http://www.piware.de
Ubuntu Developer (www.ubuntu.com) | Debian Developer (www.debian.org
Hello Tom, all,
Tom Lane [2011-12-20 21:14 -0500]:
> Getting this thread back to the original patch ... I'm afraid that if we
> apply this as-is, what will happen is that we fix ARMv7 and break older
> versions.
Right, I guess it's dependent on the compiler version, too. That's why
my original pa
on ARMv7
and newer, as stated in the original mail.
Thanks,
Martin
--
Martin Pitt| http://www.piware.de
Ubuntu Developer (www.ubuntu.com) | Debian Developer (www.debian.org)
Description: Use gcc/intel cc builtin atomic operations for test-and-set, if available (http
Tom Lane [2011-12-19 10:25 -0500]:
> Heikki Linnakangas writes:
> > On 19.12.2011 16:31, Robert Haas wrote:
> >> On Sun, Dec 18, 2011 at 5:42 PM, Martin Pitt wrote:
> >>> I agree. How about a patch like this? It uses builtin atomics if
> >>&g
)
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
Robert Haas [2011-12-19 9:31 -0500]:
> On Sun, Dec 18, 2011 at 5:42 PM, Martin Pitt wrote:
> >> It probably makes sense to use it on any platform where it's
> >> defined. Presumably an implementation provided by the compiler is
> >> always going to be at l
erifies that __sync_lock_release() is available.
The patch is against 9.1.2, but I suppose it also applies to trunk
(except perhaps the autogenerated configure part, this needs an
autoheader/autoconf run).
Thanks for considering,
Martin
--
Martin Pitt| http:
t land upstream, perhaps it is useful for
other porters/packagers.
Thanks,
Martin
[1] http://gcc.gnu.org/onlinedocs/gcc-4.1.2/gcc/Atomic-Builtins.html
--
Martin Pitt| http://www.piware.de
Ubuntu Developer (www.ubuntu.com) | Debian Developer (www.debian.org)
Description:
here is an already existing configuration for 8.4, or
the package was installed before. The default cluster only gets
created if this is more or less a "clean" install.
Martin
--
Martin Pitt| http://www.piware.de
Ubuntu Developer (www.ubuntu.com) | Debian Develo
es be fixed to do this substitution?
It doesn't only affect intarray, but pretty much all *.sql files.
Thanks for any insight,
Martin Pitt
--
Martin Pitt| http://www.piware.de
Ubuntu Developer (www.ubuntu.com) | Debian Developer (www.debian.org)
signature.asc
Description: Digital signature
ersions of packages postgresql depends on:
ii postgresql-8.4 8.4.7-0squeeze2 object-relational SQL database, ve
postgresql recommends no packages.
postgresql suggests no packages.
-- no debconf information
- End forwarded message -
--
Martin Pitt| http://
anks!
(grep failure, sorry)
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
l -Atq template1
ERROR: unterminated quoted string at or near "'"
LINE 1: select '\'a'
------- 8<
Since HISTORY does not mention this, is that an explicit decision to
finally deprecate the old \' syntax (which would be great, as it makes
this thing a lot more robust and deterministic, but it might be worth
mentioning it in HISTORY), or an unintended side effect?
Thanks,
Martin
--
Martin Pitt| http://www.piware.de
Ubuntu Developer (www.ubuntu.com) | Debian Developer (www.debian.org)
signature.asc
Description: Digital signature
ocale-archive. I
cleaned this up, and it works now.
Sorry for the noise!
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
forgot to modify postgresql.conf.sample, and I'm not entirely
> sure what to change it to. Maybe just do
>
> #log_timezone = '(default is system's timezone)'
FWIW, looks tood to me. This makes it a lot more obvious that this
isn't an accepted literal value.
ered a regression, as it's still in
postgresql.conf.sample, and in the documentation [1].
Thanks,
Martin
[1]
http://developer.postgresql.org/pgdocs/postgres/runtime-config-logging.html#GUC-LOG-TIMEZONE
--
Martin Pitt| http://www.piware.de
Ubuntu Developer (www.ubuntu.c
ion of the test suite, i. e. should I
always run the tests under the C locale? Or does it actually point
towards an unexpected behaviour?
Thanks,
Martin
--
Martin Pitt| http://www.piware.de
Ubuntu Developer (www.ubuntu.com) | Debian Developer (www.debian.org)
***
/home/mar
his isn't a gcc bug looks justified.
Aurelien sent a straightforward patch for this, I updated it to apply
to current git head, updated the comments, and git-formatted it.
Thanks for considering!
Martin
[2] http://www.open-std.org/jtc1/sc22/WG14/www/docs/n1256.pdf
--
Martin Pitt
m bug at all. Can you please open a Debian or
Ubuntu bug report, with the output of
ls -ld /sbin /bin /usr/sbin /usr/bin
? The error message suggests that one or more of these directories are
world-writable.
Thank you,
Martin
--
Martin Pitt| http://www.piware.de
Ubun
Magnus Hagander [2010-08-20 15:07 +0200]:
> Please add this to
> https://commitfest.postgresql.org/action/commitfest_view/open
Done, thanks!
https://commitfest.postgresql.org/action/patch_view?id=364
Martin
--
Martin Pitt| http://www.piware.de
Ubuntu Dev
Hello PostgreSQL developers,
Martin Pitt [2010-08-17 6:49 +0200]:
> I received a request to support system-wide root certificates in
> libpq. Right now it only looks in ~/.postgresql/root.crt, but since
> such certificates are usually set up system wide and be maintained by
> the s
fallback
lookup in /etc/postgresql/ or similar.
Would you accept a patch which adds a configure option for the path of
a system wide root certificate?
Thank you,
Martin
--
Martin Pitt| http://www.piware.de
Ubuntu Developer (www.ubuntu.com) | Debian Developer (www.debian.org
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
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
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
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
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
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.
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
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
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
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
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)
--
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
#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
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
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:
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.
,
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
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
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
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-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
(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
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
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
"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 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
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
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
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
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
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
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
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
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
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
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
Tom Lane [2008-03-17 10:48 -0400]:
> Martin Pitt <[EMAIL PROTECTED]> writes:
> > if (PQstatus(pset.db) == CONNECTION_BAD &&
> > PQconnectionNeedsPassword(pset.db) &&
> > - password == NULL &&
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
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
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
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
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
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-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
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
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,
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
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
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
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
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
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
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:/
/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
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
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
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
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
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
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.
--
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
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
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
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.
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
r postmaster to start..."$ECHO_C
while :
do
- if "$PGPATH/psql" -p $PGPORT -l >/dev/null 2>&1
+ if "$PGPATH/psql" -p $PGPORT -h "$PGHOST" -l >/dev/null 2>&1
then
break;
else
. | Software Development GIS
Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org
----- End forwarded message -
--
Martin Pitthttp://www.piware.de
Ubuntu Developer http://www.ubuntu.com
Debian Developer http://www.debian.org
In a world withou
r postmaster to start..."$ECHO_C
while :
do
- if "$PGPATH/psql" -p $PGPORT -l >/dev/null 2>&1
+ if "$PGPATH/psql" -p $PGPORT -h "$PGHOST" -l >/dev/null 2>&1
then
break;
else
SUE E
(3 registros)
Note:
Version for windows tested and OK ;)
----- End forwarded message -
--
Martin Pitthttp://www.piware.de
Ubuntu Developer http://www.ubuntu.com
Debian Developer http://www.debian.org
---(end of broadcast)---
Hi!
Tom Lane [2005-12-29 22:20 -0500]:
> Martin Pitt <[EMAIL PROTECTED]> writes:
> > I recently got a rather interesting Debian bug [1]: When upgrading a
> > pre-8.1 database to 8.1, the upgrade messes up permissions if the old
> > database had users and groups with
the manual way.
I just reported it here since other distributions have the same
problem, so knowing the official upstream approach is always helpful.
:)
Thank you,
Martin
--
Martin Pitt http://www.piware.de
Ubuntu Developer http://www.ubuntulinux.org
Debian Developerhttp:/
1 - 100 of 156 matches
Mail list logo
