[GENERAL] Re: PostgreSQL interfaces for PHP and Perl

2000-08-12 Thread Prasanth A. Kumar
David Steuber <[EMAIL PROTECTED]> writes: > For perl, using CPAN.pm, what install command will get me the > interfaces for PostgreSQL? Do I need to have PostgreSQL setup and > running first? Before you can use DBI with PostgreSQL, the PostgreSQL database server must be running on your computer

Re: [GENERAL] Re: Lock up on 7.0.2 involving CREATE FUNCTION/INDEX..

2000-08-09 Thread Prasanth A. Kumar
Mike Mascari <[EMAIL PROTECTED]> writes: > Philip Hallstrom wrote: > > > > Is there another function that will uppercase? Or is there some way to > > call the other UPPER function? Or something within plpgsql I don't know > > about. > > Thanks! > > -philip > > I don't understand this. UPPER()

Re: [GENERAL] Lock up on 7.0.2 involving CREATE FUNCTION/INDEX..

2000-08-09 Thread Prasanth A. Kumar
Philip Hallstrom <[EMAIL PROTECTED]> writes: > Hi - > The following statements lock up my machine completely (I can > ping, but can't telnet, nothing). This is FreeBSD 3.4-STABLE running > 7.0.2. > > rolo_entry.fname is of type VARCHAR(30). > > devloki=> CREATE FUNCTION upper(VARCHAR) RE

Re: [GENERAL] 4 billion record limit?

2000-07-26 Thread Prasanth A. Kumar
brad <[EMAIL PROTECTED]> writes: > Simply waiting for 64bit numbers is rather inelegant and also presumes usage > parameters for the database... remember Bill Gates saying that he couldn't > foresee any usage for more than 64MB of RAM? Besides which, PostgreSQL is the > best DB around... there's

Re: [GENERAL] Trouble with RPM

2000-07-17 Thread Prasanth A. Kumar
Gilles DAROLD <[EMAIL PROTECTED]> writes: > Hi, > > Please don't use RPM if you don't want to have a Win$ based install. > It's remember me a very old question: Where are the DLL ? > > The better way is to get the tarball and do a fresh compilation, you will > learn more about postgres (see the

Re: [GENERAL] Re: How to list and remove a user in postgres ?

2000-07-12 Thread Prasanth A. Kumar
HomerWelch <[EMAIL PROTECTED]> writes: > Fred wrote: > > > > Hi, > > > > I am a newby and i dont understand how to list al the users or delete them ? > > > > 1 do i it from the command line in Linux > > 2 or in the database > > > > i have a user Fred and a user Grades and want delete them. >

Re: [GENERAL] Slashdot discussion

2000-07-11 Thread Prasanth A. Kumar
Travis Bauer <[EMAIL PROTECTED]> writes: > Once I ran into a guy who said that the postgres rpm was broken in Red Hat > 5.2. This was when I was first getting into postgres. I spent some time > with it and realized that there were a number of things that had to be > done before it would work: c

Re: [GENERAL] Couple of design questions

2000-07-08 Thread Prasanth A. Kumar
Jesse Scott <[EMAIL PROTECTED]> writes: > Hello everyone, > > I'm just beginning a PHP / PostgreSQL project for someone and there are a > couple of things where I am not sure the best design for the database. > > The first is that we want to store kind of a history of values for the past > 3