Re: [GENERAL] postgres libpq library

1999-12-03 Thread Peter Eisentraut
On 1999-12-02, ^chewie mentioned: > > > server. I was wondering if the library is instead thread safe (i.e.: > > > if it can be safely called from multi-threaded applications). > > > > That's a definite no. > > You know. I, for one, have a little bit of free time I could donate to > contributi

Re: [GENERAL] Date & Time

1999-12-03 Thread Peter Eisentraut
On 1999-12-01, Bruce Momjian mentioned: > I am changing my book to use CURRENT_TIMESTAMP rather than now(). I recall Thomas muttering some very promising things about the date/time revolution, including conformance to SQL and ISO formats. Perhaps this could go along with it. At least move the st

Re: [GENERAL] Some MySQL features

1999-12-03 Thread Ed Loehr
"Aaron J. Seigo" wrote: > > This is a question that could be an answer. What do y'all think about > > using the OID to get the same functionality (unless he really needs a > > sequence of nice small numbers)? > > OIDs don't survive dump/reloads and sequences already provide this > functionality,

Re: [GENERAL] All writes make postgresql a slow database?

1999-12-03 Thread Jesse Kipp
> I'm using Postges to log certain customer activities on our web site - > logins, things like that. I vacuum once a night. Now the database has > grown quite large, the main table alone is 180 Mb. It contains lots and > lots of small rows. > That is a very small database. :) > Anyway, a few mi

[GENERAL] PostgreSQL 6.5.3 on SuSE 6.1

1999-12-03 Thread Vegeta
Hi list members: I am currently using PostgreSQL 6.4.2 on SuSE 6.1. This version came with the SuSE disks. Recently, I downloaded and compiled the source from the pgsql ftp site, but postgres does not run and says that a file called libreadline.so is needed to run. This file is not on my compute

Re: [GENERAL] Some MySQL features

1999-12-03 Thread kaiq
and, generally, those low-level non-sql86/92 things should be treated with caution. On Fri, 3 Dec 1999, Aaron J. Seigo wrote: > hi.. > > > This is a question that could be an answer. What do y'all think about > > using the OID to get the same functionality (unless he really needs a > > sequen

Re: [GENERAL] Some MySQL features

1999-12-03 Thread Aaron J. Seigo
hi.. > This is a question that could be an answer. What do y'all think about > using the OID to get the same functionality (unless he really needs a > sequence of nice small numbers)? OIDs don't survive dump/reloads and sequences already provide this functionality, surviving dump/reloads --

Re: [GENERAL] Some MySQL features

1999-12-03 Thread Keith G. Murphy
vincent leycuras wrote: > > Hi! > I'd like to know if pgsql supports the two excellent features that exist in > MySQL: > - the possibility to load the database with ASCII formatted file containing > the data we want to put; > - the index auto incrementation the prevents from having to specify the