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 #4946 is a reply to message #4944]

Fri, 28 August 2015 05:35

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

Senior Member

This is because RADICORE is not recognising the column uid as being an AUTO_INCREMENT column. If you look at Creating a PostgreSQL driver for Radicore you will see that it expects to see the keyword "serial" for each column that is to be filled from a sequence.

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 Nov 21 18:12:53 EST 2024

Total time taken to generate the page: 0.01053 seconds