Re: Instance Password

> Oct 14 14:59:52 ogo-account-add [31816]: PG0x0x844ea94 SQL: 
> 
> INSERT INTO person (email_alias, company_id, url, office, im_address,
> associated_company, sex, is_customer, associated_contacts,
> show_email_as, show_email3_as, degree, password, number, middlename,
> boss_name, owner_id, pop3_account, firstname, template_user_id,
> source_url, fileas, is_template_user, freebusy_url, dir_server,
> associated_categories, name, salutation, occupation, is_account,
> db_status, is_person, contact_id, keywords, is_extra_account,
> assistant_name, show_email2_as, login, is_private, name_affix,
> birthday, object_version, is_locked, priority, sensitivity,
> name_title, description, anniversary, is_readonly, is_intra_account,
> department, partner_name) 
> 
> VALUES (null, 33891, null, null, null, null, null, null, null, null,
> null, null, null, 'OGo33891', null, null, 10000, null, 'Andrew', 9999,
> null, null, null, null, null, null, 'Higgs', null, null, 1,
> 'inserted', 1, null, null, 0, null, null, 'andrew', null, null, null,
> 1, null, null, null, null, null, null, null, 1, null, null)
> 
> Password is null and email doesn't even appear. :-( Are there any
> other inserts I should be looking for... There don't seem to be any
> 'ALTER person' sql's either.

I wouldn't expect any alters.

I get an error when I try this;  which is probably a POstgreSQL 8.3
compat bug lurking in there somewhere.  I'll have to sus that out before
I can test it.

But you should see an UPDATE following the INSERT related to the
password,  the setting of the password I believe would be a second step
in the same transaction (between BEGIN & COMMIT).
-- 
Adam Tauno Williams, Network & Systems Administrator
Consultant - http://www.whitemiceconsulting.com
Developer - http://www.opengroupware.org

-- 
OpenGroupware.org Users
[email protected]
http://mail.opengroupware.org/mailman/listinfo/users