Index: index.php =================================================================== RCS file: /projects/www/pgadmin3/faq/index.php,v retrieving revision 1.11 retrieving revision 1.12 diff -Lpgadmin3/faq/index.php -Lpgadmin3/faq/index.php -u -w -r1.11 -r1.12 --- pgadmin3/faq/index.php +++ pgadmin3/faq/index.php @@ -10,6 +10,7 @@ A property is disabled on an object I want to edit
User privileges
Foreign key constraints not shown
+Problem after changing column type
ERROR: column "datpath" does not exist
Win9x problems
Query tool hangs on Win9x
@@ -73,6 +74,20 @@ Run the adddepend script, which can be found in the backend's sources contrib/adddepend directory. [AP]


+

Problem after changing column type

+

+After changing a column type in PostgreSQL 7.3 or 7.4, I get errors when executing views or triggers. +I don't see this problem on 8.0 servers. +

+PostgreSQL 7.3 and 7.4 don't support changing the column type by themselves, pgAdmin III changes system tables +directly instead. Under some circumstances, the query plan that was stored when a view or trigger created +containing that column, have to be replanned using the new type information. +

+Currently, pgAdmin III does not recreate depending objects automatically for 7.3 and 7.4 servers; you will +have to do that manually if you encounter execution errors. pgAdmin III V1.3 and later are planned to do +that automatically. This is not necessary on PostgreSQL 8.+ servers, because these versions support altering +a column type instrinsically. +


ERROR: column "datpath" does not exist

I'm using pgAdmin III V1.0.x and try to connect to a PostgreSQL 8.0.x server. I get the message