Re: [ADMIN] Implementing mod_perl, Perl 5.004, and Postgres

2000-11-09 Thread Dronamraju Rajesh
jimi, you have to install modules like DBD-pg, DBD-CSV, DBI etc, which u get from www.cpan.org all the best try ur luck after installing them. i hope u''' be on target!!! regards Rajesh Intercept Consulting - INDIA --- Jimi Thompson <[EMAIL PROTECTED]> wrote: > I am trying to get Postgres to

Re: [ADMIN] Implementing mod_perl, Perl 5.004, and Postgres

2000-11-09 Thread Dronamraju Rajesh
jimi, you have to install modules like DBD-pg, DBD-CSV, DBI etc, which u get from www.cpan.org all the best try ur luck after installing them. i hope u''' be on target!!! regards Rajesh Intercept Consulting - INDIA --- Jimi Thompson <[EMAIL PROTECTED]> wrote: > I am trying to get Postgres to

[ADMIN] Vacuum and index

2000-11-09 Thread Jean-Marc Pigeon
Bonjour, Loading data (around 112000 record) to a newly created data-base, I am able to do select such as: select * from userreg where userid='cynthiaU'; Where 'userid' is defined as: userid VARCHAR(30) UNIQUE, in the table. Everything w

Re: [ADMIN] Implementing mod_perl, Perl 5.004, and Postgres

2000-11-09 Thread Thomas Good
On Thu, 9 Nov 2000, Jimi Thompson wrote: > I keep getting error messages from my CGI scripts regarding a file > called Pg.pm. Since this appears to be a perl module, I was wondering > if anyone knows how to go about making Perl and Postgres like each other > :) If your use directive in your per

[ADMIN] Implementing mod_perl, Perl 5.004, and Postgres

2000-11-09 Thread Jimi Thompson
I am trying to get Postgres to accept Perl as an interface. I am running Apache 1.3.14, Perl 5.004_04, and mod_perl. My application is a help desk/call ticketing system called Teacup (http://www.altara.org.teacup.html) which is written in Perl. It's a series of CGI scripts which allow input, qu

Re: [ADMIN] large classes (tables)

2000-11-09 Thread Alfred Perlstein
* Charlie Crissman <[EMAIL PROTECTED]> [001109 04:21] wrote: > Since we are limited to a 2G file size on unix, is that the practical limit > to the size of a class (table) in PostgreSQL? Is it possible for a class > (table) to use more than one file? > > 2G is not a very big table in reality. Y

Re: [ADMIN] large classes (tables)

2000-11-09 Thread Brook Milligan
Since we are limited to a 2G file size on unix, is that the practical limit To be precise, only some Unix-like OSes are limited to 2G file sizes. NetBSD has had 64-bit filesystems (hence, the limit is much larger than 2G) for _many_ years (probably at least 6) already. Cheers, Brook

Re: [ADMIN] large classes (tables)

2000-11-09 Thread Larry Rosenman
* Charlie Crissman <[EMAIL PROTECTED]> [001109 06:29]: > Thanks for that info... any documentation on how it does that? Is there > something tunable to this? Lets say our table is called 'tablename', will > it just start a new file called 'tablename_2', or something like that? Is > there someth

RE: [ADMIN] large classes (tables)

2000-11-09 Thread Charlie Crissman
Thanks for that info... any documentation on how it does that? Is there something tunable to this? Lets say our table is called 'tablename', will it just start a new file called 'tablename_2', or something like that? Is there something that tells it that it is reaching the 2G limit, or does it

Re: [ADMIN] large classes (tables)

2000-11-09 Thread Larry Rosenman
* Charlie Crissman <[EMAIL PROTECTED]> [001109 06:16]: > Since we are limited to a 2G file size on unix, is that the practical limit > to the size of a class (table) in PostgreSQL? Is it possible for a class > (table) to use more than one file? > > 2G is not a very big table in reality. No, Post

[ADMIN] large classes (tables)

2000-11-09 Thread Charlie Crissman
Since we are limited to a 2G file size on unix, is that the practical limit to the size of a class (table) in PostgreSQL? Is it possible for a class (table) to use more than one file? 2G is not a very big table in reality. Charlie Charlie Crissman Sr. Oracle DBA Oracle Certified Professional

Re: [ADMIN] question

2000-11-09 Thread Oliver Elphick
"Mohammed A." wrote: >I've tries to install Postgresql version 7.0 >but I got an error while the installation (it's not my question). >My question is what is the TCL Tk/Tcl is a language for which PostreSQL offers an interface. Certain parts of PostgreSQL will not build if Tk/Tcl support i