From:
Andrew Dunstan <andrew(at)dunslane(dot)net>
To:
Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc:
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>,
"Patches (PostgreSQL)" <pgsql-patches(at)postgresql(dot)org>
Subject:
Re: drop if exists remainder
Date:
2006-02-05 19:58:19
Message-ID:
43E658DB.7030202@dunslane.net (view raw or flat )
Thread:
2006-02-05 14:44:09 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2006-02-05 16:02:47 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2006-02-05 16:15:42 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2006-02-05 18:29:56 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2006-02-05 19:58:19 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2006-02-07 02:22:34 from Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
2006-02-07 02:26:57 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2006-03-03 20:35:24 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2006-03-03 20:40:38 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2006-03-05 03:24:07 from David Fetter <david(at)fetter(dot)org>
2006-06-08 00:22:35 from Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
2006-06-08 00:24:25 from Josh Berkus <josh(at)agliodbs(dot)com>
2006-06-08 13:43:19 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2006-06-08 15:47:24 from David Fetter <david(at)fetter(dot)org>
2006-06-08 16:34:54 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2006-06-08 18:30:02 from "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>
2006-06-08 18:39:55 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2006-06-08 18:47:56 from Josh Berkus <josh(at)agliodbs(dot)com>
2006-06-08 18:54:35 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2006-06-08 19:06:01 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2006-06-08 19:18:36 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2006-06-08 19:35:18 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Lists:
pgsql-hackers pgsql-patches
Bruce Momjian wrote:
>However, I see CREATE ROLE doesn't have REPLACE functionality, so what
>is the logic of when we need IF EXISTS and when we don't? Perhaps they
>all should have it, and the REPLACE is just for objects you want to
>replace but keep existing linkage in place.
>
>
>
That was my understanding. I think these are orthogonal issues.
Another issue was MySQL compatibility. AFAIK we achieved that when we
did database, following
{ table view index sequence schema type domain conversion}, which pretty
much all had to be done together, as they share the same statement node
type.
cheers
andrew
In response to
pgsql-hackers by date
Next :From: Stephen FrostDate: 2006-02-05 20:20:12Subject : Re: Krb5 & multiple DB connectionsPrevious :From : Peter EisentrautDate : 2006-02-05 19:00:33Subject : Re: renseignement
pgsql-patches by date
Next :From: Stephen FrostDate: 2006-02-05 20:20:12Subject : Re: Krb5 & multiple DB connectionsPrevious :From : Bruce MomjianDate : 2006-02-05 18:29:56Subject : Re: drop if exists remainder
