Hello,
Thursday, August 13, 2009, 2:38:02 AM, you wrote:
JM> I am also getting repeated sudden program terminations. My
JM> environment is Windows Server 2003 Native Japanese OS. Postgresql
JM> 8.4. Pgadmin III 1.10. Often after just having added a column, the
JM> program terminates. In all cases
When I'm doing heavy development I'm always removing and recreating
tables and views.
If you
- drop a view
- create a view with the same name
- and have the data window for the view open from before it was dropped
- and do a refresh
You lose the column names, since the oid for the view/table is
If you
- have a query window open
- and you're editing a function definition, or trigger
- execute the query, and update/replace the function or trigger, or
type. or table, or any other object
- and then later right click on the object and do 'create script'
you'll get the old data that was cac
