Using pgAdminIII

Classic Servoy
1

Hi,

I´m using pgAddmin III to create databases and tables. I prefer using it because I do not see the way to indicate the precission of the numbers in Servoy, the time type of field, etc.

After I create the tables I use the option Reloadd table/tables structure from DB in Servoy. I see the new tables but when running the SmartClient I get this error:

ERROR: no existe la relación <>

That means something like ERROR: relation <> does not exist

Any clue about this? Is there a way to declare the precission of the numbers from Servoy?

Thanks in advance

2

Hi,

Do you still get this error when you relaunch Servoy ?

3

Hi jasantana

Try review table grants.
(Prueba a revisar los permisos de las tablas)

Best regards. Roberto.

4

ROCLASI:
Hi,

Do you still get this error when you relaunch Servoy ?

Yes I do

5

Roberto Blasco:
Hi jasantana

Try review table grants.
(Prueba a revisar los permisos de las tablas)

Best regards. Roberto.

Grants are the same than in other tables. Check this image, you can see two tables the one on the left works perfectly and the one on the right is giving the problem.

PermisosTablas.png
PermisosTablas.png1008×573 97.9 KB

6

Solved !!!

The big problem is that when I created the table in pgAdmin I named it Cuotas but servoy imports it as cuotas. As soon as I changed the name of the table to cuotas (all in lowercase) the problem was solved.

Sorry for disturbing with this stupid issue. I never thought that this could be a problem.

Thank you all !!!

7

Juan,

That is really strange, in postgres, table names are case insensitive and Servoy works just fine with table names in mixed case in databases that are case sensitive in table names.

Rob