[PHP] PHP + PostgreSQL: pg_query not returning the expected result for this (edge) case:

2013-02-06 Thread Peter Ford
Here's a tricky one: Versions: I'm using PostgreSQL 9.0.7 and PHP 5.3.8. First, I have a table bob with two columns: bobid (integer) and bobtext (text). The bobid field defaults to a sequence called bob_seq which is just a simple counter (1,2,3 etc.) I can do an INSERT query into bob:

Re: [PHP] postgresql database access failure

2011-05-02 Thread e-letter
The query was: $query = 'SELECT * FROM databasetablename'; So, database access seems to be the problem. Using the superuser account 'postgres', a user 'httpd' was created and all privileges were granted to the target database using the postgresql 'grant' command. However the user 'httpd' is not

Re: [PHP] postgresql database access failure

2011-05-01 Thread e-letter
On 30/04/2011, Daniel Brown danbr...@php.net wrote: Readers? Sounds like you spend too much time writing newsletters (to the wrong address, since php-general-digest-h...@lists.php.net is a self-help command list for digest-form subscriptions). ;-P On Sat, Apr 30, 2011 at 04:41, e-letter

Re: [PHP] postgresql database access failure

2011-05-01 Thread Ashley Sheridan
On Sun, 2011-05-01 at 09:24 +0100, e-letter wrote: I looked at the error file located at '/var/log/httpd/error_log', which identifies an error: ...Apache/2.2.6 (Mandriva Linux/PREFORK-8.2mdv2008.0) PHP/5.2.4 with Suhosin-Patch mod_put/2.0.8 configured -- resuming normal operations...

Re: [PHP] postgresql database access failure

2011-05-01 Thread e-letter
The file was changed: ... $value=pg_fetch_result($query,1,1); echo 'all files' . var_dump($value); ... The resultant web page produces: bool(false) all files The php file was changed again: ... $value=pg_fetch_result($query); echo 'all

Re: [PHP] postgresql database access failure

2011-05-01 Thread David Robley
e-letter wrote: The file was changed: ... $value=pg_fetch_result($query,1,1); echo 'all files' . var_dump($value); ... The resultant web page produces: bool(false) all files The php file was changed again: ... $value=pg_fetch_result($query); echo 'all files'

[PHP] postgresql database access failure

2011-04-30 Thread e-letter
Readers, A postgresql database (local disk installation) is successfully accessed as a normal user: psql -U username databasename However, creating a php file to access the database has not been successful. html body ?php $db = pg_connect('dbname=databasename

Re: [PHP] postgresql database access failure

2011-04-30 Thread Daniel Brown
Readers? Sounds like you spend too much time writing newsletters (to the wrong address, since php-general-digest-h...@lists.php.net is a self-help command list for digest-form subscriptions). ;-P On Sat, Apr 30, 2011 at 04:41, e-letter inp...@gmail.com wrote:        ?php                

Re: [PHP] postgresql database access failure

2011-04-30 Thread Daniel Brown
On Sat, Apr 30, 2011 at 12:23, Daniel Brown danbr...@php.net wrote:        ?php                echo '$_SERVER['HTTP_USER_AGENT']';        ?    First of all, no it doesn't.  Placed inside single quotes, it'll not only try to return it verbatim (i.e. - the variable would be printed to

Re: [PHP] PostgreSQL and select nextval

2007-08-16 Thread Martin Marques
Alain Roger wrote: Hi, I'm getting an error message when i run the following SQL request : $sql = INSERT INTO tmp_importedxls (rec_id, publisher) VALUES (SELECT nextval('tmp_importedxls_rec_id_seq'),'$pb'); Error in SQL query: ERROR: syntax error at or near SELECT LINE 2: VALUES (SELECT

Re: [PHP] PostgreSQL and select nextval

2007-08-16 Thread Martin Marques
Richard Lynch wrote: On Sun, August 12, 2007 2:35 am, Alain Roger wrote: I'm getting an error message when i run the following SQL request : $sql = INSERT INTO tmp_importedxls (rec_id, publisher) VALUES (SELECT nextval('tmp_importedxls_rec_id_seq'),'$pb'); Error in SQL query: ERROR: syntax

Re: [PHP] PostgreSQL and select nextval

2007-08-13 Thread Richard Lynch
On Sun, August 12, 2007 2:35 am, Alain Roger wrote: I'm getting an error message when i run the following SQL request : $sql = INSERT INTO tmp_importedxls (rec_id, publisher) VALUES (SELECT nextval('tmp_importedxls_rec_id_seq'),'$pb'); Error in SQL query: ERROR: syntax error at or near SELECT

[PHP] PostgreSQL and select nextval

2007-08-12 Thread Alain Roger
Hi, I'm getting an error message when i run the following SQL request : $sql = INSERT INTO tmp_importedxls (rec_id, publisher) VALUES (SELECT nextval('tmp_importedxls_rec_id_seq'),'$pb'); Error in SQL query: ERROR: syntax error at or near SELECT LINE 2: VALUES (SELECT

Re: [PHP] PostgreSQL and select nextval

2007-08-12 Thread brian
Alain Roger wrote: Hi, I'm getting an error message when i run the following SQL request : $sql = INSERT INTO tmp_importedxls (rec_id, publisher) VALUES (SELECT nextval('tmp_importedxls_rec_id_seq'),'$pb'); Error in SQL query: ERROR: syntax error at or near SELECT LINE 2: VALUES (SELECT

[PHP] postgreSQL and bytea / image

2007-04-30 Thread Alain Roger
Hi, In my PHP page i upload pictures into database. For that i wrote a simple function which control which user is logged and will upload his picture. here is the function : CREATE OR REPLACE FUNCTION sp_a_006(login character varying, photo bytea) RETURNS boolean AS $BODY$ DECLARE

Re: [PHP] postgreSQl and images

2006-11-07 Thread Richard Lynch
On Mon, November 6, 2006 5:17 pm, Børge Holen wrote: aaight... I get yer point there, BUT you see, what do you do when an artists changes it name... forget it, that was a bad choice... Oh no, it's a GREAT choice. First of all, if they really really changed their name, then I create a new

Re: [PHP] postgreSQl and images

2006-11-06 Thread Richard Lynch
On Sat, November 4, 2006 11:26 am, Alain Roger wrote: I create a table with some large object (ref: OID) to store some images. When my PHP will display some data, it will also display the images stored as OID. However, i've read that before i must restore the image by exporting them to

Re: [PHP] postgreSQl and images

2006-11-06 Thread Richard Lynch
On Sat, November 4, 2006 5:38 pm, Børge Holen wrote: either you end up with a had as method of grouping them together, moreover you can have thousands of small files inside one dir with an id name to it, and yes the last one, thousands of directories with one file inside... Speaking as a guy

Re: [PHP] postgreSQl and images

2006-11-06 Thread Børge Holen
aaight... I get yer point there, BUT you see, what do you do when an artists changes it name... forget it, that was a bad choice... anyway... you see, in one of my fields of interests, you got dogs... see, dogs can change name, not just the calling name, but I mean completely change it all.

[PHP] postgreSQl and images

2006-11-04 Thread Alain Roger
Hi, I create a table with some large object (ref: OID) to store some images. When my PHP will display some data, it will also display the images stored as OID. However, i've read that before i must restore the image by exporting them to local (on server) file. isn't it easier in this case, to

Re: [PHP] postgreSQl and images

2006-11-04 Thread Børge Holen
On Saturday 04 November 2006 18:26, Alain Roger wrote: Hi, I create a table with some large object (ref: OID) to store some images. When my PHP will display some data, it will also display the images stored as OID. However, i've read that before i must restore the image by exporting them

[PHP] Postgresql PHP

2005-03-22 Thread Danny Brow
Any recommendations on books for postgresql PHP usage. Thanks, Dan. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Postgresql PHP

2005-03-22 Thread Richard Davey
Hello Danny, Tuesday, March 22, 2005, 6:07:55 PM, you wrote: DB Any recommendations on books for postgresql PHP usage. Just get a good book on Postgres, the PHP side of it can be easily picked-up from the PHP manual itself. Best regards, Richard Davey -- http://www.launchcode.co.uk - PHP

[PHP] PHP/Postgresql problem

2004-01-13 Thread Ken Harris
I am trying to get PHP to work with an instance of postgresql on a server. There is already one, 'proprietary' postgresql running with its own user, own group and own (not default) port. The postgresql I am installing will be used for several database projects. following are my config/makes

[PHP] PHP/Postgresql problem

2004-01-13 Thread Ken Harris
I am trying to get PHP to work with an instance of postgresql on a server. There is already one, 'proprietary' postgresql running with its own user, own group and own (not default) port. The postgresql I am installing will be used for several database projects. following are my config/makes

[PHP] Contract Position at New York Post for PHP-PostgreSQL Developer

2003-12-01 Thread Heather Johnson
The New York Post is seeking a part-time consultant to participate in the planning and development of a web-based registration project. The position will last for approximately 3 months or until the candidate's role in the project is completed. The candidate will work with other programmers on

[PHP] PHP POSTGRESQL AND WML

2003-07-21 Thread haydo hassan
Hi. I am trying to send two variables from login.wml to auth.php. But auth.php gets empty variables. here is the code for login.wml: ?xml version=1.0? !DOCTYPE wml PUBLIC -//WAPFORUM//DTD WML 1.1//EN http://www.wapforum.org/DTD/wml_1.1.xml; wml card newcontext=true title=Fuhrpark Login

[PHP] PostgreSQL Cursor ROWCOUNT

2003-01-14 Thread typea
Given: PHP 4.x PostgreSQL 7.3.x In 'psql' monitor: declare foo cursor for select * from humongous_table; move forward all in foo; The second query will print out a number which informs one of the actual number of rows that are in the cursor's query's result set, if one were to actually fetch

[PHP] PostgreSQL/PHP: transactions: how-to abstract out?

2003-01-09 Thread Jean-Christian Imbeault
Hi. I thought I had abstracted out the SQL querying part of my code out, just to find out today that it doesn't work when it comes to transactions. I had come up with this code: function sql_query($sql) { $conn = pg_connect(dbname=JC user=postgres); $res = pg_exec($conn, $sql); if

Re: [PHP] PostgreSQL/PHP: transactions: how-to abstract out?

2003-01-09 Thread Jason Sheets
Not exactly sure why your transactions aren't working but if your script already has an open connection to the database and you issue another call to pg_connect with the same connect string PHP will return the existing connection and should not create another connection to the database, that is

Re: [PHP] PostgreSQL/PHP: transactions: how-to abstract out?

2003-01-09 Thread Jean-Christian Imbeault
Jason Sheets wrote: Manual Excerpt: If a second call is made to pg_connect() with the same connection_string, no new connection will be established, but instead, the connection resource of the already opened connection will be returned. You can have multiple connections to the same database if

Re: [PHP] PostgreSQL/PHP: transactions: how-to abstract out?

2003-01-09 Thread Ray Hunter
Jean-Christian If you are only doing an insert then you do not need the transactions BEGIN and COMMIT because that is already done for you on a single insert. PGSQL is transaction based so if it does not go then it will not work. -Ray On Thu, 2003-01-09 at 22:23, Jean-Christian Imbeault wrote:

Re: [PHP] PostgreSQL/PHP: transactions: how-to abstract out?

2003-01-09 Thread Ray Hunter
You could try leaving off the ;... Try $sql = BEGIN Try $sql = COMMIT That should work... On Thu, 2003-01-09 at 22:23, Jean-Christian Imbeault wrote: Jason Sheets wrote: Manual Excerpt: If a second call is made to pg_connect() with the same connection_string, no new connection will

Re: [PHP] PHP PostgreSQL

2003-01-01 Thread Vincent Oostindie
Michael Sims wrote: o Changing database structure is harder. With PG, I usually found it easier to dump, edit, then reload the database to make changes I did in MySQL with ALTER TABLE. True, changing schema is a major PITA with Postgres. My only real complaint about it, in fact...

[PHP] PHP PostgreSQL

2002-12-30 Thread Boget, Chris
I'm switching from a MySQL environment to PGSQL and I'm going through and trying to learn the differences between the two. I've come across some issues that I can't seem to find the answers to in the docs or on the web. I'm hoping someone can help me out. * MySQL has a function to reset the

Re: [PHP] PHP PostgreSQL

2002-12-30 Thread Jason Wong
On Monday 30 December 2002 18:13, Boget, Chris wrote: I'm switching from a MySQL environment to PGSQL and I'm going through and trying to learn the differences between the two. I've come across some issues that I can't seem to find the answers to in the docs or on the web. I'm hoping someone

RE: [PHP] PHP PostgreSQL

2002-12-30 Thread Boget, Chris
pg_result_seek() should perform a similar function. In most cases you wouldn't need to use that because if you're going to be using the results more than once you could store them in an array. Sometimes yes, sometimes no. But a valid point nonetheless. * For PGSQL, you can get the

Re: [PHP] PHP PostgreSQL

2002-12-30 Thread Jason Wong
On Monday 30 December 2002 18:41, Boget, Chris wrote: * For PGSQL, you can get the database name, the field name even the *host name* but you can't get the table name from a particular query? Not sure what you're getting at here. Surely for any particular query, _you_ would know

Re: [PHP] PHP PostgreSQL

2002-12-30 Thread Rick Widmer
At 06:20 PM 12/30/02 +0800, Jason Wong wrote: On Monday 30 December 2002 18:13, Boget, Chris wrote: I'm switching from a MySQL environment to PGSQL and I'm going through and trying to learn the differences between the two. The things that bothered me the most: o Pg doesn't have

RE: [PHP] PHP PostgreSQL

2002-12-30 Thread Rick Widmer
At 04:41 AM 12/30/02 -0600, Boget, Chris wrote: You can do this in mysql. I just don't know why you can't do this in pgsql. The basic answer to why the interfaces to the databases differ is because the PHP interfaces reflects the C interface provided by the database authors. Most PHP

Re: [PHP] PHP PostgreSQL

2002-12-30 Thread Jason Wong
On Monday 30 December 2002 19:11, Rick Widmer wrote: At 06:20 PM 12/30/02 +0800, Jason Wong wrote: On Monday 30 December 2002 18:13, Boget, Chris wrote: I'm switching from a MySQL environment to PGSQL and I'm going through and trying to learn the differences between the two. The

RE: [PHP] PHP PostgreSQL

2002-12-30 Thread Boget, Chris
Sorry, you've lost me. In your OP you say you wanted the table name, but now you're talking about the dbname? For dbname, you can use (oddly enough) pg_dbname(). Eeep, I'm ever so sorry. That's what I get for responding at 4:30a when trying to battle insomnia. Yes, I am looking for the

Re: [PHP] PHP PostgreSQL

2002-12-30 Thread Chris Boget
Due to writing this email *way* too early in the morning, I got everything mixed up and didn't say what I meant. The below is what I really meant. Not sure what you're getting at here. Surely for any particular query, _you_ would know what table(s) is/are being used? That's not necessarily

Re: [PHP] PHP PostgreSQL

2002-12-30 Thread Michael Sims
On Mon, 30 Dec 2002 04:11:02 -0700, you wrote: The things that bothered me the most: o Pg doesn't have DATE_FORMAT() to_char() accomplishes the same thing, for example: select to_char(lastlogin, 'FMMM-DD- FMHH:MI AM') as lastloginf from users; , or the types SET and ENUM. I'm not sure

Re: [PHP] PHP PostgreSQL

2002-12-30 Thread Chris Boget
o Pg doesn't have DATE_FORMAT() to_char() accomplishes the same thing, for example: select to_char(lastlogin, 'FMMM-DD- FMHH:MI AM') as lastloginf from users; Unless I missed something, that function doesn't work with unix timestamps. Is there anythin internal to PG that allows you to

Re: [PHP] PHP PostgreSQL

2002-12-30 Thread Michael Sims
On Mon, 30 Dec 2002 07:57:04 -0600, you wrote: o Pg doesn't have DATE_FORMAT() to_char() accomplishes the same thing, for example: select to_char(lastlogin, 'FMMM-DD- FMHH:MI AM') as lastloginf from users; Unless I missed something, that function doesn't work with unix timestamps. Is

Re: [PHP] PHP PostgreSQL

2002-12-30 Thread Jason Wong
On Monday 30 December 2002 21:33, Chris Boget wrote: Due to writing this email *way* too early in the morning, I got everything mixed up and didn't say what I meant. The below is what I really meant. Not sure what you're getting at here. Surely for any particular query, _you_ would know

Re: [PHP] PHP PostgreSQL

2002-12-30 Thread Chris Boget
To convert TO a unix timestamp: To convert FROM a unix timestamp: Excellent. Thank you very much for the info! And there is the major benefit of using Postgres... Why do you think I decided to move to Postgres? :P not to mention sub-selects, views, unions, etc. Indeed. And I'm going

Re: [PHP] PHP PostgreSQL

2002-12-30 Thread Jason Wong
On Monday 30 December 2002 21:57, Chris Boget wrote: o Pg doesn't have DATE_FORMAT() to_char() accomplishes the same thing, for example: select to_char(lastlogin, 'FMMM-DD- FMHH:MI AM') as lastloginf from users; Unless I missed something, that function doesn't work with unix

Re: [PHP] PHP PostgreSQL

2002-12-30 Thread Chris Boget
Either you're confused or I'm confused :) It's me. This just hasn't been a good week for me. :p One time I'll get it right! mysql_tablename() is used in conjunction with mysql_list_tables() to get the names of the tables defined in the specified database. It cannot get the table name for

Re: [PHP] PHP PostgreSQL

2002-12-30 Thread Rick Widmer
At 07:59 AM 12/30/02 -0600, Michael Sims wrote: On Mon, 30 Dec 2002 04:11:02 -0700, you wrote: , or the types SET and ENUM. I'm not sure what SET is, never used it, Color set( 'red', 'green', 'blue' ) can contain only the following values: NULL;'blue'; 'green'; 'green,blue';

[PHP] postgresql - image - php

2002-08-12 Thread Hafiz Malik
anyone know how to store an image to postgresql and load it back using php? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] PostgreSQL

2002-07-26 Thread Hadi
How can i enable PostgreSQL module? I have installed PHP 4 on IIS5, Windows 2000 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] PostgreSQL

2002-07-16 Thread rdkurth
PHP is compiled with PostgreSQL support but I can not connect. I get this error message What does it mean and what do I need to do to fix it Warning: pg_connect() unable to connect to PostgreSQL server: connectDB() -- connect() failed: Connection refused Is the postmaster running (with -i) at

Re: [PHP] PostgreSQL

2002-07-16 Thread Lejanson C. Go
[EMAIL PROTECTED] wrote: PHP is compiled with PostgreSQL support but I can not connect. I get this error message What does it mean and what do I need to do to fix it Warning: pg_connect() unable to connect to PostgreSQL server: connectDB() -- connect() failed: Connection refused Is the

[PHP] PostgreSQL - WHILE loop working too well / WARNING: Unable to jump to row 2 on PostgreSQL...

2002-05-29 Thread Steve G
I do not understand why PHP is trying to pull row 2!! I want to create an array of data and construct a table from a query. The echo of $rows shows 2 rows, so if I'm setting my variable to 0 and incrementing with each loop, it doesn't make sense to me why it tries to pull row 2. It should stop

Re: [PHP] PostgreSQL - WHILE loop working too well / WARNING: Unable to jump to row 2 on PostgreSQL...

2002-05-29 Thread Jason Wong
On Thursday 30 May 2002 11:30, Steve G wrote: Please do not reply to an existing post. Start a new one! I do not understand why PHP is trying to pull row 2!! I want to create an array of data and construct a table from a query. The echo of $rows shows 2 rows, so if I'm setting my variable

[PHP] Win32 PHP + PostgreSQL support

2002-02-07 Thread Todor Stoyanov
Any ideas how to get PHP for win32 with PostgreSql support? Cheers Todor -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] Re: Win32 PHP + PostgreSQL support

2002-02-07 Thread Gary
Doesn't php for windows come with pgsql already? extension=php_pgsql.dll Gary Todor Stoyanov wrote: Any ideas how to get PHP for win32 with PostgreSql support? Cheers Todor -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Re: [PHP-DB] PHP + Postgresql + Linux = Frustration

2002-02-03 Thread James Arthur
Is there an easy way to do this sort of stuff on Linux or is it better to just buy off the shelf products that work? Hi I hate to do the my distro is better than yours thing, but typing apt-get install postgresql postgresql-client apache php4 php4-pgsql at the command line on a Debian

[PHP] Re: [PHP-DB] PHP + Postgresql + Linux = Frustration

2002-01-26 Thread Miles Thompson
that call configure with all the various parameters. I arrived at the choices below after reading the LAMP documents, the Soothingly Seamless Installation of Linux, Apache, MySQL and PHP and the various configuration options for each of MySQL, PHP, PostgreSQL and Apache. Before building from source

Re: [PHP] PostgreSQL query taking a long time

2001-12-22 Thread Papp Gyozo
mailing list, too! btw, what version of pg do you have? - Original Message - From: K Old [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, December 21, 2001 5:51 PM Subject: [PHP] PostgreSQL query taking a long time | Hello all, | | I have a PostgreSQL database

[PHP] PostgreSQL query taking a long time

2001-12-21 Thread K Old
Hello all, I have a PostgreSQL database that is storing The Bible. It has 31,103 records in it and I have a PHP page executing this query: SELECT books.book_name, bible.chapter, bible.verse, bible.versetext FROM asv_bible bible, book_bible books WHERE bible.book = books.id ORDER BY random()

Re: [PHP] PostgreSQL query taking a long time

2001-12-21 Thread Shane Wright
Hi, You dont have the book field in the asv_bible table indexed. Use this to index it CREATE INDEX myindexname ON asv_bible(book); (the primary key fields are ok because PostgreSQL creates a unique index to implement the PRIMARY KEY constraint). Hope that helps :) -- Shane I have a

[PHP] Hmmm? PHP+PostgreSQL

2001-10-24 Thread Alexey Prohorenko
-vars --with-pgsql --with-mysql make make install (I have mySQL, too) Compilation process was great, no errors. Nevertheless, next little PHP script: html head titletesting needed functions of current-gtlg with PHP+PostgreSQL/title /head body bgcolor=white ?php $conn

[PHP] PostgreSQL connection problems

2001-09-27 Thread Alberto
Warning: Unable to connect to PostgreSQL server: No pg_hba.conf entry for host myhost, user myuser, database mydb in /path/to/principal.php on line 27 that's $bdConexion = pg_connect (host=.$bdHost. port=.$bdPuerto. dbname=.$bdBD. user=.$bdLogin. password=.$bdPassword); PHP is already

Re: [PHP] PostgreSQL connection problems

2001-09-27 Thread Marcela
PROTECTED] Sent: Thursday, September 27, 2001 7:51 AM Subject: [PHP] PostgreSQL connection problems Warning: Unable to connect to PostgreSQL server: No pg_hba.conf entry for host myhost, user myuser, database mydb in /path/to/principal.php on line 27 that's $bdConexion = pg_connect (host

[PHP] Postgresql large objects.

2001-08-12 Thread speedboy
Does using pg_loread or any other php functions for postgresql large objects modify the size of the file? I'm seeing a size increase in a few bytes when I receive the file back to my hard drive. The file still seems to run ok, but I'm wondering what is doing this? -- PHP General Mailing List

[PHP] Postgresql + Sessions + Large objects.

2001-08-04 Thread speedboy
I am having trouble with the following function working _with_ sessions. If I turn off my session checking function it enables you to download the file flawlessly, if sessions are turned on then Internet Explorer displays an error: Internet Explorer cannot download ...URL Internet Explorer was

Re: [PHP] PostgreSQL vs. Interbase

2001-05-11 Thread Geoff Caplan
Hi Please discuss as to your point of view the advantage of PostgreSQL over Interbase and/or vise versa. I'm considering three (3) important points I'm just evaluating Interbase and there is an important point that did not come out in the thread. It seems that Borland went back on key

Re: [PHP] PostgreSQL vs. Interbase

2001-05-07 Thread Luke Welling
Altunergil, Oktaywrote: The link that goes to interbase's web site in freshmeat.com redirects to http://www.borland.com/interbase/ which does not list the product as free or open source? Is there another version? oktay My understanding is that the current open source version is available

[PHP] PostgreSQL vs. Interbase

2001-05-07 Thread Arnold Gamboa
Hi there. I'm currently in serious research on what database to use for a B2B site which is expected to hold millions of records. I have in so far considered two open source databases - Interbase and PostgreSQL. With this in mind, I'm sending this email to both the PostgreSQL and Interbase

Re: [PHP] PostgreSQL vs. Interbase

2001-05-07 Thread Luke Welling
Arnold Gamboa wrote: I'm currently in serious research on what database to use for a B2B site which is expected to hold millions of records. I have in so far considered two open source databases - Interbase and PostgreSQL. With this in mind, I'm sending this email to both the PostgreSQL and

RE: [PHP] PostgreSQL vs. Interbase

2001-05-07 Thread Altunergil, Oktay
, 2001 3:17 PM To: [EMAIL PROTECTED] Subject: Re: [PHP] PostgreSQL vs. Interbase Arnold Gamboa wrote: I'm currently in serious research on what database to use for a B2B site which is expected to hold millions of records. I have in so far considered two open source databases - Interbase

[PHP] PostgreSQL and PHP - some Great Bridge news

2001-03-27 Thread Ned Lilly
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

[PHP] PHP PostgreSQL

2001-03-04 Thread Marcelo Pereira
Hi, All. I have to build a web site and I was studying postgreSQL, but, whether I am quite wrong or this database does not support Foreign Key. Does anyone use postgreSQL and know how handle Foreign Keys ??? Thanks, Marcelo Pereira Computer Programmer

Re: [PHP] PHP PostgreSQL

2001-03-04 Thread The Hermit Hacker
On Sun, 4 Mar 2001, Marcelo Pereira wrote: Hi, All. I have to build a web site and I was studying postgreSQL, but, whether I am quite wrong or this database does not support Foreign Key. Does anyone use postgreSQL and know how handle Foreign Keys ??? Yes, it supports Foreign Keys ...

Re: [PHP] PHP PostgreSQL

2001-03-04 Thread Andrew Halliday
day, March 05, 2001 1:00 AM Subject: [PHP] PHP PostgreSQL Hi, All. I have to build a web site and I was studying postgreSQL, but, whether I am quite wrong or this database does not support Foreign Key. Does anyone use postgreSQL and know how handle Foreign Keys ??? Thanks, Marcelo Pereir

Re: [PHP] PostgreSQL vs InterBase

2001-03-02 Thread Meir kriheli
On Friday 02 March 2001 00:23, Shaun Thomas wrote: On Thu, 1 Mar 2001, Meir kriheli wrote: I use both of the databases (Interbase 6.01 and PostgreSQL 7.1beta4). PostgreSQL has more features comapared to Interbase (the procedureal language is very robust and there are many datatyps to

Re: [PHP] PostgreSQL vs InterBase

2001-03-01 Thread Meir kriheli
On Wednesday 28 February 2001 06:19, [EMAIL PROTECTED] wrote: Arnold Gamboa wrote: I hve heard a great deal about InterBase. Please comment on which is better: 1. Speed 2. Data Reliability 3. Compatibility with PHP Thanks for your comments. -- 1. I think Postgresql 2

Re: [PHP] PostgreSQL vs InterBase

2001-03-01 Thread Shaun Thomas
On Thu, 1 Mar 2001, Meir kriheli wrote: I use both of the databases (Interbase 6.01 and PostgreSQL 7.1beta4). PostgreSQL has more features comapared to Interbase (the procedureal language is very robust and there are many datatyps to choose from. Also you can have some kind of object

Re: [PHP] PostgreSQL vs InterBase

2001-03-01 Thread Mark Charette
From: "Shaun Thomas" [EMAIL PROTECTED] The point about Oracle is that it *lets* you do all of those optimizations, and if you're good at it, it will outperform almost any other database you throw at it. Trust me on this one. I'm sorry, I can't trust you very much on this. Having worked as a

Re: [PHP] PostgreSQL vs InterBase

2001-02-27 Thread Wade Halsey
for a relational database and of course a bonus is that it is free :) - Original Message - From: Arnold Gamboa [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, February 27, 2001 11:00 AM Subject: [PHP] PostgreSQL vs InterBase I hve heard a great deal about InterBase. Please comment on which

Re: [PHP] PostgreSQL vs InterBase

2001-02-27 Thread Ron Wills
I know this isn't one of the databases that you;re inquiring about, but we've been using MySQL (www.mysql.com) and it has been working beautifully. We have an email server with a MySQL db that's about 4 Gigs now a it's still running strong. MySQL is free and might be worth looking into :-)

Re: [PHP] PostgreSQL vs InterBase

2001-02-27 Thread mwaples
Arnold Gamboa wrote: I hve heard a great deal about InterBase. Please comment on which is better: 1. Speed 2. Data Reliability 3. Compatibility with PHP Thanks for your comments. -- 1. I think Postgresql 2 and 3 I can't say which is better. Both seem to work ok - you might want

Re: [PHP] Postgresql session handling

2001-02-26 Thread Bolt Thrower
I [EMAIL PROTECTED] wrote: Can someone give me a simple example script that uses postgres session handling, that works with register_globals "off"? As a followup again, it seems what I've been running into is a bug in PHP: http://bugs.php.net/bugs.php?id=8772

Re: [PHP] Postgresql session handling

2001-02-22 Thread Bolt Thrower
I [EMAIL PROTECTED] wrote: It seems the pgsql_session_write() function is not even being invoked. Here it is: As a followup, it seems that turning register_globals "on" allows the pgsql_session_write() function to be called, and my test script works if I replace $HTTP_SESSION_VARS["count"]

[PHP] Postgresql session handling

2001-02-20 Thread Bolt Thrower
PHP 4.04pl1, PostgresQL 7.0.3 on a RedHat 6.2 system. I'm trying to get session data to be stored in a postgres table. I'm using the pgsql session handler from http://www.csh.rit.edu/~jon/projects/php/pgsql_session_handler/, and I think I've got it set up correctly, but I thought I'd ask here

Re: [PHP] Postgresql session handling

2001-02-20 Thread Richard Lynch
/ Wanna help me out? Like Music? Buy a CD: http://l-i-e.com/artists.htm Volunteer a little time: http://chatmusic.com/volunteer.htm - Original Message - From: Bolt Thrower [EMAIL PROTECTED] Newsgroups: php.general Sent: Tuesday, February 20, 2001 12:45 PM Subject: [PHP] Postgresql session

Re: [PHP] Postgresql session handling

2001-02-20 Thread Bolt Thrower
"Richard Lynch" [EMAIL PROTECTED] wrote: The writing of the session data occurs *after* the server-browser HTTP connection is cut. If you have any error-reporting happening in your session_write function, you won't see it. Alter that function to log errors to a file or something. It seems

Re: [PHP] Postgresql session handling

2001-02-20 Thread Yasuo Ohgaki
"Richard Lynch" [EMAIL PROTECTED] wrote: The writing of the session data occurs *after* the server-browser HTTP connection is cut. If you have any error-reporting happening in your session_write function, you won't see it. Alter that function to log errors to a file or something. It

Re: [PHP] PostgreSQL + PHP + SQL warning messages

2001-01-25 Thread Martin A. Marques
El Jue 25 Ene 2001 16:36, Evelio Martinez escribi: Hi! Is there any way to get the equivalent sqlca.sqlcode value of informix in PostgreSQL from php ? I would like to use the sqlcode to print the messages in Spanish. The problem is that informix puts in an array (sort of) all the info