Return-Path: Delivered-To: apmail-roller-user-archive@www.apache.org Received: (qmail 20872 invoked from network); 17 Sep 2007 20:08:54 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 17 Sep 2007 20:08:54 -0000 Received: (qmail 65985 invoked by uid 500); 17 Sep 2007 20:08:45 -0000 Delivered-To: apmail-roller-user-archive@roller.apache.org Received: (qmail 65965 invoked by uid 500); 17 Sep 2007 20:08:45 -0000 Mailing-List: contact user-help@roller.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@roller.apache.org Delivered-To: mailing list user@roller.apache.org Received: (qmail 65956 invoked by uid 99); 17 Sep 2007 20:08:45 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 17 Sep 2007 13:08:45 -0700 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of snoopdave@gmail.com designates 66.249.82.232 as permitted sender) Received: from [66.249.82.232] (HELO wx-out-0506.google.com) (66.249.82.232) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 17 Sep 2007 20:08:42 +0000 Received: by wx-out-0506.google.com with SMTP id t16so1250442wxc for ; Mon, 17 Sep 2007 13:08:21 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; bh=lJ5UY0NEdS3ahDZ3wVSe8LTUzjy1Mtju0mlxWRgnC6I=; b=GzYaWDc8wyPoOwMHbJ0T5sLLbSWszCdQs1BsecyuBKDzxih4iSClLe7hdzZ7tngnoKV8PqDX7EzLZuiFoC9YpNAtp+nuwg+fmH1nKgGXOp9TSZZwa7mEmxj8o6edoErGWiWlsDMgqeok4STKeNzLL3XY1CryivE4HJcgxZSnj4k= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=feDEPQTBImvvUe//YbgkEVippQI51vdA50McubPtpkOkP4vnwrPJRnKrNU0PPQjsdoU4WK6n3cp7tySI0m/LwN8Efv7gJiq/R4gEA5V/kr/0f4hM4Ss3ahrF57UGvoP/1wO/SPHT+oeJFKdbOFlmKRXG5jtHh85QmVio7rH4L7Q= Received: by 10.90.118.8 with SMTP id q8mr3377014agc.1190059700858; Mon, 17 Sep 2007 13:08:20 -0700 (PDT) Received: by 10.90.53.9 with HTTP; Mon, 17 Sep 2007 13:08:20 -0700 (PDT) Message-ID: <8fb9ac720709171308q6160f5feob83801dafd98a6b2@mail.gmail.com> Date: Mon, 17 Sep 2007 16:08:20 -0400 From: Dave To: user@roller.apache.org Subject: PostgreSQL create table problem (was Re: problems installig 4.0RC2) MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Checked: Checked by ClamAV on apache.org On 9/17/07, Dave wrote: > On 9/17/07, Edoardo Panfili 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 > ----------------------------------------------------------------- > > 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