To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs
>
--
Sincerely yours,
Nikolay Samokhvalov
Postgresmen LLC, http://postgresmen.ru
ok, sorry, I've realized that it's yet another example of "outer
reference", Tom will say "read any SQL book" again :-)
http://archives.postgresql.org/pgsql-bugs/2006-12/msg00115.php
On 12/19/06, Nikolay Samokhvalov <[EMAIL PROTECTED]> wrote:
Followin
Following query is considered as correct, no "missing from" error has
been reported (so, entire table will be updated and "on update"
triggers will be fired for every row):
update item set obj_id = obj_id
where obj_id in (select obj_id where item_point is null order by
obj_modified limit 10)
Is
uot;id"
> column of just-created row.
>
> Any thoughts?
>
> -- Forwarded message --
> From: Nikolay Samokhvalov <[EMAIL PROTECTED]>
> Date: Jul 13, 2006 6:15 PM
> Subject: Strange behaviour of RULE (selecting last inserted ID of
> 'sequenced'
I still think that this is quite strange behaviour. When I write
'...SELECT NEW.id...' I don't expect that another calling of column's
default expr will take place. I just want to have access to "id"
column of just-created row.
Any thoughts?
-- Forwarded me
On 8/2/06, Nikolay Samokhvalov <[EMAIL PROTECTED]> wrote:
Does Postgres work this way? In the case of 'delete from tbl;' we
have search condition>=TRUE for all rows. If we evaluate it *before*
any other operation, we should mark all rows to be deleted. I guess,
Postgres
t - he reports, that problem remains
even after dropping FK at all.
On 8/2/06, Tom Lane <[EMAIL PROTECTED]> wrote:
"Nikolay Samokhvalov" <[EMAIL PROTECTED]> writes:
> Is this a bug or not?
I don't think so --- or perhaps better, this is a buggy trigger.
he UPDATE i
Is this a bug or not?
Actually, ordinary person get used to think that if "delete from tbl"
ends, then there should no rows exists in tbl, but I understand that
DELETE FROM works in a loop and...
Let's take a look at the standard paper (ISO/IEC 9075-2:2003 -- 14.7
-- General Rules):
"...
11) Al
The following bug has been logged online:
Bug reference: 2490
Logged by: Nikolay Samokhvalov
Email address: [EMAIL PROTECTED]
PostgreSQL version: CVS
Operating system: fedora core 5
Description:'||' and type casting for user defined types
Details:
Assu
The following bug has been logged online:
Bug reference: 2245
Logged by: Nikolay Samokhvalov
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1.2
Operating system: Linux Fedora Core 4
Description:pg_dump doesn't dump expressions with sequence in
DEFAULT se
10 matches
Mail list logo
