Re: [BUGS] BUG #3790: pg_restore error canceling statement due to user request

2007-11-30 Thread Kevin Grittner
>>> On Fri, Nov 30, 2007 at 4:13 AM, in message <[EMAIL PROTECTED]>, Gregory Stark <[EMAIL PROTECTED]> wrote: > "Mike C." <[EMAIL PROTECTED]> writes: > >> I don't know if this is either a wording change, or a more serious bug, but >> when I do a pg_restore (from a 8.1.9 setup) to a fresh 8.3beta

Re: [BUGS] BUG #3790: pg_restore error canceling statement due touser request

2007-11-30 Thread Rodriguez Fernando
como es el pg_dump y pg_restore que usas? Saludos Fernando Mike C. wrote: The following bug has been logged online: Bug reference: 3790 Logged by: Mike C. Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3beta3 Operating system: Linux 2.6.16.21-0.8-xen #1 SMP Mon Jul

Re: [BUGS] BUG #3790: pg_restore error canceling statement due to user request

2007-11-30 Thread Usama Dar
On 11/30/07, Gregory Stark <[EMAIL PROTECTED]> wrote: > > > "Mike C." <[EMAIL PROTECTED]> writes: > > > I don't know if this is either a wording change, or a more serious bug, > but > > when I do a pg_restore (from a 8.1.9 setup) to a fresh 8.3beta3 created > > database (createdb command only), I r

Re: [BUGS] BUG #3792: cluster in UTF deny database in LATIN2

2007-11-30 Thread Heikki Linnakangas
Marek wrote: Bug reference: 3792 Logged by: Marek Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3beta3 Operating system: Linux 2.6.23.1-49.fc8 #1 SMP x86_64 Description:cluster in UTF deny database in LATIN2 Details: This postgresql was compiled myself. I

Re: [BUGS] BUG #3790: pg_restore error canceling statement due to user request

2007-11-30 Thread Gregory Stark
"Mike C." <[EMAIL PROTECTED]> writes: > I don't know if this is either a wording change, or a more serious bug, but > when I do a pg_restore (from a 8.1.9 setup) to a fresh 8.3beta3 created > database (createdb command only), I repeatedly see: > > ERROR: canceling statement due to user request >

Re: [BUGS] BUG #3791: Bug in aritmethic calculations

2007-11-30 Thread Gregory Stark
"Michailas" <[EMAIL PROTECTED]> writes: > postgres=# SELECT abs(300 - 200)/200*100 as bad, abs(300-200)*100/200 as > good; > > bad | good > -+-- >0 | 50 > (1 row) That's how integer arithmetic works. Try just 1/2 and you'll see you get 0. But if you do floating point arithmetic wit

[BUGS] BUG #3792: cluster in UTF deny database in LATIN2

2007-11-30 Thread Marek
The following bug has been logged online: Bug reference: 3792 Logged by: Marek Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3beta3 Operating system: Linux 2.6.23.1-49.fc8 #1 SMP x86_64 Description:cluster in UTF deny database in LATIN2 Details: This postg

Re: [BUGS] BUG #3791: Bug in aritmethic calculations

2007-11-30 Thread Gevik Babakhani
I think this is not a bug. abs(300 - 200)/200 is calculated as integer. try: gevik=# SELECT abs(300 - 200)/200::float*100 as bad, abs(300-200)*100/200 as good; bad | good -+-- 50 | 50 (1 row) Gevik Babakhani PostgreSQL NL http:

[BUGS] BUG #3791: Bug in aritmethic calculations

2007-11-30 Thread Michailas
The following bug has been logged online: Bug reference: 3791 Logged by: Michailas Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.4-2 Operating system: Debian Description:Bug in aritmethic calculations Details: postgres=# SELECT abs(300 - 200)/200*100 as b

[BUGS] BUG #3790: pg_restore error canceling statement due to user request

2007-11-30 Thread Mike C.
The following bug has been logged online: Bug reference: 3790 Logged by: Mike C. Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3beta3 Operating system: Linux 2.6.16.21-0.8-xen #1 SMP Mon Jul 3 18:25:39 UTC 2006 i686 i686 i386 GNU/Linux Description:pg_restore