On 9/17/07, Dave <[EMAIL PROTECTED]> wrote: > On 9/17/07, Edoardo Panfili <[EMAIL PROTECTED]> wrote: > > I am sorry if this is not the right place to post, I try with bug report > > but it always say "You have not selected a valid project to create an > > issue in." > > I did I try with manual database creation > > psql -U roller rollerdb <WEB-INF/classes/dbscripts/postgresql/createdb.sql > > ----------------------------------------------------------------- > > ERROR: syntax error at or near "text" > > LINE 204: contenttype varchar(128) default 'text/plain' not null > > Looks like we're using the wrong syntax for PostgreSQL here. If I get > you a replacement createdb.sql file, are you willing to test it with a > fresh new database?
That column definition: "contenttype varchar(128) default 'text/plain' not null" Appears to be correct according to the PostgreSQL 8.2 docs: http://www.postgresql.org/docs/8.2/static/sql-createtable.html Any PosgreSQL experts know what's wrong here? - Dave
