Hi Kasia,
thanks for the heads up. However, the problems arise before I have placed any data into the geodatabase, and by default Postgresql database cluster locale is/was en_US.UTF-8. I recreated it to fi_FI.iso88591 but that didn't have any affect.
I'm a bit sceptical whether the python script to create a geodatabase succeeded after all. When I select the database from the dropdown menu in Connection Properties dialog, the Postgresql log says:
[INDENT]ERROR: relation "sde.sde_layers" does not exist at character 22
STATEMENT: select count(*) from postgres.sde.sde_layers[/INDENT]
When I make the connection in ArcCatalog, the Postgresql log says:
[INDENT]ERROR: relation "sde.sde_logfiles" does not exist at character 174
STATEMENT: SELECT logfile_name, logfile_id, logfile_data_id, registration_id, flags, session_tag, column_name, logfile_data_db, logfile_data_owner, logfile_data_table FROM gis.sde.sde_logfiles WHERE flags%2 = 0[/INDENT]
When I try New -> Feature Class in ArcCatalog with default values, the Postgresql log says:
[INDENT]ERROR: index "r7_sde_rowid_uk" does not exist
STATEMENT: drop index sde.r7_sde_rowid_uk
ERROR: function gis.sde.i7_get_ids(integer, integer) does not exist at character 8
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
STATEMENT: SELECT gis.sde.i7_get_ids ($1,$2)
ERROR: invalid input syntax for type numeric: "-20037700,00000000000000000000000000000000"
STATEMENT: SELECT s.srid FROM gis.public.sde_spatial_references s WHERE s.falsex = $1 and s.falsey = $2 and s.xyunits = $3 AND s.srtext = $4 AND COALESCE(xycluster_tol,0.0) = $5 Order By srid Desc
ERROR: invalid input syntax for type numeric: "-20037700,00000000000000000000000000000000"
STATEMENT: SELECT gis.sde.SDE_sref_def_insert ($1, $2::numeric, $3::numeric, $4::numeric, $5::numeric, $6::numeric, $7::numeric, $8::numeric, $9, $10, $11, $12, $13, $14::numeric, $15::numeric, $16::numeric)
ERROR: relation "i7" does not exist at character 13
STATEMENT: DELETE FROM i7 WHERE id_type = 2[/INDENT]
When I try New -> Table in ArcCatalog, the Postgresql log says:
[INDENT]ERROR: function gis.sde.i8_get_ids(integer, integer) does not exist at character 8
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
STATEMENT: SELECT gis.sde.i8_get_ids ($1,$2)[/INDENT]
...but it gets created anyway. Finally, when I try Import -> Feature Class (single) in ArcCatalog, the Postgresql log says:
[INDENT]ERROR: relation "sde.sde_logfiles" does not exist at character 174
STATEMENT: SELECT logfile_name, logfile_id, logfile_data_id, registration_id, flags, session_tag, column_name, logfile_data_db, logfile_data_owner, logfile_data_table FROM gis.sde.sde_logfiles WHERE flags%2 = 0
ERROR: index "r9_sde_rowid_uk" does not exist
STATEMENT: drop index sde.r9_sde_rowid_uk
ERROR: function gis.sde.i9_get_ids(integer, integer) does not exist at character 8
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
STATEMENT: SELECT gis.sde.i9_get_ids ($1,$2)
ERROR: invalid input syntax for type numeric: "-20037700,00000000000000000000000000000000"
STATEMENT: SELECT s.srid FROM gis.public.sde_spatial_references s WHERE s.falsex = $1 and s.falsey = $2 and s.xyunits = $3 AND s.srtext = $4 AND COALESCE(xycluster_tol,0.0) = $5 Order By srid Desc
ERROR: invalid input syntax for type numeric: "-20037700,00000000000000000000000000000000"
STATEMENT: SELECT gis.sde.SDE_sref_def_insert ($1, $2::numeric, $3::numeric, $4::numeric, $5::numeric, $6::numeric, $7::numeric, $8::numeric, $9, $10, $11, $12, $13, $14::numeric, $15::numeric, $16::numeric)
ERROR: relation "i9" does not exist at character 13
STATEMENT: DELETE FROM i9 WHERE id_type = 2
ERROR: relation "sde.sde_logfiles" does not exist at character 174
STATEMENT: SELECT logfile_name, logfile_id, logfile_data_id, registration_id, flags, session_tag, column_name, logfile_data_db, logfile_data_owner, logfile_data_table FROM gis.sde.sde_logfiles WHERE session_tag = 6 AND flags % 2 = 0[/INDENT]