Re: Naive schema questions
От | Nick Barr |
---|---|
Тема | Re: Naive schema questions |
Дата | |
Msg-id | 000f01c443e6$a59c00a0$3202a8c0@webbased10 обсуждение исходный текст |
Ответ на | Naive schema questions (Rory Campbell-Lange <rory@campbell-lange.net>) |
Ответы |
Re: Naive schema questions
|
Список | pgsql-general |
----- Original Message ----- From: "Peter Eisentraut" <peter_e@gmx.net> To: "Rory Campbell-Lange" <rory@campbell-lange.net> Cc: "Postgresql General List" <pgsql-general@postgresql.org> Sent: Thursday, May 27, 2004 1:10 PM Subject: Re: [GENERAL] Naive schema questions > Am Donnerstag, 27. Mai 2004 13:15 schrieb Rory Campbell-Lange: > > I imagined schemas might allow me to globally update functions across a > > database hosting many schemas with the same structure. > > Put your data tables in separate schemas, put the functions in yet another > schema, and then when you connect set the schema search path to "dataschema, > functionschema" (or maybe vice versa). Or when you make the calls in the web app use the following: SELECT function_schema.function1(arg1, arg2); instead of just: SELECT function1(arg1, arg2); But like Peter said have a schema per client/"instance" of your database. Nick
В списке pgsql-general по дате отправления: