Best option is to add a check on column sizes.
Regards,
David
On Wed, 9 Aug 2023 at 21:39, Shaozhong SHI wrote:
> Regina,
>
> What is the robust way to do the following?
>
> If exists (select * from t) then
> insert into a_table select * from t
> End if;
>
>
> This is trying to not to inse
Regina,
What is the robust way to do the following?
If exists (select * from t) then
insert into a_table select * from t
End if;
This is trying to not to insert with no content.
Regards,
David
On Wed, 9 Aug 2023 at 15:04, Regina Obe wrote:
> Your version should have those functions ava
Hi Regina,
I think I found the answer. It is not because it is too big. It is it
returned nothing to be inserted.
The message is rather miss-leading.
I put on test run. Hopefully I get confirmation tomorrow.
Regards, David
On Wednesday, 9 August 2023, Regina Obe wrote:
> Your version should h
Your version should have those functions available since these functions came
in PostGIS 3.1 and your GEOS is newer than 3.9
https://postgis.net/docs/manual-3.2/ST_Union.html
Do you get an error when you run ST_Union with a gridsize? If so maybe your
GEOS might be newer but you compiled
Hi all.
I have a linear network as a single multilinestring. I need to cut it in
separate subnet using a point layer. ST_Split dos the job, but it
returns the subnet split into multipart, and I do not have an id to put
them together.
I cannot find a way to split the original network retaining e
