Re: [ADMIN] Auto commit Off how will it effect us ?

2003-12-09 Thread Sai Hertz And Control Systems
Dear Robert Treat , First of all accept gratitude for answering the question phppgadmin=# set autocommit = off; ERROR: SET AUTOCOMMIT TO OFF is no longer supported phppgadmin=# Now does this mean that their must exist some PHP.INI file option that will make client side auto commit on

[ADMIN] Running Postgres Daemons with same data files

2003-12-09 Thread Bhartendu Maheshwari
Dear All, I am working in Linux 8.0 and running postgresql 7.2. I am trying to access same data files from the two postgres daemons. I mean there are two PC's running with postgres and one NAS server where data files are kept. To run postgres on the machines I first mount the NAS file system and

Re: [ADMIN] Running Postgres Daemons with same data files

2003-12-09 Thread Sam Barnett-Cormack
Don't do that This absolutely cannot be done in any sane way. Instead, consider locating the database itself on one server, and then having multiple other servers running the client application. On Tue, 9 Dec 2003, Bhartendu Maheshwari wrote: Dear All, I am working in Linux 8.0 and

[ADMIN] Full textsearch gist

2003-12-09 Thread Ferdinand Smit
Hi, I'm experimenting with tsearch2. It works very good, but i have a few questions: - Is there a tsearch maillingslist ? - How can i create a muticolumn index of an date and a text field, so i for example can textsearch in de last few days. CREATE INDEX test_ix ON test USING

[ADMIN] lost database

2003-12-09 Thread Jodi Kanter
I am working with someone who has been running creating and maintaining his own database. He somehow managed to blow away his database and needs to restore. However, he has not been running regular dumps because he figured the tape backups were enough. Is there anyway that I can assist him in

[ADMIN] error in code

2003-12-09 Thread Ashok Chauhan
# include stdio.h # include stdlib.h # include libpq-fe.h int main() { PGresult *result; PGconn *conn; int feild; printf(successful); conn = PQconnectdb (ashok); result = PQexec (conn, select * from bill); feild