Re: Function with default value not replacing old definition of the function

Поиск
Список
Период
Сортировка
От Dimitri Fontaine
Тема Re: Function with default value not replacing old definition of the function
Дата
Msg-id 15544781-9E39-41EE-B242-5AF7AB99DF53@hi-media.com
обсуждение исходный текст
Ответ на Re: Function with default value not replacing old definition of the function  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Le 11 déc. 08 à 21:23, Tom Lane a écrit :
> It's not that easy to produce a message that wouldn't be annoying
> noise.

Something really amazing in PostgreSQL is the HINTs system in error
messages. Almost all the time thoses messages are focused and helping.
I'd see this warning as a HINT maybe: WARNING: variadic function xxx(int, int[]) already exists HINT: you would rather
notto mask it 

Well, I'm not sure WARNING HINTS are supported, it's more a way to
better explain the idea  than anything else.

The bottom line was that I'm betting DBA would be happy to know and
wouldn't consider it annoying noise, and for the kind of "Please, I
know what I'm doing" DBAs, maybe some kind of warning_level GUC would
be desirable?

> In particular, it's hard to know whether functions in different
> schemas
> would represent a problem or not.

I'd still vote in favor of the NOTICE/WARNING. I know I'd be happy to
have my beloved PostgreSQL being attentive and focused when maybe I'm
not. Even if this time I was.

Regards,
- --
dim




-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (Darwin)

iEYEARECAAYFAklBfT8ACgkQlBXRlnbh1bnCaACfUoRUx+7sADsb13YqQR0PWAho
dKUAoJZCoIzxstAXMRa4VejFkjgdk2jk
=REM9
-----END PGP SIGNATURE-----


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Function with default value not replacing old definition of the function
Следующее
От: Tom Lane
Дата:
Сообщение: Re: benchmarking the query planner