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
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
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
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
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("
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
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
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
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
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
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
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
Στις 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
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
14 matches
Mail list logo