Problem creating a new connection

8 views
Skip to first unread message

Jean Jacques Delannoy

unread,
May 29, 2012, 10:43:33 AM5/29/12
to web-obje...@googlegroups.com
Hello, i have a problem creating a new connection to a server were is running PostgreSQL, the connections starts but when i try to insert the connection the follow error occurs : [23505] A violation of the constraint imposed by a unique index or a unique constraint occurred. thanks in advance

Travis Torgerson

unread,
May 29, 2012, 11:34:14 AM5/29/12
to web-obje...@googlegroups.com
Hello~

This error generally occurs when you use the same Connection Alias for your connection as one that's already been created.  To get around this, just add a number or identifier after the Connection Alias name.  For example, if you've created a connection and assigned it the Alias of PostgreSQL, you cannot insert another alias called PostgreSQL, but could insert a connection with the alias PostgreSQL1, PostgreSQLTEST, PostgreSQL_Jean_Jacques_Delannoy, etc...

Thanks,
Travis

Jean Jacques Delannoy

unread,
May 30, 2012, 12:38:42 PM5/30/12
to web-obje...@googlegroups.com


El martes, 29 de mayo de 2012 12:34:14 UTC-3, Travis Torgerson escribió:
Hello~

This error generally occurs when you use the same Connection Alias for your connection as one that's already been created.  To get around this, just add a number or identifier after the Connection Alias name.  For example, if you've created a connection and assigned it the Alias of PostgreSQL, you cannot insert another alias called PostgreSQL, but could insert a connection with the alias PostgreSQL1, PostgreSQLTEST, PostgreSQL_Jean_Jacques_Delannoy, etc...

thanks! appreciate, is working now
 
Reply all
Reply to author
Forward
0 new messages