Re: [SQL] HELP : Can't load JDBC driver !

2001-04-22 Thread Josh Berkus
Nusa, I suggest that you take your question to the pgsql-jdbc list, a list specifically for JDBC interfacing with Postgres. See www.postgresql.org for directions on how to subscribe. -Josh __AGLIO DATABASE SOLUTIONS___

[SQL] Re: [GENERAL] Client/Server Security question

2001-04-22 Thread Matthew Hixson
Hi Lonnie, This is one of the reasons we are moving to an EJB server at work (we're using Oracle there, but they wanted to accomplish the same thing you want to do with Postgres). By exposing specialized interfaces to the db we effectively limit the types of queries that can be run. That might

Re: [SQL] plpgsql

2001-04-22 Thread Jie Liang
Roberto, Thanks for your help, I read the docs. I am still not entire sure, my problem is in my plpgsql function I used for rec in select ... for update loop update stmt end loop; I don't want above chosen rows be selected(i.e. I want them to be lock exclusively) by another user until transacti

[SQL] HELP : Can't load JDBC driver !

2001-04-22 Thread nusa
Hi, Yes, I cant't load the JDBC driver !!! There must be a silly set-up somewhere, but I can't find it. Here some informations that might help you : 1. Mandake 7.2 2. the postmaster is run from init script as follow : su -l postgres -c "/usr/bin/pg_ctl -D $PGDATA -o '-i' -p /usr/bin/pos