public inbox for [email protected]
help / color / mirror / Atom feedAbout SET SEARCH_PATH
4+ messages / 3 participants
[nested] [flat]
* About SET SEARCH_PATH
@ 2003-09-17 15:05 Christoph Haller <[email protected]>
2003-09-17 20:40 ` Re: About SET SEARCH_PATH Tom Lane <[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 15:05 About SET SEARCH_PATH Christoph Haller <[email protected]>
@ 2003-09-17 20:40 ` Tom Lane <[email protected]>
2003-09-19 14:13 ` Re: About SET SEARCH_PATH Harry Broomhall <[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-17 15:05 About SET SEARCH_PATH Christoph Haller <[email protected]>
2003-09-17 20:40 ` Re: About SET SEARCH_PATH Tom Lane <[email protected]>
@ 2003-09-19 14:13 ` Harry Broomhall <[email protected]>
2003-09-19 16:09 ` Re: About SET SEARCH_PATH 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-17 15:05 About SET SEARCH_PATH Christoph Haller <[email protected]>
2003-09-17 20:40 ` Re: About SET SEARCH_PATH Tom Lane <[email protected]>
2003-09-19 14:13 ` Re: About SET SEARCH_PATH Harry Broomhall <[email protected]>
@ 2003-09-19 16:09 ` Tom Lane <[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