Re: DBI::Pg perl-time to SQL timestamp?

2002-01-31 Thread Richard Poole
On Thu, Jan 31, 2002 at 07:04:59PM +0100, Bruno Boettcher wrote: > > is there a way to feed the perl time directly without any transformation > as a valid timestamp to a postgres database? > but formatting the thing before putting it into the DB seems a bit > cumbersome Not directly,

Re: Environmental Variables and DBD-Pg-1.01

2001-07-31 Thread Richard Poole
On Mon, Jul 30, 2001 at 03:06:59PM -0700, Lauren Buell wrote: > When I try to perl Makefile.PL, I am always instructed to set the > environmental variables POSTGRES_LIB and POSTGRES_INCLUDE. I have > read the instructions posted for others with similar problems and > attempted these solutions, bu

Re: Writing LONG to DBI::Pg

2001-07-12 Thread Richard Poole
On Thu, Jul 12, 2001 at 11:09:33AM +0100, Ian Summers wrote: > > Can anyone enlighten me? I'm trying to insert a field with 4000 characters > into a Pg database which is specified as varchar(4000). > > I've overcome various hurdles but it produces the following error as soon > as it encounters

Re: Help with DBD::Pg

2001-03-28 Thread Richard Poole
On Wed, Mar 28, 2001 at 10:59:05AM -0500, Peter Seabrook wrote: > When executing a CGI script with the following connect statement: > $dbh = > DBI->connect('DBI:Pg:dbname=shop;host=192.168.100.8;port=5432','postgres','' > ,{ RaiseError => 1, AutoCommit => 1}); > > I receive the following error:

Re: trouble with installation DBD-PG

2001-02-05 Thread Richard Poole
On Sun, Feb 04, 2001 at 02:37:32PM -0700, [EMAIL PROTECTED] wrote: > I'm hoping you can point me in the right direction, I'm trying to install version >0.93 or 0.95 of DBD:Pg. I'm getting the following error with either one: > In file included from Pg.xs:13: > Pg.h:13: libpq-fe.h: No such file