Skip site navigation (1) Skip section navigation (2)

Re: [GENERAL] Need concrete "Why Postgres not MySQL"

From: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
To: "Hornyak Laszlo" <kocka(at)tigrasoft(dot)hu>,<pgsql-advocacy(at)postgresql(dot)org>
Subject: Re: [GENERAL] Need concrete "Why Postgres not MySQL"
Date: 2003-08-22 06:40:32
Message-ID: 031601c36878$48f36220$2800a8c0@mars (view raw or flat)
Thread:
Lists: pgsql-advocacypgsql-generalpgsql-hackers
> Can someone explain me why is it usefull if the table created in
> transaction disapears on rollback?

Because then you can write big scripts like we do at work to install a new
feature in the live database.  Such a script might create two new tables,
add columns to existing tables, drop and recreate some foreign keys, etc.
What you do is to test it you go 'begin;' and then execute the script.  If
it all worked, commit, else rollback and fix the script.  Repeat until you
get it right.

Chris


In response to

Responses

pgsql-hackers by date

Next:From: Shridhar DaithankarDate: 2003-08-22 06:45:33
Subject: Re: Buglist
Previous:From: Hornyak LaszloDate: 2003-08-22 06:30:24
Subject: Re: [GENERAL] Need concrete "Why Postgres not MySQL"

pgsql-advocacy by date

Next:From: Shridhar DaithankarDate: 2003-08-22 06:49:25
Subject: Re: [GENERAL] [HACKERS] Need concrete "Why Postgres not MySQL" bullet list
Previous:From: Hornyak LaszloDate: 2003-08-22 06:30:24
Subject: Re: [GENERAL] Need concrete "Why Postgres not MySQL"

pgsql-general by date

Next:From: Shridhar DaithankarDate: 2003-08-22 06:45:33
Subject: Re: Buglist
Previous:From: Hornyak LaszloDate: 2003-08-22 06:30:24
Subject: Re: [GENERAL] Need concrete "Why Postgres not MySQL"

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group