Re: [GENERAL] create database from template requires the source database to be unused

2012-06-28 Thread Haszlakiewicz, Eric
> -Original Message- > From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general- > It'd be really interesting to relax that limitation to "... other > non-read-only transaction ... " and have a database that's being cloned > block or reject > DML, UPDATE, etc. There are some issues wi

Re: [GENERAL] retrieving function raise messages in ecpg embedded sql code

2012-06-25 Thread Haszlakiewicz, Eric
> -Original Message- > From: Jeff Davis [mailto:pg...@j-davis.com] > > On Mon, 2012-06-18 at 21:35 +, Haszlakiewicz, Eric wrote: > > I'm trying to get some additional information back from a trigger to > > my embedded SQL program, to essentially emulate I

[GENERAL] retrieving function raise messages in ecpg embedded sql code

2012-06-18 Thread Haszlakiewicz, Eric
I'm trying to get some additional information back from a trigger to my embedded SQL program, to essentially emulate Informix's way of generating serial values. I can get the serial to be generated, but I'm trying to figure out how to get the generated value back to my program with minimal change

Re: [GENERAL] [PERFORM] Concurrency issue under very heay loads

2009-07-17 Thread Haszlakiewicz, Eric
>-Original Message- >From: pgsql-performance-ow...@postgresql.org > >We use a typical counter within a transaction to generate >order sequence number and update the next sequence number. >This is a simple next counter - nothing fancy about it. When >multiple clients are concurrently a