Re: [GENERAL] [PERFORM] Strange performance degradation

2009-11-24 Thread Denis Lussier
IMHO the client application is already confused and it's in Prod. Shouldn't he perhaps terminate/abort the IDLE connections in Prod and work on correcting the problem so it doesn't occur in Dev/Test?? On 11/24/09, Matthew Wakeling matt...@flymine.org wrote: On Mon, 23 Nov 2009, Lorenzo

Re: [GENERAL] [PERFORM] Strange performance degradation

2009-11-24 Thread Denis Lussier
Bouncing the app will roll back the transactions. If there were any pending updates/inserts, wouldn't he be able to see them in one of the system tables... On 11/24/09, Matthew Wakeling matt...@flymine.org wrote: On Tue, 24 Nov 2009, Denis Lussier wrote: IMHO the client application is already

Re: [GENERAL] does anyone have a tool to convert SP'sT-SQL to Postgres

2007-02-10 Thread Denis Lussier
Oracle provides a free tool for converting TSQL into PL/SQL. You can then use the PL/SQL on an EnterpriseDB database, if this doesn't work for ya... PL/SQL is quite a bit closer to PLpgSQL than TSQL is so you'll be well on your way. --Luss http://www.enterprisedb.com On 2/9/07, johnf [EMAIL

Re: [GENERAL] does anyone have a tool to convert SP'sT-SQL to Postgres

2007-02-10 Thread Denis Lussier
Pavel is doing nice work on Orafce the EnterpriseDB PG Community Fund is now sponsoring him to do more. On 2/10/07, Joshua D. Drake [EMAIL PROTECTED] wrote: Denis Lussier wrote: Oracle provides a free tool for converting TSQL into PL/SQL. You can then use the PL/SQL on an EnterpriseDB

[GENERAL] pg migrator

2007-01-29 Thread Denis Lussier
Korry Douglas has an EDB sponsored project called pg_migrator on pgfoundry. I believe it works for upgrading from 8.1 to 8.2 except for tables that use the ip address datatype. It works by just replacing the 8.1 system catalogs with the 8.2 system catalogs. I believe the on-disk images for

[GENERAL] EnterpriseDB Apology

2007-01-18 Thread Denis Lussier
Hi All, EnterpriseDB recently sent out email advertising new support offerings. Unfortunately, the email was incorrectly sent to some people who should not have received it. We apologize for the error, and are taking steps to avoid such mistakes in the future. -Denis Lussier CTO Founder http

Re: [pgsql-advocacy] [GENERAL] Oracle buys Innobase

2005-10-07 Thread Denis Lussier
Title: Re: [pgsql-advocacy] [GENERAL] Oracle buys Innobase It may be hard for u to resist if those wacky guyz from Redwood offered eight figures (and I'm not counting the ones to the right of the decimal point). --Luss From: [EMAIL PROTECTED] on behalf of Marc G. FournierSent: Fri