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 inheritan

[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 Detail

[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 dis

[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 messa

[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 (netw

[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 ge

[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... ser

[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 cal

[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 TABLE

[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 r

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. Ser

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 ps

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 broadcast)

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

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 (-327

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, sec

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