Explicitly setting sequence next value, removes ownership of table of a serial

2023-02-09 Thread Regina Obe
I noticed something which might be intentional, but seems odd. If I do something like: CREATE TABLE test(id serial, name text); And then I use the pgAdmin UI to edit the current value of the sequence. I notice it does this: ALTER SEQUENCE IF EXISTS public.test_id_seq OWNED BY NONE; SELECT setv

RE: PostGIS data loader / dumper - GSOC 2022 Idea

2022-02-21 Thread Regina Obe
. We could probably come up with a sensible way of setting the path with reasonable defaults. I'd be inclined to have that as a separate setting from the normal binpath (as we likely wouldn't have per-server versions, except on Windows). [Regina Obe] I was thinking of that too, but w

PostGIS data loader / dumper - GSOC 2022 Idea

2022-02-19 Thread Regina Obe
In pgAdmin3, our ESRI shapefile loader /dumper GUI was installable as a plugin. We lost that feature with pgAdmin4. To get this feature back, I was thinking that our command line tools would be easier to integrate in pgAdmin4 than the gui and also solve the issue of our GUI not packaged on many