Index: openacs-4/packages/acs-core-docs/www/xml/developers-guide/tutorial-db.xml =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-core-docs/www/xml/developers-guide/tutorial-db.xml,v diff -u -N -r1.16 -r1.17 --- openacs-4/packages/acs-core-docs/www/xml/developers-guide/tutorial-db.xml 17 Jul 2006 05:38:37 -0000 1.16 +++ openacs-4/packages/acs-core-docs/www/xml/developers-guide/tutorial-db.xml 17 Jul 2006 07:38:45 -0000 1.17 @@ -80,7 +80,7 @@ (like the creation script the drop script calls a PL/pgSQL function: content_type__drop_type Run the create script manually to add your tables and functions. - [$OPENACS_SERVICE_NAME postgresql]$ psql -f myfirstpackage-create.sql + [$OPENACS_SERVICE_NAME postgresql]$ psql service0 -f myfirstpackage-create.sql psql:myfirstpackage-create.sql:15: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'mfp_notes_pkey' for table 'mfp_notes' psql:myfirstpackage-create.sql:15: NOTICE: CREATE TABLE will create implicit trigger(s) for FOREIGN KEY check(s) content_type__create_type @@ -91,7 +91,7 @@ [$OPENACS_SERVICE_NAME postgresql]$ If there are errors, use them to debug the sql file and try again. If there are errors in the database table creation, you may need to run the drop script to drop the table so that you can recreate it. The drop script will probably have errors since some of the things it's trying to drop may be missing. They can be ignored. Once you get the same output as shown above, test the drop script: - [$OPENACS_SERVICE_NAME postgresql]$ psql -f myfirstpackage-drop.sql + [$OPENACS_SERVICE_NAME postgresql]$ psql service0 -f myfirstpackage-drop.sql content_type__drop_type ------------------------- @@ -100,6 +100,6 @@ [$OPENACS_SERVICE_NAME postgresql]$ Once both scripts are working without errors, run the create script one last time and proceed. - [$OPENACS_SERVICE_NAME postgresql]$ psql -f myfirstpackage-create.sql + [$OPENACS_SERVICE_NAME postgresql]$ psql service0 -f myfirstpackage-create.sql