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

Sat, 29 August 2015 14:18

rafs
Messages: 69
Registered: May 2015

Member

Actually it does work!
I kept the field as is, namely 'serial' type, (a.k.a. 'integer' with DEFAULT nextval('idps_uid_seq')), but I removed the NOT NULL constraint AND the UNIQUE constraint.
Bingo.
(A day and a half spent with the debugger, but live and learn.)
Thanks Tony. Super happy to have figured this out.

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: Sat Nov 23 23:19:34 EST 2024

Total time taken to generate the page: 0.00989 seconds