Grattis Magnus! ;-)
--On 27 april 2011 19.48.48 +0100 Dave Page 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 the development and on
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 pgsq
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 needs
--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,
--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 th
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 ar
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 i
e the BEGINs 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
ser
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 /usr
--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 ... ]
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 you
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 immed
--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 no
--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 d
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 r
3 Mar 2004, Tom Lane wrote:
> "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. inste
e_part('epoch',now()::date);
/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]
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 tha
Tom Lane wrote:
>
> Lamar Owen <[EMAIL PROTECTED]> writes:
> > The real problem with redirecting the postmaster output is the issue
> > of log rolling, which is impossible to do in the 'classic'
> > stderr/stdout redirect UNLESS you throw down postmaster when rolling
> > the log (unless you know
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 th
With FreeBSD, you should really use the port; it saves you much grief. I
recommend it! cd /usr/ports/databases/postgresql && make install (with
a fresh ports tree, which you get with "cvsup
/usr/share/examples/cvsup/ports-supfile").
Regards,
Palle
"Allan C. Lemos" wrote:
>
> Hi,
> I'm running
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
22 matches
Mail list logo
