Re: [BUGS] BUG #1523: precision column value returned from getTypeInfo()

2005-03-04 Thread Sergio Lob
Hi Oliver, The Microsoft ODBC 2.0 SDK guide and reference (Appendix D) contains a pretty thorough definition of what precision means in relation to various data types. I have never seen a definition of precision in any JDBC doc I have read, however. According to ODBC 2.0 spec definition of

[BUGS] BUG #1514: Inheritance and Primary Keys

2005-03-04 Thread Peter Newman
The following bug has been logged online: Bug reference: 1514 Logged by: Peter Newman Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4.7 Operating system: Fedora Core 3 Description:Inheritance and Primary Keys Details: Hi Just exploring the use of

[BUGS] BUG #1517: SQL interval syntax is accepted by the parser, but the interpretation is bogus

2005-03-04 Thread Roy Badami
The following bug has been logged online: Bug reference: 1517 Logged by: Roy Badami Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.1 Operating system: Solaris 9 Description:SQL interval syntax is accepted by the parser, but the interpretation is bogus

[BUGS] BUG #1518: Conversions to (undocumented) SQL year-month and day-time interval types silently discard data

2005-03-04 Thread Roy Badami
The following bug has been logged online: Bug reference: 1518 Logged by: Roy Badami Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.1 Operating system: Solaris 9 Description:Conversions to (undocumented) SQL year-month and day-time interval types silently

[BUGS] BUG #1520: messages in Russian is made wrong

2005-03-04 Thread Ivan Chumak
The following bug has been logged online: Bug reference: 1520 Logged by: Ivan Chumak Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0 Operating system: Windows XP SP2 Description:messages in Russian is made wrong Details: The derivation (conclusion) of

[BUGS] BUG #1527: select retrieves 0 rows after vacuum analyze

2005-03-04 Thread Theo Petersen
The following bug has been logged online: Bug reference: 1527 Logged by: Theo Petersen Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4 Operating system: Linux (Gentoo) Description:select retrieves 0 rows after vacuum analyze Details: I have a database

[BUGS] BUG #1525: wrong time when getting timestamp from date field

2005-03-04 Thread François LECOMTE
The following bug has been logged online: Bug reference: 1525 Logged by: François LECOMTE Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.1 Operating system: Linux Debian Description:wrong time when getting timestamp from date field Details: Problem when

[BUGS] BUG #1526: SHRT_MIN out of range on explicit type conversion

2005-03-04 Thread Kelly Burkhart
The following bug has been logged online: Bug reference: 1526 Logged by: Kelly Burkhart Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4.2 Operating system: SuSE Linux 9.1 i386 x86-64 Description:SHRT_MIN out of range on explicit type conversion Details:

[BUGS] BUG #1519: server closed the connection unexpectedly

2005-03-04 Thread Al Torres
The following bug has been logged online: Bug reference: 1519 Logged by: Al Torres Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0 Operating system: Windows XP Pro Description:server closed the connection unexpectedly Details: Need to know the cause...

[BUGS] BUG #1521: precision column value returned from getTypeInfo() always value of 9

2005-03-04 Thread Sergio Lob
The following bug has been logged online: Bug reference: 1521 Logged by: Sergio Lob Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.1 Operating system: linux Description:precision column value returned from getTypeInfo() always value of 9 Details: After

[BUGS] BUG #1524: drop view cascade deletes other user's views

2005-03-04 Thread Dennis van Dok
The following bug has been logged online: Bug reference: 1524 Logged by: Dennis van Dok Email address: [EMAIL PROTECTED] PostgreSQL version: 7.3.4 Operating system: Linux Description:drop view cascade deletes other user's views Details: Using DROP VIEW or DROP

[BUGS] BUG #1516: DOC BUG: Interval type syntax and interval literal syntax

2005-03-04 Thread Roy Badami
The following bug has been logged online: Bug reference: 1516 Logged by: Roy Badami Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.1 Operating system: Solaris 9 Description:DOC BUG: Interval type syntax and interval literal syntax Details: Interval types

[BUGS] BUG #1522: there's a syntax error using psql, distinct

2005-03-04 Thread DIEGO URRA
The following bug has been logged online: Bug reference: 1522 Logged by: DIEGO URRA Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0 Operating system: REDHAT 6.2 Description:there's a syntax error using psql, distinct Details: hi! select distinct(id) from

Re: [BUGS] BUG #1516: DOC BUG: Interval type syntax and interval literal

2005-03-04 Thread Roy Badami
eg the following type is not accepted in CREATE TABLE Oops, meant to write eg the following type IS accepted in CREATE TABLE interval year to month ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[BUGS] BUG #1515: cant start, err 10045

2005-03-04 Thread Armin Diehl
The following bug has been logged online: Bug reference: 1515 Logged by: Armin Diehl Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0 and 8.0.1 Operating system: Windows XP Description:cant start, err 10045 Details: Inatalling 8.0 or 8.0.1 on Windows XP.

Re: [BUGS] BUG #1522: there's a syntax error using psql, distinct

2005-03-04 Thread Stephan Szabo
On Thu, 3 Mar 2005, DIEGO URRA wrote: The following bug has been logged online: Bug reference: 1522 Logged by: DIEGO URRA Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0 Operating system: REDHAT 6.2 Description:there's a syntax error using psql,

Re: [BUGS] BUG #1524: drop view cascade deletes other user's views

2005-03-04 Thread Tom Lane
Dennis van Dok [EMAIL PROTECTED] writes: Using DROP VIEW or DROP TABLE with CASCADE will drop all dependent views, even those that aren't owned by the caller. This is per SQL spec. regards, tom lane ---(end of

Re: [BUGS] BUG #1527: select retrieves 0 rows after vacuum analyze

2005-03-04 Thread Tom Lane
Theo Petersen [EMAIL PROTECTED] writes: I have a database (network monitoring data created by OpenNMS) that exhibits this behavior: 1) I restore the database from a production backup. 2) I perform a select that joins four tables, and get 9 rows of output. 3) I use the command VACUUM ANALYZE

Re: [BUGS] BUG #1526: SHRT_MIN out of range on explicit type conversion

2005-03-04 Thread Tom Lane
Kelly Burkhart [EMAIL PROTECTED] writes: From psql, the following will fail: select -32768::int2; This is not a bug. The reason is that :: binds more tightly than -, so what you have written is equivalent to select -(32768::int2); which obviously *should* fail. Try it as select

Re: [BUGS] BUG #1525: wrong time when getting timestamp from date

2005-03-04 Thread Kris Jurka
On Fri, 4 Mar 2005, François LECOMTE wrote: Bug reference: 1525 PostgreSQL version: 8.0.1 Description:wrong time when getting timestamp from date field Problem when getting a Java Timestamp object on a DATE database field. With driver pg74jdbc3.jar : hours, minutes, seconds

Re: [BUGS] BUG #1527: select retrieves 0 rows after vacuum analyze

2005-03-04 Thread Michael Fuhr
Theo Petersen [EMAIL PROTECTED] writes: I have a database (network monitoring data created by OpenNMS) that exhibits this behavior: 1) I restore the database from a production backup. 2) I perform a select that joins four tables, and get 9 rows of output. 3) I use the command VACUUM ANALYZE