Search Postgresql Archives

Re: Row ordering after CREATE TABLE AS...SELECT regexp_split_to_table(source_text, regexp) AS new_column

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



John Gage wrote:

> Unfortunately, it prompts a new question.  I am using 8.4.2 which I
> assume is new enough to trigger a "yes" response to "If you have a
> version new enough to have synchronize_seqscans...".  I have
> absolutely no idea how to turn that off.  Perhaps the best thing
> would be to direct me to the documentation where turning it off is
> described so that I can become more autonomous.  However,
> accompanying that with explicit directions would be welcome too.

See postgresql.conf, but you probably want to leave it turned on in
general and turn it off only for the specific case of this usage.
(Using the SET command, or ALTER ROLE, or ALTER DATABASE).

See here 
http://www.postgresql.org/docs/8.4/static/runtime-config-compatible.html#RUNTIME-CONFIG-COMPATIBLE-VERSION

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux