[PHP-DB] PostgreSQL Conference East: 2011 CFP

Following on the smashing success of PostgreSQL Conference West, PostgreSQL Conference West, The PostgreSQL Conference for Developers, End Users and Decision Makers, is being held at the Hotel Pennsylvania, in New York City from March 22nd through 25th 2011. Please join us in continuing to make thi

Re: [PHP-DB] PostgreSQL query many escape characters?

On May 1, 2009, at 3:59 PM, Carol Walter wrote: It would be much easier to read and write like this: $query = 'INSERT INTO "tblPeople"("fName","mName","lName", ivlweb, cnsweb)' . " VALUES ($new_f_name_new, $new_m_name_new, $new_l_name_new, $new_ivl_web_peop, $new_cns_web_peop);"; First

Re: [PHP-DB] PostgreSQL query many escape characters?

Okay, Here are the queries I've written. I gave up on trying to make pg_query_params() work but this is what I have using pg_query(). I have been printing the query. In fact, I can take the query as constructed, paste it into psql and it runs just fine. I would be grateful for any help

Re: [PHP-DB] PostgreSQL query many escape characters?

Hi, you should post the INSERT query too. I'd recommend you to print the query before running it. Just put echo $query; before/after pg_query(). You'll see what are you sending to the database. This may help you find the problem. Also using ` instead of " in query may help you to make it e

[PHP-DB] PostgreSQL query many escape characters?

Hello, I am very new to this process, so please forgive me if this is a silly question. I have a number of PostgreSQL tables that use the naming convention that capitalizes the first character of each word, therefor the data names require quotes. When I put together my queries using par

[PHP-DB] PostgreSQL Conference, U.S. East 09 Call for Papers

PostgreSQL Conference, U.S., East 09 will be held in Philadelphia at historic Drexel University from April 3rd through 5th. The call for papers is now out at: http://www.postgresqlconference.org/2009/east/ . As always we let our submissions define our actual tracks. If you have something you want

[PHP-DB] PostgreSQL pg_query_params, PHP locales, and double data types

Hi all, I'm trying to get a PHP bug in the PostgreSQL pg_query_params function reopened; it's been marked bogus (incorrectly IMO). There are lots of details at . If this is in fact bogus, I'd appreciate a little bit of feedback. Many thanks! Alec Smecher

Re: [PHP-DB] postgresql connection management

Chris wrote: jim white wrote: I am running several web sites on one server, each of which connects to a different Postgresql database. I use some include files to load functions and classes. If I put pg_connect at the start of the include file, then sometimes I do not connect to the correct da

Re: [PHP-DB] postgresql connection management

jim white wrote: I am running several web sites on one server, each of which connects to a different Postgresql database. I use some include files to load functions and classes. If I put pg_connect at the start of the include file, then sometimes I do not connect to the correct database from f

[PHP-DB] postgresql connection management

I am running several web sites on one server, each of which connects to a different Postgresql database. I use some include files to load functions and classes. If I put pg_connect at the start of the include file, then sometimes I do not connect to the correct database from functions in a clas

[PHP-DB] PostgreSQL Conference East: Call for Papers

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 PostgreSQL Conference East is being held on the weekend of March 29th and 30th, 2008 in College Park, Maryland. The conference will have a series of talks, mini-tutorials and tutorials and we are now accepting submissions! If you are a third pary vend

[PHP-DB] PostgreSQL pg_connection_status() bug?

I found some quite odd today and I am wondering if anyone else has encountered this (or can reproduce it) - or maybe I am just going crazy. The function pg_connection_status() should return PGSQL_CONNECTION_BAD or null if the PostgreSQL service/database has stopped/restarted/ is not responding

Re: [PHP-DB] postgresql, pg_pconnect issues, how to close connection properly

2006/9/8, Julian Tree <[EMAIL PROTECTED]>: I have a pretty complex data base that runs a lot of aggreated function (sum, count in addtion to joins) constantly. If I turn off pg_pconnect, the connection takes too long, if I turn on the pg_pconnect, the connection eventually max out. My current

[PHP-DB] postgresql, pg_pconnect issues, how to close connection properly

I have a pretty complex data base that runs a lot of aggreated function (sum, count in addtion to joins) constantly. If I turn off pg_pconnect, the connection takes too long, if I turn on the pg_pconnect, the connection eventually max out. My current solution is to have cron job to restart apac

[PHP-DB] PostgreSQL function call model for PHP

A short article on using a class to call PostgreSQL functions: http://pgedit.com/resource/php/pgfuncall Comments and suggestions welcome! John DeSoi, Ph.D. http://pgedit.com/ Power Tools for PostgreSQL -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.ne

Re: [PHP-DB] PostgreSQL functions missing

Hi Chris, I'm not sure if PG was updated at the same time. I do know that a separate server has no problem connecting to the database and it's running PHP 4.3. In any case, I think I've given the support guys enough info to go on. I figure if they broke it, they can fix it :) Thanks, Tony On 4

Re: [PHP-DB] PostgreSQL functions missing

On 4/27/06, Tony Grimes <[EMAIL PROTECTED]> wrote: > Hi, > > My sys admin installed an update to H-Sphere (control panel software) that > broke PEAR::DB and phpBB last week. After much trial and error, I finally > tracked it down to missing pg_affected_rows() and pg_cmdtuples() functions > (for PEA

[PHP-DB] PostgreSQL functions missing

Hi, My sys admin installed an update to H-Sphere (control panel software) that broke PEAR::DB and phpBB last week. After much trial and error, I finally tracked it down to missing pg_affected_rows() and pg_cmdtuples() functions (for PEAR and phpBB respectively) in PHP. I'm assuming that the H-Sphe

Re: [PHP-DB] PostgreSQL 7.2 - 8.0 replication issue

Hi, I write an litle procedure about migration from postgres 7x to 8x. this is the link: http://fastonion.blogspot.com/2005/04/gentoo-migrando-postgres-7x-8.html In Resume you must be do: On current DB Server: su - postgres pg_dumpall > /tmp/db.out On remote DB Server: copy db.out to new loc

Re: [PHP-DB] PostgreSQL 7.2 - 8.0 replication issue

El Lun 27 Jun 2005 15:31, Mark Galbreath escribió: > I have to upgrade a web app from PHP 4.3.11 with PostgreSQL 7.2 to PHP 5.0.4 with PostgreSQL 8.0.3. > > Currently I have PHP4 (as Apache 2.54 mod on port 80) and PHP5 (default CGI mode on port 8181) running concurrently on my DEV box. I insta

Re: [PHP-DB] PostgreSQL 7.2 - 8.0 replication issue

El Lun 27 Jun 2005 17:48, Mark Galbreath escribió: > The solution was to make sure that ftp mode is in ASCII (type I) and then execute the following, assuming a dummy database, "test," has been created as part of the installation, and the database dump resides at /usr/local/pgsql/temp: The best

RE: [PHP-DB] PostgreSQL 7.2 - 8.0 replication issue

The solution was to make sure that ftp mode is in ASCII (type I) and then execute the following, assuming a dummy database, "test," has been created as part of the installation, and the database dump resides at /usr/local/pgsql/temp: On 7.2 server: $ /usr/local/pgsql/bin/pg_dumpall --format=ASC

Re: [PHP-DB] PostgreSQL 7.2 - 8.0 replication issue

Le 27 juin 05, à 21:23, Mark Galbreath a écrit : Thanks for your reply, Des; unfortunately, your suggestion had no affect. I realize this is technically a PostgreSQL issue, but rationalized my request help here because (1) this is the PHP-DB list and PHP is used with MySQL and PostgreSQL more

RE: [PHP-DB] PostgreSQL 7.2 - 8.0 replication issue

Thanks for your reply, Des; unfortunately, your suggestion had no affect. I realize this is technically a PostgreSQL issue, but rationalized my request help here because (1) this is the PHP-DB list and PHP is used with MySQL and PostgreSQL more than any other databases, and (2) I assumed that s

Re: [PHP-DB] PostgreSQL 7.2 - 8.0 replication issue

Le 27 juin 05, à 20:31, Mark Galbreath a écrit : I have to upgrade a web app from PHP 4.3.11 with PostgreSQL 7.2 to PHP 5.0.4 with PostgreSQL 8.0.3. Currently I have PHP4 (as Apache 2.54 mod on port 80) and PHP5 (default CGI mode on port 8181) running concurrently on my DEV box. I installed

[PHP-DB] PostgreSQL 7.2 - 8.0 replication issue

I have to upgrade a web app from PHP 4.3.11 with PostgreSQL 7.2 to PHP 5.0.4 with PostgreSQL 8.0.3. Currently I have PHP4 (as Apache 2.54 mod on port 80) and PHP5 (default CGI mode on port 8181) running concurrently on my DEV box. I installed PostgreSQL 8.0.3 on the DEV box as well. On the Po

[PHP-DB] PostgreSQL with php error

Hello All, I’m trying to get php to connect to my PostgreSQL database. The code that I’m using is below. Login Warning: pg_connect(): Unable to connect to PostgreSQL server: FATAL: IDENT authentication failed for user "auth" in /var/www/html/thomas/cis166ae/database/se

[PHP-DB] PostgreSQL error with PHP

Hello All, I’m trying to get php to connect to my PostgreSQL database. The code that I’m using is below. Login Warning: pg_connect(): Unable to connect to PostgreSQL server: FATAL: IDENT authentication failed for user "auth" in /var/www/html/thomas/cis166ae/database/se

[PHP-DB] PostgreSQL error with PHP

Hello All, I’m trying to get php to connect to my PostgreSQL database. The code that I’m using is below. Login Warning: pg_connect(): Unable to connect to PostgreSQL server: FATAL: IDENT authentication failed for user "auth" in /var/www/html/thomas/cis166ae/database/se

[PHP-DB] PostgreSQL error with php

Hello All, I’m trying to get php to connect to my PostgreSQL database. The code that I’m using is below. Login Warning: pg_connect(): Unable to connect to PostgreSQL server: FATAL: IDENT authentication failed for user "auth" in /var/www/html/thomas/cis166ae/database/se

Re: [PHP-DB] postgresql and php

On Sat, 2005-04-23 at 20:31 -0500, Tate wrote: > I have php and postgresql installed on my laptop with linux fedora core > 3. Everything is working fine, but I have created a survey and want the > entries automatically inserted into the database. > > I know what my SQL should be, but I'm not su

[PHP-DB] postgresql and php

I have php and postgresql installed on my laptop with linux fedora core 3. Everything is working fine, but I have created a survey and want the entries automatically inserted into the database. I know what my SQL should be, but I'm not sure if my other coding is correct. In my form, I have ra

Re: [PHP-DB] Postgresql Performance

On Thu, 19 Aug 2004 18:12:16 -0500, Norma Ramirez <[EMAIL PROTECTED]> wrote: > Hi all, I have a problem with a small software in Postresql, through the > time the database become slower and slower so, quick solution: pg_dump, > dropdb, createdb and pg_dump again but this software is becoming import

[PHP-DB] Postgresql Performance

Hi all, I have a problem with a small software in Postresql, through the time the database become slower and slower so, quick solution: pg_dump, dropdb, createdb and pg_dump again but this software is becoming important and such procedure is not a very reliable way to improve the performance, I hav

Re: [PHP-DB] postgresql field size information

Hi Try select attname, format_type(atttypid, atttypmod), col_description(attrelid, attnum) from pg_attribute, pg_class c where c.oid = attrelid and attnum > 0 and c.relname = 'tablename' ; Regards Conni -- Datenbanklösungen + PostgreSQL + Webdesign http://www.cornelia-boenigk.de | http://www.pg

[PHP-DB] postgresql field size information

I need to get the size of the fields defined in a postgresql table for use in my PHP script. For instance: $fieldname = pg_field_name($stat,$i); $size = pg_field_size($stat,$i); $type = pg_field_type($stat,$i); I tried using pg_field_size but for char type fields it returns a -1 indicating the f

Re: [PHP-DB] PostgreSQL lib and character case

El Wednesday 28 April 2004 03:21, Tumurbaatar S. escribió: > I use pg_fetch_array() to get a record content. But it seems that > to access elements of the returned associative array, I should > use lowercase field names. Is there any way to use case-insensitive > field names? No. PHP is case-sens

Re: [PHP-DB] PostgreSQL lib and character case

Tumurbaatar S. wrote: I use pg_fetch_array() to get a record content. But it seems that to access elements of the returned associative array, I should use lowercase field names. Is there any way to use case-insensitive field names? Assuming you want all lower case, convert the form field entry usi

[PHP-DB] PostgreSQL lib and character case

I use pg_fetch_array() to get a record content. But it seems that to access elements of the returned associative array, I should use lowercase field names. Is there any way to use case-insensitive field names? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.p

[PHP-DB] PostgreSQL + Cygwin

Alguien ha hecho funcionar PostgreSQL con Cygwin, que error puede ser que me diga que gcc no puede generar ejecutables. Gracias desde ya, Saludos, Gabriel.

[PHP-DB] postgresql

Hi, I know this isn't PHP related but I have a quick question about postgresql. I come from a mysql enviroment so I'm a little clueless, even after reading the postgresql docs. I am moving a postgresql database from one server to another. As the user that owns the database, lculber, I ran p

RE: [PHP-DB] PostgreSQL on Windows

I think yes. For more information see http://techdocs.postgresql.org/guides/InstallingOnWindows Mike U. Petrov -Original Message- From: Rosen [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 6:50 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] PostgreSQL on Windows Hi, Can I

[PHP-DB] PostgreSQL on Windows

Hi, Can I start PostgreSQL server and client on Windows machine ? Thanks in advance! Rosen -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] postgresql and unicode

Hi, I would like to connect to a postgres server which is configured in unicode with php. In java, when I do the connexion, I specify the charset at the connexion. Apparently I have no option in pg_connect() function to specify this. How can I do this ? By the pg_set_client_encoding() function ?

Re: [PHP-DB] PostgreSQL

On Monday 24 November 2003 10:58 am, David Kendal wrote: > Hello! I'm new to to Postgre so excuse me, but is Postgre the same as > MySQL? Yes and No. Both are databases. Both can be interfaced to php. But Under the hoods of both, are very different. For more information, http://www.mysql.com

[PHP-DB] PostgreSQL

Hello! I'm new to to Postgre so excuse me, but is Postgre the same as MySQL? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] PostgreSQL, Triggers

Thank you Martin!!! you've just saved my life! ; ) Regards Ling. "Martin Marques" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] El Dom 19 Oct 2003 13:54, Ling escribió: > Hello there. > Can anybody help me with Postgresql triggers? > what I need is a trigger which inrements val

Re: [PHP-DB] PostgreSQL, Triggers

El Dom 19 Oct 2003 13:54, Ling escribió: > Hello there. > Can anybody help me with Postgresql triggers? > what I need is a trigger which inrements value in field "total_rows.rows" > if I insert new row in table "zzz"... > > CAREATE TABLE zzz ( > ... > ... > ); > CREATE TABLE total_rows ( >

[PHP-DB] PostgreSQL, Triggers

Hello there. Can anybody help me with Postgresql triggers? what I need is a trigger which inrements value in field "total_rows.rows" if I insert new row in table "zzz"... CAREATE TABLE zzz ( ... ... ); CREATE TABLE total_rows ( table_name VARCHAR(32), total_rows BIGINT, CONSTRA

[PHP-DB] PostgreSQL connection

Hi all, i have a question, i have a php file with all my class to connect into a postgresql db and i'm using the pg_connect in this form: pg_connect("192.168.1.100","","","",$dbase); but when i have 8 or 10 users inserting data the db response is very slow, is problem in the pg_connect?, all ppl

[PHP-DB] postgresql primarykeys foreignkeys tablenames screenfieldlength

Any suggestions or improvements to the following code would be much appreciated. Please send me an email: function kgtables () { if ($this->connection) { $tablelist = ""; $sql = "SELEC

RE: [PHP-DB] postgresql vs mysql

e PHP might take you tomorrow. -Original Message- From: John W. Holmes [mailto:[EMAIL PROTECTED]] Sent: Saturday, December 28, 2002 2:48 AM To: 'Yasuo Ohgaki'; [EMAIL PROTECTED] Subject: RE: [PHP-DB] postgresql vs mysql > This benchmark do not help much in real life, if

Re: [PHP-DB] postgresql vs mysql

John W. Holmes wrote: This benchmark do not help much in real life, if one care database performance. Did you even read the article? They used a real-world bookstore application called Nile written in JSP and tested it with 50 to 1,000 concurrent users. Real life differs from systems to syste

RE: [PHP-DB] postgresql vs mysql

> This benchmark do not help much in real life, if one care database > performance. Did you even read the article? They used a real-world bookstore application called Nile written in JSP and tested it with 50 to 1,000 concurrent users. > Database performance will vary a lot with configuration/sc

Re: [PHP-DB] postgresql vs mysql

> To: "'Boaz Yahav'" <[EMAIL PROTECTED]>; "'David Bryant'" <[EMAIL PROTECTED]>; "'Ryan Jameson (USA)'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Saturday, December 28, 2002 5:12 AM Subject: RE: [PHP-DB] post

Re: [PHP-DB] postgresql vs mysql

27;Ryan Jameson (USA)'; [EMAIL PROTECTED] Subject: RE: [PHP-DB] postgresql vs mysql I've worked with both extensively. My personal preference is PG. However, here are my findings over the years. The biggest factor in performance is the size of the database, more than anything else. If y

RE: [PHP-DB] postgresql vs mysql

mailto:[EMAIL PROTECTED]] > Sent: Friday, December 27, 2002 3:58 PM > To: David Bryant; Ryan Jameson (USA); [EMAIL PROTECTED] > Subject: RE: [PHP-DB] postgresql vs mysql > > This is why i was amazed to see this : > http://www.mysql.com/eweek/index.html > > -Original Mes

RE: [PHP-DB] postgresql vs mysql

This is why i was amazed to see this : http://www.mysql.com/eweek/index.html -Original Message- From: David Bryant [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 26, 2002 10:43 PM To: 'Ryan Jameson (USA)'; [EMAIL PROTECTED] Subject: RE: [PHP-DB] postgresql vs mysql I

RE: [PHP-DB] postgresql vs mysql

D]] Sent: Thursday, December 26, 2002 1:18 PM To: [EMAIL PROTECTED] Subject: RE: [PHP-DB] postgresql vs mysql There's a substantiated rumor that says postgres is faster for complex queries. <>< Ryan -Original Message- From: Ellen Solomon [mailto:[EMAIL PROTECTED]] Sent: Thur

RE: [PHP-DB] postgresql vs mysql

There's a substantiated rumor that says postgres is faster for complex queries. <>< Ryan -Original Message- From: Ellen Solomon [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 26, 2002 12:58 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] postgresql vs mysql I'm sta

[PHP-DB] postgresql vs mysql

I'm starting a project for which the lead programmer wants to use postgresql.  I'll be working in php.  Any major disadvantages to postgresql over mysql, other than mysql seems to be more widespread? TIA Ellen -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.

[PHP-DB] postgresql and php - my codes running twice?!?!?

Hi, Can anyone help I'm going mad with this... I'm using postgresql with php and writing a small login and sign-up system. Whena user wishes to sign-up Iwant to check there are not any other users with the same username, so I'm doing a select against the db with the requested username before allo

[PHP-DB] PostgreSQL and HTML output

With psql you can get all your output in HTML format. Anyone know of a way to do this in PHP? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] PostgreSQL and HTML output

makes any sense to you please start at the beginning, Try http://www.devshed.com for some excellent tutorials. Good Luck, Maarten Verheijen - Original Message - From: "Edwin Robertson" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, October 18, 2002 7:

Re: [PHP-DB] PostgreSQL and HTML output

On Saturday 19 October 2002 01:02, Edwin Robertson wrote: > With psql you can get all your output in HTML format. Anyone know of a way > to do this in PHP? The usual way is to write some code to do it. If you don't want to write your own code search for some ready-made ones, ADOdb springs to mi

Re: [PHP-DB] POSTGRESQL & PHP

t; <[EMAIL PROTECTED]> To: "Tomator" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, September 09, 2002 11:52 AM Subject: Re: [PHP-DB] POSTGRESQL & PHP > 1. run a script containing phpinfo() function and confirm you have support > for pgsql > 2. add code t

Re: [PHP-DB] POSTGRESQL & PHP

"Miles Thompson" wrote: > 1. run a script containing phpinfo() function and confirm you have support > for pgsql > 2. add code to display the error message generated by either php or pgsql > when you try to connnect > 3. (Maybe this should have been first) I don't know about Windows systems, > but

Re: [PHP-DB] POSTGRESQL & PHP

Gosh.. It could be a bunch of things. Maybe it requires a password, a username, is running on an alternate port, etc... Any more information you can provide to us would be helpful. Maybe echo out the output of pg_last_error()? -Brad > I've installed MySQL and PostgreSQL on my XP. I'd like t

Re: [PHP-DB] POSTGRESQL & PHP

1. run a script containing phpinfo() function and confirm you have support for pgsql 2. add code to display the error message generated by either php or pgsql when you try to connnect 3. (Maybe this should have been first) I don't know about Windows systems, but on *nix, PostgreSQL has to be st

[PHP-DB] POSTGRESQL & PHP

I've installed MySQL and PostgreSQL on my XP. I'd like to make an PHP script working with pgsql base. I created database (typed "createdb name") but when trying execute script with "pg_connect("host=localhost dbname=name"); it fails. Any suggestions? -- PHP Database Mailing List (http://www.p

[PHP-DB] postgresql in windows

Hi, i'm new in this news group, i want to know how can i install postgresql at Windows XP, i found some tutorials, but using CygWin, i can't create the database the scripts says: "CREATE DATABASE ERROR" I found the ODBC driver, install, but can't connect, because he says for i verify if my connec

[PHP-DB] Postgresql Connection

I was using PostgreSQL 7.1.3 before, and I have upgraded PostgreSQL to 7.2.1 in these days. But after I upgraded the PostgreSQL server, I cannot connect it by the PHP scripts. It shows nothing , not even error message telling me what' going wrong? Could anyone tell me how to solve this problem

Re: [PHP-DB] PostgreSQL and Regular Expressions

On Monday 17 December 2001 09:12, Joe Koenig wrote: > I've been digging through the postgres docs and haven't found a way to > use reg ex's in a query. Is there a simple way? Something similar to > MySQL's RLIKE? I'm trying to select all records that start with a number > [0-9]. Thanks, > > Joe Ta

[PHP-DB] PostgreSQL and Regular Expressions

I've been digging through the postgres docs and haven't found a way to use reg ex's in a query. Is there a simple way? Something similar to MySQL's RLIKE? I'm trying to select all records that start with a number [0-9]. Thanks, Joe -- PHP Database Mailing List (http://www.php.net/) To unsubscri

Re: [PHP-DB] PostgreSql query help....

On Monday 19 November 2001 20:27, Vincent Ma wrote: > Hi everybody: > > I would like to ask why the error occur when retrieve current sequence > number. Eg. "select currval('student_id_seq')" is not working, and warning > prompt "student_id_seq.currval is not yet defined in this session". > > H

[PHP-DB] PostgreSql query help....

Hi everybody: I would like to ask why the error occur when retrieve current sequence number. Eg. "select currval('student_id_seq')" is not working, and warning prompt "student_id_seq.currval is not yet defined in this session". However, this is work for the "select nextval()"; do anyone know

[PHP-DB] PostgreSQL connection problem #2

Hi, I could solve part of the problem by creating a user and database called 'www-data'. The new question is how can I connect to an arbitrary database? (This seems to be a configuration problem for me.) Since I have more sites on the same server, I really need more db-s. My previous letter was:

[PHP-DB] PostgreSQL connection problem

Hi, I try to connect to a PostgreSQL database from my php script, and I get the following error: Warning: Unable to connect to PostgreSQL server: FATAL 1: Database "www-data" does not exist in the system catalog. in /home/lao/proj/hajnalcsillag/www/classes/DBConnection.php on line 10 The code i

[PHP-DB] PostgreSQL to MySQL

hi i have a .sql file that was dumped from PostgreSQL and i want to import that into MySQL. I haven't got a clue how i am gonna approach that. Can anyone suggest me a good starting point? maybe a script or something that can perform the action for me ??? ax -- PHP Database Mailing List (http

[PHP-DB] PostgreSQL / PHP Overrun Error

I have just upgraded to the new PostgreSQL 7.1.3 (from 7.0.3) and have been experiencing a pretty serious problem: On one particular page, in what seems to be completely random instances, I get buffer overruns and either 0-rows or a crashed apache child. Turning on PHP's --enable-debug, I rec

[PHP-DB] postgresql groups and users

for my application in php I connect with a postgresql database. In this database I have made users and groups, where 1 user can be the member of many groups (n on m relation) That works, but how do I let php find out if a user is a member of a certain group? I tried to get the relation out of the

[PHP-DB] Postgresql/PHP backend error

I have PHP 4.06, Postgres7.1 and Apache on a Solaris server. Most of the time all works as expected. Occasionally I get an database error: Database error There was a database error when accessing Database zwg: pqReadData() -- backend closed the channel unexpectedly. This probably means the bac

[PHP-DB] PostgreSQL or SAPDB

I'm starting a project and I have this doubt: Postgres or SAPDB? I have some experience in Oracle, but I need a free DB. Any idea? Alex -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the l

[PHP-DB] PostgreSQL connections within classes & collisions.

I recently did a re-install of PostgreSQL and php4 on Debian, which has broken some development code here. None of the actual code has changed in days, which I can verify against the CVS tree, so I know it's one of two things: a) botched server config b) the code wasn't as robust as it should

[PHP-DB] PostgreSQL errors on persistent connections in PHP 4.0.6

Hi - I have discovered an issue in PHP 4.0.6 and PostgreSQL (I'm running 7.1.2) where PHP will not return/show the entire error messages involving PostgreSQL when using persistent connections. A simple example would be: [PHP 4.0.5] Unable to connect to PostgreSQL server: Password authentication

Re: [PHP-DB] PostgreSQL versus MySQL

Check out: http://openacs.org/philosophy/why-not-mysql.html and: http://www.phpbuilder.com/columns/tim20001112.php3 On Fri, 6 Apr 2001, Matt Braynard wrote: > Can someone outline the differences between the two? I am partial to MySQL > from experience but want to get a good view of why one i

[PHP-DB] PostgreSQL versus MySQL

Can someone outline the differences between the two? I am partial to MySQL from experience but want to get a good view of why one is better than the other. Also, I've heard that you will lose data with MySQL if a system failure should occur. Thanks. Matt -- PHP Database Mailing List (http://

[PHP-DB] PostgreSQL and PHP - some Great Bridge news

All, I'm pleased to announce two initiatives at Great Bridge aimed at improving the integration of PostgreSQL and PHP, and some exciting stuff that we're doing as a company to get behind PHP more fully. First, Great Bridge is partnering with Zend Technologies to include a fully-integrated ins

FW: [PHP-DB] Postgresql PHP

You will need the source file of PHP to build the pgsql function in the module. Ronnie > -Original Message- > From: Shaun Mitchell [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, January 10, 2001 2:18 AM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] Postgresql PHP &g