On Sep 28, 2005, at 3:36 AM, Partners - Majolee InfoTech wrote:
now at a different machine we are trying to restore but the plpgsql functions are having $_$ after "as" and after "end;". This is causing errors while restoring. Do anyone know how to get rid of this easily.
Dollar quoting was not implemented until PostgreSQL 8.0. Are you trying to restore to an earlier version? If so you have to change the $_$ to single quotes and then appropriately escape any quotes in the function body.
John DeSoi, Ph.D. http://pgedit.com/ Power Tools for PostgreSQL ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
