Re: [BUGS] panic? return of the btree-bug

2008-02-26 Thread Tom Lane
"Pieter Jansen" <[EMAIL PROTECTED]> writes: > 2008-02-25 17:07:28 CET PANIC: failed to add item to the right > sibling for "ttrss_user_entries_feed_id" > What information is needed to further investigate this? What's the exact index definition (including datatypes of the index columns)? Are you

Re: [BUGS] BUG #3968: ssh tunnel instructions could use improvement

2008-02-26 Thread Faheem Mitha
On Tue, 26 Feb 2008, Peter Eisentraut wrote: Am Montag, 18. Februar 2008 schrieb Faheem Mitha: ssh -L 333ssh -L :foo.com:5432 [EMAIL PROTECTED] I think this should be changed to ssh -L :localhost:5432 [EMAIL PROTECTED] Good point. Please see the updated version at http://developer

[BUGS] panic? return of the btree-bug

2008-02-26 Thread Pieter Jansen
Hi, 2008-02-25 17:07:28 CET PANIC: failed to add item to the right sibling for "ttrss_user_entries_feed_id" 2008-02-25 17:07:28 CET STATEMENT: INSERT INTO ttrss_user_entries (ref_id, owner_uid, feed_id, unread, last_read, marked, published)

Re: [BUGS] BUG #3968: ssh tunnel instructions could use improvement

2008-02-26 Thread Peter Eisentraut
Am Dienstag, 26. Februar 2008 schrieb Faheem Mitha: > At the end, you might want to point out that in the line > > ssh -L 6:db.foo.com:5432 [EMAIL PROTECTED] > > the connection from shell.foo.com to db.foo.com will not be encrypted by > the ssh tunnel, at least according to the documentation I'

Re: [BUGS] help me plz with 2 postgres users

2008-02-26 Thread Euler Taveira de Oliveira
[EMAIL PROTECTED] wrote: How can I delete first postgres user. Ugh. How did you duplicate if there is an unique index in rolname ? pg_shadow is a view; you want to take a look at the real relation pg_authid. delete from pg_authid where ctid = '(0,1)' -- Euler Taveira de Oliveira http

Re: [BUGS] BUG #3968: ssh tunnel instructions could use improvement

2008-02-26 Thread Peter Eisentraut
Am Montag, 18. Februar 2008 schrieb Faheem Mitha: > ssh -L 333ssh -L :foo.com:5432 [EMAIL PROTECTED] > > I think this should be changed to > > ssh -L :localhost:5432 [EMAIL PROTECTED] Good point. Please see the updated version at http://developer.postgresql.org/pgdocs/postgres/ssh-tunnel

Re: [BUGS] BUG #3991: pgsql function sum()

2008-02-26 Thread Zdenek Kotala
flout/double? Zdenek __ NOD32 Informacje 2903 (20080226) __ Wiadomosc zostala sprawdzona przez System Antywirusowy NOD32 http://www.nod32.com lub http://www.nod32.pl ---(end of broadcast)--- TIP 4: Have you searche

Re: [BUGS] BUG #3991: pgsql function sum()

2008-02-26 Thread Tom Lane
"mirek" <[EMAIL PROTECTED]> writes: > problem is in: sum(wvat-wvatp) where field in view wvat = 33.08 and wvatp = > 36.09 > Result is -3.010001 > If I ask postgres manualy: select sum(33.08 - 36.09) > result is ok -3.01 > Now I fix it with round function but i think that is a bug. You

Re: [BUGS] BUG #3991: pgsql function sum()

2008-02-26 Thread Zdenek Kotala
mirek napsal(a): The following bug has been logged online: Bug reference: 3991 Logged by: mirek Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.4 Operating system: Linux fedora(for work) and windows(for development) Description:pgsql function sum() Details:

[BUGS] help me plz with 2 postgres users

2008-02-26 Thread [EMAIL PROTECTED]
Hello? help me plz? i don't khow what to do... How can I delete first postgres user. template1=# select usename,passwd,valuntil,ctid,xmin,xmax,cmin,cmax from pg_shadow where usesysid=1; usename | passwd| valuntil | ctid | xmin | xmax | cmin | cmax --

[BUGS] BUG #3991: pgsql function sum()

2008-02-26 Thread mirek
The following bug has been logged online: Bug reference: 3991 Logged by: mirek Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.4 Operating system: Linux fedora(for work) and windows(for development) Description:pgsql function sum() Details: I saw a very str

Re: [BUGS] BUG #3985: select command not working

2008-02-26 Thread Magnus Hagander
On Sun, Feb 24, 2008 at 12:05:36PM +, srijit wrote: > > The following bug has been logged online: > > Bug reference: 3985 > Logged by: srijit > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.1 > Operating system: windows xp sp2 > Description:select comma