From:
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To:
Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk>
Cc:
Dimitri Fontaine <dfontaine(at)hi-media(dot)com>, Dave Page <dpage(at)pgadmin(dot)org>,
Robert Haas <robertmhaas(at)gmail(dot)com>,
Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>,
pgsql-hackers(at)postgresql(dot)org
Subject:
Re: contrib function naming, and upgrade issues
Date:
2009-03-23 23:10:32
Message-ID:
4635.1237849832@sss.pgh.pa.us (view raw or flat )
Thread:
2009-03-21 01:57:05 from Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk>
2009-03-21 02:42:29 from Robert Haas <robertmhaas(at)gmail(dot)com>
2009-03-21 04:38:01 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-03-21 13:05:35 from Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk>
2009-03-21 13:22:15 from Martijn van Oosterhout <kleptog(at)svana(dot)org>
2009-03-21 16:27:27 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-03-22 01:34:37 from Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
2009-03-22 01:49:18 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-03-22 03:55:54 from Robert Haas <robertmhaas(at)gmail(dot)com>
2009-03-22 11:54:15 from Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk>
2009-03-22 13:29:45 from Dave Page <dpage(at)pgadmin(dot)org>
2009-03-22 14:42:58 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2009-03-22 20:27:20 from Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
2009-03-22 21:05:01 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-03-22 21:27:04 from Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
2009-03-22 21:46:20 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-03-22 22:15:30 from Guillaume Smet <guillaume(dot)smet(at)gmail(dot)com>
2009-03-23 08:41:48 from Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
2009-03-23 14:43:04 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-03-23 17:44:14 from Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
2009-03-23 20:34:11 from Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk>
2009-03-23 23:10:32 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-03-23 03:05:04 from Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk>
2009-03-23 08:51:17 from Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
2009-03-23 01:40:35 from Robert Haas <robertmhaas(at)gmail(dot)com>
2009-03-23 02:25:40 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-03-23 02:40:31 from Robert Haas <robertmhaas(at)gmail(dot)com>
2009-03-23 03:11:08 from Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk>
2009-03-23 03:26:03 from Greg Stark <greg(dot)stark(at)enterprisedb(dot)com>
2009-03-23 11:34:31 from Robert Haas <robertmhaas(at)gmail(dot)com>
2009-03-23 11:46:52 from Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
2009-03-23 19:33:00 from Robert Haas <robertmhaas(at)gmail(dot)com>
2009-03-23 20:11:49 from Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
2009-03-24 08:24:49 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
2009-03-25 12:12:47 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2009-03-22 11:42:49 from Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk>
2009-03-22 13:48:02 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2009-03-23 02:57:47 from Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk>
2009-03-22 20:16:59 from Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
2009-03-23 03:03:12 from Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk>
2009-03-22 11:09:27 from Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk>
2009-03-21 09:13:39 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2009-03-21 12:25:21 from Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk>
Lists:
pgsql-hackers
Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk> writes:
> "Tom" == Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:
> Tom> A defining SQL script is the way to go.
> But I disagree with this, for the simple reason that we don't have
> anything like enough flexibility in the form of conditional DDL or
> error handling, when working in pure SQL without any procedural help.
So? You can have the script create, execute, and remove a function,
and thereby perform any operation that a function could possibly
perform for you.
regards, tom lane
In response to
pgsql-hackers by date
Next :From: Greg SmithDate: 2009-03-23 23:15:35
Subject : Resetting cluster-wide statistics
Previous :From : Jeff DavisDate : 2009-03-23 22:59:45
Subject : Re: GIN fast-insert vs autovacuum scheduling