[BUGS] Spam Re: Protected Mail Delivery

2005-06-03 Thread t-ishii
First part of the secure mail is available. +++ Attachment: No Virus found +++ Bitdefender AntiVirus - www.bitdefender.com Dangerous Attachment has been Removed. The file "message.zip" has been removed because of a virus. It was infected with the "W32/Netsky.P-mm" virus. File quarantined a

[BUGS] BUG #1700: Error on Subselect with date in where condition

2005-06-03 Thread Michael
The following bug has been logged online: Bug reference: 1700 Logged by: Michael Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.3 Operating system: Windows 2000 Pro Description:Error on Subselect with date in where condition Details: Hello, we're porting o

[BUGS] BUG #1698: Different behavior in UNIQUE and DISTINCT

2005-06-03 Thread Mauro Delfino
The following bug has been logged online: Bug reference: 1698 Logged by: Mauro Delfino Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4.6 and 8.0.3 Operating system: Debian and Windows 2003 Server Description:Different behavior in UNIQUE and DISTINCT Details:

[BUGS] BUG #1699: Invalid timestamps with timezone and interger timestamps

2005-06-03 Thread Guillaume Beaudoin
The following bug has been logged online: Bug reference: 1699 Logged by: Guillaume Beaudoin Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4.8 Operating system: Debian GNU/Linux Description:Invalid timestamps with timezone and interger timestamps Details: SE

Re: [BUGS] BUG #1697: Select getting slower on continously updating data

2005-06-03 Thread Bahadur Singh
--- Bruno Wolff III <[EMAIL PROTECTED]> wrote: > This does not belong on the pgsql-bugs list. The > pgsql-novice or > pgsql-performance lists seem more appropiate. I have > set followups > to the pgsql-novice list. > > On Thu, Jun 02, 2005 at 12:05:00 +0100, > Bahadur Singh <[EMAIL PROTECTED]

Re: [BUGS] BUG #1698: Different behavior in UNIQUE and DISTINCT

2005-06-03 Thread Bruno Wolff III
On Thu, Jun 02, 2005 at 20:22:07 +0100, Mauro Delfino <[EMAIL PROTECTED]> wrote: > > I have the these two tables: > CREATE TABLE table_one > ( field1 VARCHAR(255) ); > > CREATE TABLE table_two > ( field1 VARCHAR(255) UNIQUE ); > > table_one has 500k records. I certify that all strings are dist

Re: [BUGS] BUG #1700: Error on Subselect with date in where condition

2005-06-03 Thread Michael Fuhr
On Fri, Jun 03, 2005 at 01:47:46PM +0100, Michael wrote: > > Description:Error on Subselect with date in where condition Are you sure that "Subselect with date in where condition" accurately describes the conditions that produce the error? Do you get the error if you don't use a subselec

Re: [BUGS] BUG #1698: Different behavior in UNIQUE and DISTINCT

2005-06-03 Thread John Hansen
> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Bruno Wolff III > Sent: Friday, June 03, 2005 11:58 PM > To: Mauro Delfino > Cc: pgsql-bugs@postgresql.org > Subject: Re: [BUGS] BUG #1698: Different behavior in UNIQUE > and DISTINCT > > On Thu, J

Re: [BUGS] BUG #1678: pw_shadow BUS ERROR

2005-06-03 Thread Tom Lane
=?iso-8859-9?Q?Haluk_G=DCN=C7ER?= <[EMAIL PROTECTED]> writes: > I would like to get the patch list installed on the machine you compiled > postgresQL FROM YOU , so that I can compare with ours. It takes about 12kB. I used one of the PA-RISC servers provided by HP's testdrive program http://www.t

Re: [BUGS] BUG #1697: Select getting slower on continously updating data

2005-06-03 Thread Bruno Wolff III
On Fri, Jun 03, 2005 at 00:09:00 -0700, Bahadur Singh <[EMAIL PROTECTED]> wrote: > > Many thanks for this tip ! > But is this good idea to analyse/vacuuming the > database tables while updates are taking place.. > Since, I update continuously say (100,000 ) times or > more the same data set. >

Re: [BUGS] BUG #1700: Error on Subselect with date in where condition

2005-06-03 Thread Michael Fuhr
[Please copy the mailing list on replies. I'm sending this copy of your message to the list so others can see what the problem was.] On Fri, Jun 03, 2005 at 05:48:19PM +0200, Michael Horsten wrote: > I'm really sorry, > it was my fault. > I only executed the SQL Statement in "EMS SQL Query", not

Re: [BUGS] BUG #1678: pw_shadow BUS ERROR

2005-06-03 Thread Haluk GÜNÇER
Hello Tom, You wrote that you ran postgresql on HPUX11.11. Our Server type: V2500 12CPU 16GB RAM. I would like to get the patch list installed on the machine you compiled postgresQL FROM YOU , so that I can compare with ours. It takes about 12kB. Command for patch list # swlist .. PHSS_3047