| From: | "Harpreet Dhaliwal" <harpreet(dot)dhaliwal01(at)gmail(dot)com> |
|---|---|
| To: | "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com> |
| Cc: | "Postgres General" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Transactional DDL |
| Date: | 2007-08-15 05:58:07 |
| Message-ID: | d86a77ef0708142258h64124507j6e3508661947ce3b@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
So you mean to say something like this as far as oracle is concerned:
BEGIN
DDL 1 (commits right after its execution)
DDL 2 (commits right after its execution)
END
That means there's no concept of putting DDL statements in a transaction in
oracle basically, right?
Thanks,
~Harpreet
On 8/15/07, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> wrote:
>
> On 8/14/07, Harpreet Dhaliwal <harpreet(dot)dhaliwal01(at)gmail(dot)com> wrote:
> > So you mean to say DDL statements can't be put in one single transaction
> in
> > Oracle ?
>
> You can put them in, but then they will cause the previous DMK to be
> silently committed
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pavel Stehule | 2007-08-15 06:01:24 | is this trigger safe and efective? - locking (caching via triiggers) |
| Previous Message | Scott Marlowe | 2007-08-15 05:26:00 | Re: Transactional DDL |