syntax error at or near "binary" running users-postgres.sql

Forum User

July 11, 2013 15:48

When running users-postgres.sql from Frevvo v4 in a postgres 9.2 server the script fails with this error

========================================
ERROR:  syntax error at or near "binary"
LINE 79:  sid varchar(50) binary NOT NULL,
                          ^

********** Error **********

ERROR: syntax error at or near "binary"
SQL state: 42601
Character: 2168
========================================

Execution stops here

========================================
...

create table spaces (
    id SERIAL PRIMARY KEY,
    sid varchar(50) binary NOT NULL,     <--------execution stop
    name varchar(50) binary NOT NULL,
    blocks int,
    owner varchar(50) binary NOT NULL,
    tenant varchar(50) binary not NULL,
    theme varchar(50) binary,
    menu text,
    leftcontent text,
    homecontent text,
    bottomcontent text,
    logo bytea,
    logofilename varchar(50),
    version int,
    width varchar(10),
    customwidth varchar(10),
    mainwidth varchar(10),
    leftwidth varchar(10),
    height varchar(10)
);

...

========================================

Database is UTF8

Thanks

0

• 

  Prajakta

  July 11, 2013 15:49

  Hi

  frevvo is not certified with Postgres. Please take a look at the list of certified databases.

  Maybe you can use one of the certified DBs?

  0

Please sign in to leave a comment.