Fw: Priority against catalog
От | Cristian Custodio |
---|---|
Тема | Fw: Priority against catalog |
Дата | |
Msg-id | 002601c2d211$a4036c80$fb01a8c0@ttcristian обсуждение исходный текст |
Список | pgsql-general |
Tom, I was doing this way: set search_path = myschema; without pg_catalog; Thanks, thanks, thanks, thanks..... its very nice Cristian ----- Original Message ----- From: "Tom Lane" <tgl@sss.pgh.pa.us> To: "Cristian Custodio" <crstian@terra.com.br> Cc: <pgsql-general@postgresql.org> Sent: Tuesday, February 11, 2003 2:09 PM Subject: Re: Fw: [GENERAL] Priority against catalog "Cristian Custodio" <crstian@terra.com.br> writes: > Thanks for your answer, but I already did this. > Don't you would have another sugestion? It works for me, what are you doing differently? regression=# create schema myschema; CREATE SCHEMA regression=# create function myschema.version() returns text as ' regression'# select ''hello there''::text;' language sql; CREATE FUNCTION regression=# select version(); version ------------------------------------------------------------------ PostgreSQL 7.4devel on hppa-hp-hpux10.20, compiled by GCC 2.95.3 (1 row) regression=# set search_path = myschema, pg_catalog; SET regression=# select version(); version ------------- hello there (1 row) regression=# Try looking at "show search_path" and "select current_schemas(true)" to see what's going on. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
В списке pgsql-general по дате отправления: