amal.barman

What does it mean? PostgreSQL support triggers, rules etc. etc.  :)

Hello Jamest, PostgreSQL does not allow anybody to connect without proper authenticity. Apache (incase of LINUX) or SYSTEM (incase of XP), may be two default user tries to connect the postgresql when connection made without any proper user information. This is not the problem of PHP anyway. 

HOW TO INSTALL pgAdmin III on FC6T3 ----------------------------------- PgAdmin3 is not distributed along with Fedora Core 6 (Test3 as in my case). I have downloaded it from the pgadmin site. RPM of pgAdmin3 depends on the wxWidgets, and that can be downloaded from it's site. Since wxWidgets is coming with tar.gz form, compilation is required. Once you have both RPM and tar ball do the followings.  1. Expand the tar ball of wxWidgets $tar -zxvf wxWidgets-2.6.3.tar.gz $cd wxWidgets/ 3. Compile the wxWidgets ( I have developed a script abx.sh to do that.) $./configure --with-gtk --enable-gtk2 --enable-unicode \ --enable-mimetype=no --enable-compat22 --enable--compat24 $make $make install $/sbin/ldconfig $cd contrib/ $make $make install NOTE: --enable-compat22 --enable--compat24 is necessary for pgadmin3-1.4.3-1.i686.rpm package. ([b]I need to compile twice for this reason and wasted a few hour to fix that.[/b]) :o 4. Create the link of shared library object of wxWidgets to /usr/lib/ . (I do not know the reason, why? ???) $cd /usr/lib $for x in `ls /usr/local/lib/*2.6.so.0`; do ln -s $x; done 5. Install pgadmin3-1.4.3-1.i686.rpm (use --nodeps) and run pgadmin3, from menu or from terminal using $pgadmin3 command. Note that help is still not working from pgadmin3, and can any body tell me the reason or how to fix it? ??? That's all.

Hello, I am accessing PostgreSQL from PHP pages. But to access the database, I need to create a super user in PostgreSQL database with name "apache" incase of LINUX and "SYSTEM" incase of WindowsXP operating system, otherwise I can not able to access to my database. Can anybody explain the reason or refer any markup? I am using LINUX+Apache+PostgreSQL+PHP5 and WindowsXP+Apache+PostgreSQL+PHP5 both. ... $db=pg_connect($HOST,$DATABASE); ... Thanks in advance.

Thanks btherl for your response.

Hello, I am unable to solve a locking problem. I am using postgresql database for this project. Here script one (booking.php) tries to setup a lock for update and ask user to fill-up the form. Now when the user fill-up the form and submit it for update, second script (update.php) update the database and releasing the locks. This is working for client (say) A and B from psql prompts but failed from PHP scripts. I have written following scripts as follows. booking.php ----------- ... $db=pg_pconnect($host,$database); // PostgreSQL database $sql_str="BEGIN; SELECT * FROM seat WHERE seat_no=1 FOR UPDATE NOWAIT"; ... <FORM method="get" action="update.php"> // collecting user's input ... update.php ---------- ... $db=pg_pconnect($host,$database); $sql_str="UPDATE seat SET status='booked' WHERE seat_no=1; END"; ... // end My update script failed to do lock the table and records. How can I fix? One WARNING is showing by PostgreSQL, "there is no tranaction in progress". Thanks for your help in advance. ???