PQconnectdb() problem

[Ivan Kohler]

Sorry for the delay getting back to you.

Yes, the current PostgreSQL port was contributed.  At this time I develop
using MySQL, though I will attempt to do more testing with PostgreSQL.

Both PostgreSQL and MySQL have some non-standard CREATE syntax, though
most other commands (SELECT, INSERT, UPDATE, DELETE) have identical
syntax.  I missed a small quirk in PostgreSQL, which should be corrected
by the attached dbdef_column.pm file.  You (and anyone else using
PostgreSQL) should put this in your site_perl directory.  It will be
included in all later versions. 

Please tell me if you have any further problems.

On Wed, 30 Sep 1998, Robert Davidson wrote:

> 
> 
> Ivan, I followed your instructions, which did help me. Now I've been faced with
> another error (and sence I'm no perl or C programmer , and I'm no sql wizard, I
> dont have a clue what it means).
> 
> Creating cust_pkg...DBD::Pg::db do failed: WARN:parser: parse error at or near
> "null"
> CREATE error: WARN:parser: parse error at or near "null"
> 
> doing statement: CREATE TABLE cust_pkg ( setup int NULL, pkgnum int , bill int
> NULL, cancel int NULL, otaker varchar(8) , pkgpart int , susp int NULL, expire
> int NULL, custnum int , PRIMARY KEY (pkgnum) ) at ./fs-setup line 166.
> 
> .... now, I'm just wondering.. is it just me that has these kinds or problems,
> or is it because I'm using PostgreSQL and not MySQL ?
> 
> Has much testing been done with PostgreSQL ?


> 
> Cya.
> 
> Regards,
> Robert davidson.
> puttputt at mail.express.bbs.net.au
> 
> 

-- 
Ivan Kohler <ivan at sisd.com> - finger for PGP key
Silicon Interactive Software Design - http://www.sisd.com/ - 888-670-SISD
Open-source billing and administration for ISPs - http://www.sisd.com/freeside
20 4,16 * * * saytime # please don't be surprised if you find me dreaming too




-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/x-perl
Size: 3289 bytes
Desc: 
Url : http://420.am/pipermail/freeside-users/attachments/19981013/19689fc6/attachment.bin