[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 "b

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 t

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); > ech

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 fi

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
On 30/04/2011, Daniel Brown 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 wrote: >>

Re: [PHP] postgresql database access failure

2011-04-30 Thread Daniel Brown
On Sat, Apr 30, 2011 at 12:23, Daniel Brown wrote: >> >>        >                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 screen), but it'

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 wrote: >                        $db = pg_connect('dbnam

[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. why does this fail? The followin

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 er

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 nex

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

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 nex

[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 nextval('tmp_importedxls

[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 my_

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

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. seco

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

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

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 t

[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 s

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] 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

[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 a

[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 a

[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: http://www.wapforum.org/DTD/wml_1.1.xml";> Name: Password: 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 them

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 con

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 wrot

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 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 pro

[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

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

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'; '

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

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

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 goin

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

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 timestam

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 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
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 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 th

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.

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 extension

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 DATE_FOR

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_

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 da

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 some

[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 resu

[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

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 t

[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 'lo

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 variabl

[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

[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] 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

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 D

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

2002-01-26 Thread Miles Thompson
st scripts 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 Apac

Re: [PHP] PostgreSQL query taking a long time

2001-12-22 Thread Papp Gyozo
tgres 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

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] 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() LI

[PHP] Hmmm? PHP+PostgreSQL

2001-10-24 Thread Alexey Prohorenko
track-vars --with-pgsql --with-mysql make make install (I have mySQL, too) Compilation process was great, no errors. Nevertheless, next little PHP script: testing needed functions of current-gtlg with PHP+PostgreSQL still says: Fatal error: Call to unde

Re: [PHP] PostgreSQL connection problems

2001-09-27 Thread Marcela
> To: <[EMAIL 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 > > th

[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 alrea

[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 (h

[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 n

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 com

Re: [PHP] PostgreSQL vs. Interbase

2001-05-07 Thread Luke Welling
"Altunergil, Oktay"wrote: > 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 a

RE: [PHP] PostgreSQL vs. Interbase

2001-05-07 Thread Altunergil, Oktay
ay 07, 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 databa

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 an

[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 mailin

[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 instal

Re: [PHP] PHP & PostgreSQL

2001-03-04 Thread Andrew Halliday
we can put the field name in brackets after the table name. As before, the following will fail: DELETE FROM school WHERE id = 1; - AndrewH - Original Message - From: "Marcelo Pereira" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, March 05, 2001 1:00 AM Su

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 Ke

[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] 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 datatyp

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 a

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 su

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

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

Re: [PHP] PostgreSQL vs InterBase

2001-02-27 Thread Martin A. Marques
Mensaje citado por: Ron Wills <[EMAIL PROTECTED]>: > 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 str

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 :-) Arnold

Re: [PHP] PostgreSQL vs InterBase

2001-02-27 Thread Wade Halsey
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. Pl

[PHP] PostgreSQL vs InterBase

2001-02-27 Thread Arnold Gamboa
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. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAI

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 http://bugs.

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"]

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

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

Re: [PHP] Postgresql session handling

2001-02-20 Thread Richard Lynch
store/ 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] Postgre

[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 fi

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 inf

[PHP] PostgreSQL + PHP + SQL warning messages

2001-01-25 Thread Evelio Martinez
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. Thanks in advance -- Evelio Martínez Testanet. Dept. desarrollo software. Av. Reino de Valencia, 15 - 5 46005 Valencia (Spain)