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.
Molukkenstraat 14
6524NB Nijmegen
tel: 024-3888063 / 06-51855277
fax: 024-3608416
email: [EMAIL PROTECTED]
web: www.askesis.nl

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 mean something like:

SELECT nextval('koe_pkey_id') as val, (INSERT INTO koe (id, name) 
values (val, 'uusi')) as dummy FROM koe;"

That would both insert new record and return serial value - if it 
just worked...

Thanks 
Esa

Alessio Bragadini wrote (15 Dec 00,):
 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');

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 have not managed to dot it. I mean something like:
 
 SELECT nextval('koe_pkey_id') as val, (INSERT INTO koe (id, name)
 values (val, 'uusi')) as dummy FROM koe;"

I don't think so.

 That would both insert new record and return serial value - if it
 just worked...

In one of your examples you used a double statement, so you could
probably try:

INSERT INTO koe (id, name) (SELECT nextval('koe_pkey_id'), 'uusi');
SELECT currval('koe_pkey_id');

This should INSERT and then retrieve the same sequence value. As has
been explained to me before :-) the sequence value is safe (i.e. doesn't
get updated by another connection) inside the connection. One of your
examples was similar, but without the nextval part, so probably the
backend doesn't have a value for currval yet.

-- 
Alessio F. Bragadini[EMAIL PROTECTED]
APL Financial Services  http://village.albourne.com
Nicosia, Cyprus phone: +357-2-755750

"It is more complicated than you think"
-- The Eighth Networking Truth from RFC 1925

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 can give two queries in iHTML like this:
 
 SQL ="SELECT nextval('koe_pkey_id') as val;
   INSERT INTO koe (id, name) values (val, 'uusi');"
 
 Now there are some problems. The previous example causes an error:
 ERROR: Attribute 'val' not found
 Is there a method how to transmit a value from one query to another?
 
 If I try the examples of FAQ:
 SQL ="$newSerialID = nextval('koe_pkey_id');
   INSERT INTO koe (id, name) values ($newSerialID, 'uusi');"
 Or
 SQL ="INSERT INTO koe (name) values ('uusi');"
   $newSerialID = curr('koe_pkey_id');
 
 I get: ERROR: parser: parse error at or near "$"
 
 And lately (this may be an iHTML problem) if I try:
 SQL ="INSERT INTO koe (name) values ('uusi');
   SELECT currval('koe_pkey_id') as val;"
 It causes no error, but I cannot retrieve the value because the
 queries seem not return any recordsets (nothig can be fetched).
 
 Any hints are valuable!
 Thanks
 Esa Pikkarainen

[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 - 69276 
 I.P.R  |  EXT 336,315
 BHAT, GANDHINAGAR  | Residence -- 079 - 6619967
 Gujrat -- 382 428  | FAX --- 69017
  --

[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
Marco

[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 "org.postgresql.Driver", not "postgresql.Driver".

I don't write applets.  Can they have jars in the classpath or do you
have to extract all the .class files?

-- 
Bruce R. Lewis  http://brl.sourceforge.net/

[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