Hmm - on the face of it, it looks like there should be a new PG schema
update file created in
system/classes/pgsql/upgrades/post/XXXXX
This file, as a minimum, needs to include
ALTER TABLE {$prefix}sessions ADD COLUMN ip VARCHAR(45);
However, this column is defined as mandatory (NOT NULL) so I don't know what
dummy value
we could place there for pre-existing data.
This sequence also needs to be created in the schema upgrade script...
CREATE SEQUENCE {$prefix}log_pkey_seq;
..and possibly this table definition needs changing as a consequence.
CREATE TABLE {$prefix}log (
id BIGINT NOT NULL DEFAULT nextval('{$prefix}log_pkey_seq'),
user_id INTEGER NULL DEFAULT NULL,
type_id INTEGER NOT NULL,
severity_id SMALLINT NOT NULL,
message VARCHAR(255) NOT NULL,
data BYTEA NULL,
timestamp INT NOT NULL,
ip VARCHAR(45) NOT NULL,
PRIMARY KEY (id)
);
Hopefully, someone with more detailed knowledge of PG can make these
changes which hopefully should let to progress further.
However, as the last PG schema upgrade script is dated April 2009, it is
possible there are a few other schema changes that still need to be added.
--
Andy
--
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/habari-users
