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. > 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 Corporation > PGP Key: 0x14964AC8 200608181942 > http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 > [ Attachment, skipping... ] -- End of PGP section, PGP failed! -- Bruce Momjian [EMAIL PROTECTED] EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match