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.

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

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? I

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] 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 -

[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

[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 . . . APPLET CODE = "JDBC.class" ARCHIVE = "jdbc7_0-1_2.jar" WIDTH = 400 HEIGHT = 400 Good luck, Greg Speegle In article [EMAIL PROTECTED], [EMAIL PROTECTED] says... One problem: use

[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