Re: [ADMIN] Deadlocks ?

2008-05-13 Thread Alvaro Herrera
kevin kempter wrote: >>> On Tue, May 13, 2008 at 01:18:24PM -0600, kevin kempter wrote: >>> ProgrammingError: deadlock detected >>> DETAIL: Process 23098 waits for ShareUpdateExclusiveLock on >>> relation 428126 of database 427376; blocked by process 23916. >>> Process 23916 waits for ShareLock o

Re: [ADMIN] Deadlocks ?

2008-05-13 Thread kevin kempter
On May 13, 2008, at 5:00 PM, Tom Lane wrote: Tino Schwarze <[EMAIL PROTECTED]> writes: On Tue, May 13, 2008 at 01:18:24PM -0600, kevin kempter wrote: ProgrammingError: deadlock detected DETAIL: Process 23098 waits for ShareUpdateExclusiveLock on relation 428126 of database 427376; blocked by

Re: [ADMIN] Deadlocks ?

2008-05-13 Thread Tom Lane
Tino Schwarze <[EMAIL PROTECTED]> writes: > On Tue, May 13, 2008 at 01:18:24PM -0600, kevin kempter wrote: > ProgrammingError: deadlock detected > DETAIL: Process 23098 waits for ShareUpdateExclusiveLock on > relation 428126 of database 427376; blocked by process 23916. > Process 23916 waits for

Re: [ADMIN] Deadlocks ?

2008-05-13 Thread Tino Schwarze
On Tue, May 13, 2008 at 01:18:24PM -0600, kevin kempter wrote: > we seem to be getting deadlock quite a lot. We have a python process > that does the following and we keep getting deadlocks. Is this a real > deadlock or maybe a wait condition? Any help in debugging / resolving > this would b

[ADMIN] Deadlocks ?

2008-05-13 Thread kevin kempter
Hi All; we seem to be getting deadlock quite a lot. We have a python process that does the following and we keep getting deadlocks. Is this a real deadlock or maybe a wait condition? Any help in debugging / resolving this would be much appreciated. Thanks in advance cursor.execute("

Re: [ADMIN] Postgres Cluster on Solaris

2008-05-13 Thread Robert Lor
Travis, Travis Smith wrote: Hello All, I am interested in running Postgres on Solaris using SunCluster. I am hoping that someone this list has experience with this configuration. To be honest I am having a difficult time understanding the concept of Postgres clusters. I originally began lo

Re: [ADMIN] how to get a number of seconds in some interval ?

2008-05-13 Thread Tom Lane
Achilleas Mantzios <[EMAIL PROTECTED]> writes: > So it seems that the arbitary assumption of (1 month=30 days, and 1 day = 24 > hours) has already been made in the extract function. Right, as I said: >> You can derive a number if you're willing to make arbitrary assumptions >> about the relation

Re: [ADMIN] EDB database link to Oracle

2008-05-13 Thread Travis Smith
Thanks for the head up. I was just informed. -Original Message- From: Joshua D. Drake [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 13, 2008 8:56 AM To: Travis Smith Cc: [email protected] Subject: Re: [ADMIN] EDB database link to Oracle Travis Smith wrote: > When using a databa

Re: [ADMIN] EDB database link to Oracle

2008-05-13 Thread Joshua D. Drake
Travis Smith wrote: When using a database link in Postgres Plus AS 8.3 to an Oracle instance I receive… You should contact EnterpriseDB for support with their products. Joshua D. Drake -- Sent via pgsql-admin mailing list ([email protected]) To make changes to your subscription: http

[ADMIN] EDB database link to Oracle

2008-05-13 Thread Travis Smith
When using a database link in Postgres Plus AS 8.3 to an Oracle instance I receive... SQL> create database link ezdev connect to pguser identified by pguser 2 using oci '//devdb:1521/ezdev' 3 ; Database Link created. SQL> select * from [EMAIL PROTECTED]; ERROR near line 1: unab

Re: [ADMIN] how to get a number of seconds in some interval ?

2008-05-13 Thread Scott Marlowe
On Tue, May 13, 2008 at 2:42 AM, Shane Ambler <[EMAIL PROTECTED]> wrote: > Scott Marlowe wrote: > >> True. But that's only because it doesn't have a date to work against. >> If you run: >> >> select '2007-02-01 12:00:00'::timestamp + '1 month'::interval; >> you get: 2007-03-01 12:00:00 >> >> If y

Re: [ADMIN] how to get a number of seconds in some interval ?

2008-05-13 Thread Shane Ambler
Scott Marlowe wrote: True. But that's only because it doesn't have a date to work against. If you run: select '2007-02-01 12:00:00'::timestamp + '1 month'::interval; you get: 2007-03-01 12:00:00 If you run: select '2007-03-01 12:00:00'::timestamp + '1 month'::interval; you get: 2007-04-01 1

Re: [ADMIN] how to get a number of seconds in some interval ?

2008-05-13 Thread Achilleas Mantzios
Στις Tuesday 13 May 2008 11:22:28 ο/η Scott Marlowe έγραψε: > On Tue, May 13, 2008 at 12:56 AM, Achilleas Mantzios > <[EMAIL PROTECTED]> wrote: > > Monday 12 May 2008 18:09:11 �/� Tom Lane ��: > >> Achilleas Mantzios <[EMAIL PROTECTED]> writes: > >> > Monday 12 May 2008 17:32:39 �/� J

Re: [ADMIN] how to get a number of seconds in some interval ?

2008-05-13 Thread Scott Marlowe
On Tue, May 13, 2008 at 12:56 AM, Achilleas Mantzios <[EMAIL PROTECTED]> wrote: > Στις Monday 12 May 2008 18:09:11 ο/η Tom Lane έγραψε: >> Achilleas Mantzios <[EMAIL PROTECTED]> writes: >> > Στις Monday 12 May 2008 17:32:39 ο/η Julius Tuskenis έγραψε: >> >> do you know why division of intervals was