Achilleas Mantzios <achill@xxxxxxxxxxxxxxxxxxxxx> wrote: > **** Sunday 30 October 2011 12:34:38 */* Akash Kodibail ******: >> I am using postgresql 8.4.0 Please consider an immediate update to 8.4.9. http://www.postgresql.org/support/versioning >> I have trying to set search path >> the search_path is set only for that session, it is not a >> permanent change that is done. > As superuser > ALTER user username set search_path ... Or set it in the postgresql.conf file. -Kevin -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin