From: | "Hiroshi Inoue" <Inoue(at)tpf(dot)co(dot)jp> |
---|---|
To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | "Ron Snyder" <snyder(at)roguewave(dot)com>, <pgsql-general(at)postgresql(dot)org>, "pgsql-hackers" <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Using views and MS access via odbc |
Date: | 2002-05-04 23:20:46 |
Message-ID: | EKEJJICOHDIEMGPNIFIJGEFBHLAA.Inoue@tpf.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
> -----Original Message-----
> From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
>
> "Hiroshi Inoue" <Inoue(at)tpf(dot)co(dot)jp> writes:
> > If you'd not like to change the behavior, I would change it, OK ?
> >>
> >> To what? I don't want to simply undo the 7.2 change.
>
> > What I'm thinking is the following makeshift fix.
> > I expect it solves Ron's case though I'm not sure.
> > Returning UPDATE 0 seem to make no one happy.
>
> Agreed, that doesn't seem like it's going over well. Let's see, you
> propose returning the tag if there is only one replacement query, ie,
> we had just one DO INSTEAD rule. [ thinks... ] I guess the only thing
> that bothers me about this is the prospect that the returned tag is
> completely different from what the client expects. For example,
> consider a rule like ON UPDATE DO INSTEAD INSERT INTO history_table...
> With your patch, this would return an "INSERT nnn nnn" tag, which'd
> confuse a client that expects an "UPDATE nnn" response.
Is it worse than returning "UPDATE 0" ?
Unfortunately "UPDATE 0" never means the result is unknown
but clearly means no rows were affected. It can never be safe
to return "UPDATE 0".
regards,
Hiroshi Inoue
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2002-05-05 00:16:26 | Re: pg_dump -C doesn't capture encoding |
Previous Message | Culley Harrelson | 2002-05-04 22:42:16 | pg_dump -C doesn't capture encoding |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2002-05-05 00:08:35 | Re: HEADS UP: Win32/OS2/BeOS native ports |
Previous Message | Ron Snyder | 2002-05-04 21:40:07 | Re: Using views and MS access via odbc |