I am using turbine with postgres and I need to use the scheduler
service. However the jobentry table uses "OID" as the column name for
the primary key. "OID" is reserved in portgres. So I am wondering if
the column can be changed to "ID" or something that will not cause a
problem with postgres?
The JobEntryPeer would also have to be changed from:
public static final String OID_COLUMN = "OID";
to
public static final String OID_COLUMN = "ID";
It would also be very helpful if there were postgres install scripts for
jobentry and id_table included in the turbine doc/schemas directory for
those who are new to turbine. I have included these files below. NOTE:
The jobentry script changes OID to ID.
Postgres_Job_Entry.sql
#########################################################
-- ------------------------------------
-- Creates Jobentry table for Postgres
-- -----------------------------------
drop table Jobentry;
create table Jobentry (
ID integer NOT NULL,
MINUTE integer default -1 NOT NULL,
HOUR integer default -1 NOT NULL,
WEEKDAY integer default -1 NOT NULL,
DAY_OF_MONTH integer default -1 NOT NULL,
TASK varchar(99) NOT NULL,
EMAIL varchar(99),
PRIMARY KEY (ID)
);
#########################################################
Postgres_id_table.sql
#########################################################
-- ------------------------------------
-- This table provides the primary keys for all
-- other tables in the system. Should be used
-- with util.db.IDBroker.
-- -----------------------------------
drop table id_table;
create table id_table
(
id_table_id integer NOT NULL,
table_name varchar(255) NOT NULL,
next_id integer,
quantity integer,
PRIMARY KEY (ID_TABLE_ID)
);
create unique index id_table_id_table_id on id_table(id_table_id);
insert into ID_TABLE (id_table_id, table_name, next_id, quantity)
values (1, 'Permission', 20, 10);
insert into ID_TABLE (id_table_id, table_name, next_id, quantity)
values (2, 'UserRole', 20, 10);
insert into ID_TABLE (id_table_id, table_name, next_id, quantity)
values (3, 'Visitor', 20, 10);
insert into ID_TABLE (id_table_id, table_name, next_id, quantity)
values (4, 'Jobentry', 20, 10);
#########################################################
John Thorhauer
--
********************************
** John Thorhauer
** [EMAIL PROTECTED]
********************************
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Search: <http://www.mail-archive.com/turbine%40list.working-dogs.com/>
Problems?: [EMAIL PROTECTED]
