没有序列和触发器有没有简单的方法呢？我有一般的sql技能,我想用pl / sql(Postgresql)的行业标准方法.我基本上是从
Spring Security转换这个例子：
create table group_members (
id bigint generated by default as identity(start with 0) primary key,username varchar(50) not null,group_id bigint not null,constraint fk_group_members_group foreign key(group_id) references groups(id));
@H_502_3@我到目前为止
CREATE TABLE auth_group_members (
id NUMBER,username VARCHAR(50) NOT NULL,group_id NUMBER NOT NULL,CONSTRAINT "FK_AuthGroupMembers" FOREIGN KEY(group_id) REFERENCES auth_groups(id)
);
标准的方式是使用
serial or bigserial：
@H_502_3@The data types serial and bigserial are not true types,but merely a notational convenience for creating unique identifier columns (similar to the AUTO_INCREMENT property supported by some other databases).@H_502_3@所以你会创建一个这样的表：
[…]
Thus,we have created an integer column and arranged for its default values to be assigned from a sequence generator.
CREATE TABLE auth_group_members (
id bigserial primary key,CONSTRAINT "FK_AuthGroupMembers" FOREIGN KEY(group_id) REFERENCES auth_groups(id)
);
@H_502_3@串行和大型类型确实创建了幕后的序列,但是您不必直接使用序列.
