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

john snow <[email protected]> Thu, 19 Sep 2019 12:00:39 +0800
Newsgroups gmane.comp.db.postgresql.novice,gmane.comp.db.postgresql.sql
Message-ID <CAE67tvVuNQw1rJRQR=s8Dqi3tjyesZMFmfrzCk-HivJv4NrOPQ@mail.gmail.com>
--000000000000dc31260592dfff14
Content-Type: text/plain; charset="UTF-8"

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?
>
>
>
> thanks in advance for any info
>

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

<div dir=3D"ltr">does anyone know how to get past this?<br><br>pgxnclient i=
nstall --pg_config &quot;C:\PostgreSQL11\bin&quot; safeupdate<br><br>ERROR:=
 [WinError 5] Access is denied running command: C:\PostgreSQL11\bin --libdi=
r<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:\Post=
greSQL11\bin&quot; is in my PATH<br></div><br><div class=3D"gmail_quote"><d=
iv dir=3D"ltr" class=3D"gmail_attr">On Thu, Sep 19, 2019 at 11:47 AM john s=
now &lt;<a href=3D"mailto:[email protected]">[email protected]</a=
>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0px=
 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><di=
v dir=3D"ltr"><a href=3D"https://github.com/eradman/pg-safeupdate" target=
=3D"_blank">https://github.com/eradman/pg-safeupdate</a> requires criteria =
for updates and deletes, so can protect from accidental wholesale updates /=
 deletes.<br><br>but i have not been able to install it on my windows 10 ma=
chine.<br><br>i&#39;ve installed python 3.7, pgxnclient, but pgxnclient ins=
tall safeupate fails<br><br>does any one know other extensions with functio=
nalities similar to pg-safeupdate that can be installed on a windows postgr=
esql environment?<br><br><br><br>thanks in advance for any info<br></div>
</blockquote></div>

--000000000000dc31260592dfff14--