[BUGS] BUG #1922: bit string of calculated length

2005-09-30 Thread Sorin Schwimmer
The following bug has been logged online: Bug reference: 1922 Logged by: Sorin Schwimmer Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.2 Operating system: Gentoo Linux 2005 Description:bit string of calculated length Details: When puting in an expression

[BUGS] BUG #1926: /etc/init.d/postgresql - script version 7.4.5 fails on startup

2005-09-30 Thread Kevin Waldron
The following bug has been logged online: Bug reference: 1926 Logged by: Kevin Waldron Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.3 Operating system: CentOS 4.1 Description:/etc/init.d/postgresql - script version 7.4.5 fails on startup Details: I'm usi

[BUGS] BUG #1925: upper() and lower() fails with non-english char.

2005-09-30 Thread Søren Vainio
The following bug has been logged online: Bug reference: 1925 Logged by: Søren Vainio Email address: [EMAIL PROTECTED] PostgreSQL version: j2sdk1.4.2_07 Operating system: win XP Description:upper() and lower() fails with non-english char. Details: upper(string) and

[BUGS] BUG #1927: incorrect timestamp returned

2005-09-30 Thread Deyan Chepishev
The following bug has been logged online: Bug reference: 1927 Logged by: Deyan Chepishev Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4.8, 8.0.3 Operating system: Linux Description:incorrect timestamp returned Details: Postgre: 1. PostgreSQL 8.0.3 on i686-

[BUGS] BUG #1923: infinity arithmetic errors

2005-09-30 Thread Sorin Schwimmer
The following bug has been logged online: Bug reference: 1923 Logged by: Sorin Schwimmer Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.2 Operating system: Gentoo Linux 2005 Description:infinity arithmetic errors Details: Hi, I was able to store in tables

Re: [BUGS] BUG #1922: bit string of calculated length

2005-09-30 Thread Tom Lane
"Sorin Schwimmer" <[EMAIL PROTECTED]> writes: > When puting in an expression something like > '0'::BIT(20-LENGTH(something_here)) > I receive an error message suggesting that integer arithmetic is not allowed > in a BIT declaration. Yup, you're right. > I'd like to suggest to allow for any expres

Re: [BUGS] BUG #1926: /etc/init.d/postgresql - script version 7.4.5

2005-09-30 Thread Devrim GUNDUZ
Hi, On Fri, 30 Sep 2005, Kevin Waldron wrote: The following bug has been logged online: Bug reference: 1926 Logged by: Kevin Waldron Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.3 Operating system: CentOS 4.1 Description:/etc/init.d/postgresql - script

Re: [BUGS] BUG #1925: upper() and lower() fails with non-english char.

2005-09-30 Thread Magnus Hagander
> The following bug has been logged online: > > Bug reference: 1925 > Logged by: Søren Vainio > Email address: [EMAIL PROTECTED] > PostgreSQL version: j2sdk1.4.2_07 > Operating system: win XP > Description:upper() and lower() fails with non-english char. > Details: >

Re: [BUGS] BUG #1926: /etc/init.d/postgresql - script version 7.4.5

2005-09-30 Thread Tom Lane
Devrim GUNDUZ <[EMAIL PROTECTED]> writes: > See : https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=152931 > I've increased the sleep time from 1 to 2 for PGDG 8.1 beta RPMs. Let's > see what will happen in next beta. I've been using 2 in Red Hat's RPMs for some time. The whole thing is pret

[BUGS] Bug?: Text after right paren in query is ignored

2005-09-30 Thread Steve Peterson
Is this a bug or some artifact of the SQL language that I've never seen before? SELECT v_id FROM table WHERE col = 'V') AND blah executes without errors, ignoring the closing paren and everything thereafter. Platform: PostgreSQL 8.0.3 on Intel / Windows XP ---(end of

Re: [BUGS] Bug?: Text after right paren in query is ignored

2005-09-30 Thread Alvaro Herrera
On Thu, Sep 29, 2005 at 10:04:04PM -0500, Steve Peterson wrote: > Is this a bug or some artifact of the SQL language that I've never > seen before? > > SELECT v_id > FROM table > WHERE col = 'V') > AND blah > > executes without errors, ignoring the closing paren and everything > thereafter. No

[BUGS] BUG #1928: Postgresql is terminated by signal 10 (bus error) when using prepared statements

2005-09-30 Thread Till Toenges
The following bug has been logged online: Bug reference: 1928 Logged by: Till Toenges Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.3 Operating system: Mac OS X Description:Postgresql is terminated by signal 10 (bus error) when using prepared statements Det

[BUGS] BUG #1929: Successful COPY fails with less records in CSV file

2005-09-30 Thread Michael Rau
The following bug has been logged online: Bug reference: 1929 Logged by: Michael Rau Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.3 Operating system: Windows Professional 5.1, Build 2600 Service Pack 2 Description:Successful COPY fails with less records in