On Wed, Dec 21, 2011 at 10:58:40AM -0500, Eric Lake wrote:
> On Wed, Dec 21, 2011 at 9:00 AM, Eric Lake <el...@lexmark.com> wrote:
> > SQL> select * from user_sequences where sequence_name =
> > upper('rhn_tasko_template_id_seq') ;
> >
> > SEQUENCE_NAME MIN_VALUE MAX_VALUE INCREMENT_BY C O
> > CACHE_SIZE
> > ------------------------------ ---------- ---------- ------------ - -
> > ----------
> > LAST_NUMBER
> > -----------
> > RHN_TASKO_TEMPLATE_ID_SEQ 1 1.0000E+27 1 N N
> > 20
> > 1330170
>
> I altered the rhn_tasko_template_id_seq last_value to match what the
> oracle-xe db had and taskomatic seems to have started working.
If you still have the schema dump that you used to migrate from Oracle,
could you check whether it contains a line which would look like
select pg_catalog.setval('rhn_tasko_template_id_seq', 1330170, false);
? Because the sequences should be set via the schema dump as well.
--
Jan Pazdziora
Principal Software Engineer, Satellite Engineering, Red Hat
_______________________________________________
Spacewalk-devel mailing list
Spacewalk-devel@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-devel
