Skip site navigation (1) Skip section navigation (2)

Re: management of BLOBs

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 (view raw or flat)
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
);

In response to

pgsql-ru-general by date

Next:From: Dmitry TurinDate: 2007-09-27 07:52:50
Subject: Re: management of BLOBs
Previous:From: Andrey N. OktyabrskiDate: 2007-09-27 06:50:42
Subject: Re: management of BLOBs

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group