Hello,
I am using 7.3 and I had to pg_dump a table and then change one of the fields to be able to store varchar(64) instead of 32. The problem came when I had to drop the table to load in the pg_dump.sql file. The table was referenced by a couple of views. So, I had to do a
DROP table tablename CASCADE.
Then postgres gave me these notices:
NOTICE: Drop cascades to rule _RETURN on view view_actor
NOTICE: Drop cascades to view view_actor
NOTICE: Drop cascades to rule _RETURN on view actor_list
NOTICE: Drop cascades to view actor_list
I know what to do about the views, I just have to recreate them. However, what are the rule _RETURNs ?? The problem is that where I work some things are documented and some are not
So, is the rule _RETURN just something to do with all views or am I going to have to ask every developer if they know what it is and just hope they remember making and have the code for it :[
Thanks for your help.
Later
I am using 7.3 and I had to pg_dump a table and then change one of the fields to be able to store varchar(64) instead of 32. The problem came when I had to drop the table to load in the pg_dump.sql file. The table was referenced by a couple of views. So, I had to do a
DROP table tablename CASCADE.
Then postgres gave me these notices:
NOTICE: Drop cascades to rule _RETURN on view view_actor
NOTICE: Drop cascades to view view_actor
NOTICE: Drop cascades to rule _RETURN on view actor_list
NOTICE: Drop cascades to view actor_list
I know what to do about the views, I just have to recreate them. However, what are the rule _RETURNs ?? The problem is that where I work some things are documented and some are not
So, is the rule _RETURN just something to do with all views or am I going to have to ask every developer if they know what it is and just hope they remember making and have the code for it :[
Thanks for your help.
Later