Tag Info

New answers tagged

1

I took a closer look and actually the data wasn't truncated. It's just that some values are bigger (1477701) and others are smaller (203071). I thought I had a truncation issue when I saw the smaller values in the first page of the DBF and the large values from a segment of the attribute table of the shapefile they are supposed to match. On a different note ...


2

At the suggestion of Chris W I'll post the comments as an answer in case it helps others in the future. Make sure that there are no other connections to the shapefile you are trying to change. Schema changes require and exclusive lock, which means no one except you can be looking at the shapefile and even then you must only be looking at the shapefile from ...


2

I don't know of a way to do what you want, but I would suggest turning on the System Protection capability on Windows. It's saved me a couple times. If the folder you deleted was inside another folder, right click on it and check the Previous Versions tab. Find an older date and click on the Open button. Maybe you'll get lucky and System Protection was ...


0

Here is a function that I wrote for PostgreSQL geodatabases that grants permissions on all user tables and views. It ignores the SDE i*, sde_log*, n_* (network), nd_* (network dataset), t_* (topology) tables but includes the version tables a* and d*. CREATE OR REPLACE FUNCTION public.mgis_gdb_grant_all(dbrole text) RETURNS void AS $BODY$ DECLARE schemaname ...


0

The error is not very clear, but definitely not related to the number of users connecting to the database. (In such cases you get error - Unable to connect to database. Maximum number of connections to instance exceeded). I error message mentions STATE_ID, considering this I would recommend you to COMPRESS the database once (it is okay to compress even ...



Top 50 recent answers are included