Hi Bryan,
On Thu, Mar 06, 2003 at 07:21:58PM -0500, Bryan Fullerton wrote:
> >Is there something in in your charset table (select * from charset;)?
>
> Apparently not. :)
>
> otrs=> select * from charset;
> ERROR: Relation "charset" does not exist
>
> I'm unsure why the DBUpdate-to-1.0.postgresql.sql script didn't create
> it - can I safely re-run that script?
Yes. But I think the best way is to create/insert the charset this way:
CREATE TABLE charset
(
id serial,
name varchar (200) NOT NULL,
charset varchar (50) NOT NULL,
comment varchar (250),
valid_id smallint NOT NULL,
create_time timestamp(0) NOT NULL,
create_by integer NOT NULL,
change_time timestamp(0) NOT NULL,
change_by integer NOT NULL,
PRIMARY KEY(id),
UNIQUE (name)
);
INSERT INTO charset
(name, charset, comment, valid_id, create_by, create_time, change_by,
change_time)
VALUES
('Latin-1 (iso-8859-1)', 'iso-8859-1', 'Western European languages.', 1, 1,
current_timestamp, 1, current_timestamp);
INSERT INTO charset
(name, charset, comment, valid_id, create_by, create_time, change_by,
change_time)
VALUES
('Latin-2 (iso-8859-2)', 'iso-8859-2', 'Slavic and Central European
languages.', 1, 1, current_timestamp, 1, current_timestamp);
INSERT INTO charset
(name, charset, comment, valid_id, create_by, create_time, change_by,
change_time)
VALUES
('Latin-3 (iso-8859-3)', 'iso-8859-3', 'Esperanto, Galician, Maltese, and
Turkish.', 1, 1, current_timestamp, 1, current_timestamp);
INSERT INTO charset
(name, charset, comment, valid_id, create_by, create_time, change_by,
change_time)
VALUES
('Latin-4 (iso-8859-4)', 'iso-8859-4', 'Estonian, Latvian, and Lithuanian.',
1, 1, current_timestamp, 1, current_timestamp);
INSERT INTO charset
(name, charset, comment, valid_id, create_by, create_time, change_by,
change_time)
VALUES
('Cyrillic (iso-8859-5)', 'iso-8859-5', 'Bulgarian, Byelorussian, Macedonian,
Russian, Serbian and Ukrainian.', 1, 1, current_timestamp, 1, current_timestamp);
INSERT INTO charset
(name, charset, comment, valid_id, create_by, create_time, change_by,
change_time)
VALUES
('Greek (iso-8859-7)', 'iso-8859-7', 'Modern monotonic Greek.', 1, 1,
current_timestamp, 1, current_timestamp);
INSERT INTO charset
(name, charset, comment, valid_id, create_by, create_time, change_by,
change_time)
VALUES
('Unicode (UTF-8)', 'UTF-8', 'Unicode UTF-8', 1, 1, current_timestamp, 1,
current_timestamp);
INSERT INTO charset
(name, charset, comment, valid_id, create_by, create_time, change_by,
change_time)
VALUES
('Cyrillic Charset (KOI8-R)', 'KOI8-R', 'Unicode UTF-8', 1, 1,
current_timestamp, 1, current_timestamp);
INSERT INTO charset
(name, charset, comment, valid_id, create_by, create_time, change_by,
change_time)
VALUES
('Cyrillic Charset (Windows-1251)', 'Windows-1251', 'Windows-1251 - cp1251',
1, 1, current_timestamp, 1, current_timestamp);
INSERT INTO charset
(name, charset, comment, valid_id, create_by, create_time, change_by,
change_time)
VALUES
('Turkish (iso-8859-9)', 'iso-8859-9', 'Turkish.', 1, 1, current_timestamp, 1,
current_timestamp);
INSERT INTO charset
(name, charset, comment, valid_id, create_by, create_time, change_by,
change_time)
VALUES
('Latin-15 (iso-8859-15)', 'iso-8859-15', 'Western European languages with
euro.', 1, 1, current_timestamp, 1, current_timestamp);
> Bryan
Martin
--
Martin Edenhofer - <martin at edenhofer.de> - http://martin.edenhofer.de/
--
nohl: 6:47am up 18 days, 17:08, 6 users, load average: 0.13, 0.22, 0.23
_______________________________________________
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
