[BUGS] pls unsubscribe me

2002-04-03 Thread Ganesh Kumar
please , unsubscribe me from list i dont want to receive nay mails reg : postgresql __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ ---(end of broadcast)-

[BUGS] Problem in postgresql installation

2002-04-03 Thread Pierre-Alexis Paquin
Hi   I have installed a 7.1.3 postgresql version on my linux server. When I type "createuser " it asks me :  Shall the new user allowed to create databases (y/n)?                                                                         Shall the new user allowed to create more

Re: [BUGS] Inconsistant use of index.

2002-04-03 Thread Tom Lane
Ron Mayer <[EMAIL PROTECTED]> writes: > I did quite a bit more playing with this, and no matter what the > correlation was (1, -0.001), it never seemed to have any effect > at all on the execution plan. > Should it? With a high correlation the index scan is a much better choice. I'm confused.

Re: [BUGS] date function 'age' problem

2002-04-03 Thread Thomas Lockhart
> osk=> select age('2001-03-29','2001-03-01'); > --- > 27 days 23:00 > osk=> select age('2002-03-29','2002-03-01'); > --- > 1 mon > osk=> select version(); > PostgreSQL 7.1.3 on i686-pc-linux-gnu, compiled by GCC 2.95.4 ... > look at the difference betwen results of execution fu

Re: [BUGS] Inconsistant use of index.

2002-04-03 Thread Ron Mayer
On Tue, 26 Mar 2002, Tom Lane wrote: > Ron Mayer <[EMAIL PROTECTED]> writes: > >> I'm particularly interested in the correlation estimate for the dat > >> column. (Would you happen to have an idea whether the data has been > >> inserted more-or-less in dat order?) > > > I beleve much of February

[BUGS] Bug #628: move works incorrectly on cursors using GiST indexes

2002-04-03 Thread pgsql-bugs
Dmitry Tkach ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description move works incorrectly on cursors using GiST indexes Long Description If you declare a cursor for a query, that's using a gist index, then fetch a few rows from it,