Subject: [GENERAL] Multiple multithreaded insert
Hi, everyone!
I have a table:
create table testpr(id serial,priority integer,unique(priority) DEFERRABLE,
primary key(id));
and a trigger which, when added to this table, automatically sets priority as
the maximum value +1
CREATE OR REPLACE
On Fri, Oct 14, 2016 at 7:12 AM, Арсен Арутюнян wrote:
> Hi, everyone!
>
> I have a table:
>
> create table testpr(id serial,priority integer,unique(priority) DEFERRABLE,
> primary key(id));
>
This:
> and a trigger which, when added to this table, automatically sets priority
> as the maximum val
Hi, everyone!
I have a table:
create table testpr(id serial,priority integer,unique(priority) DEFERRABLE,
primary key(id));
and a trigger which, when added to this table, automatically sets priority as
the maximum value +1
CREATE OR REPLACE FUNCTION PriorityCheck() RETURNS trigger AS $$
BEGIN