On 03/16/2012 08:00 AM, salah jubeh wrote:
Hello Adrian,
Sorry, I was not clear.
what I meant is that.
GRANT INSERT, UPDATE ON tablenaem TO USER; -- leads to GRANT ALL ON
TABLE tablename_colname_seq TO USER
Another thought you do not happen to have DEFAULT PRIVILEGES set up for
sequences:
On 03/16/2012 08:00 AM, salah jubeh wrote:
Hello Adrian,
Sorry, I was not clear.
what I meant is that.
GRANT INSERT, UPDATE ON tablenaem TO USER; -- leads to GRANT ALL ON
TABLE tablename_colname_seq TO USER
CCing the list.
Still not following.
What version of Postgres are you using?
Using 9.
On 03/16/2012 07:06 AM, salah jubeh wrote:
Hello,
When creating a serial, a sequence is created automatically.
CREATE TABLEtablename (
colname SERIAL
);
CREATE SEQUENCE tablename_colname_seq;
CREATE TABLE tablename (
colname integer NOT NULL DEFAULT nextval('tablename_colname_seq')
Hello,
When creating a serial, a sequence is created automatically.
CREATE TABLE tablename ( colname SERIAL
);
CREATE SEQUENCE tablename_colname_seq;
CREATE TABLE tablename ( colname integer NOT NULL DEFAULT
nextval('tablename_colname_seq')
);
ALTER SEQUENCE tablename_colname_seq OWNED BY tablen
