Re: update phenomenom

> sub SQL {
> my $command=shift;
> ...
> $sth=$db->prepare($command);
> $sth->execute();
> ...
> }

running latest postgresql 7.3.3

--

Mit freundlichem Gruß

Henrik Steffen
Geschäftsführer

top concepts Internetmarketing GmbH
Am Steinkamp 7 - D-21684 Stade - Germany
--------------------------------------------------------
http://www.topconcepts.com Tel. +49 4141 991230
mail: steffen(at)topconcepts(dot)com Fax. +49 4141 991233
--------------------------------------------------------
24h-Support Hotline: +49 1908 34697 (EUR 1.86/Min,topc)
--------------------------------------------------------
Ihr SMS-Gateway: JETZT NEU unter: http://sms.city-map.de
System-Partner gesucht: http://www.franchise.city-map.de
--------------------------------------------------------
Handelsregister: AG Stade HRB 5811 - UstId: DE 213645563
--------------------------------------------------------

----- Original Message -----
From: "Ian Barwick" <barwick(at)gmx(dot)net>
To: "Henrik Steffen" <steffen(at)city-map(dot)de>; "pgsql"
<pgsql-general(at)postgresql(dot)org>
Sent: Friday, June 06, 2003 9:03 PM
Subject: Re: [GENERAL] update phenomenom

> On Friday 06 June 2003 10:58, Henrik Steffen wrote:
> > Hello all,
> (...)
> > For me it's almost 99.9 % sure, that it's no error in the
> > perl-program. There is only one command issuing exactly
> >
> > SQL("UPDATE $table SET $daten WHERE kundennummer='$kundennummer';");
> >
> > where $table is the table-variable
> > $daten is what is to be set
> > $kundennummer is the client-number, which is checked before to match
> > exactly 9 digits.
>
> What exactly does the function SQL() do? Is it possible that the script
could
> receive input along these lines?
> SQL("UPDATE table SET manio='071002'; WHERE kundennummer='071002883';")
>
> > Could there be any postgresql-server-side explanation for this
phenomenom ?
> > Perhaps
> > anything about corrupted indexes, or anything?
>
> Any idea what version the server is running?
>
>
> Schöne Grüße
>
> Ian Barwick
> barwick(at)gmx(dot)net
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster