roller-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dave <snoopd...@gmail.com>
Subject PostgreSQL create table problem (was Re: problems installig 4.0RC2)
Date Mon, 17 Sep 2007 20:08:20 GMT
On 9/17/07, Dave <snoopdave@gmail.com> wrote:
> On 9/17/07, Edoardo Panfili <edoardo@aspix.it> 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

Mime
View raw message