Re: [BUGS] BUG #7578: Not able to drop user if S/he has permission on tablespace

2012-10-08 Thread Nikolay
Where can I found this path? 03.10.2012 18:55, Alvaro Herrera пишет: Excerpts from wheelly's message of mar oct 02 05:49:27 -0300 2012: Where is a bug in PostgreSQL or in documentation? I think it was a bug in the code. I have committed a patch that should fix this problem. -- Sent via

[BUGS] BUG #6330: Incorrect select results when using mutually exclusive conditions for nullable column with index

2011-12-07 Thread nikolay . gorshkov
The following bug has been logged on the website: Bug reference: 6330 Logged by: Nikolay Gorshkov Email address: nikolay.gorsh...@gmail.com PostgreSQL version: 9.0.4 Operating system: Ubuntu 10.04.2 LTS Description: How to reproduce: # create table test (uid

[BUGS] BUG #5214: Permission troubles for views

2009-11-26 Thread Nikolay
The following bug has been logged online: Bug reference: 5214 Logged by: Nikolay Email address: whee...@gmail.com PostgreSQL version: 8.4.1 Operating system: Gentoo Linux Description:Permission troubles for views Details: There is two users in database: user_a and

Re: [BUGS] BUG #4479: Incorrect TSearch2 results when inserting after deleting

2008-10-23 Thread Nikolay Samokhvalov
To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-bugs > -- Sincerely yours, Nikolay Samokhvalov Postgresmen LLC, http://postgresmen.ru

Re: [BUGS] No error when FROM is missing in subquery

2006-12-18 Thread Nikolay Samokhvalov
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

[BUGS] No error when FROM is missing in subquery

2006-12-18 Thread Nikolay Samokhvalov
dified limit 10) Is it a bug? If no, maybe to produce warning in such cases? -- Best regards, Nikolay ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [BUGS] Fwd: Strange behaviour of RULE (selecting last inserted ID of 'sequenced' column)

2006-08-11 Thread Nikolay Samokhvalov
8/8/06, Jim Nasby <[EMAIL PROTECTED]> wrote: More of a gotcha than a bug... basically, your select rule is hitting the sequence again. I think there's a section in the rules chapter that talks about this. GeneralBits might also have info. Probably a better question is, what are you tryi

[BUGS] Fwd: Strange behaviour of RULE (selecting last inserted ID of 'sequenced' column)

2006-08-04 Thread Nikolay Samokhvalov
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

Re: [BUGS] Fwd: [NOVICE] Trigger and Recursive Relation ?

2006-08-02 Thread Nikolay Samokhvalov
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

Re: [BUGS] Fwd: [NOVICE] Trigger and Recursive Relation ?

2006-08-02 Thread Nikolay Samokhvalov
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

[BUGS] Fwd: [NOVICE] Trigger and Recursive Relation ?

2006-08-01 Thread Nikolay Samokhvalov
id, parent) values(4, 3); --only 1/2 of the records are deleted! DELETE FROM recursive; ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings -- Best regards, Nikolay ---(end of broadcast

[BUGS] BUG #2490: '||' and type casting for user defined types

2006-06-22 Thread Nikolay Samokhvalov
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

[BUGS] BUG #2245: pg_dump doesn't dump expressions with sequence in DEFAULT setting for some column in table

2006-02-07 Thread Nikolay Samokhvalov
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

[BUGS] Bug #843: pg_clog files problem - clarification

2002-12-11 Thread Nikolay Hristov
esses DEBUG: all server processes terminated; reinitializing shared memory and semaphores Then I copied the data directory to my machine and continued there. The log entries from my original message actually should start here. Please excuse me. Best regards, Nikolay Hristov [EMAIL PROT