[SQL] How to know table structure from a java program

2000-11-22 Thread Ramesh H R
Sir, Please help me in knowing the structure from a java program. Regards Ramesh

Re: [SQL] Bug or feature

2000-11-22 Thread Stephan Szabo
What is it actually giving you as an error message in the failing case? Someone pointed out a problem in deferred constraints recently and I think this may be related. Stephan Szabo [EMAIL PROTECTED] On Mon, 20 Nov 2000, Kyle wrote: > Here's an interesting test of referential integrity. I'm

Re: [PHP] Re: [SQL] FTI, paged, ranked searching and efficiency.

2000-11-22 Thread Stephen van Egmond
My example wasn't complete. You need to wrap the cursor calls in BEGIN and END. Read the DECLARE docs for the minutiae. /Steve

Re: [PHP] Re: [SQL] FTI, paged, ranked searching and efficiency.

2000-11-22 Thread Stephen van Egmond
Josh Berkus ([EMAIL PROTECTED]) wrote: > Unfortunately, your only real option I can see for DB server-side row > grabbing is: Create the query(ies) as a temporary table or view using a > function. Then use Limit and Offset to grab one chunk of data at a > time. This is, of course, a seriou

Re: [SQL] Persistent Connects (pg_pconnect)

2000-11-22 Thread Roberto Mello
Itai Zukerman wrote: > > Not sure if this is related, but under the non-threading Apache > server, you get 1 persistent connection per Apache process. I don't > think you can be sure which process gets the page with the connection > request, so if you have a limit of, say, 50 processes, and your

Re: [SQL] Persistent Connects (pg_pconnect)

2000-11-22 Thread Serge Canizares
> Not sure if this is related, but under the non-threading Apache > server, you get 1 persistent connection per Apache process. I don't > think you can be sure which process gets the page with the connection > request, so if you have a limit of, say, 50 processes, and your server > is hit fairly