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

2010-07-08 Thread Tom Lane
"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 anywhere near enough information for someone else to reproduce

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

2010-07-08 Thread Daniel Grace
The following bug has been logged online: Bug reference: 5548 Logged by: Daniel Grace Email address: dgr...@wingsnw.com PostgreSQL version: 9.0beta2 Operating system: Windows XP 32-bit Description:ERROR: invalid attnum ## for rangetable entry on EXPLAIN VERBOSE, not

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

2010-07-08 Thread Craig Ringer
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 Description:not able to connect to postgres through the oracle usi

Re: [BUGS] BUG #5546: not able to connect to postgres through the oracle using

2010-07-08 Thread Craig Ringer
On 8/07/2010 10:33 PM, Hemanth wrote: The following bug has been logged online: Bug reference: 5546 Logged by: Hemanth Email address: hxku...@qwest.com PostgreSQL version: 8.4 Operating system: Linux Description:not able to connect to postgres through the oracle usi

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

2010-07-08 Thread Craig Ringer
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\ (no leading period). You're quite right. Sorry - I thought it used .postgres

Re: [BUGS] BUG #5542: Query optimization problem

2010-07-08 Thread Robert Haas
On Tue, Jul 6, 2010 at 2:43 AM, Roman wrote: > I have a query: > > SELECT d1.ID, d2.ID > FROM DocPrimary d1 >  JOIN DocPrimary d2 ON d2.BasedOn=d1.ID > WHERE (d1.ID=234409763) or (d2.ID=234409763) > > i think what QO(Query Optimizer) can make it faster (now it seq scan and on > million records wor

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

2010-07-08 Thread Tom Lane
"Hemanth" writes: > I am able to install Linux ODBC driver for Postgres successfully. i am able > to connect to the postgres using demo in the driver. > but not able to connect to the postgres using the same username and password > from DB LINK created b/w postgres and oracle . > ERROR at line 1:

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

2010-07-08 Thread Kevin Grittner
"Hemanth" wrote: > role "AIP" does not exist This suggests that you're trying to log in as "AIP", and PostgreSQL is not finding that role. Can you connect to PostgreSQL with the psql command-line utility and run?: \du If so, please show us the results. By the way, in the future please t

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

2010-07-08 Thread Hemanth
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 Description:not able to connect to postgres through the oracle using Linux ODBC driver for Postgres Detail

[BUGS] BUG #5546: not able to connect to postgres through the oracle using

2010-07-08 Thread Hemanth
The following bug has been logged online: Bug reference: 5546 Logged by: Hemanth Email address: hxku...@qwest.com PostgreSQL version: 8.4 Operating system: Linux Description:not able to connect to postgres through the oracle using Details: I am able to install Linux

Re: [BUGS] BUG #5544: Bug while loading the csv file into the table

2010-07-08 Thread Tom Lane
"Pavani Mallampati" writes: > Creating “emp” table in grid with the syntax. > GridSQL -> create table employee_details(emp_id integer, > GridSQL -> emp_name varchar, > GridSQL -> emp_address varchar) with xrowid; > OK I don't know what "with xrowid" does; I suspect you need to be asking the E

Re: [BUGS] BUG #5545: permission denied on delete

2010-07-08 Thread Robert Haas
On Thu, Jul 8, 2010 at 8:49 AM, Niranjan Pandit wrote: > role A is member of role B, role B has delete privilege also the select > privilege on the id field of the table. when logged in with role A and set > role to B, the permission is still denied to delete a record, any ideas why > is permissio

[BUGS] BUG #5545: permission denied on delete

2010-07-08 Thread Niranjan Pandit
The following bug has been logged online: Bug reference: 5545 Logged by: Niranjan Pandit Email address: smartn...@gmail.com PostgreSQL version: 8.4 Operating system: Fedora 13 Description:permission denied on delete Details: role A is member of role B, role B has de

[BUGS] BUG #5544: Bug while loading the csv file into the table

2010-07-08 Thread Pavani Mallampati
The following bug has been logged online: Bug reference: 5544 Logged by: Pavani Mallampati Email address: pavanimallamp...@gmail.com PostgreSQL version: 8.3 Operating system: Centos Description:Bug while loading the csv file into the table Details: NOT WORKING The “

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

2010-07-08 Thread Magnus Hagander
On Wed, Jul 7, 2010 at 16:28, Lou Picciano wrote: > Magnus, > Tks for your response. >> What is your connection string? Are you specifying the cert file there as >> well? > Well, no.  Specifically, the exercise was to determine default locations of > certs on Windows 7, as inferred from - the expe

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

2010-07-08 Thread Magnus Hagander
On Thu, Jul 8, 2010 at 03:10, Craig Ringer wrote: > On 07/07/10 22:28, Lou Picciano wrote: > >> Well, no. Specifically, the exercise was to determine default locations of >> certs on Windows 7, as inferred from - the expected - error message from the >> PG client. In this case, the client was pg