Re: RE: [PATCHES] relation filename patch

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: "Ross J(dot) Reedstrom" <reedstrm(at)wallace(dot)ece(dot)rice(dot)edu>, Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>, pgsql-patches(at)postgresql(dot)org
Subject: Re: RE: [PATCHES] relation filename patch
Date: 2000-05-01 18:08:30
Message-ID: 200005011808.OAA29916@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> > Hmm. Further perusal leads me to believe that this override is a
> > standards extension, as the clause about the tablename being unique in
> > the current namespace does not have an exception for temporary tables.
> > Nothing wrong with that, just making it clear. What's the use/case for
> > this feature? Does it come from some other DMBS?
>
> I am quite surprised people don't like that feature, or at least one
> person doesn't. If someone else creates a table, it should not prevent
> me from creating a temporary table of the same name.
>
> I know Informix doesn't implement it that way, and they complained

Sorry, I should have said "One of my users complained..."

> because a program started not working. Research showed that someone had
> created a real table with the same name as the temp table.

--
Bruce Momjian | http://www.op.net/~candle
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Ross J. Reedstrom 2000-05-01 18:45:51 Re: FW: [PATCHES] relation filename patch
Previous Message Bruce Momjian 2000-05-01 17:50:36 Re: RE: [PATCHES] relation filename patch