Re: any alternative to pg-safeupdate for windows 10?

--00000000000044cd170592e3929b
Content-Type: text/plain; charset="UTF-8"

On Thu, Sep 19, 2019 at 5:01 AM john snow <[email protected]> wrote:

> does anyone know how to get past this?
>
> pgxnclient install --pg_config "C:\PostgreSQL11\bin" safeupdate
>
> ERROR: [WinError 5] Access is denied running command: C:\PostgreSQL11\bin
> --libdir
>
>
>
> i am the admin in the postgresql11 machine i'm trying to install the
> "safeupdate" extension to
>
> and "C:\PostgreSQL11\bin" is in my PATH
>
> On Thu, Sep 19, 2019 at 11:47 AM john snow <[email protected]> wrote:
>
>> https://github.com/eradman/pg-safeupdate requires criteria for updates
>> and deletes, so can protect from accidental wholesale updates / deletes.
>>
>> but i have not been able to install it on my windows 10 machine.
>>
>> i've installed python 3.7, pgxnclient, but pgxnclient install safeupate
>> fails
>>
>> does any one know other extensions with functionalities similar to
>> pg-safeupdate that can be installed on a windows postgresql environment?
>>
>> When you say you are an "in the postgresql11 machine" does that mean you
are an admin in Postgres or you're an admin as a Windows user? If the
former, obviously you should get Windows admin rights. If the latter, are
you running your command prompt in elevated admin mode or just regular user
mode? (You should be running the cmd prompt in elevated admin mode, I
think).

Steve

--00000000000044cd170592e3929b
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr"><br></div><br><div class=3D"gmail_quote">=
<div dir=3D"ltr" class=3D"gmail_attr">On Thu, Sep 19, 2019 at 5:01 AM john =
snow &lt;<a href=3D"mailto:[email protected]">[email protected]</=
a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0p=
x 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><d=
iv dir=3D"ltr">does anyone know how to get past this?<br><br>pgxnclient ins=
tall --pg_config &quot;C:\PostgreSQL11\bin&quot; safeupdate<br><br>ERROR: [=
WinError 5] Access is denied running command: C:\PostgreSQL11\bin --libdir<=
br><br><br><br>i am the admin in the postgresql11 machine i&#39;m trying to=
 install the &quot;safeupdate&quot; extension to<br><br>and &quot;C:\Postgr=
eSQL11\bin&quot; is in my PATH<br></div><br><div class=3D"gmail_quote"><div=
 dir=3D"ltr" class=3D"gmail_attr">On Thu, Sep 19, 2019 at 11:47 AM john sno=
w &lt;<a href=3D"mailto:[email protected]" target=3D"_blank">ofbizfans=
[email protected]</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" sty=
le=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);paddi=
ng-left:1ex"><div dir=3D"ltr"><a href=3D"https://github.com/eradman/pg-safe=
update" target=3D"_blank">https://github.com/eradman/pg-safeupdate</a> requ=
ires criteria for updates and deletes, so can protect from accidental whole=
sale updates / deletes.<br><br>but i have not been able to install it on my=
 windows 10 machine.<br><br>i&#39;ve installed python 3.7, pgxnclient, but =
pgxnclient install safeupate fails<br><br>does any one know other extension=
s with functionalities similar to pg-safeupdate that can be installed on a =
windows postgresql environment?<br><br></div></blockquote></div></blockquot=
e><div>When you say you are an &quot;in the postgresql11 machine&quot; does=
 that mean you are an admin in Postgres or you&#39;re an admin as a Windows=
 user? If the former, obviously you should get Windows admin rights. If the=
 latter, are you running your command prompt in elevated admin mode or just=
 regular user mode? (You should be running the cmd prompt in elevated admin=
 mode, I think).</div><div><br></div><div>Steve<br></div></div></div>

--00000000000044cd170592e3929b--