[rt-devel] First attempt at importing

Jesse jesse at fsck.com
Fri Jun 8 23:00:26 EDT 2001



On Fri, Jun 08, 2001 at 06:23:14PM -0700, Bob Finch wrote:
> >>>>> "Jesse" == Jesse  <jesse at fsck.com> writes:
> 
>     Jesse> Weird. Incidentally, which of the three req importers did
>     Jesse> you use?
> 
> yar2r-1.13
> 
> Just finished importing w/ 1.3.97.  Adding an index for Users on
> EmailAddress shaved about an hour off the total time.

Urk. the pg schema was out of sync with the base schema. sorry about that.

> 
> Merging looks good this time.  The handful of merged tickets I looked
> at were all OK.  I'll take a closer look over the weekend...
> 
> I had to do:
> 
>   select setval('tickets_id_seq', (select max(id) from tickets));
> 
> in psql before I could add new tickets.  I guess since import
> explicitly sets ticket numbers, the sequence number never gets
> incremented...


*nod* I will add a note to this effect to the install instructions.

> 
> -- Bob
> 
> _______________________________________________
> Rt-devel mailing list
> Rt-devel at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-devel
> 

-- 
jesse reed vincent -- root at eruditorum.org -- jesse at fsck.com 
70EBAC90: 2A07 FC22 7DB4 42C1 9D71 0108 41A3 3FB3 70EB AC90

I think co-ordinating 1000 prima donnas living all over the world will be as 
easy as herding cats..." -- Andy Tanenbaum on the linux development model, 1992




More information about the Rt-devel mailing list