On 06/17/2010 01:19 PM, Jason Oster wrote:
What's the table schema so I can create it manually?
It appears to be defined in: UI/MainUI/SOGoProfile.sql So I created this table manually:sogo=> CREATE TABLE sogo_user_profile (c_uid VARCHAR(255) NOT NULL PRIMARY KEY, c_defaults TEXT, c_settings TEXT); NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "sogo_user_profile_pkey" for table "sogo_user_profile"
CREATE TABLE
sogo=> \dt
List of relations
Schema | Name | Type | Owner
--------+-------------------+-------+-------
public | sogo_user_profile | table | sogo
(1 row)
And then I restart SOGo. postgres log shows:
2010-06-17 13:18:38 MST STATEMENT: CREATE TABLE sogo_user_profile;
2010-06-17 13:24:10 MST FATAL: database "sogo/sogo_user_profile" does
not exist
The CREATE statement was from my manual SQL entry. So there's still no change, here.
<<attachment: jason_oster.vcf>>
-- users@sogo.nu https://inverse.ca/sogo/lists
