Hi Scott, On Mon, Jun 24, 2002 at 07:39:44AM -0400, Scott Brewerton wrote:
> when I try to run the table creation script, it doesn't seem to like the > (0) after the timestamp entries !! > > will it harm the system if I remove them so the entries simply read > > create_time timestamp NOT NULL, > create_by integer NOT NULL, > change_time timestamp NOT NULL, > change_by integer NOT NULL, > > ?? > > it is also complaining about 'serial8' on the 'article' table :o( any > hints on how to force the tables and seeding process through ?? Oh. .) Fine. You use probably PostgreSQL < 7.2. Ja, use 'timestamp' instead of 'timestamp(0)' and 'serial' instead of 'serial8'. Then it will work fine. Thanks to Ingo Ciechowski for this hit. > thanks > > _scott Have a lot of fun. Martin -- Martin Edenhofer - <martin at edenhofer.de> - http://martin.edenhofer.de/ -- "The number of Unix installations has grown to 10, with more expected." The Unix Programmer's Manual, 2nd Edition, June 1972 _______________________________________________ OpenTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
