Hey,
Thanks for the reply. Actually the error is in this part of the SQL file:
CREATE SEQUENCE user_ids
INCREMENT BY 1
NO MAXVALUE
NO MINVALUE
CACHE 1;
psql:postgres.initial.sql:10: ERROR: parser: parse error at or near
"BY" at character 40
Which is weird. All other parts of the file that have a BY clause
will get the same error.
I haven't tested this script with a newer version o Postgres -
maybe thats the issue?
If anybody else can confirm this, it'd be appreciated.
cheers,
-- Breno
On 4/7/06, N P List <[EMAIL PROTECTED]> wrote:
> Breno Jacinto Duarte da Costa wrote:
>
> >Hello,
> >
> > I'm trying to install Roundcube for testing here at the company
> >I'm working for, but the system is old - Conectiva Linux 9. Since it's
> >under production, and I'm not willing to change many things by now,
> >here'`s what I've got:
> >
> >- Postgresql 7.3.2
> >- PHP 4.3.1
> >
> > While trying to create the database on Postgres, I got some errors:
> >
> >psql:SQL/postgres.initial.sql:10: ERROR: parser: parse error at or
> >near "BY" at character 40
> >psql:SQL/postgres.initial.sql:26: NOTICE: CREATE TABLE / PRIMARY KEY
> >will create implicit index 'users_pkey' for table 'users'
> >CREATE TABLE
> >psql:SQL/postgres.initial.sql:41: NOTICE: CREATE TABLE / PRIMARY KEY
> >will create implicit index 'session_pkey' for table 'session'
> >
> > Although the tables were created. But when I try to access the
> >system (index.php), nothing returns, not even a debugging message.
> >
> > In the docs it's not explicit it requires a greater version of
> >Postgres (although it was not tested)... but I suppose this is the
> >problem?
> >
> > Thanks,
> >
> >
> I don't know what the sql file has in it. See if this helps.
> Remove the table names from postgres.initial.sql, like the example below:
> -------------------
> query=# UPDATE uuser SET uuser.id='6',uuser.login='NEW',uuser.name='Mr.
>
> foo' WHERE id='6';
> ERROR: parser: parse error at or near "." at character 23
>
> remove uuser.,
> query=# UPDATE uuser SET id='6',login='NEW',name='Mr. foo' WHERE
> id='6';
> UPDATE 0
> -------------
>
>
> -Nitin
>
>
--
.''`. -- Breno Jacinto
: :ยด` : -- breno /at/ freeunix dot com dot br
: ' ' : -- 88AE 3F43 7110 57F6 A206
`. `'` -- D116 02CA 02F4 803D 4294
`-- -- Debian GNU/Linux - The Universal OS
