Is the drop/recreate being done from a stored procedure? When postgres
compiles a procedure it ends up referencing it by it's OID (Object ID).
When you recreate something it'll get a new OID, and so mess up the
proc.
The workaround is to use EXECUTE in your stored proc so it re-evals the
statement.
I believe the same issue can apply to triggers dependent upon the table.
-Steve
On Wed, 2002-08-28 at 10:14, Steve Linabery wrote:
> someone has some ideas anyway. When I try to access the jsp, the bean's
> Connection throws this exception:
> java.sql.SQLException: ERROR: Relation "dw_adcosts" with OID 597084 no
> longer exists