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