babelfish_extensions icon indicating copy to clipboard operation
babelfish_extensions copied to clipboard

[Bug]: Failed to create the postgis_tiger_geocoder extension.

Open w345731923 opened this issue 1 year ago • 2 comments

What happened?

babelfish_db=# create extension postgis_tiger_geocoder ; ERROR: The scale -1 for 'numeric' datatype must be within the range 0 to precision 14

Version

BABEL_4_X_DEV (Default)

Extension

babelfishpg_tsql (Default)

Which flavor of Linux are you using when you see the bug?

No response

Relevant log output

No response

Code of Conduct

  • [X] I agree to follow this project's Code of Conduct.

w345731923 avatar Dec 11 '24 07:12 w345731923

This could be a case where one of the hooks are active when it should not be. Temporarily removing babelfishpg_tds from shared preload libraries and then installing this postgis_tiger_geocoder extensions might work.

tanscorpio7 avatar Dec 31 '24 05:12 tanscorpio7

Thanks @w345731923 for reporting this issue. This is known issue and we are internally tracking it for the fix.

rishabhtanwar29 avatar Jan 02 '25 08:01 rishabhtanwar29