Revision 12131
Added by Aaron Marcuse-Kubitza almost 11 years ago
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 719 | 719 |
-- don't datasource_rm() the datasource to publish! |
| 720 | 720 |
IF live_datasource = datasource THEN RETURN; END IF; |
| 721 | 721 |
|
| 722 |
BEGIN -- nested transaction |
|
| 723 |
PERFORM datasource_rm(live_datasource, schema_null); |
|
| 724 |
PERFORM datasource_rename(datasource, live_datasource, schema_null); |
|
| 725 |
EXCEPTION |
|
| 726 |
WHEN SQLSTATE /*successful_completion*/'00000' THEN NULL; -- need at least one WHEN clause |
|
| 727 |
END; |
|
| 722 |
PERFORM datasource_rm(live_datasource, schema_null); |
|
| 723 |
PERFORM datasource_rename(datasource, live_datasource, schema_null); |
|
| 728 | 724 |
END; |
| 729 | 725 |
$$; |
| 730 | 726 |
|
Also available in: Unified diff
schemas/vegbien.sql: datasource_publish(): removed nested transaction, which is not needed because Postgres runs each top-level command in a transaction (including in autocommit mode)