Re: [BUGS] BUG #7626: Query planner never returns, uses 100% CPU

2012-10-29 Thread Bill MacArthur
On 10/29/2012 12:29 PM, br...@omniti.com wrote: The following bug has been logged on the website: Bug reference: 7626 Logged by: Brian Dunavant Email address: br...@omniti.com PostgreSQL version: 9.2.1 Operating system: MacOS + Others Description: Running this causes the th

Re: [BUGS] BUG #7604: adding criteria to a query against a view in 9.2 expands the results instead of constraining them

2012-10-15 Thread Bill MacArthur
On 10/15/2012 2:29 PM, Tom Lane wrote: Bill MacArthur writes: Tom, in preparation for a test case I created a new schema (testcase) and copied 6 tables to that, including only the columns significant to enable the VIEWs to be created. I took the 3 VIEWs involved and tweaked them into the new

Re: [BUGS] BUG #7604: adding criteria to a query against a view in 9.2 expands the results instead of constraining them

2012-10-15 Thread Bill MacArthur
On 10/15/2012 12:18 PM, Tom Lane wrote: webmas...@dhs-club.com writes: vip_declines_mailers_base is another VIEW that merely adds some criteria to limit the result set of the 'base' VIEW. In versions 9.0 and back it did just that. After upgrading to 9.2, the criteria actually expand the result s

Re: [BUGS] TYPE of TEMP table does not seem to get set

2012-04-16 Thread Bill MacArthur
On 4/16/2012 4:29 PM, Bill MacArthur wrote: On 4/16/2012 4:11 PM, Tom Lane wrote: Bill MacArthur writes: I have a view "configurations.tp_transactions" which is a blend of many tables using INNER and LEFT JOINs. I want to populate a temp table from which I can obtain th

Re: [BUGS] TYPE of TEMP table does not seem to get set

2012-04-16 Thread Bill MacArthur
On 4/16/2012 4:11 PM, Tom Lane wrote: Bill MacArthur writes: I have a view "configurations.tp_transactions" which is a blend of many tables using INNER and LEFT JOINs. I want to populate a temp table from which I can obtain the data and programmatically write queries to operate on

[BUGS] TYPE of TEMP table does not seem to get set

2012-04-16 Thread Bill MacArthur
Hello, I am hoping that I'm just missing some kind of syntax tweak, but after experimenting a bit, I cannot seem to get this working. I have a view "configurations.tp_transactions" which is a blend of many tables using INNER and LEFT JOINs. I want to populate a temp table from which I can obtai

[BUGS] table row type and query-specified row type do not match

2012-03-08 Thread Bill MacArthur
has already been discussed. Googling it didn't seem to turn up anything. Thank you for a great product anyway! Bill MacArthur Postgres version: PostgreSQL 9.0.5 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 4.1.2 20080704 (Red Hat 4.1.2-50), 64-bit OS version: CentOS release 5.7 (

[BUGS] table row type and query-specified row type do not match

2012-03-08 Thread Bill MacArthur
has already been discussed. Googling it didn't seem to turn up anything. Thank you for a great product anyway! Bill MacArthur Postgres version: PostgreSQL 9.0.5 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 4.1.2 20080704 (Red Hat 4.1.2-50), 64-bit OS version: CentOS release 5.7 (