-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Thu, 29 Jan 2009 21:00:06 +0530 Gurjeet Singh <[email protected]> wrote:
> Can you post the exact error message you got? Not really an error so much as my code tries to call the procedure but I have no PostgreSQL schema or procedures yet. :) The ora2pg generated schema currently checked into git is *totally* broken. :) It errors out in a magnificent fashion when trying to load it, and psql was returning success code 0. :) I'm going to get rid of that schema today and make a proper directory layout for Makefile and order.sql as per emails earlier this week. > > >From the looks of it, I think following are the issues with it: > > 1) In Postgres we have to CREATE FUNCTION RETURNS VOID. > > 2) rhn_user_group_id_seq.nextval is being used, so we need to port > that Sequence too. > > Will be doing this in about an hour from now.. let me know if you need > anything more. Many thanks! Devan > > Best regards, > > On Thu, Jan 29, 2009 at 8:29 PM, Devan Goodwin <[email protected]> > wrote: > > > -----BEGIN PGP SIGNED MESSAGE----- > > Hash: SHA1 > > > > As mentioned in phone call this morning, a couple early requests for > > PostgreSQL schema + procs to be ported, I ran into a need for these > > in spacewalk-setup: > > > > Stored procedure: create_first_org.sql > > > > It delves out into a few tables, hopefully not far and if it goes > > too far then surely it's not possible to get it up and running > > quickly but I thought I'd make the request just in case. :) > > > > 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) > > > > iEYEARECAAYFAkmBxEUACgkQAyHWaPV9my4YxwCfQ3NcmFtGvGdhHzxKRo8Rg9kF > > FG0Anja/hFbY2ymjYJuuzI25attcgwUR > > =jtyf > > -----END PGP SIGNATURE----- > > > > _______________________________________________ > > Spacewalk-devel mailing list > > [email protected] > > https://www.redhat.com/mailman/listinfo/spacewalk-devel > > > > > - -- Devan Goodwin <[email protected]> Software Engineer Spacewalk / RHN Satellite Halifax, Canada 650.567.9039x79267 -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.9 (GNU/Linux) iEYEARECAAYFAkmBzRUACgkQAyHWaPV9my4pDwCeL26msQdXVWNTQkrkvPe7GkDC QN8An3z9S/qj9uGYFrX2PHcgCHL9/sGo =oJo9 -----END PGP SIGNATURE----- _______________________________________________ Spacewalk-devel mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-devel
