Re: Instance Password

Hi Adam,

On Wed, Oct 15, 2008 at 3:55 PM, Adam Tauno Williams
<[email protected]>wrote:

>
> > 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.


Sorry, of course. Alter would be changing the table structure. Wasn't
thinking clearly.

>
>
> 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).


No. There is no UPDATE done when the command is run. At least not according
to the output. Could this be a version problem? I have the version package
for Ubuntu 7.04 running on 7.10. I haven't tried to upgrade to the latest.
The server is in use and I don't really want it to go down.

Regards