Naming conventions for lots of stored procedures

Поиск
Список
Период
Сортировка
От Chris Travers
Тема Naming conventions for lots of stored procedures
Дата
Msg-id 5ed37b141003101716h1e8e4dc8s5749ffd1ec285c7e@mail.gmail.com
обсуждение исходный текст
Ответы Re: Naming conventions for lots of stored procedures  (Justin Graf <justin@magwerks.com>)
Список pgsql-general
Hi all;

One of my applications currently has over 60 stored procedures and
future versions will likely have several hundred.  I am wondering what
folks find to be helpful naming conventions for managing a large
number of stored procedures.  We tried using double underscores to
separate module vs procedure names and that just became a mess.  I
have found a few possible separators that might possibly work but they
are aesthetically revolting (_$ for example, like select
test_$echo(1);).

I can't imagine I am the first person to run up against this problem
and would rather ask advice of more experienced folks then to wander
from one maintenance headache into a possibly far worse one.

So, what are approaches each of you have taken in the past?

Best Wishes,
Chris Travers

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

Предыдущее
От: Amol Chiplunkar
Дата:
Сообщение: crosstab functionality for postgres 8.1.4
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: log_statement and syslog severity