Hi
Have been watching the fork unfold with interest and decided to take the plunge and upgrade to 1.1.1c from SL 2.6.16 before I get left too far behind
The following error message shows up after logging in and after the upgrade scripts run and I'd be grateful for any suggestions as to how to sort it:
Upgrading to Version 1.1.1c ...
Error!
CREATE TRIGGER parts_short AFTER UPDATE ON parts
FOR EACH ROW EXECUTE PROCEDURE trigger_parts_short();
create table transactions (
id int PRIMARY KEY,
table_name text
);
insert into transactions (id, table_name) SELECT id, 'ap' FROM ap;
CREATE RULE ap_id_track_i AS ON insert TO ap
DO ALSO INSERT INTO transactions (id, table_name) VALUES (new.id, 'ap');
CREATE RULE ap_id_track_u AS ON update TO ap
DO ALSO UPDATE transactions SET id = new.id WHERE id = old.id;
insert into transactions (id, table_name) SELECT id, 'ar' FROM ar;
CREATE RULE ar_id_track_i AS ON insert TO ar
DO ALSO INSERT INTO transactions (id, table_name) VALUES (new.id, 'ar');
CREATE RULE ar_id_track_u AS ON update TO ar
DO ALSO UPDATE transactions SET id = new.id WHERE id = old.id;
INSERT INTO transactions (id, table_name) SELECT id, 'business' FROM business;
CREATE RULE business_id_track_i AS ON insert TO business
DO ALSO INSERT INTO transactions (id, table_name) VALUES (new.id, 'business');
CREATE RULE business_id_track_u AS ON update TO business
DO ALSO UPDATE transactions SET id = new.id WHERE id = old.id;
INSERT INTO transactions (id, table_name) SELECT id, 'chart' FROM chart;
CREATE RULE chart_id_track_i AS ON insert TO chart
DO ALSO INSERT INTO transactions (id, table_name) VALUES (new.id, 'chart');
CREATE RULE chart_id_track_u AS ON update TO chart
DO ALSO UPDATE transactions SET id = new.id WHERE id = old.id;
INSERT INTO transactions (id, table_name) SELECT id, 'customer' FROM customer;
CREATE RULE customer_id_track_i AS ON insert TO customer
DO ALSO INSERT INTO transactions (id, table_name) VALUES (new.id, 'customer');
CREATE RULE customer_id_track_u AS ON update TO customer
DO ALSO UPDATE transactions SET id = new.id WHERE id = old.id;
INSERT INTO transactions (id, table_name) SELECT id, 'department' FROM department;
CREATE RULE department_id_track_i AS ON insert TO department
DO ALSO INSERT INTO transactions (id, table_name) VALUES (new.id, 'department');
CREATE RULE department_id_track_u AS ON update TO department
DO ALSO UPDATE transactions SET id = new.id WHERE id = old.id;
INSERT INTO transactions (id, table_name) SELECT id, 'employee' FROM employee;
CREATE RULE employee_id_track_i AS ON insert TO employee
DO ALSO INSERT INTO transactions (id, table_name) VALUES (new.id, 'employee');
CREATE RULE employee_id_track_u AS ON update TO employee
DO ALSO UPDATE transactions SET id = new.id WHERE id = old.id;
INSERT INTO transactions (id, table_name) SELECT id, 'gl' FROM gl;
CREATE RULE gl_id_track_i AS ON insert TO gl
DO ALSO INSERT INTO transactions (id, table_name) VALUES (new.id, 'gl');
CREATE RULE gl_id_track_u AS ON update TO gl
DO ALSO UPDATE transactions SET id = new.id WHERE id = old.id;
INSERT INTO transactions (id, table_name) SELECT id, 'oe' FROM oe;
CREATE RULE oe_id_track_i AS ON insert TO oe
DO ALSO INSERT INTO transactions (id, table_name) VALUES (new.id, 'oe');
CREATE RULE oe_id_track_u AS ON update TO oe
DO ALSO UPDATE transactions SET id = new.id WHERE id = old.id;
INSERT INTO transactions (id, table_name) SELECT id, 'parts' FROM parts;
CREATE RULE parts_id_track_i AS ON insert TO parts
DO ALSO INSERT INTO transactions (id, table_name) VALUES (new.id, 'parts');
CREATE RULE parts_id_track_u AS ON update TO parts
DO ALSO UPDATE transactions SET id = new.id WHERE id = old.id;
INSERT INTO transactions (id, table_name) SELECT id, 'partsgroup' FROM partsgroup;
CREATE RULE partsgroup_id_track_i AS ON insert TO partsgroup
DO ALSO INSERT INTO transactions (id, table_name) VALUES (new.id, 'partsgroup');
CREATE RULE partsgroup_id_track_u AS ON update TO partsgroup
DO ALSO UPDATE transactions SET id = new.id WHERE id = old.id;
INSERT INTO transactions (id, table_name) SELECT id, 'pricegroup' FROM pricegroup;
CREATE RULE pricegroup_id_track_i AS ON insert TO pricegroup
DO ALSO INSERT INTO transactions (id, table_name) VALUES (new.id, 'pricegroup');
CREATE RULE pricegroup_id_track_u AS ON update TO pricegroup
DO ALSO UPDATE transactions SET id = new.id WHERE id = old.id;
INSERT INTO transactions (id, table_name) SELECT id, 'project' FROM project;
CREATE RULE project_id_track_i AS ON insert TO project
DO ALSO INSERT INTO transactions (id, table_name) VALUES (new.id, 'project');
CREATE RULE project_id_track_u AS ON update TO project
DO ALSO UPDATE transactions SET id = new.id WHERE id = old.id;
INSERT INTO transactions (id, table_name) SELECT id, 'vendor' FROM vendor;
CREATE RULE vendor_id_track_i AS ON insert TO vendor
DO ALSO INSERT INTO transactions (id, table_name) VALUES (new.id, 'vendor');
CREATE RULE employee_id_track_u AS ON update TO vendor
DO ALSO UPDATE transactions SET id = new.id WHERE id = old.id;
INSERT INTO transactions (id, table_name) SELECT id, 'warehouse' FROM warehouse;
CREATE RULE warehouse_id_track_i AS ON insert TO warehouse
DO ALSO INSERT INTO transactions (id, table_name) VALUES (new.id, 'employee');
CREATE RULE warehouse_id_track_u AS ON update TO warehouse
DO ALSO UPDATE transactions SET id = new.id WHERE id = old.id;
CREATE TABLE custom_table_catalog (
table_id SERIAL PRIMARY KEY,
extends TEXT,
table_name TEXT
);
CREATE TABLE custom_field_catalog (
field_id SERIAL PRIMARY KEY,
table_id INT REFERENCES custom_table_catalog,
field_name TEXT
);
CREATE OR REPLACE FUNCTION add_custom_field (VARCHAR, VARCHAR, VARCHAR)
RETURNS BOOL AS
'
DECLARE
table_name ALIAS FOR $1;
new_field_name ALIAS FOR $2;
field_datatype ALIAS FOR $3;
BEGIN
EXECUTE ''SELECT TABLE_ID FROM custom_table_catalog
WHERE extends = '''''' || table_name || '''''' '';
IF NOT FOUND THEN
BEGIN
INSERT INTO custom_table_catalog (extends) VALUES (table_name);
EXECUTE ''CREATE TABLE custom_''||table_name ||
'' (row_id INT)'';
EXCEPTION WHEN duplicate_table THEN
-- do nothing
END;
END IF;
EXECUTE ''INSERT INTO custom_field_catalog (field_name, table_id)
VALUES ( '''''' || new_field_name ||'''''', (SELECT table_id FROM custom_table_catalog
WHERE extends = ''''''|| table_name || ''''''))'';
EXECUTE ''ALTER TABLE custom_''||table_name || '' ADD COLUMN ''
|| new_field_name || '' '' || field_datatype;
RETURN TRUE;
END;
' LANGUAGE PLPGSQL;
ERROR: duplicate key violates unique constraint "transactions_pkey"
-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users