Re: [BUGS] BUG #3476: description of root.crt/crl in documentation

2007-07-23 Thread Jim C. Nasby
On Sat, Jul 21, 2007 at 04:54:24AM +, Walter Roeland wrote: > > The following bug has been logged online: > > Bug reference: 3476 > Logged by: Walter Roeland > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.2.4 > Operating system: Windows XP Professional > Descr

Re: [BUGS] BUG #3479: contraint exclusion and locks

2007-07-23 Thread Simon Riggs
On Mon, 2007-07-23 at 11:46 -0300, Tiago Daniel Jacobs wrote: > Tom and Gregory. U're right! The problem is that we're using > constraints for partitioned tables and by definition, a partition > never, absolutely never, can affect the entire system. > Yeh, the problem is that partitioning uses ad

Re: [BUGS] BUG #3480: JDBC driver: getIndexInfo() returns quotes around quoted column names

2007-07-23 Thread Kris Jurka
On Mon, 23 Jul 2007, Andrei Badea wrote: The following bug has been logged online: Bug reference: 3480 Description:JDBC driver: getIndexInfo() returns quotes around quoted column names Details: The DatabaseMetaData.getIndexInfo() method returns quotes around quoted column names,

Re: [BUGS] BUG #3481: wrong link on website?

2007-07-23 Thread Hiroshi Saito
Done! Thanks Regards, Hiroshi Saito Hi. Please visit this. http://psqlodbc.projects.postgresql.org/ P.S) Sorry, The link of URL is not referred. It is corrected soon. Thanks! Regards, Hiroshi Saito - Original Message - From: "Magnus Hagander" christof.elmiger wrote: The foll

Re: [BUGS] BUG #3481: wrong link on website?

2007-07-23 Thread Hiroshi Saito
Hi. Please visit this. http://psqlodbc.projects.postgresql.org/ P.S) Sorry, The link of URL is not referred. It is corrected soon. Thanks! Regards, Hiroshi Saito - Original Message - From: "Magnus Hagander" christof.elmiger wrote: The following bug has been logged online: Bug r

Re: [BUGS] BUG #3481: wrong link on website?

2007-07-23 Thread Magnus Hagander
christof.elmiger wrote: > The following bug has been logged online: > > Bug reference: 3481 > Logged by: christof.elmiger > Email address: [EMAIL PROTECTED] > PostgreSQL version: -- > Operating system: winxp > Description:wrong link on website? > Details: > > Hello >

[BUGS] BUG #3481: wrong link on website?

2007-07-23 Thread christof.elmiger
The following bug has been logged online: Bug reference: 3481 Logged by: christof.elmiger Email address: [EMAIL PROTECTED] PostgreSQL version: -- Operating system: winxp Description:wrong link on website? Details: Hello I'm desperately looking for the postgres odbc-

Re: [BUGS] BUG #3479: contraint exclusion and locks

2007-07-23 Thread Gregory Stark
"Tiago Daniel Jacobs" <[EMAIL PROTECTED]> writes: > Tom and Gregory.  U're right! The problem is > that we're using constraints for partitioned tables and by definition, > a partition never, absolutely never, can affect the entire system. > > But I think that we have nothing to do about this. Th

Re: [BUGS] BUG #3479: contraint exclusion and locks

2007-07-23 Thread Tiago Daniel Jacobs
Tom and Gregory.  U're right! The problem is that we're using constraints for partitioned tables and by definition, a partition never, absolutely never, can affect the entire system. But I think that we have nothing to do about this. There are plans to another kind of partitioning? If yes, I w

Re: [BUGS] BUG #3479: contraint exclusion and locks

2007-07-23 Thread Tom Lane
"Tiago Jacobs" <[EMAIL PROTECTED]> writes: > oh-ow... It waits while the table (That is not used) is locked. This is not a bug. It has to inspect the table to find out that there is a constraint. regards, tom lane ---(end of broadcast)

Re: [BUGS] BUG #3479: contraint exclusion and locks

2007-07-23 Thread Gregory Stark
"Tiago Jacobs" <[EMAIL PROTECTED]> writes: > oh-ow... It waits while the table (That is not used) is locked. > > Even that the final plan dont use tab_2007_07, it wait for unlock of table > for make the plan. Well one of the reasons exclusive locks are taken are to make changes to constraints. >

[BUGS] BUG #3480: JDBC driver: getIndexInfo() returns quotes around quoted column names

2007-07-23 Thread Andrei Badea
The following bug has been logged online: Bug reference: 3480 Logged by: Andrei Badea Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.4 Operating system: Debian GNU/Linux testing/lenny, Linux 2.6.17 Description:JDBC driver: getIndexInfo() returns quotes aroun

[BUGS] BUG #3479: contraint exclusion and locks

2007-07-23 Thread Tiago Jacobs
The following bug has been logged online: Bug reference: 3479 Logged by: Tiago Jacobs Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.4 Operating system: Linux 2.6.21.5 Description:contraint exclusion and locks Details: Hi People! Connection #1 create tabl