Re: [BUGS] BUG #1675: very slow work

2005-05-19 Thread Michael Fuhr
On Thu, May 19, 2005 at 01:27:17PM +0100, Dimitar wrote: > > Posgre works slower on Wndows than on Linux. We worked previously with > Posgre on Linux and it's over 100 times faster than Windows. Could you provide more information about what you're doing? Are you running comparable queries agains

Re: [BUGS] BUG #1676: Statment order in rules

2005-05-19 Thread Tom Lane
"Olleg Samoylov" <[EMAIL PROTECTED]> writes: > create rule delete_first as on delete to v do instead (delete from a where > a=old.a;update c set c=c-1); > delete from v where a=0; > select * from a; > -- 0 row, as expected :-) > select * from c; > -- 1, this is incorrect This isn't a bug. The DE

Re: [BUGS] [PORTS] Bug Report with Postgres 7.4 on AIX 5.3

2005-05-19 Thread Mohan, Ross
Vincent, Thanks for this, I'll run this by our SAs. Should be funny to watch their reaction. Meanwhile, I've requested that we file a bug w/IBM as well. Thanks again for sharing your information! -- Ross Mohan -Original Message- From: Vincent Vanwynsberghe [mailto:[EMAIL PROTECTED

Re: [BUGS] BUG #1674: CREATE TABLE "name" (with double quotes) and

2005-05-19 Thread Neil Conway
Herman Bos wrote: vib=> select * from "bedrag"; ERROR: relation "bedrag" does not exist Naturally: there is no such table, regardless of case. vib=> select "BEDRAG" from sancties; BEDRAG (0 rows) Not with the SQL you provided: neilc=# select "BEDRAG" from sancties; ERROR: relation "sanc

[BUGS] BUG #1673: Can not run initdb on install and no log

2005-05-19 Thread Iavor Raytchev
The following bug has been logged online: Bug reference: 1673 Logged by: Iavor Raytchev Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.3 Operating system: Windows XP Professional Description:Can not run initdb on install and no log Details: C: is on FAT32

[BUGS] BUG #1676: Statment order in rules

2005-05-19 Thread Olleg Samoylov
The following bug has been logged online: Bug reference: 1676 Logged by: Olleg Samoylov Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4.7 Operating system: on x86_64-pc-linux-gnu, compiled by GCC x86_64-linux-gcc (GCC) 3.3.5 (Debian 1:3.3.5-12) Description:St

Re: [BUGS] [PORTS] Bug Report with Postgres 7.4 on AIX 5.3

2005-05-19 Thread Mohan, Ross
Vincent, 1) I am having the exact same problem: I cannot even do a CREATEDB in 8.0.2 on AIX5.3 2) You sent your mail to the PG lists, but not to IBM, possibly? 3) If you think it will help, I can call support as well. If you get ANY word on this, whether a fix, a tweak, or a workaround, p

Re: [BUGS] BUG #1671: Long interval string representation rejected

2005-05-19 Thread Neil Conway
Tom Lane wrote: I'm too tired to think about this more tonight, but it seems like the basic point is that we can't just construct a list of pointers into (a copy of) the original input string. I think we _can_ do it that way, it's just a question of whether that is the best approach. I think the s

[BUGS] BUG #1674: CREATE TABLE "name" (with double quotes) and resulting behavior

2005-05-19 Thread Herman Bos
The following bug has been logged online: Bug reference: 1674 Logged by: Herman Bos Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4.7 Operating system: Ubuntu Linux 5.04 Description:CREATE TABLE "name" (with double quotes) and resulting behavior Details: fo

[BUGS] BUG #1675: very slow work

2005-05-19 Thread Dimitar
The following bug has been logged online: Bug reference: 1675 Logged by: Dimitar Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.2 win32 Operating system: Windows Server 2003: Web Edition Description:very slow work Details: Posgre works slower on Wndows tha

Re: [BUGS] [PORTS] Bug Report with Postgres 7.4 on AIX 5.3

2005-05-19 Thread Vincent Vanwynsberghe
Hi, We opened a call to IBM also, but until now we didn't receive anything (see the attached mail). In order to take into account the RFC 3943, we find a way to fixed the problem by modifying the file socket.h : #define _SS_MAXSIZE 128 /* Implementation specific max size */ SHOULD BE