Re: [BUGS] BUG #5547: not able to connect to postgres through the oracle using Linux ODBC driver for Postgres

2010-07-09 Thread Dave Page
On Fri, Jul 9, 2010 at 4:03 AM, Craig Ringer wrote: > On 8/07/2010 10:40 PM, Hemanth wrote: >> >> The following bug has been logged online: >> >> Bug reference:      5547 >> Logged by:          Hemanth >> Email address:      hxku...@qwest.com >> PostgreSQL version: 8.4 >> Operating system:   Linux

Duplicate bugs (was Re: [BUGS] BUG #5547: not able to connect to postgres through the oracle using Linux ODBC driver for Postgres)

2010-07-09 Thread Tom Lane
Dave Page writes: > On Fri, Jul 9, 2010 at 4:03 AM, Craig Ringer > wrote: >> I wonder if there's any way to have the bug report form de-duplicate posts >> based on similar/identical text in sequential submissions. > Not without starting down the path of writing a full blown bug > tracker. The cu

Re: Duplicate bugs (was Re: [BUGS] BUG #5547: not able to connect to postgres through the oracle using Linux ODBC driver for Postgres)

2010-07-09 Thread Magnus Hagander
On Fri, Jul 9, 2010 at 15:26, Tom Lane wrote: > Dave Page writes: >> On Fri, Jul 9, 2010 at 4:03 AM, Craig Ringer >> wrote: >>> I wonder if there's any way to have the bug report form de-duplicate posts >>> based on similar/identical text in sequential submissions. > >> Not without starting down

Re: [BUGS] pg_upgrade issues

2010-07-09 Thread depstein
Encountered another problem with pg_upgrade on Windows XP Pro: I was trying to migrate from 8.4 to 9.0beta2 without linking, and apparently there was not enough space on the hard drive. However, pg_upgrade didn't report any problems, and it looked for all the world as if everything went well. I

[BUGS] BUG #5549: Feature: plpgsql should allow DECLARE cursor FOR EXECUTE '...'

2010-07-09 Thread David Schmitt
The following bug has been logged online: Bug reference: 5549 Logged by: David Schmitt Email address: da...@dasz.at PostgreSQL version: 8 and 9 Operating system: n/a Description:Feature: plpgsql should allow DECLARE cursor FOR EXECUTE '...' Details: This is not impl

Re: [BUGS] BUG #5549: Feature: plpgsql should allow DECLARE cursor FOR EXECUTE '...'

2010-07-09 Thread Tom Lane
"David Schmitt" writes: > This is not implemented: > DECLARE > working_cursor NO SCROLL CURSOR FOR EXECUTE $$SELECT something $$ || tbl > || $$ ... $$; What's wrong with OPEN FOR EXECUTE? The proposed addition seems a bit weird anyway since it presumes nontrivial calculation to be done duri

Re: [BUGS] pg_upgrade issues

2010-07-09 Thread Bruce Momjian
depst...@alliedtesting.com wrote: > Encountered another problem with pg_upgrade on Windows XP Pro: > > I was trying to migrate from 8.4 to 9.0beta2 without linking, and > apparently there was not enough space on the hard drive. However, > pg_upgrade didn't report any problems, and it looked for al

Re: [BUGS] [TESTERS] Location of certs -Windows 7 SSL mode?

2010-07-09 Thread Magnus Hagander
On Fri, Jul 9, 2010 at 04:58, Craig Ringer wrote: > On 8/07/2010 6:31 PM, Magnus Hagander wrote: >> >> On Thu, Jul 8, 2010 at 03:10, Craig Ringer >>  wrote: >>> >>> IIRC on Windows client certificates live in >>> >>>  %APPDATA%\.postgresql\ >> >> That's a typo, it should be %APPDATA%\postgresql\ (

Re: [BUGS] BUG #5548: ERROR: invalid attnum ## for rangetable entry on EXPLAIN VERBOSE, not on EXPLAIN

2010-07-09 Thread Daniel Grace
On Thu, Jul 8, 2010 at 10:52 PM, Tom Lane wrote: > "Daniel Grace" writes: >> I apologize for not including detailed schema information.  It took a lot to >> get this to reduce to the point it did, and hopefully this is enough >> information to find a bug. > > It is not.  You haven't provided anyw

Re: [BUGS] BUG #5548: ERROR: invalid attnum ## for rangetable entry on EXPLAIN VERBOSE, not on EXPLAIN

2010-07-09 Thread Tom Lane
Daniel Grace writes: > So I've spent the greater portion of the last two hours trying to slim > down the schema and query enough to provide something that can > reproduce this. > While I can reproduce it 100% of the time with live data, I can't get > it to reproduce at all with test data -- thoug

Re: [BUGS] BUG #5539: Generally incorrect planner estimations on join with UNION ALL

2010-07-09 Thread Robert Haas
On Sat, Jul 3, 2010 at 8:47 PM, Maksym Boguk wrote: > notable planner had correctly estimated amount of rows in one side of the > join: > (Append  (cost=0.00..0.98 rows=2 width=4)) > and planner hard correctly estimated amount of rows in the another side of > the join: > Index Scan using t3_value_

Re: [BUGS] BUG #5548: ERROR: invalid attnum ## for rangetable entry on EXPLAIN VERBOSE, not on EXPLAIN

2010-07-09 Thread Tom Lane
Daniel Grace writes: > Plan that fails on EXPLAIN VERBOSE: > "Nested Loop (cost=0.00..132.35 rows=24 width=4)" > " -> Subquery Scan on t (cost=0.00..131.00 rows=6 width=4)" > "Filter: (t.foo IS NULL)" > "-> WindowAgg (cost=0.00..119.50 rows=1150 width=4)" > " ->