You need to run getnextid() function in postgres in order to get the
ID's correct (next available number, should not be in use). I've
bumped into this before; for some reason eperson id's jump wild
sometimes and you need to run the function in order to get things
synchronized.
SELECT getnextid('eperson') AS result;
Hope this helps,
Mika
2009/6/2 Filippos Kolovos <[email protected]>:
> Dear all,
>
> for some time now we have been receiving the following error when a user
> tries to register:
>
> Exception:
> org.postgresql.util.PSQLException: ERROR: duplicate key violates unique
> constraint "eperson_email_key"
>
> Apart from the user trying to register twice, are there any other reasons
> that may generate that error?
>
> Thank you for any help provided.
>
> -Fk
>
>
> --
> Filippos Kolovos
> Software Systems Analyst & Engineer
> M.Sc. (Eng.) in Data Communications
>
> Automation & Networking Department
> University of Macedonia Library
> Egnatia 156, P.O.Box 1591
> 540 06 Thessaloniki, Greece
>
> E-Mail: [email protected],
> [email protected]
> Profile: http://www.linkedin.com/in/filipposkolovos
> -----------------------------------------------------------------------
>
>
> ------------------------------------------------------------------------------
> OpenSolaris 2009.06 is a cutting edge operating system for enterprises
> looking to deploy the next generation of Solaris that includes the latest
> innovations from Sun and the OpenSource community. Download a copy and
> enjoy capabilities such as Networking, Storage and Virtualization.
> Go to: http://p.sf.net/sfu/opensolaris-get
> _______________________________________________
> DSpace-tech mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/dspace-tech
>
>
------------------------------------------------------------------------------
OpenSolaris 2009.06 is a cutting edge operating system for enterprises
looking to deploy the next generation of Solaris that includes the latest
innovations from Sun and the OpenSource community. Download a copy and
enjoy capabilities such as Networking, Storage and Virtualization.
Go to: http://p.sf.net/sfu/opensolaris-get
_______________________________________________
DSpace-tech mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech
