| From: | "Luke Lonergan" <LLonergan(at)greenplum(dot)com> |
|---|---|
| To: | "Lukas Kahwe Smith" <smith(at)pooteeweet(dot)org>, "Greg Smith" <gsmith(at)gregsmith(dot)com>, pgsql-advocacy(at)postgresql(dot)org |
| Subject: | Re: L |
| Date: | 2007-08-14 08:10:45 |
| Message-ID: | C3E62232E3BCF24CBA20D72BFDCB6BF805CE8BD4@MI8NYCMAIL08.Mi8.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-advocacy pgsql-www |
Lukas,
> Actually very few RDBMS support transactional DDL, though
> right this second I do not remember what they do in case you
> issue DDL inside a transaction. I would assume/hope that they
> give you an error and not do an implicit commit.
See here for Oracle:
http://download.oracle.com/docs/cd/B19306_01/server.102/b14220/transact.
htm
"Committing means that a user has explicitly or implicitly requested
that the changes in the transaction be made permanent. An explicit
request occurs when the user issues a COMMIT statement. An implicit
request occurs after normal termination of an application or completion
of a data definition language (DDL) operation."
- Luke
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2007-08-14 13:25:03 | Re: default_text_search_config and expression indexes |
| Previous Message | Lukas Kahwe Smith | 2007-08-14 08:03:36 | Re: L |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Magnus Hagander | 2007-08-14 08:37:58 | Re: Change to community logins |
| Previous Message | Lukas Kahwe Smith | 2007-08-14 08:03:36 | Re: L |