Re: A cronjob for copying a table from Oracle
| От | Dmitriy Igrishin |
|---|---|
| Тема | Re: A cronjob for copying a table from Oracle |
| Дата | |
| Msg-id | AANLkTi=3vCnJnXhWY22DE2-v4s-CyF-T5=koXK2FXJO1@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: A cronjob for copying a table from Oracle (Adrian Klaver <adrian.klaver@gmail.com>) |
| Список | pgsql-general |
2010/12/10 Adrian Klaver <adrian.klaver@gmail.com>
On 12/10/2010 09:45 AM, Dmitriy Igrishin wrote:My guess the reversal is taking place in the PHP code. The table definition and the argument list to the Pg function have one order for emailid,email and the update and insert statements have another; email,emailid. I would guess that the PHP is building the row variables using the SQL statement order and than passing that to the Pg function which has a different order.Huh! Yes, indeed ! But how is it possible ?! I see
EMAIL = _EMAIL,
EMAILID = _EMAILID,
rather than
EMAIL = $7,
EMAILID = $8,
in the function definition...
Yeah, thats why I've asked the OP to post SQL with call of the function (in PHP).
--
--
// Dmitriy.
В списке pgsql-general по дате отправления: