Re: [GENERAL] [ANNOUNCE] PostgreSQL Core Team

2011-04-27 Thread Palle Girgensohn
Grattis Magnus! ;-) --On 27 april 2011 19.48.48 +0100 Dave Page dp...@postgresql.org wrote: I'm pleased to announce that effective immediately, Magnus Hagander will be joining the PostgreSQL Core Team. Magnus has been a contributor to PostgreSQL for over 12 years, and played a major part in

[GENERAL] why doesn't insert into foo delete from bar returning baz work?

2010-05-26 Thread Palle Girgensohn
While you can do insert into foo (a, b) select a, b from bar; and delete from bar where a=1 returning a, b; it fails to run insert into foo (a, b) delete from bar where a=1 returning a, b; This is not what I would expect. Is there a reason for it not working? Cheers Palle -- Sent via

Re: [GENERAL] pg_restore out of memory - big problem :(

2007-04-17 Thread Palle Girgensohn
Never mind this, the file was mangled when sent non-binary over ftp (windows ftp servers apparently still send ascii unless set type i is specified :) Cheers, Palle --On tisdag, april 17, 2007 12.49.46 +0200 Palle Girgensohn [EMAIL PROTECTED] wrote: Hi, I get out of memory immediately

Re: [GENERAL] /libexec/ld-elf.so.1: Shared object libpq.so.4 not found

2007-03-01 Thread Palle Girgensohn
postgresql-8-2 installs libpq.so.5. You need to upgrade pgadmin to link with libpq.so.5, or you need to downgrade postgresql to 8.1.x. Once you downgraded postgres, you can upgrade it again using portupgrade; it will save a copy of libpq.so.4 in /usr/local/lib/ compat/pkg/, so as long as

Re: [GENERAL] [EMAIL PROTECTED]: Re: port fault on pg_ctl's

2006-12-13 Thread Palle Girgensohn
--On onsdag, december 13, 2006 11.04.54 -0500 Tom Lane [EMAIL PROTECTED] wrote: Gergely CZUCZY [EMAIL PROTECTED] writes: This is wierd, I agree. The split between server and client is really made = in the postgresql sources, I just follow their guidelines. [ checks RPM specfiles ... ]

[GENERAL] linking problems with Kerberos (heimdal) on FreeBSD

2005-10-15 Thread Palle Girgensohn
Hi! I'm having some difficulties using postgresql version 8.0.x with heimdal installed from /usr/src (i.e. the base system). This is on FreeBSD-5.x. When using the port of heimdal, from /usr/ports/security/heimdal, it works. The port install into /usr/local, whereas the base system is in

[GENERAL] transaction started without BEGIN??? Please help!

2005-04-21 Thread Palle Girgensohn
Hi! I have a huge problem here. On a busy server (a web system, mainly java servlets/jsp running on tomcat) running postgresql-8.0.2, all of a sudden, one of the postgres processes gets into the state idle in transation (revealed by `ps axU pgsql'). We use transaction very sparesly, so this is

Re: [GENERAL] transaction started without BEGIN??? Please help!

2005-04-21 Thread Palle Girgensohn
are not logged? Is there no way to log the start of a transaction? I thought there would be a BEGIN, but there's not. /Palle Good luck. On 4/21/05, Palle Girgensohn [EMAIL PROTECTED] wrote: Hi! I have a huge problem here. On a busy server (a web system, mainly java servlets/jsp running on tomcat

[GENERAL] logging prepared queries' arguments?

2005-03-31 Thread Palle Girgensohn
Hi! When setting log_statement = all, and using JDBC PreparedStatements, I get $n where arguments used to be in previous versions of postgresql: postgres[30059]: [97-1] LOG: statement: INSERT INTO group_data (this_group_id, item_text, link_path) VALUES ($1, $2, $3) I really need to know the

[GENERAL] where is the locale set for each server instance?

2005-03-13 Thread Palle Girgensohn
Hi! I'm pluggin ICU into PostgreSQL for unicode collation, since FreeBSD has no support for unicode collation. It works fine, but I cannot find out where to set the default locale for each backend instance. I want to use the LC_COLLATE used in initdb, now I've just hard wired it for my own

Re: [GENERAL] where is the locale set for each server instance?

2005-03-13 Thread Palle Girgensohn
--On söndag, mars 13, 2005 17.01.31 -0500 Tom Lane [EMAIL PROTECTED] wrote: Palle Girgensohn [EMAIL PROTECTED] writes: So, I'm trying to find out where LC_COLLATE is overridden. Any tips? access/transam/xlog.c (which is the only file that touches pg_control, I believe). OK, seems my problem

Re: [GENERAL] where is the locale set for each server instance?

2005-03-13 Thread Palle Girgensohn
--On söndag, mars 13, 2005 18.37.24 -0500 Tom Lane [EMAIL PROTECTED] wrote: Palle Girgensohn [EMAIL PROTECTED] writes: OK, seems my problem is with ICU. The xlog.c:ReadConfigFile() is not run for each backend, it seems, I assume it is forked after that. No, it is run once in the postmaster

Re: [GENERAL] databases/p5-postgresql-plperl links to wrong

2005-02-14 Thread Palle Girgensohn
--On fredag, februari 11, 2005 18.35.45 -0500 Tom Lane [EMAIL PROTECTED] wrote: Sven Willenberger [EMAIL PROTECTED] writes: it looks like the sed line is stripping out pgac_tmp2 from the pgac_tmp1 leaving the system to use the default perl libperl.so. when I modified perl_embed_ldflags to not

Re: [GENERAL] databases/p5-postgresql-plperl links to

2005-02-14 Thread Palle Girgensohn
--On fredag, februari 11, 2005 19.08.54 -0500 Sven Willenberger [EMAIL PROTECTED] wrote: On Fri, 2005-02-11 at 18:35 -0500, Tom Lane wrote: Sven Willenberger [EMAIL PROTECTED] writes: it looks like the sed line is stripping out pgac_tmp2 from the pgac_tmp1 leaving the system to use the

Re: [GENERAL] [ANNOUNCE] PostgreSQL 7.3.6 Now Available ...

2004-03-03 Thread Palle Girgensohn
Thinking some more, I say re-package. Those using this file for automatic packaging have not fetched it yet, hopefully... /Palle --On Wednesday, March 03, 2004 11:21:28 -0400 Marc G. Fournier [EMAIL PROTECTED] wrote: On Wed, 3 Mar 2004, Palle Girgensohn wrote: Hi, Just realized that man

Re: [GENERAL] [ANNOUNCE] PostgreSQL 7.3.6 Now Available ...

2004-03-03 Thread Palle Girgensohn
: Marc G. Fournier [EMAIL PROTECTED] writes: On Wed, 3 Mar 2004, Palle Girgensohn wrote: Just realized that man pages are not installed. Reason is that doc/man.tar.gz does not exists, but Makefile expects it. instead, there is a doc/man-7.3.tar.gz... Damn ... its a quick/easy change on my

Re: [GENERAL] Unixtime from timedate?

2001-10-12 Thread Palle Girgensohn
); /Palle -- Palle Girgensohn Partitur Informationsteknik AB http://www.partitur.se/partitur/visitkort/girgensohn.jpg ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [GENERAL] pop3 server and Postgresql

2001-10-12 Thread Palle Girgensohn
On 10 Oct 2001, Steve Heaven wrote: Does anyone know of a POP3 server that can use a Postgresql DB to authenticate usernames passwords ? The cyrus mail server has an authentication scheme whereby one can very easily plug in different ways of authenticating users. It is really cyrus sasl that

[GENERAL] Re: FreeBSD PostgreSQL7 port and v7.0.2

2000-06-12 Thread Palle Girgensohn
John Daniels wrote: (After I have installed 7.0.2, I will send a diff and comments to the port maintainer to help him when he updates the port.) John, Since Andreas is busy for so long, I'd suggest you send-pr your patches so people can upgrade postgres before he gets back and commits

[GENERAL] pgaccess removed from 6.5.2?

1999-09-18 Thread Palle Girgensohn
The release notes talk about pgaccess beeing updated, but it is removed from the tarball? Only docs and demos are left; Makefile and tcl code is gone. How come? /Palle