Dave ha scritto:
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?
The definition is correct, another try:
- open createdb.sql with Xcode
- there is a "strange" character in webpage declaration before the 'c'
of 'custom', delete it
- copy the whole text of the file
- parte the text in pgadminIII
- execute
it works
maybe possible that trere a are some non visible character that causes
the error?
edoardo
