Re: [SQL] how to execute a C program via trigger ?

2000-12-04 Thread S.F. Lee
Thank for your hint, but I have some questions : 1. Do I have to compile the C program into a shared object (*.so)? 2. Do I have to use SPI (SPI is too complicate to me)? My request is very simple. I have a program (my_c_program) that I can execute it under shell by typing (my_c_progr

Re: [SQL] reinitialize a sequence?

2000-12-04 Thread Mike Castle
setval(); Sometimes it's good to read files in the source tree (such as HISTORY). mrc -- Mike Castle Life is like a clock: You can work constantly [EMAIL PROTECTED] and be right all the time, or not work at all www.netcom.com/~dalgoda/ and be right at least twice a day. -- mr

[SQL] reinitialize a sequence?

2000-12-04 Thread Dan Lyke
Bruno Boettcher writes: > is there a simple way to tell all sequences to take the max value +1 of > their respective tables? (a bit like the vacuum command?) This is completely gross, but what I've done: #!/usr/bin/perl -w use strict; use DBI; my ($dbh); sub BEGIN { $dbh = DBI->connect('DBI

[SQL] reinitialize a sequence?

2000-12-04 Thread Bruno Boettcher
hello, played a bit around with the serial type wanted to adapt my already existing tables to this system... dumped the DB, created the new tables, loaded old data in all works, until i try to insert something without specifying the id field (that's the now sequential field). And the reas

Re: [SQL] how to execute a C program via trigger ?

2000-12-04 Thread clayton cottingham
take a look at the contrib sections fti or fulltext index example it takes you through it all "S.F. Lee" wrote: > > Hi, > >I am using Red Hat 6.1 + PostgreSQL 7.0.3. All of > my > applications are developed by C and ECPG. I would > like to know how to execute a C program by Trigger,for

[SQL] SETOF

2000-12-04 Thread Limin Shen
Hi, This is my first time using this address, so if I sent to the wroing place, please forgive me. I have a question on how to use SETOF to return multiple values. IF someone can help me on that subject, that will be great. Thank you.    Get more from the Web. FREE MSN Explorer download : http://e

[HACKERS] Re: [SQL] Rules with Conditions: Bug, or Misunderstanding

2000-12-04 Thread Jan Wieck
Tom Lane wrote: > Jan Wieck <[EMAIL PROTECTED]> writes: > > Tom Lane wrote: > >> Hm. Perhaps the "cannot update view" test is too strict --- it's not > >> bright enough to realize that the two rules together cover all cases, > >> so it complains that you *might* be trying to update the view. As

[SQL] how to execute a C program via trigger ?

2000-12-04 Thread S.F. Lee
Hi, I am using Red Hat 6.1 + PostgreSQL 7.0.3. All of my applications are developed by C and ECPG. I would like to know how to execute a C program by Trigger,for example: 1. I have a program my_c_program.c shuch as: #include main() { printf("Hello World !\n"); } 2. I create a

Re: [GENERAL] Re: [PHP-DB] Re: [SQL] a script that queries database periodically

2000-12-04 Thread Dan Wilson
> Jason wrote: > > > > aolserver is a web/application server. PHP is a server-side scripting > > language. Why exactly *should* it have a job scheduler? > > > > Some (such as myself) might also ask why should a web server have a job > > scheduler, but that's a thread for a different list :) > >