[GENERAL] question

2000-12-15 Thread Sandeep Joshi
I need to update a second database through a trigger function written 'C'. Is that possible ? how? Do I need to go to commercial product for this? - Sandeep

[GENERAL] Re: Help!Can't connect Postgresql JDBC driver

2000-12-15 Thread Greg Speegle
You can have jars with an applet by using the ARCHIVE field in the applet tag. Something like . . . Good luck, Greg Speegle In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] says... > >One problem: use "org.postgresql.Driver", not "postgresql.Driver". > >I don't write applets. Can they ha

[GENERAL] How can I set the right of access in a pgsql database?

2000-12-15 Thread Marco Wittwer
Hello I want to connect (with php) from a webserver to another servers database. I have a error: Unable to connect to PostgresSQL server: Failed to authenticate client as Postgres user 'wwwrun' using authentication scheme 131072 How can I set the right of access in the database? Thanks a lot Mar

[GENERAL] Trigger

2000-12-15 Thread Manika dey
Hi, Can anyone help me . I want to know how to write triggers. i am using java and postgresql --- From:- | Ms. Manika Dey.|Ph.No:-- Engineer-SC (Comp. Tech.) | IPR -- 02712 -

Re: [GENERAL] Sequence value

2000-12-15 Thread Roger Wernersson
You could try INSERT INTO koe (id, name) SELECT nextval('koe_pkey_id'), 'uusi'; or something like that. /Roger Esa Pikkarainen wrote: > > So, I want to insert new record and get immediately its sequence > value (serial column) (or OID). I Use iHTML web interface. > Now I have found out that I

[GENERAL] Re: Sequence value (Record Id)

2000-12-15 Thread Esa Pikkarainen
AAAHHH, I DID IT That: SQL="SELECT nextval('koe_pkey_id'); INSERT INTO koe (id, name) VALUES (SELECT currval('koe_pkey_id'), 'uusi');" Now it returns the correct Serial value of the record it inserts. Yee, I'm glad now :-D Thank you all and have a good weekend! Esa Pikkarainen

Re: [GENERAL] Sequence value

2000-12-15 Thread Alessio Bragadini
Esa Pikkarainen wrote: > but unfortunately it did not solve my problem. Now I have no access > to the value of nextval('koe_pkey_id'). This query does not return > any recordset. Sorry, I didn't check this requirement. > Is it possible to embed Insert query as a subquery into a Select > query?

Re: [GENERAL] Sequence value

2000-12-15 Thread Esa Pikkarainen
Thank you, Yet another way to do it ;-) but unfortunately it did not solve my problem. Now I have no access to the value of nextval('koe_pkey_id'). This query does not return any recordset. Is it possible to embed Insert query as a subquery into a Select query? I have not managed to dot it. I m

Re: [GENERAL] Sequence value

2000-12-15 Thread Alessio Bragadini
Esa Pikkarainen wrote: > SQL ="SELECT nextval('koe_pkey_id') as val; > INSERT INTO koe (id, name) values (val, 'uusi');" INSERT INTO koe (id, name) (SELECT nextval('koe_pkey_id'), 'uusi'); -- Alessio F. Bragadini[EMAIL PROTECTED] APL Financial Services http://village

RE: [GENERAL] Working under NT

2000-12-15 Thread Joost Kraaijeveld
Follow the instructions on http://people.freebsd.org/~kevlo/postgres/portNT.html and it will run. The regression test will fail on 2 tests: horology an alter_table. The first one seems to be a problem in the CygWin environment, the second on I don't know. Joost Kraaijeveld Askesis B.V. Molukkens