From: | "Andrey N(dot) Oktyabrski" <ano(at)antora(dot)ru> |
---|---|
To: | Dmitry Turin <sql4-en(at)narod(dot)ru> |
Cc: | pgsql-ru-general(at)postgresql(dot)org |
Subject: | Re: management of BLOBs |
Date: | 2007-09-27 07:44:42 |
Message-ID: | 46FB5F6A.1050407@antora.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-ru-general |
Andrey N. Oktyabrski wrote:
> -- OBJECT with rights and parameters
> CREATE TABLE _blob (
> id SERIAL,
> usr TEXT NOT NULL CHECK (usr ~ '^[A-Za-z0-9_]+$'),
> grp TEXT NOT NULL CHECK (grp ~ '^[A-Za-z0-9_]+$'),
> param HSTORE NOT NULL DEFAULT '',
> file BYTEA
> );
Прошу прощения, самое главное поле не добавил в таблицу...
-- OBJECT with rights and parameters
CREATE TABLE _blob (
id SERIAL,
usr TEXT NOT NULL CHECK (usr ~ '^[A-Za-z0-9_]+$'),
grp TEXT NOT NULL CHECK (grp ~ '^[A-Za-z0-9_]+$'),
+ acl ROW_ACL NOT NULL DEFAULT 'u+rwd',
param HSTORE NOT NULL DEFAULT '',
file BYTEA
);
From | Date | Subject | |
---|---|---|---|
Next Message | Dmitry Turin | 2007-09-27 07:52:50 | Re: management of BLOBs |
Previous Message | Andrey N. Oktyabrski | 2007-09-27 06:50:42 | Re: management of BLOBs |