Eu l-am dat si dupa commit si tot degeaba.
Vampi
On Mon, 9 Jul 2001, George Mihalcea wrote:
>
>
> Am dat asta din php :
>
> $res=pg_exec($pg,"VACUUM") or die (pg_errormessage());
>
> Si a mers.
>
> Am dat asta:
> pg_exec($pg, "BEGIN");
> $res=pg_exec($pg,"VACUUM") or die (pg_errormessage());
> pg_exec($pg, "COMMIT");
>
> Si ghici ce mi-a zis ?
>
> "ERROR: VACUUM cannot run inside a BEGIN/END block "
>
> Deci, merge daca nu il dai intre "BEGIN" si "COMMIT".
>
>
>
> Stefanita Vilcu wrote:
>
> > Daca tu ai incercat si merge atunci e ok, la mine nu merge si da
> > eroarea:
> >
> > DBD::Pg::st execute failed: ERROR: VACUUM cannot run inside a
> > BEGIN/END block at /home/vsv/radius/radius.pl line 47, <IN> line 22.
> >
> > folosesc postgres 7.1.2 si DBD::Pg 1.01
> >
> > codul este:
> >
> > $sth=$dbh->prepare('VACUUM CURENT');
> > $sth->execute;
> >
> > Vampi
> >
> > On Mon, 9 Jul 2001, George Mihalcea wrote:
> >
> > >
> > > Pai daca dai din perl un query "vacuum" nu asta face?
> > > Vacuum poti da fie cu comanda vacuum, fie din promptul sql ('the PostgreSQL
> > > interactive terminal').
> > >
> > > Stefanita Vilcu wrote:
> > >
> > > > Salve,
> > > >
> > > > Stie cineva cum pot sa fac vacuum din perl? Ca eu nu am gasit.
> > > > Solutia e sa apelez un script extern, dar nu vreau.
> > > >
> > > > Multumesc,
> > > >
> > > > Vampi
> > > >
> > > > --
> > > > Stefanita Valeriu Vilcu, [EMAIL PROTECTED]
> > > > Chief Technology Officer
> > > > Dynamic Network Technologies, Romania
> > > > Tel: +40-1-2106863 Fax: +40-1-3122745
> > >
> > > ---
> > > Send e-mail to '[EMAIL PROTECTED]' with 'unsubscribe rlug' to
> > > unsubscribe from this list.
> > >
> > >
> >
> > --
> > Stefanita Valeriu Vilcu, [EMAIL PROTECTED]
> > Chief Technology Officer
> > Dynamic Network Technologies, Romania
> > Tel: +40-1-2106863 Fax: +40-1-3122745
> >
> > ---
> > Send e-mail to '[EMAIL PROTECTED]' with 'unsubscribe rlug' to
> > unsubscribe from this list.
>
> ---
> Send e-mail to '[EMAIL PROTECTED]' with 'unsubscribe rlug' to
> unsubscribe from this list.
>
>
--
Stefanita Valeriu Vilcu, [EMAIL PROTECTED]
Chief Technology Officer
Dynamic Network Technologies, Romania
Tel: +40-1-2106863 Fax: +40-1-3122745
---
Send e-mail to '[EMAIL PROTECTED]' with 'unsubscribe rlug' to
unsubscribe from this list.
