Re: Calling Java from psql (was Re: [SQL] requesting help)

2001-03-29 Thread Peter Mount
At 21:37 26/03/01 +0200, Mathijs Brands wrote: >On Mon, Mar 26, 2001 at 07:00:43PM +0200, Peter Eisentraut allegedly wrote: > > Mathijs Brands writes: > > > > > Has anybody ever tried calling Java code from a pgsql trigger written > > > in C? Shouldn't this be possible using JNI? > > > > I have, a

Re: Calling Java from psql (was Re: [SQL] requesting help)

2001-03-29 Thread Peter Mount
At 10:33 26/03/01 +0200, Mathijs Brands wrote: >Has anybody ever tried calling Java code from a pgsql trigger written >in C? Shouldn't this be possible using JNI? This was discussed recently. >I'm not exactly a Java expert myself, but this is the way PHP allows >you to call Java code from your

Re: [SQL] JDBC Performance

2000-10-17 Thread Peter Mount
On Mon, 16 Oct 2000, Josh Berkus wrote: > Mr. May, > > For discussions of JDBC, please subscribe to the pgsql-interfaces > list. You will find many JDBC users on that list. > > -Josh Berkus > > P.S. PGSQL folks, is there any way we can clarify this

Re: [SQL] Loading JDBC Driver

2000-10-09 Thread Peter Mount
On Thu, 5 Oct 2000, Jos Hernndez Zavala wrote: > Hello. > > I am trying to load a jdbc driver for postgres, only I > want to make it from an Applet. For an application I > used the form: > > Class.forName ("postgresql.Driver"); > > Which the correct form would be to be able to mak

RE: [SQL] Object features of pg

2000-10-03 Thread Peter Mount
On Tue, 3 Oct 2000, Michael Ansley wrote: > Hi, Peter, > > I suspected as much of the querying, but I can't even get data into the > tables. I tried this: > > insert into client values ('Michael'); > insert into address values ('11 Windsor Close, 'RH16 4QR'); > INSERT 18935 1 > update client s

Re: [SQL] Object features of pg

2000-10-03 Thread Peter Mount
On Tue, 3 Oct 2000, Michael Ansley wrote: > I've done the following: > > create table address (address varchar(50), postcode varchar(9)); > create table client(id integer, name varchar(30), address address); > > Now, how the hell do I get information into the address field of client? > There ap

Re: [SQL] Web Hosts (off-topic)

2000-09-14 Thread Peter Mount
At work, were using dedicated-servers.co.uk for our new sites. They use Redhat 6.2, but I compiled both php4 and PostgreSQL 7.0.2 and it's running smoothly. -- Peter T Mount [EMAIL PROTECTED] http://www.retep.org.uk PostgreSQL JDBC Driver http://www.retep.org.uk/postgres/ Java PDF Generator http

Re: [SQL] postgresql and java2

2000-08-15 Thread Peter Mount
First sorry for the late reply, I only get this list from home, and just got email working again.   I was working on ARRAY and STRUCT for 7.0, but it a snag. I couldn't get a grips with what the spec meant, and couldn't work out how the SQL3 ARRAY type relates to our arrays. From the document