Re: management of BLOBs - Mailing list 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
);