Hi Devan,
In rhnSsmOperation.sql column user_id references rhnUser(id). rhnUser
table does not exist in Postgres port.
A little digging shows that in Oracle schema rhnUser is a synonym for
web_contact. So in the Postgres port I have made that column reference
web_contact(id). Hope it's okay with you.
In the beginning, we had agreed to not use synonyms anymore, so I guess
replacing this synonym from the table will be helpful in future too. Leaving
that change for you to decide.
Best regards,
2009/2/18 Devan Goodwin <[email protected]>
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Just did a master to pgsql merge this morning and about to push the
> results. Here's a diff of what's changed in the schema since the last
> merge. (only on the rhnsat/ subdir, left the rest out as it includes
> upgrades and such which we're not interested in)
>
> Generated with this command run before I pushed the merge, here pgsql
> is my tracking branch that tracks the remote pgsql branch, and HEAD is
> my current branch where I actually did the merge.
>
> git diff pgsql..HEAD -- schema/spacewalk/rhnsat/
>
> Cheers,
>
> Devan
>
> - --
> Devan Goodwin <[email protected]>
> Software Engineer Spacewalk / RHN Satellite
> Halifax, Canada 650.567.9039x79267
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v2.0.9 (GNU/Linux)
>
> iEYEARECAAYFAkmcNxIACgkQAyHWaPV9my6l+wCgxCMOkU+cRA9D3Rr+grk+ws7h
> W1UAn1kXX/5tdSYBPQSoh4fXFU442V9M
> =X+kw
> -----END PGP SIGNATURE-----
>
> _______________________________________________
> Spacewalk-devel mailing list
> [email protected]
> https://www.redhat.com/mailman/listinfo/spacewalk-devel
>
--
gurjeet[[email protected]
EnterpriseDB http://www.enterprisedb.com
singh.gurj...@{ gmail | hotmail | indiatimes | yahoo }.com
_______________________________________________
Spacewalk-devel mailing list
[email protected]
https://www.redhat.com/mailman/listinfo/spacewalk-devel
