Re: [PATCHES] Information_schema fixes for sequences and

2006-09-04 Thread Bruce Momjian
Patch applied. Thanks. I did not batckpatch because someone would need to re-initdb to see the changes, and we haven't gotten any complaints about the bug. --- Greg Sabino Mullane wrote: -- Start of PGP signed section. >

Re: [PATCHES] Information_schema fixes for sequences and temporary tables

2006-08-18 Thread Greg Sabino Mullane
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 > I'd be interested to see you cite chapter and verse in the SQL spec > where it says that information_schema should hide temp tables of > other backends. That change seems pretty dubious to me. (More > likely, we should be adding tests on whether

Re: [PATCHES] Information_schema fixes for sequences and temporary tables

2006-08-18 Thread Tom Lane
Greg Sabino Mullane <[EMAIL PROTECTED]> writes: > More to come, but these two are probably worth backpatching. We can't really backpatch changes to information_schema, since we can't force initdb in back branches. I'd be interested to see you cite chapter and verse in the SQL spec where it says t

[PATCHES] Information_schema fixes for sequences and temporary tables

2006-08-18 Thread Greg Sabino Mullane
More to come, but these two are probably worth backpatching. Sequences were not being shown due to the use of lowercase 's' instead of 'S', and the views were not checking for table visibility with regards to temporary tables and sequences. -- Greg Sabino Mullane [EMAIL PROTECTED] End Point Corpor