Re: [BUGS] BUG #5999: Postgresql using Excel 2010 Powerpivot

2011-04-29 Thread Kevin Grittner
"Brian" wrote: > I need to connect Postgres SQL to Excel 2010 Power Pivot > > > Please help on instructions This is not a bug. Try posting to pgsql-general, or if you expect that it will use ODBC you could post on pgsql-odbc. When starting a new thread, it's best to look at this page and c

[BUGS] BUG #5999: Postgresql using Excel 2010 Powerpivot

2011-04-29 Thread Brian
The following bug has been logged online: Bug reference: 5999 Logged by: Brian Email address: briancaji...@gmail.com PostgreSQL version: 1.12.2 Operating system: Windows 7 Description:Postgresql using Excel 2010 Powerpivot Details: I need to connect Postgres SQL to

Re: [BUGS] BUG #5998: CLUSTER and "ERROR: missing chunk number 0 for toast value"

2011-04-29 Thread Tom Lane
"Mark Reid" writes: > This morning I noticed that a normally small table (18 wide rows) was > bloated to 6GB in size. This has happened before using older postgres > versions in the past, where the main table got vacuumed, but the pg_toastXX > table did not. This is the first time I've seen a pr

Re: [BUGS] BUG #5997: [queryplan] PostgreSQL is sorting the query results when the result can only be 1 item.

2011-04-29 Thread Kevin Grittner
"Michiel" wrote: > [query with ORDER BY clause] > [plan which spends 0.039 ms sorting one row] > What i see and expect: > > I see that the query is sorted. But the result is max 1 item. This is not a bug; it is a feature request for the planner. If you see a way that a query can be reli

[BUGS] BUG #5997: [queryplan] PostgreSQL is sorting the query results when the result can only be 1 item.

2011-04-29 Thread Michiel
The following bug has been logged online: Bug reference: 5997 Logged by: Michiel Email address: mich...@ict4schools.nl PostgreSQL version: 8.4.7 Operating system: Linux Description:[queryplan] PostgreSQL is sorting the query results when the result can only be 1 item.

[BUGS] BUG #5998: CLUSTER and "ERROR: missing chunk number 0 for toast value"

2011-04-29 Thread Mark Reid
The following bug has been logged online: Bug reference: 5998 Logged by: Mark Reid Email address: m...@markreid.org PostgreSQL version: 8.3.5 Operating system: Debian Etch Description:CLUSTER and "ERROR: missing chunk number 0 for toast value" Details: Hello, This