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
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
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'
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)
);
