Re: update phenomenom
От | Henrik Steffen |
---|---|
Тема | Re: update phenomenom |
Дата | |
Msg-id | 00d101c32d31$3b65ca80$9800a8c0@henrik обсуждение исходный текст |
Ответ на | update phenomenom ("Henrik Steffen" <steffen@city-map.de>) |
Список | pgsql-general |
ok, you are right. I checked it once more, and now it worked.... thanks for your help, -- 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@topconcepts.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: "Jan Wieck" <JanWieck@Yahoo.com> To: "Henrik Steffen" <steffen@city-map.de> Cc: "pgsql" <pgsql-general@postgresql.org> Sent: Saturday, June 07, 2003 10:03 PM Subject: Re: [GENERAL] update phenomenom > Henrik Steffen wrote: > > hi, > > > > I tried both: > > > > $command="UPDATE table SET miano='12345'; commit; ' WHERE ... ;"; > > > > > > and > > > > $command="UPDATE table SET miano='12345'; -- ' WHERE ... ;"; > > > > > > neither worked. > > What do you mean "neither worked"? > > the second form works just like a charm. I checked it with PG 7.3.3, DBI > 1.14 and DBD::Pg 0.95. > > > > > it just gives an error and dies. > > no update done. > > What error and where is that coming from? If I use the comment hack it > doesn't show any message in the postmaster log. It is totally happy with > it and shows exactly the symptom you described. > > > I looked at man DBI, but couldn't find any restriction > > for $dbh->prepare() .... I am not sure, if it's possible > > to pass multiple statements to the prepare-method. > > I'm not too familiar with Perl, but if DBD blindly forwards the query > given in the string argument of prepare() into libpq's pg_exec() ... and > it is supposed to do it that way ... then it is possible to pass > multiple statements. This is a long standing functionality of the > frontend/backend protocol. > > > Jan > > -- > #======================================================================# > # It's easier to get forgiveness for being wrong than for being right. # > # Let's break this rule - forgive me. # > #================================================== JanWieck@Yahoo.com # >
В списке pgsql-general по дате отправления: