Обсуждение: Re: [COMMITTERS] [WEBMASTER] 'www/html main.html'
> Modified Files: > main.html > Log Message: > Add mention of TEMP tables. Bruce, would this be a good time to start the v6.5 release notes? Certainly the temp tables capability would make the short list of "highlighted features" in the 1-paragraph-per-topic summary above the one-liners. Do you want to start the v6.5 section in release.sgml? Also, we apparently have not yet gotten the v6.4.2 release notes in there either, so perhaps you could drop those in also? I'll polish the markup as needed... - Tom
> > Modified Files: > > main.html > > Log Message: > > Add mention of TEMP tables. > > Bruce, would this be a good time to start the v6.5 release notes? > Certainly the temp tables capability would make the short list of > "highlighted features" in the 1-paragraph-per-topic summary above the > one-liners. > > Do you want to start the v6.5 section in release.sgml? Also, we > apparently have not yet gotten the v6.4.2 release notes in there either, > so perhaps you could drop those in also? I'll polish the markup as > needed... > > - Tom > OK, got to finish temp table and commit them first. -- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610) 853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania19026
Re: [HACKERS] Re: [COMMITTERS] [WEBMASTER] 'www/html main.html'
От
jwieck@debis.com (Jan Wieck)
Дата:
> > > > Modified Files: > > > main.html > > > Log Message: > > > Add mention of TEMP tables. > > > > Bruce, would this be a good time to start the v6.5 release notes? > > Certainly the temp tables capability would make the short list of > > "highlighted features" in the 1-paragraph-per-topic summary above the > > one-liners. > > > > Do you want to start the v6.5 section in release.sgml? Also, we > > apparently have not yet gotten the v6.4.2 release notes in there either, > > so perhaps you could drop those in also? I'll polish the markup as > > needed... > > > > - Tom > > > > OK, got to finish temp table and commit them first. Don't know if you noticed my statement in another thread. I think temp tables could confuse any function that uses the prepared/saved plan feature of SPI manager. If such a function called once saved a plan for a temp table named 'test', and later called again but 'test' is now another table, probably the parsetree and plan might point to the old (wrong, not anymore existent) table. Should not be a real drawback against temp tables. But maybe something to mention in the release notes. Jan -- #======================================================================# # It's easier to get forgiveness for being wrong than for being right. # # Let's break this rule - forgive me. # #======================================== jwieck@debis.com (Jan Wieck) #
> > OK, got to finish temp table and commit them first. > > Don't know if you noticed my statement in another thread. > > I think temp tables could confuse any function that uses the > prepared/saved plan feature of SPI manager. If such a > function called once saved a plan for a temp table named > 'test', and later called again but 'test' is now another > table, probably the parsetree and plan might point to the old > (wrong, not anymore existent) table. Yes. There are going to be limitations to the temp tables. Not sure how what the limitations are going to be.. -- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610) 853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania19026
-----BEGIN PGP SIGNED MESSAGE----- >>>>> "Bruce" == Bruce Momjian <maillist@candle.pha.pa.us> writes: Bruce> Yes. There are going to be limitations to the temp tables. Bruce> Not sure how what the limitations are goingto be.. As a possible suggestion...I know Sybase requires that temp tables have names that begin with a `#'. This avoids the problem of shadowing ordinary names. roland - -- PGP Key ID: 66 BC 3B CD Roland B. Roberts, PhD Custom Software Solutions roberts@panix.com 101 West 15th St #4NN rbroberts@acm.org New York, NY 10011 -----BEGIN PGP SIGNATURE----- Version: 2.6.2 Comment: Processed by Mailcrypt 3.4, an Emacs/PGP interface iQCVAwUBNrZgIuoW38lmvDvNAQGW0gP9Egug1ICjbI9u93oXnWtWuGFQ+SV9XdEK CpSkEiGbFBIB3MgXVc+6sCTbAsL5Y3RVEM3G0p91f/frFZVCpJYwuqvhxM6NHf3U VUuHXUIBKwFUJsv/+t687/dlzX3e6jVUGx8BW++SrrpcDOHWmCMBJK+9v+gJqRum axGwmGJgBZw= =Q37n -----END PGP SIGNATURE-----
-- Start of PGP signed section. > >>>>> "Bruce" == Bruce Momjian <maillist@candle.pha.pa.us> writes: > > Bruce> Yes. There are going to be limitations to the temp tables. > Bruce> Not sure how what the limitations are going to be.. > > As a possible suggestion...I know Sybase requires that temp tables > have names that begin with a `#'. This avoids the problem of > shadowing ordinary names. That's cheezy. Here is my latest temp trick. Create a table and index, create temp versions, insert into them, and test temp table removal. This is the regression test. I am about to commit the code. ---------------------------------------------------------------------------QUERY: CREATE TABLE temptest(col int);QUERY: CREATEINDEX i_temptest ON temptest(col);QUERY: CREATE TEMP TABLE temptest(col int);QUERY: CREATE INDEX i_temptest ON temptest(col);QUERY:DROP INDEX i_temptest;QUERY: DROP TABLE temptest;QUERY: DROP INDEX i_temptest;QUERY: DROP TABLE temptest;QUERY:CREATE TABLE temptest(col int);QUERY: INSERT INTO temptest VALUES (1);QUERY: CREATE TEMP TABLE temptest(colint);QUERY: INSERT INTO temptest VALUES (2);QUERY: SELECT * FROM temptest;col--- 2(1 row)QUERY: DROP TABLE temptest;QUERY:SELECT * FROM temptest;col--- 1(1 row)QUERY: DROP TABLE temptest;QUERY: CREATE TEMP TABLE temptest(col int);--restarts backend\connect regression QUERY: SELECT * FROM temptest;ERROR: temptest: Table does not exist. -- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610) 853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania19026
Re: [DOCS] Re: [HACKERS] Re: [COMMITTERS] [WEBMASTER] 'www/html main.html'
От
"Thomas G. Lockhart"
Дата:
> As a possible suggestion...I know Sybase requires that temp tables > have names that begin with a `#'. This avoids the problem of > shadowing ordinary names. Interesting. We could do something similar if supporting SQL92 conventions is impossible, but why not try for something compatible first? - Tom