pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedpl/PgSQL, variable names in NEW
11+ messages / 6 participants
[nested] [flat]
* pl/PgSQL, variable names in NEW
@ 2008-04-07 11:19 Martin Edlman <edlman@fortech.cz>
2008-04-07 12:11 ` Re: pl/PgSQL, variable names in NEW Pavel Stehule <pavel.stehule@gmail.com>
0 siblings, 1 reply; 11+ messages in thread
From: Martin Edlman @ 2008-04-07 11:19 UTC (permalink / raw)
To: pgsql-sql
Hello,
is it possible to use variables as field names in the NEW record? Let's
suppose I have a varchar attname containg the name of the field and I want
to know a value that field of the NEW record.
Problem is that I get an error 'record "new" has no field "attname"'. Of
course I want to use a value of NEW.author when col.attname = attname =
'author'.
Is there a solution?
Example trigger function. It finds all columns in the table which are
referenced in other tables and checks if the value of the column has
changed. If yes, then invoke some other function. The problem is that the
column name is in the 'col' record and is different during the loop and at
each function call.
CREATE OR REPLACE FUNCTION replace_values() RETURNS trigger AS
$BODY$
DECLARE
col record;
attname varchar;
BEGIN
FOR col IN
SELECT DISTINCT pgaf.attname, pgaf.attnum
FROM pg_constraint, pg_attribute AS pgaf
WHERE pg_constraint.contype = 'f' -- fkey
AND pg_constraint.confrelid = TG_RELID -- table oid
AND pgaf.attrelid = TG_RELID
AND pgaf.attnum = ANY(pg_constraint.confkey) LOOP
attname := col.attname;
IF NEW.attname <> OLD.attname THEN
RAISE NOTICE ' value changed from "%" to "%"', OLD.attname, NEW.attname;
-- INVOKE OTHER FUNCTION
END IF;
END LOOP;
END;
$BODY$
LANGUAGE 'plpgsql' VOLATILE;
--
Martin Edlman
Fortech Ltd.
57001 Litomysl, CZ
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: pl/PgSQL, variable names in NEW
2008-04-07 11:19 pl/PgSQL, variable names in NEW Martin Edlman <edlman@fortech.cz>
@ 2008-04-07 12:11 ` Pavel Stehule <pavel.stehule@gmail.com>
2008-04-08 11:06 ` Re: pl/PgSQL, variable names in NEW Martin Edlman <edlman@fortech.cz>
0 siblings, 1 reply; 11+ messages in thread
From: Pavel Stehule @ 2008-04-07 12:11 UTC (permalink / raw)
To: Martin Edlman <edlman@fortech.cz>; +Cc: pgsql-sql
Hello
no, it's not possible in plpgsql. Please, use plperl or plpython.
Regards
Pavel Stehule
On 07/04/2008, Martin Edlman <edlman@fortech.cz> wrote:
> Hello,
>
> is it possible to use variables as field names in the NEW record?
> Let's suppose I have a varchar attname containg the name of the field and I
> want to know a value that field of the NEW record.
>
> Problem is that I get an error 'record "new" has no field "attname"'. Of
> course I want to use a value of NEW.author when col.attname = attname =
> 'author'.
>
> Is there a solution?
>
> Example trigger function. It finds all columns in the table which are
> referenced in other tables and checks if the value of the column has
> changed. If yes, then invoke some other function. The problem is that the
> column name is in the 'col' record and is different during the loop and at
> each function call.
>
> CREATE OR REPLACE FUNCTION replace_values() RETURNS trigger AS
> $BODY$
> DECLARE
> col record;
> attname varchar;
> BEGIN
> FOR col IN
> SELECT DISTINCT pgaf.attname, pgaf.attnum
> FROM pg_constraint, pg_attribute AS pgaf
> WHERE pg_constraint.contype = 'f' -- fkey
> AND pg_constraint.confrelid = TG_RELID -- table oid
> AND pgaf.attrelid = TG_RELID
> AND pgaf.attnum = ANY(pg_constraint.confkey) LOOP
>
> attname := col.attname;
> IF NEW.attname <> OLD.attname THEN
> RAISE NOTICE ' value changed from "%" to
> "%"', OLD.attname, NEW.attname;
> -- INVOKE OTHER FUNCTION
> END IF;
> END LOOP;
>
> END;
> $BODY$
> LANGUAGE 'plpgsql' VOLATILE;
>
> --
> Martin Edlman
> Fortech Ltd.
> 57001 Litomysl, CZ
>
> --
> Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql
>
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: pl/PgSQL, variable names in NEW
2008-04-07 11:19 pl/PgSQL, variable names in NEW Martin Edlman <edlman@fortech.cz>
2008-04-07 12:11 ` Re: pl/PgSQL, variable names in NEW Pavel Stehule <pavel.stehule@gmail.com>
@ 2008-04-08 11:06 ` Martin Edlman <edlman@fortech.cz>
2008-04-08 13:21 ` Re: pl/PgSQL, variable names in NEW Alvaro Herrera <alvherre@commandprompt.com>
0 siblings, 1 reply; 11+ messages in thread
From: Martin Edlman @ 2008-04-08 11:06 UTC (permalink / raw)
To: pgsql-sql
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hello,
| no, it's not possible in plpgsql. Please, use plperl or plpython.
thanks for the response. It's as I expected and was afraid of :-(
I select data from DB using pl/PgSQL in the replace_values trigger and
then call plPerl function which returns value from NEW and OLD. The
problem is that as I need to pass NEW and OLD to the Perl function I get
error message "no function matching get_value(x_lokalita, name)" as NEW
and OLD are records of table x_lokalita.
My plPerl function is declared as get_value(record, name). Is it
possible to cast table record type "x_lokalita" to generic type
"record"? (NEW::record doesn't work!)
I call the trigger replace_values() on several tables so I don't know
the record type. Do I have to create get_value() for each table, eg.
get_value(x_lokalita, name)?
I don't want to rewrite whole trigger to plPerl as I would have to use
DBD-PgSPI.
CREATE OR REPLACE FUNCTION get_value(record, name) RETURNS character
varying AS $BODY$
my($rec, $col) = @_;
return $rec->{$col};
$BODY$ LANGUAGE 'plperl' VOLATILE;
CREATE OR REPLACE FUNCTION replace_values() RETURNS "trigger" AS $BODY$
-- code with SQL queries
-- ...
newval := get_value(NEW, col.attname);
oldval := get_value(OLD, col.attname);
IF newval <> oldval THEN
-- call other functions
END IF;
-- code
RETURN NEW;
END;
$BODY$ LANGUAGE 'plpgsql' VOLATILE;
| On 07/04/2008, Martin Edlman <edlman@fortech.cz> wrote:
|> Hello,
|>
|> is it possible to use variables as field names in the NEW record?
|> Let's suppose I have a varchar attname containg the name of the field
and I
|> want to know a value that field of the NEW record.
|>
|> Problem is that I get an error 'record "new" has no field "attname"'. Of
|> course I want to use a value of NEW.author when col.attname = attname =
|> 'author'.
|>
|> Is there a solution?
|>
|> Example trigger function. It finds all columns in the table which are
|> referenced in other tables and checks if the value of the column has
|> changed. If yes, then invoke some other function. The problem is that the
|> column name is in the 'col' record and is different during the loop
and at
|> each function call.
|>
|> CREATE OR REPLACE FUNCTION replace_values() RETURNS trigger AS
|> $BODY$
|> DECLARE
|> col record;
|> attname varchar;
|> BEGIN
|> FOR col IN
|> SELECT DISTINCT pgaf.attname, pgaf.attnum
|> FROM pg_constraint, pg_attribute AS pgaf
|> WHERE pg_constraint.contype = 'f' -- fkey
|> AND pg_constraint.confrelid = TG_RELID -- table oid
|> AND pgaf.attrelid = TG_RELID
|> AND pgaf.attnum = ANY(pg_constraint.confkey) LOOP
|>
|> attname := col.attname;
|> IF NEW.attname <> OLD.attname THEN
|> RAISE NOTICE ' value changed from "%" to
|> "%"', OLD.attname, NEW.attname;
|> -- INVOKE OTHER FUNCTION
|> END IF;
|> END LOOP;
|>
|> END;
|> $BODY$
|> LANGUAGE 'plpgsql' VOLATILE;
|>
|> --
|> Martin Edlman
|> Fortech Ltd.
|> 57001 Litomysl, CZ
|>
|> --
|> Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
|> To make changes to your subscription:
|> http://www.postgresql.org/mailpref/pgsql-sql
|>
- --
S pozdravem,
Martin Edlman
Fortech, spol. s r.o,
Ropkova 51, 57001 Litomyšl
Public GPG key: http://edas.visaci.cz/#gpgkeys
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.7 (GNU/Linux)
Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org
iD8DBQFH+1HHqmMakYm+VJ8RAn8qAKCRNAxBjv3kIQ5eCMkH/OkWshNEqACfYI0L
oN4Gbz6cuoqRuZN1yl4DMew=
=NM+K
-----END PGP SIGNATURE-----
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: pl/PgSQL, variable names in NEW
2008-04-07 11:19 pl/PgSQL, variable names in NEW Martin Edlman <edlman@fortech.cz>
2008-04-07 12:11 ` Re: pl/PgSQL, variable names in NEW Pavel Stehule <pavel.stehule@gmail.com>
2008-04-08 11:06 ` Re: pl/PgSQL, variable names in NEW Martin Edlman <edlman@fortech.cz>
@ 2008-04-08 13:21 ` Alvaro Herrera <alvherre@commandprompt.com>
2008-04-10 11:34 ` Re: pl/PgSQL, variable names in NEW Martin Edlman <edlman@fortech.cz>
0 siblings, 1 reply; 11+ messages in thread
From: Alvaro Herrera @ 2008-04-08 13:21 UTC (permalink / raw)
To: Martin Edlman <edlman@fortech.cz>; +Cc: 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
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: pl/PgSQL, variable names in NEW
2008-04-07 11:19 pl/PgSQL, variable names in NEW Martin Edlman <edlman@fortech.cz>
2008-04-07 12:11 ` Re: pl/PgSQL, variable names in NEW Pavel Stehule <pavel.stehule@gmail.com>
2008-04-08 11:06 ` Re: pl/PgSQL, variable names in NEW Martin Edlman <edlman@fortech.cz>
2008-04-08 13:21 ` Re: pl/PgSQL, variable names in NEW Alvaro Herrera <alvherre@commandprompt.com>
@ 2008-04-10 11:34 ` Martin Edlman <edlman@fortech.cz>
2008-04-10 13:16 ` Re: [SQL] pl/PgSQL, variable names in NEW Alvaro Herrera <alvherre@commandprompt.com>
0 siblings, 1 reply; 11+ messages in thread
From: Martin Edlman @ 2008-04-10 11:34 UTC (permalink / raw)
To: pgsql-sql
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
|> 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.
Thanks.
Martin
- --
Regards,
Martin Edlman
Fortech, spol. s r.o,
Ropkova 51, 57001 Litomyšl
Public GPG key: http://edas.visaci.cz/#gpgkeys
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.7 (GNU/Linux)
Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org
iD8DBQFH/fstqmMakYm+VJ8RAjLSAKCW4rqz2w1CaND8/BxAxLcOlwwziQCgjxsA
PAAPqST5r5St08OgJsVkVK4=
=ZUKV
-----END PGP SIGNATURE-----
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: [SQL] pl/PgSQL, variable names in NEW
2008-04-07 11:19 pl/PgSQL, variable names in NEW Martin Edlman <edlman@fortech.cz>
2008-04-07 12:11 ` Re: pl/PgSQL, variable names in NEW Pavel Stehule <pavel.stehule@gmail.com>
2008-04-08 11:06 ` Re: pl/PgSQL, variable names in NEW Martin Edlman <edlman@fortech.cz>
2008-04-08 13:21 ` Re: pl/PgSQL, variable names in NEW Alvaro Herrera <alvherre@commandprompt.com>
2008-04-10 11:34 ` Re: pl/PgSQL, variable names in NEW Martin Edlman <edlman@fortech.cz>
@ 2008-04-10 13:16 ` Alvaro Herrera <alvherre@commandprompt.com>
2008-04-10 14:45 ` Re: [HACKERS] [SQL] pl/PgSQL, variable names in NEW Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 11+ messages in thread
From: Alvaro Herrera @ 2008-04-10 13:16 UTC (permalink / raw)
To: Martin Edlman <edlman@fortech.cz>; +Cc: pgsql-sql@postgresql.org, Pg Hackers <pgsql-hackers@postgresql.org>; Pg Docs <pgsql-docs@postgresql.org>; andrew@dunslane.net
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
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: [HACKERS] [SQL] pl/PgSQL, variable names in NEW
2008-04-07 11:19 pl/PgSQL, variable names in NEW Martin Edlman <edlman@fortech.cz>
2008-04-07 12:11 ` Re: pl/PgSQL, variable names in NEW Pavel Stehule <pavel.stehule@gmail.com>
2008-04-08 11:06 ` Re: pl/PgSQL, variable names in NEW Martin Edlman <edlman@fortech.cz>
2008-04-08 13:21 ` Re: pl/PgSQL, variable names in NEW Alvaro Herrera <alvherre@commandprompt.com>
2008-04-10 11:34 ` Re: pl/PgSQL, variable names in NEW Martin Edlman <edlman@fortech.cz>
2008-04-10 13:16 ` Re: [SQL] pl/PgSQL, variable names in NEW Alvaro Herrera <alvherre@commandprompt.com>
@ 2008-04-10 14:45 ` Tom Lane <tgl@sss.pgh.pa.us>
2008-04-10 14:51 ` Re: [HACKERS] [SQL] pl/PgSQL, variable names in NEW Joshua D. Drake <jd@commandprompt.com>
0 siblings, 1 reply; 11+ messages in thread
From: Tom Lane @ 2008-04-10 14:45 UTC (permalink / raw)
To: Alvaro Herrera <alvherre@commandprompt.com>; +Cc: Martin Edlman <edlman@fortech.cz>; pgsql-sql@postgresql.org, Pg Hackers <pgsql-hackers@postgresql.org>; Pg Docs <pgsql-docs@postgresql.org>; andrew@dunslane.net
Alvaro Herrera <alvherre@commandprompt.com> writes:
> Question for plperl hackers: Should we remove the mention of DBD::PgSPI
> from the PL/Perl manual?
It seems like a reasonable suggestion to me, since perl database users
probably already know DBD and don't have to learn something new if they
go that way.
Possibly the text should be reworded, with the mention of DBD::PgSPI put
somewhere else or stuck into a <note> or something.
regards, tom lane
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: [HACKERS] [SQL] pl/PgSQL, variable names in NEW
2008-04-07 11:19 pl/PgSQL, variable names in NEW Martin Edlman <edlman@fortech.cz>
2008-04-07 12:11 ` Re: pl/PgSQL, variable names in NEW Pavel Stehule <pavel.stehule@gmail.com>
2008-04-08 11:06 ` Re: pl/PgSQL, variable names in NEW Martin Edlman <edlman@fortech.cz>
2008-04-08 13:21 ` Re: pl/PgSQL, variable names in NEW Alvaro Herrera <alvherre@commandprompt.com>
2008-04-10 11:34 ` Re: pl/PgSQL, variable names in NEW Martin Edlman <edlman@fortech.cz>
2008-04-10 13:16 ` Re: [SQL] pl/PgSQL, variable names in NEW Alvaro Herrera <alvherre@commandprompt.com>
2008-04-10 14:45 ` Re: [HACKERS] [SQL] pl/PgSQL, variable names in NEW Tom Lane <tgl@sss.pgh.pa.us>
@ 2008-04-10 14:51 ` Joshua D. Drake <jd@commandprompt.com>
2008-04-10 14:56 ` Re: [HACKERS] [SQL] pl/PgSQL, variable names in NEW Andrew Dunstan <andrew@dunslane.net>
2008-04-10 14:58 ` Re: [HACKERS] [SQL] pl/PgSQL, variable names in NEW Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 2 replies; 11+ messages in thread
From: Joshua D. Drake @ 2008-04-10 14:51 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: Alvaro Herrera <alvherre@commandprompt.com>; Martin Edlman <edlman@fortech.cz>; pgsql-sql@postgresql.org, Pg Hackers <pgsql-hackers@postgresql.org>; Pg Docs <pgsql-docs@postgresql.org>; andrew@dunslane.net
On Thu, 10 Apr 2008 10:45:25 -0400
Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Alvaro Herrera <alvherre@commandprompt.com> writes:
> > Question for plperl hackers: Should we remove the mention of
> > DBD::PgSPI from the PL/Perl manual?
>
> It seems like a reasonable suggestion to me, since perl database users
> probably already know DBD and don't have to learn something new if
> they go that way.
>
> Possibly the text should be reworded, with the mention of DBD::PgSPI
> put somewhere else or stuck into a <note> or something.
From what I can see on CPAN (unless I am missing something) DBD::PgSPI
hasn't been updated since 2004 and is at version 0.2.
http://www.cpan.org/modules/by-module/DBD/
I think it can safely be removed in entirety from our manuals.
Sincerely,
Joshua D. Drake
--
The PostgreSQL Company since 1997: http://www.commandprompt.com/
PostgreSQL Community Conference: http://www.postgresqlconference.org/
United States PostgreSQL Association: http://www.postgresql.us/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: [HACKERS] [SQL] pl/PgSQL, variable names in NEW
2008-04-07 11:19 pl/PgSQL, variable names in NEW Martin Edlman <edlman@fortech.cz>
2008-04-07 12:11 ` Re: pl/PgSQL, variable names in NEW Pavel Stehule <pavel.stehule@gmail.com>
2008-04-08 11:06 ` Re: pl/PgSQL, variable names in NEW Martin Edlman <edlman@fortech.cz>
2008-04-08 13:21 ` Re: pl/PgSQL, variable names in NEW Alvaro Herrera <alvherre@commandprompt.com>
2008-04-10 11:34 ` Re: pl/PgSQL, variable names in NEW Martin Edlman <edlman@fortech.cz>
2008-04-10 13:16 ` Re: [SQL] pl/PgSQL, variable names in NEW Alvaro Herrera <alvherre@commandprompt.com>
2008-04-10 14:45 ` Re: [HACKERS] [SQL] pl/PgSQL, variable names in NEW Tom Lane <tgl@sss.pgh.pa.us>
2008-04-10 14:51 ` Re: [HACKERS] [SQL] pl/PgSQL, variable names in NEW Joshua D. Drake <jd@commandprompt.com>
@ 2008-04-10 14:56 ` Andrew Dunstan <andrew@dunslane.net>
1 sibling, 0 replies; 11+ messages in thread
From: Andrew Dunstan @ 2008-04-10 14:56 UTC (permalink / raw)
To: Joshua D. Drake <jd@commandprompt.com>; +Cc: Tom Lane <tgl@sss.pgh.pa.us>; Alvaro Herrera <alvherre@commandprompt.com>; Martin Edlman <edlman@fortech.cz>; pgsql-sql@postgresql.org, Pg Hackers <pgsql-hackers@postgresql.org>; Pg Docs <pgsql-docs@postgresql.org>
Joshua D. Drake wrote:
> On Thu, 10 Apr 2008 10:45:25 -0400
> Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
>
>> Alvaro Herrera <alvherre@commandprompt.com> writes:
>>
>>> Question for plperl hackers: Should we remove the mention of
>>> DBD::PgSPI from the PL/Perl manual?
>>>
>> It seems like a reasonable suggestion to me, since perl database users
>> probably already know DBD and don't have to learn something new if
>> they go that way.
>>
>> Possibly the text should be reworded, with the mention of DBD::PgSPI
>> put somewhere else or stuck into a <note> or something.
>>
>
> From what I can see on CPAN (unless I am missing something) DBD::PgSPI
> hasn't been updated since 2004 and is at version 0.2.
>
> http://www.cpan.org/modules/by-module/DBD/
>
> I think it can safely be removed in entirety from our manuals.
>
>
>
+1. It's also GNU licensed, so we can't include it. A clean room BSD
licensed implementation would be a nice addition, but it really doesn't
buy you much in functionality that you don't already have.
cheers
andrew
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: [HACKERS] [SQL] pl/PgSQL, variable names in NEW
2008-04-07 11:19 pl/PgSQL, variable names in NEW Martin Edlman <edlman@fortech.cz>
2008-04-07 12:11 ` Re: pl/PgSQL, variable names in NEW Pavel Stehule <pavel.stehule@gmail.com>
2008-04-08 11:06 ` Re: pl/PgSQL, variable names in NEW Martin Edlman <edlman@fortech.cz>
2008-04-08 13:21 ` Re: pl/PgSQL, variable names in NEW Alvaro Herrera <alvherre@commandprompt.com>
2008-04-10 11:34 ` Re: pl/PgSQL, variable names in NEW Martin Edlman <edlman@fortech.cz>
2008-04-10 13:16 ` Re: [SQL] pl/PgSQL, variable names in NEW Alvaro Herrera <alvherre@commandprompt.com>
2008-04-10 14:45 ` Re: [HACKERS] [SQL] pl/PgSQL, variable names in NEW Tom Lane <tgl@sss.pgh.pa.us>
2008-04-10 14:51 ` Re: [HACKERS] [SQL] pl/PgSQL, variable names in NEW Joshua D. Drake <jd@commandprompt.com>
@ 2008-04-10 14:58 ` Tom Lane <tgl@sss.pgh.pa.us>
2008-04-10 15:21 ` Re: [HACKERS] [SQL] pl/PgSQL, variable names in NEW Alvaro Herrera <alvherre@commandprompt.com>
1 sibling, 1 reply; 11+ messages in thread
From: Tom Lane @ 2008-04-10 14:58 UTC (permalink / raw)
To: Joshua D. Drake <jd@commandprompt.com>; +Cc: Alvaro Herrera <alvherre@commandprompt.com>; Martin Edlman <edlman@fortech.cz>; pgsql-sql@postgresql.org, Pg Hackers <pgsql-hackers@postgresql.org>; Pg Docs <pgsql-docs@postgresql.org>; andrew@dunslane.net
"Joshua D. Drake" <jd@commandprompt.com> writes:
> From what I can see on CPAN (unless I am missing something) DBD::PgSPI
> hasn't been updated since 2004 and is at version 0.2.
Oh, if it's not a live project then that changes things entirely.
+1 for just dropping the mention.
regards, tom lane
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: [HACKERS] [SQL] pl/PgSQL, variable names in NEW
2008-04-07 11:19 pl/PgSQL, variable names in NEW Martin Edlman <edlman@fortech.cz>
2008-04-07 12:11 ` Re: pl/PgSQL, variable names in NEW Pavel Stehule <pavel.stehule@gmail.com>
2008-04-08 11:06 ` Re: pl/PgSQL, variable names in NEW Martin Edlman <edlman@fortech.cz>
2008-04-08 13:21 ` Re: pl/PgSQL, variable names in NEW Alvaro Herrera <alvherre@commandprompt.com>
2008-04-10 11:34 ` Re: pl/PgSQL, variable names in NEW Martin Edlman <edlman@fortech.cz>
2008-04-10 13:16 ` Re: [SQL] pl/PgSQL, variable names in NEW Alvaro Herrera <alvherre@commandprompt.com>
2008-04-10 14:45 ` Re: [HACKERS] [SQL] pl/PgSQL, variable names in NEW Tom Lane <tgl@sss.pgh.pa.us>
2008-04-10 14:51 ` Re: [HACKERS] [SQL] pl/PgSQL, variable names in NEW Joshua D. Drake <jd@commandprompt.com>
2008-04-10 14:58 ` Re: [HACKERS] [SQL] pl/PgSQL, variable names in NEW Tom Lane <tgl@sss.pgh.pa.us>
@ 2008-04-10 15:21 ` Alvaro Herrera <alvherre@commandprompt.com>
0 siblings, 0 replies; 11+ messages in thread
From: Alvaro Herrera @ 2008-04-10 15:21 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: Joshua D. Drake <jd@commandprompt.com>; Martin Edlman <edlman@fortech.cz>; pgsql-sql@postgresql.org, Pg Hackers <pgsql-hackers@postgresql.org>; Pg Docs <pgsql-docs@postgresql.org>; andrew@dunslane.net
Tom Lane wrote:
> "Joshua D. Drake" <jd@commandprompt.com> writes:
> > From what I can see on CPAN (unless I am missing something) DBD::PgSPI
> > hasn't been updated since 2004 and is at version 0.2.
>
> Oh, if it's not a live project then that changes things entirely.
> +1 for just dropping the mention.
Done.
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
^ permalink raw reply [nested|flat] 11+ messages in thread
end of thread, other threads:[~2008-04-10 15:21 UTC | newest]
Thread overview: 11+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-04-07 11:19 pl/PgSQL, variable names in NEW Martin Edlman <edlman@fortech.cz>
2008-04-07 12:11 ` Pavel Stehule <pavel.stehule@gmail.com>
2008-04-08 11:06 ` Martin Edlman <edlman@fortech.cz>
2008-04-08 13:21 ` Alvaro Herrera <alvherre@commandprompt.com>
2008-04-10 11:34 ` Martin Edlman <edlman@fortech.cz>
2008-04-10 13:16 ` Alvaro Herrera <alvherre@commandprompt.com>
2008-04-10 14:45 ` Tom Lane <tgl@sss.pgh.pa.us>
2008-04-10 14:51 ` Joshua D. Drake <jd@commandprompt.com>
2008-04-10 14:56 ` Andrew Dunstan <andrew@dunslane.net>
2008-04-10 14:58 ` Tom Lane <tgl@sss.pgh.pa.us>
2008-04-10 15:21 ` Alvaro Herrera <alvherre@commandprompt.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox