[rt-devel] Changes for bigint tickets

[Rich Lafferty]

On Tue, Feb 05, 2002 at 04:14:50PM -0500, Rich Lafferty (rich+rt at lafferty.ca) wrote:
> 
> I've attached my new schema. When I go to create a new ticket now, I
> get an empty error -- through the web UI, it's an "RT error" table
> with no text in, and rt-mailgate returns
> 
>   Create failed:  /  /  
> 
> I also noticed that EffectiveId in the Tickets table remains NULL
> rather than matching the id of the ticket as it does for tickets
> created prior to the change.

An additional observation: Deleting the malformed tickets and setting
the sequence to start back at an int-sized number got everything
working fine, but pushing the sequence back up beyond an int breaks. 
The sequence appears to keep working, though, because Ticket.id is set
correctly.

   -Rich

-- 
Rich Lafferty --------------+-----------------------------------------------
 Ottawa, Ontario, Canada    |  Save the Pacific Northwest Tree Octopus!
 http://www.lafferty.ca/    |    http://zapatopi.net/treeoctopus.html
rich at lafferty.ca -----------+-----------------------------------------------