| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
| Cc: | Robert Haas <robertmhaas(at)gmail(dot)com>, Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>, Andrew Dunstan <andrew(at)dunslane(dot)net>, Thom Brown <thombrown(at)gmail(dot)com>, PGSQL Mailing List <pgsql-general(at)postgresql(dot)org>, pgsql-hackers(at)postgresql(dot)org, Craig Ringer <craig(at)postnewspapers(dot)com(dot)au> |
| Subject: | Re: [HACKERS] Updating column on row update |
| Date: | 2009-11-24 19:23:06 |
| Message-ID: | 22147.1259090586@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> writes:
> On Tue, Nov 24, 2009 at 11:34 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>> The point would be to reduce the risk that you're changing the language
>> definition in a surprising way. Extra args would imply that you're
>> trying to install a non-default definition of the language.
> But if you'd installed it that way before, wouldn't you then need the
> arguments this time to have them match?
If you knew you'd installed it that way before, you wouldn't be
executing this command at all. The use-case for commands like this
IMO is scripts that don't know exactly what the database state is.
The use-case for a script that is installing non-default language
parameters into somebody else's database seems pretty darn thin.
I'm not dead set on this by any means. But it seems like it would
help reduce the risk of bad consequences from CREATE OR REPLACE
LANGUAGE.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Bailey | 2009-11-24 19:26:17 | Re: [COMMITTERS] recover deleted records |
| Previous Message | Kevin Grittner | 2009-11-24 19:07:56 | Re: [HACKERS] Updating column on row update |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2009-11-24 19:29:20 | Re: [HACKERS] Updating column on row update |
| Previous Message | Peter Eisentraut | 2009-11-24 19:20:43 | Re: extract('dow', ...) mention |