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

2008-11-16 Thread Chris
Alec Smecher wrote: Hi all, If you'll excuse my persistence, I'm still wondering about this issue. Is there a better place to go for feedback, or someone I can contact directly? You'll have to join the -internals list if you want to discuss. The -general, -db (and other) lists are only

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

2008-11-14 Thread Alec Smecher
Hi all, If you'll excuse my persistence, I'm still wondering about this issue. Is there a better place to go for feedback, or someone I can contact directly? Thanks, Alec Smecher Public Knowledge Project Team Alec Smecher wrote: Hi all, I'm trying to get a PHP bug in the PostgreSQL

Re: [PHP-DB] Re: PostgreSQL error with PHP

2005-06-27 Thread Martín Marqués
El Dom 26 Jun 2005 22:48, Thomas Bonham escribió: Thanks for the help. The code now looks like this. CODE: htmlheadtitleLogin/title /head body ?php $conn = pg_connect(user=auth dbname=auth password=redhat) or die (Could not connect) ; echo

[PHP-DB] Re: PostgreSQL error with PHP

2005-06-26 Thread Thomas Bonham
I modafide the code some more and now with the following code I get this error. CODE: htmlheadtitleLogin/title /head body ?php pg_connect(name=auth); (user=auth); ? /body /html Parse error: parse error, unexpected '=' in

RE: [PHP-DB] Re: PostgreSQL error with PHP

2005-06-26 Thread Robbert van Andel
- From: Thomas Bonham [mailto:[EMAIL PROTECTED] Sent: Sunday, June 26, 2005 5:43 PM To: php-db@lists.php.net Subject: [PHP-DB] Re: PostgreSQL error with PHP I modafide the code some more and now with the following code I get this error. CODE: htmlheadtitleLogin/title /head body

Re: [PHP-DB] Re: PostgreSQL error with PHP

2005-06-26 Thread Thomas Bonham
- From: Thomas Bonham [mailto:[EMAIL PROTECTED] Sent: Sunday, June 26, 2005 5:43 PM To: php-db@lists.php.net Subject: [PHP-DB] Re: PostgreSQL error with PHP I modafide the code some more and now with the following code I get this error. CODE: htmlheadtitleLogin/title /head body

RE: [PHP-DB] Re: PostgreSQL error with PHP

2005-06-26 Thread Robbert van Andel
You might need to include the hostname and port. -Original Message- From: Thomas Bonham [mailto:[EMAIL PROTECTED] Sent: Sunday, June 26, 2005 6:48 PM To: php-db@lists.php.net Subject: Re: [PHP-DB] Re: PostgreSQL error with PHP Thanks for the help. The code now looks like this. CODE

Re: [PHP-DB] Re: PostgreSQL error with PHP

2005-06-26 Thread Thomas Bonham
[mailto:[EMAIL PROTECTED] Sent: Sunday, June 26, 2005 6:48 PM To: php-db@lists.php.net Subject: Re: [PHP-DB] Re: PostgreSQL error with PHP Thanks for the help. The code now looks like this. CODE: htmlheadtitleLogin/title /head body ?php $conn = pg_connect(user

Re: [PHP-DB] Re: PostgreSQL error with PHP

2005-06-26 Thread Thomas Bonham
Robbert van Andel wrote: You might need to include the hostname and port. -Original Message- From: Thomas Bonham [mailto:[EMAIL PROTECTED] Sent: Sunday, June 26, 2005 6:48 PM To: php-db@lists.php.net Subject: Re: [PHP-DB] Re: PostgreSQL error with PHP Thanks for the help. The code now

RE: [PHP-DB] Re: PostgreSQL error with PHP

2005-06-26 Thread Robbert van Andel
this helps, Robbert -Original Message- From: Thomas Bonham [mailto:[EMAIL PROTECTED] Sent: Sunday, June 26, 2005 5:43 PM To: php-db@lists.php.net Subject: [PHP-DB] Re: PostgreSQL error with PHP I modafide the code some more and now with the following code I get this error. CODE

Re: [PHP-DB] Re: PostgreSQL error with PHP

2005-06-26 Thread Thomas Bonham
? -Original Message- From: Thomas Bonham [mailto:[EMAIL PROTECTED] Sent: Sunday, June 26, 2005 8:03 PM To: php-db@lists.php.net Subject: Re: [PHP-DB] Re: PostgreSQL error with PHP I rewrote the code. This is the code and errors. This is starting to get old, I have been working

[PHP-DB] Re: PostgreSQL

2004-09-29 Thread Stefan Reimers
M Saleh Eg wrote: Any Idea about where I'd get an installer version of PostgreSQL for windows? Wow, I recently had a project working on PostgreSQL. For local development we installed cygwin on WIN and tried to keep that working. How long does that installer exist? Nevertheless, thx for the link,

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

2004-04-28 Thread Hans Lellelid
Hi - 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? This is how Postgres works: it always returns arrays

[PHP-DB] Re: postgresql

2004-04-14 Thread Jason S Motes
if i remember correctly you have to do this su su postgres createuser your-user-id Adam Williams wrote: 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

[PHP-DB] Re: PostgreSQL connection

2003-08-15 Thread Stephane
take a look at your postgresql.conf config optimize request and test your requests Joe Nilson Zegarra Galvez [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] 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

[PHP-DB] Re: postgresql vs mysql

2003-01-02 Thread Diggy Bell
Ellen, From a strict database perspective, PostgreSQL has a bit more power than MySQL. In particular, support for transactions (and database integrity) is very complete with PostgreSQL. With that being the case, the disadvantage would be with MySQL, not PostgreSQL. In addition, Tim Purdue

[PHP-DB] Re: PostgreSQL and HTML output

2002-10-18 Thread Yasuo Ohgaki
Edwin Robertson wrote: (B With psql you can get all your output in HTML format. Anyone know of a way (B to do this in PHP? (B (BIt's psql feature and there is no automatic HTML format (Bin PHP's pgsql module. (B (BIf really would like, you can use passthru() and psql. (B (B?php

[PHP-DB] Re: PostgreSQL and HTML output

2002-10-18 Thread Yasuo Ohgaki
If you need to dump query result for debugging purpose, etc. (BTry something like, (B (B?php (B (B$db = pg_connect(); (B$result = pg_query($db, 'SELECT * FROM some_table'); (B (Becho "pre\n"; (Bvar_dump(pg_fetch_all($result)); (Becho "/pre\n"; (B (B? (B (BYou need PHP 4.3.0-dev or

Re: [PHP-DB] Re: PostgreSQL versus MySQL

2001-11-23 Thread Paul DuBois
Has this thread got anything at all to do with PHP? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] Re: postgresql groups and users

2001-09-08 Thread Michiel_Lange
I finally had the time to check it out, your solution should be really close... to clarify: - one user can be the member of many groups - one group can have many members I thought that was n on m relation, but oh well :) Anyways: there's no relation groups, but instead a pg_group and pg_user

[PHP-DB] Re: postgresql groups and users

2001-09-05 Thread Steve Brett
Michiel Lange [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... 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)

[PHP-DB] Re: PostgreSQL connections within classes collisions.

2001-08-26 Thread Yasuo Ohgaki
I have very smilar code and they are working for me. I'm using - PHP4.0.6 and PHP4.0.7RC1 - PostgreSQL 7.1.3 They are built from source. Your PHP might be linked against older libpq(?) than your PostgreSQL? -- Yasuo Ohgaki Justin Buist wrote: I recently did a re-install of PostgreSQL and

[PHP-DB] Re: PostgreSQL connections within classes collisions.

2001-08-26 Thread Yasuo Ohgaki
I have very smilar code and they are working for me. I'm using - PHP4.0.6 and PHP4.0.7RC1 - PostgreSQL 7.1.3 They are built from source. Your PHP might be linked against older libpq(?) than your PostgreSQL? -- Yasuo Ohgaki Justin Buist wrote: I recently did a re-install of PostgreSQL and

[PHP-DB] Re: Postgresql/PHP backend error

2001-08-21 Thread Steve Brett
i'd trt trawling the newsgroups - started to do it for you but got zillions of results back. try postgresql.org for starters ... Steve Nigel Gilbert [EMAIL PROTECTED] wrote in message news:p05100314b7a6fc817874@[192.168.123.1]... I have PHP 4.06, Postgres7.1 and Apache on a Solaris server.

[PHP-DB] Re: Postgresql/PHP backend error

2001-08-21 Thread Yasuo Ohgaki
Nigel Gilbert [EMAIL PROTECTED] wrote in message news:p05100314b7a6fc817874@[192.168.123.1]... 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: I think you are better to post your problem in PostgreSQL

Re: [PHP-DB] Re: PostgreSQL versus MySQL

2001-04-11 Thread Bob Hall
On Mon, 9 Apr 2001, Bob Hall wrote: MySQL is providing an SQL frontend to a bunch of tables and indices, that is it ... it is up to the programmer to handle the "managing of data" part where it revolves around being relational ... I've developed database apps in which the

Re: [PHP-DB] Re: PostgreSQL versus MySQL

2001-04-10 Thread Bob Hall
Doug, There's something wrong here. This is the internet, we're disagreeing, but we're not flaming each other. If we keep this up, they'll revoke all our software licenses because of our noncompliant behavior. Hi Bob! That would make a very interesting study. Attempting to come up with a

RE: [PHP-DB] Re: PostgreSQL versus MySQL

2001-04-10 Thread Steve Brett
I'm rooting for PostgreSQL to become the open source app that ate Oracle. MySQL will never be capable of that, but I don't think it needs to be. There will always be a niche for small, quirky apps that have just enough functionality to get the job done and keep the learning curve

Re: [PHP-DB] Re: PostgreSQL versus MySQL

2001-04-09 Thread Bob Hall
On Sun, 8 Apr 2001, Bob Hall wrote: Doug, You've posted your usual good sense, combined with one statement I strongly disagree with. One of these products is a relational database management system. The other is a quasi-SQL-like-front-end-to-systems-of-indexed-files that

Re: [PHP-DB] Re: PostgreSQL versus MySQL

2001-04-09 Thread The Hermit Hacker
On Mon, 9 Apr 2001, Bob Hall wrote: MySQL is providing an SQL frontend to a bunch of tables and indices, that is it ... it is up to the programmer to handle the "managing of data" part where it revolves around being relational ... I've developed database apps in which the data was

Odp: [PHP-DB] Re: PostgreSQL versus MySQL

2001-04-09 Thread Jarek Zgoda
Od: "Bob Hall" [EMAIL PROTECTED] Temat: Re: [PHP-DB] Re: PostgreSQL versus MySQL The implication is that MySQL is not an RDBMS. The only attempt I know of to define an RDBMS was Codd's, and no DBMS has ever met the criteria he published in a paper in the late 80s (19

Re: [PHP-DB] Re: PostgreSQL versus MySQL

2001-04-08 Thread The Hermit Hacker
On Sun, 8 Apr 2001, Bob Hall wrote: Doug, You've posted your usual good sense, combined with one statement I strongly disagree with. One of these products is a relational database management system. The other is a quasi-SQL-like-front-end-to-systems-of-indexed-files that has never

[PHP-DB] Re: PostgreSQL versus MySQL

2001-04-07 Thread Jon Valvatne
On the contrary, MySQL is much better at handling table crashes and data corruption than PostgreSQL is. What you may have heard is that due to lack of transaction support, critical data may be lost "in transit" from your application to the database, in the event of a system crash or a dropped

Re: [PHP-DB] Re: PostgreSQL versus MySQL

2001-04-07 Thread The Hermit Hacker
As for a full comparison between the two, I think the bottom line is that MySQL is slightly more light-weight, but easier to use and faster than PostgreSQL. So if you're looking for a database for a relatively noncritical web application, I'd say go with MySQL, especially since that's what