On 7/28/20 10:20 AM, Shashikanth Komandoor wrote:
I tried for the command to know if any entry in the "address" table for which 'id' is not an integer.
But unfortunately, I could not get any command or idea how to find that.
But out of my extra talent, I tried the below commands which, I thought, may print the records which contain a non integer id value.
...
select id,email from address where id NOT BETWEEN 1 AND 84203; id | email ----+-------(0 rows)
mailman=# select id,email from address where id NOT BETWEEN 1 AND 84202; id | emai> -------+-----------------------------> 84203 | user@exampl.com
*1 and 84203 are the minimum and maximum values of the id:*
Please see the above outputs and suggest if anything possible or please let me know the command what should I run to find a non integer id value.
The above looks qood to determine if there is a non-integer value.
I also doubt this error as if my REST API is contacting postgresql in a delayed manner. If possible, can you say what optimal setting I can do at Postgresql so that faster responses would be given to REST API.
I'm out of ideas.
-- Mark Sapiro <mark@msapiro.net> The highway is for gamblers, San Francisco Bay Area, California better use your sense - B. Dylan