Re: management of BLOBs

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