Here's the error in the postgres log files
ERROR: cannot change return type of existing function
HINT: Use DROP FUNCTION first?
Here's the error as displayed from step02.php
+----------------------------------------------------------------------------------------------------------------+
| MySource Error |
|----------------------------------------------------------------------------------------------------------------|
| [ASSERT EXCEPTION] DB Error: unknown error |
| -- returns the parent treeids for the specified assetid |
| -- if timestamp is null then the function will assume that we are not in rollback mode |
| -- if the timestamp is valid the function will return the treeids from the rollback tables |
| CREATE OR REPLACE FUNCTION sq_get_parent_treeids(VARCHAR, INT, TIMESTAMP) RETURNS SETOF BYTEA AS ' |
| DECLARE |
| treeids RECORD; |
| offset int; |
| minorid ALIAS FOR $1; |
| next_treeid BYTEA; |
| concat_treeids BYTEA; |
| SQ_TREE_BASE_SIZE ALIAS FOR $2; |
| rb_date ALIAS FOR $3; |
| table_prefix VARCHAR; |
| sql VARCHAR; |
| BEGIN |
| IF rb_date IS NULL THEN |
| table_prefix := ''sq_''; |
| ELSE |
| table_prefix := ''sq_rb_''; |
| END IF; |
| |
| sql := ''SELECT treeid FROM '' || table_prefix || |
+----------------------------------------------------------------------------------------------------------------+Thnaks...John.
)