| From: | mlw <markw(at)mohawksoft(dot)com> |
|---|---|
| To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
| Cc: | Don Baccus <dhogaza(at)pacifier(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Hackers List <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: SET variables |
| Date: | 2001-05-13 21:31:28 |
| Message-ID: | 3AFEFD30.3859E3E6@mohawksoft.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Bruce Momjian wrote:
>
> > A Postgres with enough Oracle-isms would be a world beater. As it is, when I
> > show Oracle people what Postgres can do, they are blown away. They love the
> > fact that temporary tables are in an isolated name space, sequences are more
>
> Are you saying that multiple people can't create temp tables with the
> same name, or that you can't create a temp table that masks a real
> table? I know PostgreSQL does both.
In Oracle, temp tables occupy the same name space. One can not have two or more
users with the same temp table name without it being the same table. This is
why temp tables are not as used as one would think in Oracle.
To use a temp table in Oracle you have to some up with some random naming
scheme. It really blows. Because of this Oracle developers have long stayed
away from temp tables.
--
42 was the answer, 49 was too soon.
------------------------
http://www.mohawksoft.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | mlw | 2001-05-13 22:45:10 | Re: SET variables |
| Previous Message | Bruce Momjian | 2001-05-13 21:29:12 | Re: SET variables |