acardona/CATMAID — Issue #119: install example-projects.sql fails 
Author: kotowicz
Created: 2011-10-12 12:34:30+00:00
State: open

following the install guide, I try to prepopulate the database with the shipped example-projects.sql file. Unfortunately I get a lot of error messages:

```
$ psql -U catmaid_user catmaid < docs/example-projects.sql
Can't exec "dpkg-architecture": No such file or directory at /usr/bin/psql line 103.
Use of uninitialized value $multiarch in scalar chomp at /usr/bin/psql line 104.
Password for user catmaid_user:

ERROR: relation "project" does not exist
LINE 1: INSERT INTO project VALUES (1, 'Default Project', true);
^
ERROR: relation "project" does not exist
LINE 1: INSERT INTO project VALUES (2, 'Evaluation data set', true);
^
ERROR: relation "project" does not exist
LINE 1: INSERT INTO project VALUES (3, 'Focussed Ion Beam (FIB)', tr...
^
ERROR: relation "stack" does not exist
LINE 1: INSERT INTO stack VALUES (1, 'Original data.', '(4096,4096,1...
^
ERROR: relation "stack" does not exist
LINE 1: INSERT INTO stack VALUES (3, 'Focussed Ion Beam (FIB) stack ...
^
ERROR: relation "user" does not exist
LINE 1: INSERT INTO "user" VALUES (1, 'saalfeld', '84789cbcbd2daf359...
^
ERROR: relation "user" does not exist
LINE 1: INSERT INTO "user" VALUES (2, 'test', '098f6bcd4621d373cade4...
^
ERROR: relation "user" does not exist
LINE 1: INSERT INTO "user" VALUES (3, 'gerhard', '494524b27acdc356fb...
^
ERROR: relation "class" does not exist
LINE 1: INSERT INTO class VALUES (14, 1, '2010-08-26 13:19:57.046457...
^
ERROR: relation "class" does not exist
LINE 1: INSERT INTO class VALUES (5, 1, '2010-08-26 12:23:53.551017-...
^
ERROR: relation "class" does not exist
LINE 1: INSERT INTO class VALUES (106, 3, '2010-10-12 03:42:55.85649...
^
ERROR: relation "class" does not exist
LINE 1: INSERT INTO class VALUES (33, 3, '2010-08-27 11:28:08.713582...
^
ERROR: relation "class" does not exist
LINE 1: INSERT INTO class VALUES (112, 3, '2010-10-12 05:29:38.38539...
^
ERROR: relation "class" does not exist
LINE 1: INSERT INTO class VALUES (7, 3, '2010-08-26 12:30:53.288021-...
^
ERROR: relation "class" does not exist
LINE 1: INSERT INTO class VALUES (755, 3, '2010-12-20 10:17:48.12216...
^
ERROR: relation "class" does not exist
LINE 1: INSERT INTO class VALUES (756, 3, '2010-12-20 10:18:07.23163...
^
ERROR: relation "relation" does not exist
LINE 1: INSERT INTO relation VALUES (35, 3, '2010-08-27 11:30:10.480...
^
ERROR: relation "relation" does not exist
LINE 1: INSERT INTO relation VALUES (24, 1, '2010-08-26 15:21:35.859...
^
ERROR: relation "relation" does not exist
LINE 1: INSERT INTO relation VALUES (23, 1, '2010-08-26 15:20:51.554...
^
ERROR: relation "relation" does not exist
LINE 1: INSERT INTO relation VALUES (11, 1, '2010-08-26 13:15:41.060...
^
ERROR: relation "relation" does not exist
LINE 1: INSERT INTO relation VALUES (10, 1, '2010-08-26 13:15:31.939...
^
ERROR: relation "relation" does not exist
LINE 1: INSERT INTO relation VALUES (9, 1, '2010-08-26 13:15:22.4089...
^
ERROR: relation "relation" does not exist
LINE 1: INSERT INTO relation VALUES (8, 1, '2010-08-26 13:08:19.4885...
^
ERROR: relation "class_instance" does not exist
LINE 1: INSERT INTO class_instance VALUES (2323, 3, '2011-01-13 09:1...
^
ERROR: relation "project_stack" does not exist
LINE 1: INSERT INTO project_stack VALUES (1, 1, '(0,0,0)');
^
ERROR: relation "project_stack" does not exist
LINE 1: INSERT INTO project_stack VALUES (3, 3, '(0,0,0)');
^
ERROR: relation "project_user" does not exist
LINE 1: INSERT INTO project_user VALUES (1, 1);
^
ERROR: relation "project_user" does not exist
LINE 1: INSERT INTO project_user VALUES (3, 1);
^
ERROR: relation "project_user" does not exist
LINE 1: INSERT INTO project_user VALUES (1, 3);
^
ERROR: relation "project_user" does not exist
LINE 1: INSERT INTO project_user VALUES (3, 3);
^
ERROR: relation "project_user" does not exist
LINE 1: INSERT INTO project_user VALUES (2, 3);
```

any idea what might be going wrong here?