Radicore Forum: Application Development » ERROR: 22P02: invalid input syntax for integer

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)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Re: ERROR: 22P02: invalid input syntax for integer [message #4950 is a reply to message #4949]

Sat, 29 August 2015 05:08

AJM
Messages: 2361
Registered: April 2006
Location: Surrey, UK

Senior Member

The AUTO_INCREMENT/SERIAL option should only be used for primary keys. Any other usage is not supported.

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

Report message to a moderator

[Message index]

		ERROR: 22P02: invalid input syntax for integer By: rafs on Thu, 27 August 2015 15:35
		Re: ERROR: 22P02: invalid input syntax for integer By: rafs on Thu, 27 August 2015 21:41
		Re: ERROR: 22P02: invalid input syntax for integer By: AJM on Fri, 28 August 2015 05:35
		Re: ERROR: 22P02: invalid input syntax for integer By: rafs on Fri, 28 August 2015 14:29
		Re: ERROR: 22P02: invalid input syntax for integer By: rafs on Fri, 28 August 2015 16:53
		Re: ERROR: 22P02: invalid input syntax for integer By: AJM on Sat, 29 August 2015 05:08
		Re: ERROR: 22P02: invalid input syntax for integer By: rafs on Sat, 29 August 2015 14:18
		Re: ERROR: 22P02: invalid input syntax for integer By: AJM on Sun, 30 August 2015 05:28
		Re: ERROR: 22P02: invalid input syntax for integer By: rafs on Mon, 31 August 2015 16:30
		Re: ERROR: 22P02: invalid input syntax for integer By: AJM on Tue, 01 September 2015 05:45
		Re: ERROR: 22P02: invalid input syntax for integer By: AJM on Wed, 02 September 2015 09:02

Previous Topic:	How to provide choices for two compound foreign keys in a form?
Next Topic:	Running batch jobs

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Thu Sep 12 07:10:48 EDT 2024

Total time taken to generate the page: 0.01024 seconds