Dear all
I ask for your help cause I can't point out the solution to my problem on PG 8.3
I would catch an exception outside any function/procedure but directly within
script.
BEGIN;
-- raise an exception code
EXCEPTION
WHEN 'exception_type'
THEN ROLLBACK;
COMMIT;
is it possible with PG 8
Roberto Grandi wrote:
> I ask for your help cause I can't point out the solution to my problem on PG
> 8.3
> I would catch an exception outside any function/procedure but directly within
> script.
>
>
> BEGIN;
>
> -- raise an exception code
>
> EXCEPTION
> WHEN 'exception_type'
> THEN ROLLBAC
Hi
this is my script in details, remember that I launch it by .Net code (devart
connector):
SET LOCAL statement_timeout TO 1000;
BEGIN;
SELECT pg_sleep(5); -- QUERY that is long running;
-- Some exception catch such as EXCEPTION
END;
I supposed my code can throw an eception for timeout and
Roberto Grandi wrote:
> this is my script in details, remember that I launch it by .Net code (devart
> connector):
>
>
> SET LOCAL statement_timeout TO 1000;
> BEGIN;
>
> SELECT pg_sleep(5); -- QUERY that is long running;
>
> -- Some exception catch such as EXCEPTION
>
> END;
>
>
> I suppos
Roberto Grandi wrote
> Hi
>
> this is my script in details, remember that I launch it by .Net code
> (devart connector):
>
>
> SET LOCAL statement_timeout TO 1000;
> BEGIN;
>
> SELECT pg_sleep(5); -- QUERY that is long running;
>
> -- Some exception catch such as EXCEPTION
>
> END;
>
>
> I
On Sep 18, 2013, at 5:53 AM, Roberto Grandi
wrote:
> Do you have any suggestion for me?
After the timeout, roll back the current transaction.
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-admin mailing list (pgsql-admin@po
> -Original Message-
> From: pgsql-admin-ow...@postgresql.org [mailto:pgsql-admin-
> ow...@postgresql.org] On Behalf Of Roberto Grandi
> Sent: Wednesday, September 18, 2013 6:17 AM
> To: pgsql-admin@postgresql.org
> Subject: [ADMIN] Catch exceptions outside function
>
>
> Dear all
>
> I
On Sep 18, 2013, at 7:23 AM, David Johnston wrote:
> If an exception gets that far your transaction
> has failed and you have to ROLLBACK.
Right, and after my prior post where I suggested rollback, I realized, it may
be the case OP doesn't even realize there's an open transaction, which must
e
Thanks Igor,
this is a sufficient idea to take into account for upgrading to 9.x release.
Thanks again.
Roberto
- Messaggio originale -
Da: "Igor Neyman"
A: "Roberto Grandi" , pgsql-admin@postgresql.org
Inviato: Mercoledì, 18 settembre 2013 15:37:12
Oggetto: RE: Catch exceptions outsid
Roberto Grandi wrote
> Thanks Igor,
>
> this is a sufficient idea to take into account for upgrading to 9.x
> release.
> Thanks again.
There is no 9.x "release" - singular
A release designation requires both the first and second position.
8.4.x
9.0.x
9.1.x
9.2.x
9.3.x
An ".x" can be used in th
On Sep 17, 2013, at 3:46 PM, Kevin Grittner wrote:
> Natalie Wenz wrote:
>
>> Sorry; my description of what is going on was a little unclear.
>> We didn't upgrade the existing database. We moved it to different
>> hardware, and just created a brand new database to accept the
>> data that had b
Natalie Wenz wrote:
>>> autovacuum_freeze_max_age | 8
> We talked a little bit about lowering the
> autovacuum_max_freeze_age, at least some, but there was concern
> that it would end up doing a lot more lengthy full-table scans.
> Is that a legitimate concern?
It will cause full-
12 matches
Mail list logo
