broken.
Are you using the same version of libpq?
i.e. When you connect to 7.3 backend, use libpq comes with 7.3.
7.3 is not compatible with earlier versions of libpq as noted in
PostgreSQL documents.
--
Yasuo Ohgaki
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http
server with many users until PostgreSQL 7.3)
--
Yasuo Ohgaki
Boaz Yahav wrote:
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
original poster would like to compare PostgreSQL
and MySQL.
What's this got to do with PHP? Nada... Happy New Year!
Compare performance PostgreSQL and MySQL using PHP?
Have a happy new year.
--
Yasuo Ohgaki
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http
IIRC, someone added automatic rollback to MySQL from PHP 4.3.0 just
like PostgreSQL.
BTW, PostgreSQL module rollbacks uncommitted transaction automatically
from PHP3.
--
Yasuo Ohgaki
John W. Holmes wrote:
I Am using the latest PHP version 4.2.3 with MySQL 3.23.51-max. I use
InnoDB tables
Edwin Robertson wrote:
With psql you can get all your output in HTML format. Anyone know of a way
to do this in PHP?
It's psql feature and there is no automatic HTML format
in PHP's pgsql module.
If really would like, you can use passthru() and psql.
?php
t
in PHP's pgsql module.
If really would like, you can use passthru() and psql.
?php
passthru('/usr/local/pgsql/bin/psql -f select.sql -H -U yohgaki -d test');
?
where "select.sql" is query you need.
--
Yasuo Ohgaki
--
P
account with v+1 (debit)
COMMIT WORK
It works for me. (at least with CVS version)
If there is uncommitted transaction, pgsql module
rollback automatically.
BTW, if you have too long timeout limit, your site
became weaker for DoS attack.
--
Yasuo Ohgaki
--
PHP Database Mailing List (http
/
--
Yasuo Ohgaki
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--+-+---
ThisIsNumber | integer |
test=# create table (ThisIsNumber int);
CREATE
test=# \d
Table
Column| Type | Modifiers
--+-+---
thisisnumber | integer |
test=#
--
Yasuo Ohgaki
--
PHP Database Mailing List (http://www.php.net
Matthew Newby wrote:
I am having trouble with the pg_fetch_result function when trying to access
a boolean field in a PostgreSQL database. Here's the code snippet:
It's a spec.
PostgresSQL's boolean is returned as 't' or 'f' and both are string.
Test as string.
--
Yasuo Ohgaki
--
PHP
Don't cross post such question...
All you need to understand is how cookie is managed unless
you are passing session id via URL.
Read RFC2965 and RFC2964.
You probably want to read netscape cookie spec also.
--
Yasuo Ohgaki
Youngie wrote:
Why would my session data not be deleted after my
records in
a result set.
--
Yasuo Ohgaki
Brown wrote:
# Sorry to my poor English
I have a procedure ( named by select_table )
##
BEGIN;
select select_table('select_cur','table_name');
FETCH ALL IN select_cur;
COMMIT
Does this happen with latest PHP? If yes, please report
this as a bug.
PS: Current PostgreSQL module is trying to rollback
uncommitted transactions when request is finished.
This is old postgresql module issue, probably.
--
Yasuo Ohgaki
Max Buvry wrote:
Hi,
I use Postgresql 7.0 + php
-scheme that
sucks or could it be that mysql is leaking memory in some way?
Would it help to move mysql to a separate machine?
If you do normal query, mysql store whole result in memory!
You can avoid that. It's in the manual.
--
Yasuo Ohgaki
--
PHP Database Mailing List (http://www.php.net
many ways to do certain things, and so
few ways to do other things. =)
Oh no. You are saying PHP is like a PERL.
PHP stands for People Hate PERL.
(Just kidding, I like PERL and other developers like PERL)
--
Yasuo Ohgaki
Just Curious,
Adam Voigt
[EMAIL PROTECTED]
On Mon, 08 Apr 2002 13
Adam Voigt wrote:
think it's funny PHP has so many ways to do certain things, and so
few ways to do other things. =)
I forgot to ask.
May I ask what kind of features/functions are missing?
It does not have to be about PostgreSQL module.
--
Yasuo Ohgaki
--
PHP Database Mailing List (http
could not get the custom error
PHP5 has try, catch.
However, there are many rooms for improvements...
in ASP or iHTML for that matter, I'm a pure PHP evangelist from
top to bottom.
:)
--
Yasuo Ohgaki
Adam Voigt
[EMAIL PROTECTED]
On Mon, 08 Apr 2002 23:04:25 +0900, Yasuo Ohgaki [EMAIL
Large Object cause I connecting to Postgres via ODBC
( there is no support for large objects )
Have anybody solved this problem? is there any alternative datatypes or ways
of solution?
If you are using PostgreSQL and PHP, just use pgsql extension
--
Yasuo Ohgaki
Please CC me when you reply
Large Object cause I connecting to Postgres via ODBC
( there is no support for large objects )
Have anybody solved this problem? is there any alternative datatypes or ways
of solution?
If you are using PostgreSQL and PHP, just use pgsql extension
--
Yasuo Ohgaki
Please CC me when you reply
Could you post backtrace and CC the meesage to me?
I'm almost sure pgsql module will never cause segfault
like this, I can tell more if you send backtrace
PS: If you don't know how to get backtrace, visit
http://bugsphpnet/
--
Yasuo Ohgaki
Kevin Traas wrote:
Greetings everyone,
I've been
Read current manual page.
If you still have problem, let me know what's the problem.
http://www.php.net/manual/en/ref.session.php
--
Yasuo Ohgaki
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
'Field num is '.$fn.\n; // $fn is 1
$res = pg_query(SELECT 1 AS one);
$fn = pg_field_num($res, 'one');
echo 'Field num is '.$fn.\n; // $fn is 0
?
--
Yasuo Ohgaki
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
/install them with this order. PostgreSQL-Apache-PHP.
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?
Install from RPM or like, they should work out of box.
BTW, do not cross post :)
--
Yasuo Ohgaki
Please CC me when you reply
mysql_affected_rows($result);
}
session_set_save_handler(
sess_open,
sess_close,
sess_read,
sess_write,
sess_destroy,
sess_gc);
?
--
Yasuo Ohgaki
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED
4.1.0 or 4.2.0-dev see if it helps.
--
Yasuo Ohgaki
_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED
-recommened)
--
Yasuo Ohgaki
--
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]
extesion does not require any external lib.
You should be able to use it under UNIX, if it is working :)
Use of dbase for production system is not recommended as
described in the manual.
--
Yasuo Ohgaki
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED
report.
Regards,
--
Yasuo Ohgaki
--
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]
ions would be greatly appreciated
:)
-torrent
How about take a look at the manual page?
http://www.php.net/manual/en/ref.errorfunc.php
You may also be interested in output buffering.
Look for ob_start(), ob_end_clean(), etc.
--
Yasuo Ohgaki
--
PHP Database Mailing List (http://www.php.net/)
To unsu
])
Someone will takes care of your patch.
If you really would like to know who is the maintainer, take a look at
EXTENTIONS file in source.
Yasuo Ohgaki
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED
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
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
list.
If you are not using 7.1.2, upgrade to 7.1.2 see if you have problem.
If you get core file, confiugre/build PostgreSQL with debug and post
back trace to list.
--
Yasuo Ohgaki
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional
,
--
Yasuo Ohgaki
Ron Patterson [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Hi there,
I'm building the new PHP-4.0.5 with support for PostgreSQL 7.1 database and
get the following build error:
gmake[3]: Entering directory `/net/clear1/home/rpatters/php-4
. With 7.0, it will gives you a lot of troubles.
Regards,
--
Yasuo Ohgaki
""Marc Blum"" [EMAIL PROTECTED] wrote in message
9c64tv$k7u$[EMAIL PROTECTED]">news:9c64tv$k7u$[EMAIL PROTECTED]...
Hello
We're trying to get this running. php4 is running as dynamically l
for one,
different setting for other.
Regards,
--
Yasuo Ohgaki
Brad Hubbard [EMAIL PROTECTED] wrote in message
015301c0cdfc$bc211030$3200a8c0@BADNOTE">news:015301c0cdfc$bc211030$3200a8c0@BADNOTE...
Does anyone know what causes PHP to generate the following error/warning?
It not related to database. Anyway,
If you use $HTTP_SESSION_VARS, forget about session_(un)register(). (Do not use
them)
Just use $HTTP_SESSION_VARS. It's known issue.
(If you use global vars, only use global vars and use session_(un)register())
Regards,
--
Yasuo Ohgaki
Nicolas Guilhot
for PHP4.0.4pl1, could you tell where to get or
send it to me?)
--
Yasuo Ohgaki
--
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]
Did you have install pgsql.dll in your system directory? and load the extension?
I noticed pg_cmdtuples() is missing, though.
--
Yasuo Ohgaki
""Jerome O Macaranas"" [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]...
using PHP 4.0 under Win2K IIS 5.0
got this
()?
If there is pg_cmdtuples(), it would be really nice.
--
Yasuo Ohgaki
""Jerome O Macaranas"" [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]...
using PHP 4.0 under Win2K IIS 5.0
got this error
- Fatal error: Call to undefined function: pg_connect() in
C:\Inetpub\PHPwwwroot\
this helps.
--
Yasuo Ohgaki
"John Starkey" [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
I've been using mysql too much lately.
Can anyone tell me how to set up an auto increment in postgres? I need
to select a row based on a user's menu selecti
Why you want to create MAC address type? It's already there in V7.
macaddr| XX:XX:XX:XX:XX, MAC address
Besides, do you have functions defined for INPUT and OUTPUT?
You must define them. Refer to PostgreSQL User Manual for details.
Regards,
--
Yasuo Ohgaki
"Olivier Thauvin&qu
PHP takes care of closing it, just like other resources. However, it seems there
is bug in closing none persistent PgSQL link in current version. 4.0.5 hopefully
fix this.
Regards,
--
Yasuo Ohgaki
"Sharmad Naik" [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">new
on your DB.
--
Yasuo Ohgaki
""Matt Braynard"" [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
I have created a news script and to my dismay, the script is breaking when
there is a single quote - ' - in a form that goes to the database
I've posted notes on PHP Manual
http://www.php.net/manual/en/install-windows.php
It might help.
--
Yasuo Ohgaki
""Shahmat Dahlan"" [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
I have IIS 4 with PHP 4pl1 running on Win NT 4. I ca
45 matches
Mail list logo