I have created a trigger function.
could somebody tell me how I get the values from the insert in the trigger
function.
I tried the function
SPI_getvalue(trigger,tupdesc,attnum)
but after starting the trigger, I become this terminating output:
pqReadData() -- backend closed the channel
Hello Thomas,
I have used the same thing and it does work for me I was also getting
similar problems initially
What does your trigger do? does it insert a tuple back into the table? if
yes then that is your problem ... coz the insert will fire another trigger
and this may continue
I have just installed PHP on my new Cobalt RaQ3i, which came with
PostgreSQL already installed. Both PHP and PostgreSQL work
independently. I have created several sample databases using psql. My
test PHP scripts embedded in html work. But when I try to use PHP to
access a PostgreSQL all I
How can we do STORED PRECEDURE in PostgreSQL?
__
Get Your Private, Free Email at http://www.hotmail.com
Hello,
I am looking for a tool which allows to use Postgres from a
Smalltalk environment.
Has everyone heard of it ?
Thank you for your answers.
Regards,
Christophe Touzemail
: [EMAIL PROTECTED]
Michael Poon wrote:
How can we do STORED PRECEDURE in PostgreSQL?
Several options exist (C, SQL, PL/pgSQL...). For starters, see CREATE
FUNCTION at
http://www.postgresql.org/docs/postgres/index.html
Cheers,
Ed Loehr
Michael,
I'm new to both PHP and PostgreSQL, and I had the same problem.
I fixed it by doing 2 things:
1) Requiring the database to be accessed by a username/passwd combination.
2) Connecting to the database with the username/passwd combination.
Here is my code:
?php
require
Ed, There is big difference between PG's functions and Stored Procedures,
as they are commonly used.
PG's functions return a single value, Stored Procedures return a record set.
This will require some substantial changes to things like pg_tables, to
support what are effectively
'virtual