3 INSERT INTO config.upgrade_log (version) VALUES ('0259'); -- Scott McKellar
5 -- Warning: Due to an oversight, the acq.edi_message table was added via an
6 -- upgrade script, but the CREATE TABLE statement was never added to the
7 -- 200.schema.acq.sql script (till now).
9 -- If you have rebuilt your system from scratch since then, you may find that
10 -- the following ALTER will fail because the table doesn't exist yet.
12 -- Solution: run the relevant CREATE TABLE statement from 200.schema.acq.sql
13 -- instead of this upgrade script. You may also want to manually insert a
14 -- row into config.upgrade_log, as per the above.
16 ALTER TABLE acq.edi_message
17 ADD COLUMN purchase_order INT
18 REFERENCES acq.purchase_order
19 DEFERRABLE INITIALLY DEFERRED;