Re: [BUGS] Bug in parser?

2003-06-02 Thread Stephan Szabo
On 31 May 2003, Gerhard Dieringer wrote: > > > > POSTGRESQL BUG REPORT TEMPLATE > > > > Your name : Ge

Re: [BUGS] sudoers file??

2003-06-02 Thread Stephan Szabo
On Wed, 28 May 2003, Vivek wrote: > I am trying to connect to postgreSQL through PHP. I am > facing lots of problems. Itried to configure postgreSQL > for the above purpose.I tried the following command to set > PGALLOWTCPIP=yes > > > sudo vi /etc/postgresql/postmaster.init > > It says : postgres

Re: [BUGS] Bug in parser?

2003-06-02 Thread Tom Lane
Gerhard Dieringer <[EMAIL PROTECTED]> writes: > Inconsistent results when calling '+' operator with text arguemts I suspect you are looking for the '||' operator, which is the SQL-standard spelling of concatenation. '+' ends up invoking the one-byte-"char" datatype's addition operator.

Re: [BUGS] Bug or not...

2003-06-02 Thread Bruno Wolff III
On Sun, Jun 01, 2003 at 11:10:56 +0400, Nick Altmann <[EMAIL PROTECTED]> wrote: > Ok. I agree about psql. But how can I do pg_dump??? Please keep discussions on the list. Ident authentication will work for pg_dump if it is supported by your OS. I suspect that .pgpass will work with pg_dump (wi

Re: [BUGS] Index speeds up one row table (why)?

2003-06-02 Thread Bruno Wolff III
On Sun, Jun 01, 2003 at 01:20:03 -0600, Dave E Martin XXIII <[EMAIL PROTECTED]> wrote: > Rod Taylor wrote: > > >An 8 k page will hold approx 140 tuples based on your structure. So, > >for every ~100 updates you'll want to run vacuum (regular, not full) on > >the table > > Alas, for this applica

[BUGS] Detecting proper bison version before make

2003-06-02 Thread Greg Sabino Mullane
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I just installed Postgres on an older machine and was surprised that configure did not throw an error about running an old version of bison, but let me get a bit into the whole 'make' cycle before a cryptic error was thrown. Can the configure scri

Re: [BUGS] Index speeds up one row table (why)?

2003-06-02 Thread Dave E Martin XXIII
Bruno Wolff III wrote: Maybe you should reconsider how badly you want the app to be totally database agnostic? Using a sequence might be less of a contortion than using vacuum a few times a minute. You are likely to have similar performance issues with other databases, so this section of code may

Re: [BUGS] Index speeds up one row table (why)?

2003-06-02 Thread Peter Childs
On Mon, 2 Jun 2003, Dave E Martin XXIII wrote: > Bruno Wolff III wrote: > > >Maybe you should reconsider how badly you want the app to be totally database > >agnostic? Using a sequence might be less of a contortion than using vacuum > >a few times a minute. You are likely to have similar performa