Re: [GENERAL] SQL-question: returning the id of an insert querry

2003-11-09 Thread Andreas Fromm
ert. > > Hope this helps, > ..going to try it. Thanks Andreas Fromm -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.1 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE/rkMwPkvkZVZzNY0RAnajAJ0ePCTi/UODhGAxOs5NuptZAT0tUgCgpNAz Oqh8rM934O3SRRzv4Mh9

[GENERAL] SQL-question: returning the id of an insert querry

2003-11-09 Thread Andreas Fromm
something like that after doing the insert(a) to get the correct id value, or is there a better way to do this. Im writing my app in Perl with DBD/DBI Thanks in advance, Andreas Fromm -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.1 (GNU/Linux) Comment: Using GnuPG with Mozi

Re: [GENERAL] [Fwd: [LIH]OpenOffice.org 1.1 <-> PostgreSQL connectivity]

2003-11-03 Thread Andreas Fromm
u can even design embeded forms ( Forms which disply Data from different tables). There are some usfull articles abaut that on the OOo-db project site. Regards Andreas Fromm -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.1 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://en

Re: [GENERAL] poor cpu utilization on dual cpu box

2003-10-22 Thread Andreas Fromm
where you don't get the full performanco out of your box and the only thing you can do is to improve your application to reuse data which is in the caches, which is something you probably won't be able to do, due to the nature of databse applications. Regards Andreas Fromm Simo

Re: [GENERAL] PG tools

2003-10-15 Thread Andreas Fromm
-(end of broadcast)--- > TIP 4: Don't 'kill -9' the postmaster - -- Andreas Fromm -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.1 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE/jT+pPkvkZVZzNY0RAuIFAJ9Kpssft5AX

Re: [GENERAL] MPI interface

2003-09-26 Thread Andreas Fromm
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Ramkrishna Chakrabarty wrote: | Hi, | | Is there a MPI interface to PostgreSQL ? Has anybody used. | If yes could please send me some links about the same. | | Regards | RC | What do you mean with a MPI interface? Do you want to access a DB from a mpi-p

[GENERAL] add constraints to views

2003-09-20 Thread Andreas Fromm
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Please consider the following situation. CREATE TABLE test_table ( ~id SERIAL PRIMARY_KEY, ~tag BOOLEAN, ~field1 INTEGER ); CREATE VIEW test_view ( ~SELECT * FROM test_table WHERE tag ); Now I want ad a NOT NULL constraint to the view o

Re: [GENERAL] char o varchar

2003-09-17 Thread Andreas Fromm
Messenger: http://messenger.yupimsn.com/ ---(end of broadcast)--- TIP 8: explain analyze is your friend -- Andreas Fromm - Drink wet cement... ... and get stoned ---(end of

Re: [GENERAL] inserting via "on insert" rule

2003-09-03 Thread Andreas Fromm
Peter Eisentraut wrote: Andreas Fromm writes: I was thinking of defining a view "users" over "persons" which would let me retrive the list of useres. But How would I implement the rule for insertiung users? I tryed the following but NEW is not known where I want to use i

Re: [GENERAL] deleting referenced data

2003-08-28 Thread Andreas Fromm
Bruno Wolff III wrote: On Wed, Aug 27, 2003 at 00:09:34 +0200, Andreas Fromm <[EMAIL PROTECTED]> wrote: Bruno Wolff III wrote: On Tue, Aug 26, 2003 at 18:34:04 +0100, Richard Huxton <[EMAIL PROTECTED]> wrote: I don't think that is what he wants. He seems to want t

[GENERAL] deleting referenced data

2003-08-26 Thread Andreas Fromm
INTEGER REFERENCES data1, data2 INTEGER REFERENCES data2, data3 INTEGER REFERENCES data3 ); When I delete a record of the table realtions I also want to delete the record on the data-tables if there is no other record referencing them. How can I do this? Regards Andreas Fromm