Memory alloc exception

Hi list, I get this error when running a SQL statement in my Java application. ERROR: Invalid memory alloc request size 1683636507 Location: File: d:\pginstaller.auto\postgres.windows-x64\src\backend\utils\mmgr\mcxt.c, Routine: MemoryContextAlloc, Line: 779 Server SQLState: XX000 I think it has

SV: SQL delete and update at the same time

Hi Michael, Thanks for taking interest in my problem. My biggest problem is that I’m not so familiar with SQL, and having problems to see how I can realize your suggestion. I’ve been testing in pgAdmin with 2 tables: linesegments and buffered. linesegments (splitted line strings into segments) fi

SQL delete and update at the same time

Hi list, the question is in the ens of the Mail. I have a problem with adjacent polygons when converting them to lines, as I would like to only have one line in the boundaries between the former polygons. Now it could be up to 5. I’ve been thinking of: 1. Creating a thin buffer around the l

Help with a selection

Hi, I have a column named col (varchar) col could look like this 902930 902920 902900 903110 913210 913200 ... I would like to remove an object that doesn't end '00' and if there are objects that start with the same 4 charcters and ending with 00. All objects ending with 00 shall remain. All obje

SV: delimeters psql /CSV

Sorry, I recognized that it was not "/" who caused the problem. I'm doing this in a java program and if I pause the program before running psql.exe and just open the csv file in windows with Excel and close it (without doing anything else) and then let the program run again. Then it works! Coul

delimeters psql /CSV

Hi, I have a problem with psql and CSV. C:\Users\an\bin>C:\Tmp\psql -h 10.211.43.22 -p 5432 -U postgres -d aatest -w -c "\copy public.""Bayern"" FROM 'C:\Users\an\test\Bayern.csv' WITH DELIMITER ';' CSV" Error: extra data after expected last column CONTEXT: COPY Bayern, row 1: "48.4

Re: psql \copy

Thanx, it worked! :) 4 juni 2019 kl. 11:00 skrev Pavel Stehule mailto:pavel.steh...@gmail.com>>: Hi út 4. 6. 2019 v 10:50 odesílatel mailto:paul.m...@lfv.se>> napsal: Hi. I’m trying to execute this command: C:\P_bin\psql -h 10.233.37.24 -p 5432 -U tester -d test -w -c "\copy public.BadenWuer

psql \copy

Hi. I'm trying to execute this command: C:\P_bin\psql -h 10.233.37.24 -p 5432 -U tester -d test -w -c "\copy public.BadenWuerttemberg_20181011 FROM C:\data\Baden-Wuerttemberg.csv' WITH DELIMITER ';' CSV" Error: relation "public.badenwuerttemberg_20181011" does not exist. What am I Doing wrong?