[GENERAL] RPMs for PHP accessing PostgreSQL via ODBC over RedHat

2001-03-06 Thread Paulo Parola
Hi, We are currently running the following configuration on our server: Linux Red Hat 7.0 PostgreSQL 7.1beta4-1 PHP 4.0.1pl2 I need to add some RPM package (or perhaps an apache module) to enable PHP to access PostgreSQL via ODBC. In order to have PostgreSQL native access support we installed

[GENERAL] [PHP] How to connect to PostgreSQL with phpPgAdmi

2001-03-05 Thread Paulo Parola
For the phpPgAdmin users, if you might help!!! I am running PostgreSQL 7.1 over RedHat. When trying to connect through the web everything goes right. A script that is currently working: ?php $link = pg_Connect("host=localhost port=5432 dbname=teste") or die ("Could not connect");

Re: [GENERAL] Re: RPMs for PHP accessing PostgreSQL via ODBC over RedHat

2001-03-05 Thread Paulo Parola
The case is really code compatibility. I have benn using PHP to access mSQL, MySQL and PostgreSQL natively for quite a while, *but* we need to port an apllication currently running on NT written in PHP and accessing MS Access using ODBC. We have already exported the database to PostgreSQL over

[GENERAL] How to automatically start postmastrer with TCP/IP support (-i option) ???

2001-03-04 Thread Paulo Parola
Hi, I am trying to configure PostgreSQL 7.1 over RedHat 7.0 (according to Lamar Owen the RPM's for 7.1 were built on RedHat 6.2and not 7.0 - does that implies any possible problems?). I have PostgreSQL already starting automatically but with no support to TCP/IP connections. I can see this

With which user Apache accesses PostgreSQL (was Re: [GENERAL] How to automatically start postmastrer with TCP/IP support (-i option) ???)

2001-03-04 Thread Paulo Parola
- Original Message - From: Uro Gruber [EMAIL PROTECTED] To: Paulo Parola [EMAIL PROTECTED] Sent: Sunday, March 04, 2001 7:14 PM Subject: Re: [GENERAL] How to automatically start postmastrer with TCP/IP support (-i option) ??? Hi, Sunday, March 04, 2001, 10:38:04 PM, you wrote: PP

Re: [GENERAL] PostgreSQL 7.1 Linux Installation

2001-03-01 Thread Paulo Parola
ow to procceed? TIA, Paulo Parola [EMAIL PROTECTED] - Original Message - From: Mirko Zeibig [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, February 22, 2001 7:20 PM Subject: Re: [GENERAL] PostgreSQL 7.1 Linux Installation On Thu, Feb 22, 2001 at 04:07:06PM -0300, Paulo Parola

[GENERAL] Location of 7.1 version for download

2001-02-22 Thread Paulo Parola
Where can Idownload PostgreSQL v7.1? Please forward me to the URL where I can download it. Is there already binaries or do I have to compile it? TIA, Paulo

[GENERAL] unions on views (workaround?)

2001-02-20 Thread Paulo Parola
a union among two views with SQL (I don't want to put this inteligence into the application). TIA, Paulo Parola [EMAIL PROTECTED]

[GENERAL] Case insensitive searches

1999-05-06 Thread Paulo Parola
Hi, When using mSQL I can perform case insensitive queries by using statements like below: select some_field from table where another_field clike '%substring_entered_by_user%' How should I do that with PostgreSQL? (I understand 'clike' is not a standard SQL feature and there is no