Is there some kind of log, table or something that I could get more
information about a deadlock situation that is occurring in my database? I
just get a transaction number and a process id, which is useless to me
because my application terminates on any errors from the database? It occurs
infreque
On Thu, Sep 15, 2005 at 12:32:05PM -0500, Bart McFarling wrote:
> Is there some kind of log, table or something that I could get more
> information about a deadlock situation that is occurring in my database? I
> just get a transaction number and a process id, which is useless to me
We are installing a new Postgresql server, it will not run
anything else but postgresql. We are currently looking at moving from a RHEL
4.0 system to FreeBSD.
Does one OS offer better performace over the other when
running postgresql?
Thanks,
Bart
I have a column that is a varchar(6) I need to sort it by the rows that
are integers 1st then the character ones or vice versa, I just need the
values that can be converted to integer to sort by their numeric value.
i.e
1, 2, 3, 4, 5, 10, 11, A, B, C
instead of
1, 10, 11, 2, 3, 4, 5, A, B, C
An
Thanks,
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Andreas
Kretschmer
Sent: Monday, January 08, 2007 11:19 AM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Sorting
Ragnar <[EMAIL PROTECTED]> schrieb:
> > test=*# select w, case when w ~ '^
Would anyone happen to have any examples or be able to point me to how to
write a stored procedure in C? Ive looked at
http://www.postgresql.org/docs/8.1/interactive/trigger-interface.html
But am still having problems with getting a compile to work on a Linux
machine. (linker options etc..)
Than
postgres 7.4.2 on a RedHat Enterprise Server
using libpq on SCO Open Server
Seems that if a command takes too long I get ERROR:Canceling query due
to user request.
I have ulimit=unlimited
postgresql.conf has statement_timeout = 0
Any ideas on what could be causing this?
Thanks,
Bart
-
