Corn wrote:
There is a comma missing. The Statement must be
CREATE TABLE usersright (
userid INTEGER NOT NULL,
rightid INTEGER NOT NULL,
allow BOOLEAN NOT NULL DEFAULT FALSE,
^^^
CONSTRAINT pk_usersright PRIMARY KEY (userid, rightid)
);
You have to escape the ' inside of your function definition:
CREATE FUNCTION testid()
RETURNS INTEGER
AS 'SELECT nextval(\'seq1\');'
LANGUAGE 'SQL';
The quotationmark in front of seq1 terminated the literal string that
should contain your
SQL statement and the parser was confused to find an 's'
ip (One person can purchase many things, one person can attend
> many schools) I would have to create many junction tables
> (school_persons, purchase_persons, etc). What I am looking for is a
> solution to creating all these tables, if at all possible.
>
> --eric
>
> Arne Weine
cify the username in the
command line.
createuser -d -a -U root
Or you just say:
createuser -d -a
and you will be prompted for username.
Arne Weiner.
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
