public inbox for [email protected]help / color / mirror / Atom feed
About SET SEARCH_PATH 4+ messages / 3 participants [nested] [flat]
* About SET SEARCH_PATH @ 2003-09-17 15:05 Christoph Haller <[email protected]> 0 siblings, 1 reply; 4+ messages in thread From: Christoph Haller @ 2003-09-17 15:05 UTC (permalink / raw) To: pgsql-docs I'm thinking of introducing schemas within my databases. Reading the doc I've found some stuff which does not seem right. I'm referring to 7.3.4. (1) $PGSQLD/doc/html/functions-misc.html The search path may be altered by a run-time setting. The command to use is SET SEARCH_PATH 'schema'[,'schema']... It should be SET SEARCH_PATH TO schema[,schema]... May be a link to $PGSQLD/doc/html/ddl-schemas.html should be used instead, it has it all right. (2) $PGSQLD/doc/html/sql-set.html This page does not mention the SEARCH_PATH variable at all. Is this intended? Regards, Christoph ^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: About SET SEARCH_PATH @ 2003-09-17 20:40 Tom Lane <[email protected]> parent: Christoph Haller <[email protected]> 0 siblings, 1 reply; 4+ messages in thread From: Tom Lane @ 2003-09-17 20:40 UTC (permalink / raw) To: Christoph Haller <[email protected]>; +Cc: pgsql-docs Christoph Haller <[email protected]> writes: >> The search path may be altered by a run-time setting. >> The command to use is SET SEARCH_PATH 'schema'[,'schema']... > It should be > SET SEARCH_PATH TO schema[,schema]... Actually, you can do it either way: regression=# set search_path TO a,b,c; regression=# set search_path TO 'a','b','c'; although not regression=# set search_path TO 'a,b,c'; ERROR: schema "a,b,c" does not exist This is mainly for legacy reasons (the grammar involved was originally used for DateStyle...). I don't object to documenting primarily the first form, though. > (2) > $PGSQLD/doc/html/sql-set.html > This page does not mention the SEARCH_PATH variable at all. > Is this intended? Yeah; that page only documents SET items that are not in the main list of run-time-configurable parameters. regards, tom lane ^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: About SET SEARCH_PATH @ 2003-09-19 14:13 Harry Broomhall <[email protected]> parent: Tom Lane <[email protected]> 0 siblings, 1 reply; 4+ messages in thread From: Harry Broomhall @ 2003-09-19 14:13 UTC (permalink / raw) To: pgsql-docs On Wed, 17 Sep 2003 16:40:32 -0400, [email protected] (Tom Lane) wrote: >Christoph Haller <[email protected]> writes: >>> The search path may be altered by a run-time setting. >>> The command to use is SET SEARCH_PATH 'schema'[,'schema']... > >> It should be >> SET SEARCH_PATH TO schema[,schema]... > >Actually, you can do it either way: > >regression=# set search_path TO a,b,c; >regression=# set search_path TO 'a','b','c'; > >although not > >regression=# set search_path TO 'a,b,c'; >ERROR: schema "a,b,c" does not exist > But surely not without the 'TO' word, which is how it appears in 6.13 of the User's Guide? Regards, Harry. ^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: About SET SEARCH_PATH @ 2003-09-19 16:09 Tom Lane <[email protected]> parent: Harry Broomhall <[email protected]> 0 siblings, 0 replies; 4+ messages in thread From: Tom Lane @ 2003-09-19 16:09 UTC (permalink / raw) To: [email protected]; +Cc: pgsql-docs Harry Broomhall <[email protected]> writes: > But surely not without the 'TO' word, which is how it appears in > 6.13 of the User's Guide? Right. I see this is already fixed in the 7.4 docs. regards, tom lane ^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2003-09-19 16:09 UTC | newest] Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2003-09-17 15:05 About SET SEARCH_PATH Christoph Haller <[email protected]> 2003-09-17 20:40 ` Tom Lane <[email protected]> 2003-09-19 14:13 ` Harry Broomhall <[email protected]> 2003-09-19 16:09 ` Tom Lane <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox