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 cr...@postnewspapers.com.au 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

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 loupicci...@comcast.net 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

[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

[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

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 smartn...@gmail.com 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

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

2010-07-08 Thread Tom Lane
Pavani Mallampati pavanimallamp...@gmail.com 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

[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

[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

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 hxku...@qwest.com 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

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 hxku...@qwest.com 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

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

2010-07-08 Thread Robert Haas
On Tue, Jul 6, 2010 at 2:43 AM, Roman zo...@oe-it.ru 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

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 Ringercr...@postnewspapers.com.au 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 -

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

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

[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 #5548: ERROR: invalid attnum ## for rangetable entry on EXPLAIN VERBOSE, not on EXPLAIN

2010-07-08 Thread Tom Lane
Daniel Grace dgr...@wingsnw.com 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