Radicore Forum
Fast Uncompromising Discussions. FUDforum will get your users talking.
Home » RADICORE development » Application Development » ERROR: 22P02: invalid input syntax for integer ( LINE 1: SELECT count(*) FROM idps WHERE uid='' ^ LOCATION: pg_atoi, numutils.c:52)
Re: ERROR: 22P02: invalid input syntax for integer [message #4981 is a reply to message #4960] Wed, 02 September 2015 09:02 Go to previous message
AJM is currently offline  AJM
Messages: 2367
Registered: April 2006
Location: Surrey, UK
Senior Member
If you need an auto-incrementing unique key but you already have a natural unique key (which may or may not be a compound key) then my advice is to set the auto-increment field as the primary key and leave the other as a candidate key. The reason for this approach is that it then becomes possible to update the values in the candidate key (provided that the result is still unique) while the primary key remains fixed and immutable.

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator

[Message index]
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: How to provide choices for two compound foreign keys in a form?
Next Topic: Running batch jobs
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ] [ PDF ]

Current Time: Thu Nov 21 12:05:14 EST 2024

Total time taken to generate the page: 0.01018 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.1.3.
Copyright ©2001-2023 FUDforum Bulletin Board Software