Re: [BUGS] BUG #2737: hash indexing large table fails, while btree of same index works

2006-11-10 Thread Tom Lane
[ cc'ing to pgsql-performance because of performance issue for hash indexes ] "Balazs Nagy" <[EMAIL PROTECTED]> writes: > Database table size: ~60 million rows > Field to index: varchar 127 > CREATE INDEX ... USING hash ... > fails with a file not found error (psql in verbose mode): > ERROR: 5

Re: [BUGS] BUG #2732: pg_get_serial_sequence error

2006-11-10 Thread Tom Lane
"Basil Evseenko" <[EMAIL PROTECTED]> writes: > So pg_catalog.pg_get_serial_sequence return garbage: index name vs sequence > name Fixed, thanks for the report! regards, tom lane ---(end of broadcast)--- TIP 1: if posting/rea

Re: [BUGS] BUG #2750: information_schema broken with primary and foreign key on the same column

2006-11-10 Thread Tom Lane
"Stephen haberman" <[EMAIL PROTECTED]> writes: > Just tried postgresql 8.2 beta 3 and it is missing a patch I had sent to > pgsql-patches after trying 8.2 beta 2 a few weeks ago. Hm, there is no such message in the archives. > The information_schema `position_in_unique_constraint` is broken when

Re: [BUGS] BUG #2751: contrib\pgxml.sql

2006-11-10 Thread Tom Lane
"Dennis" <[EMAIL PROTECTED]> writes: > PostgreSQL version: 8.1.5 > contrib\pgxml.sql has reference to xml_is_well_formed function. Not in 8.1 there isn't. Sounds like you are trying to use an 8.2 beta sql script with an 8.1 library. regards, tom lane ---

[BUGS] BUG #2752: Website bug

2006-11-10 Thread Denis
The following bug has been logged online: Bug reference: 2752 Logged by: Denis Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.5 Operating system: Gentoo 2006.1 server x86 Description:Website bug Details: Don't know where to file this bug, but when I submit

[BUGS] BUG #2751: contrib\pgxml.sql

2006-11-10 Thread Dennis
The following bug has been logged online: Bug reference: 2751 Logged by: Dennis Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.5 Operating system: Gentoo 2006.1 server x86 Description:contrib\pgxml.sql Details: contrib\pgxml.sql has reference to xml_is_wel

Re: [BUGS] JDBC driver bug PreparedStatement.setNull(int,Types.BOOLEAN)

2006-11-10 Thread Kris Jurka
On Wed, 8 Nov 2006, David Green wrote: the JDBC driver does not handle setNull for boolean types. the switch statement in setNull should be expanded with a case that checks for Types.BOOLEAN The JDBC2 driver does not handle Types.BOOLEAN because that was added in JDBC3. See org.postgresq