From: | Scott Marlowe <smarlowe(at)g2switchworks(dot)com> |
---|---|
To: | Alban Hertroys <alban(at)magproductions(dot)nl> |
Cc: | Berend Tober <btober(at)seaworthysys(dot)com>, Postgres General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Template1 oops |
Date: | 2006-09-13 15:13:18 |
Message-ID: | 1158160398.24726.0.camel@state.g2switchworks.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Wed, 2006-09-13 at 10:05, Alban Hertroys wrote:
> Berend Tober wrote:
> > On Wed, Sep 13, 2006 at 10:56:41AM +0200, Alban Hertroys wrote:
> >
> > I'm humble (or naive) enough to admit that I've used the approach
> > outlined there by Josh Berkus, and it worked fine. More than once, even.
>
> I'm quite certain that approach can be made more bullet-proof by
> wrapping it inside a transaction. I saw no mention of that on his page.
>
> It's quite amazing what PostgreSQL can handle inside transactions :)
Every time I write a DDL change request for an Oracle database, I am
reminded of this. :)
From | Date | Subject | |
---|---|---|---|
Next Message | rloefgren | 2006-09-13 15:40:35 | Re: serial, sequence, and COPY FROM |
Previous Message | Andrew - Supernews | 2006-09-13 15:10:59 | Re: Template1 oops |