Re: [SQL] pl/PgSQL, variable names in NEW

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Martin Edlman <edlman(at)fortech(dot)cz>
Cc: pgsql-sql(at)postgresql(dot)org, Pg Hackers <pgsql-hackers(at)postgresql(dot)org>, Pg Docs <pgsql-docs(at)postgresql(dot)org>, andrew(at)dunslane(dot)net
Subject: Re: [SQL] pl/PgSQL, variable names in NEW
Date: 2008-04-10 13:16:02
Message-ID: 20080410131602.GF4697@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs pgsql-hackers pgsql-sql

Martin Edlman wrote:

> |> I don't want to rewrite whole trigger to plPerl as I would have to use
> |> DBD-PgSPI.
> |
> | Huh? Certainly not -- there are functions in PL/Perl for this. See
> | spi_exec_query in
> | http://www.postgresql.org/docs/8.3/static/plperl-database.html
>
> Oh, I see. I have read the doc "...can be done via the function
> spi_exec_query described below, or via an experimental module
> DBD::PgSPI...", but missed the "OR" and thought that DBD::PgSPI is
> mandatory.

Yeah, that's a bit confusing. I don't know why we have a mention of
DBD::PgSPI on the plperl manual at all. Is there anything it can do
that can't be done with PL/Perl native calls?

Question for plperl hackers: Should we remove the mention of DBD::PgSPI
from the PL/Perl manual?

--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Alvaro Herrera 2008-04-10 13:35:56 Re: Patch for pg_backend_pid
Previous Message Martin Edlman 2008-04-10 11:34:06 Re: pl/PgSQL, variable names in NEW

Browse pgsql-hackers by date

  From Date Subject
Next Message Gregory Stark 2008-04-10 13:24:34 Re: Separate psql commands from arguments
Previous Message Alvaro Herrera 2008-04-10 13:00:16 Re: Commit fest queue

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2008-04-10 14:45:25 Re: [HACKERS] [SQL] pl/PgSQL, variable names in NEW
Previous Message Volkan YAZICI 2008-04-10 12:37:13 Re: dateformat issue