Re: [HACKERS] Loading 7.4 dump to 8.1 with user-custom search_path

2005-11-17 Thread Christopher Kings-Lynne
[EMAIL PROTECTED]:08]~:90>grep search_path fritz-20051106.sql ALTER USER decibel SET search_path TO 'decibel, rrs, rrd, page_log, public'; Trying that command in psql... decibel=# ALTER USER decibel SET search_path TO 'decibel, rrs, rrd, page_log, public'; NOTICE: schema "decibel, rrs, rrd, pag

[HACKERS] Loading 7.4 dump to 8.1 with user-custom search_path breaks

2005-11-17 Thread Jim C. Nasby
>From a 7.4 dump: [EMAIL PROTECTED]:08]~:90>grep search_path fritz-20051106.sql ALTER USER decibel SET search_path TO 'decibel, rrs, rrd, page_log, public'; Trying that command in psql... decibel=# ALTER USER decibel SET search_path TO 'decibel, rrs, rrd, page_log, public'; NOTICE: schema "deci