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 #4955 is a reply to message #4952]

Sun, 30 August 2015 05:28

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

Senior Member

If you are not using a SERIAL/AUTO_INCREMENT field as the primary key, then what is the point?

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: Mon Jul 07 04:50:08 EDT 2025

Total time taken to generate the page: 0.01409 seconds