[rt-users] ticket creation error after using migration scripts

Andy Harrison ah3 at mlz.us
Tue Aug 19 13:55:18 EDT 2003


-----BEGIN PGP SIGNED MESSAGE-----


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
On 08-Apr-2003, Jamie Wilkinson wrote message "Re: [rt-users] ticket creation
error after using migration scrip"
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> rt3=# select max(id) from tickets;
>  max
> -----
>  365
> (1 row)
>      
> rt3=# select setval('tickets_id_seq', 366);
>  setval
> --------
>     366
> (1 row)


FYI, you can instead do:

rt3=# select setval('tickets_id_seq', (select max(id) from tickets)+1);



~~ 
Andy Harrison
(full headers for details)


-----BEGIN PGP SIGNATURE-----
Version: PGP 6.5.8

iQCVAwUBP0JkhVPEkLgodAWVAQEqlAP/QlMMMU/+Ac2vlN2s4GGOazmYlx9efXep
9AqBT25O8VSFLVYeSDm4r1DmiGIrCOBsnSVUeSXyLBhyPbOq+IHx3PJ96h54NoBm
/t+RZ0bxLZFlo9k85SwTwnOe4K1kL90wkx95dyyvaq+qpOaC04wj8hVPr4R4P0uA
pu79cA3w9Xo=
=rvR8
-----END PGP SIGNATURE-----



More information about the rt-users mailing list