Using a Foreign Members Table with Oracle or PostgreSQL

If you are using a foreign members table with Oracle or PostgreSQL, you'll need to create a sequence and a trigger for the member ID column.

For example, suppose you want to use a foreign members table with the name LOCAL_MEMBERS, using the column ID as the Member ID column.

1. Find out the maximum number already in the ID column:

select max(ID) from LOCAL_MEMBERS;

2. Create a sequence for that table, starting with the maximum number already in the ID column, and adding one. For example, if the maximum number is 50, create the following sequence:

create sequence LOCAL_MEMBER_seq start 51;

3. (Oracle only) Create a "before trigger" to allow ListManager to transparently create new rows. It will then fill in the member id, which ListManager doesn't specify when working with foreign members tables.

create TRIGGER localmemtrig before insert on LOCAL_MEMBERS
for each row
begin
select LOCAL_MEMBERS_seq.nextval into :new ID_ from dual;
end;

Other steps needed to use a foreign members table may be found in Using a Foreign Members Table.