From: | Alex Pilosov <alex(at)pilosoft(dot)com> |
---|---|
To: | Martín Marqués <martin(at)bugs(dot)unl(dot)edu(dot)ar> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: TODO item |
Date: | 2001-07-05 03:16:23 |
Message-ID: | Pine.BSO.4.10.10107042312310.7004-100000@spider.pilosoft.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Wed, 4 Jul 2001, [iso-8859-1] Martn Marqus wrote:
> I was thinking about a par of things that I think are quite interesting for
> the 7.2 release.
>
> The first one is related to a problem I had with views and rules (permission
> problem). If someone is granted insert on a view with his respective rule,
> won't be able to insert a row if there is a sequence (SERIAL type), saying
> that the user doesn't have permission to change the sequence.
Essentially, sequence is treated as a separate table for purposes of
permission checking. Its probably _not very hard_ to fix, by forcing check
of the underlying relation instead of check of sequence itself...Whether
its a right thing to do, I'm not sure.
> The other is related to indexes on databases other then initiated with C
> locale. The docs say that those databases don't use the indexes on sequencial
> searches. Is this right?
Only queries using LIKE 'foo%', cannot use indices.
Reason: you don't know what foo will collate in different locale, i.e.
there may be foo with umlaut o, which _should_ match 'foo', but you cannot
index this kind of a search...
From | Date | Subject | |
---|---|---|---|
Next Message | Colin Taylor | 2001-07-05 07:08:55 | RE: Table Description!! |
Previous Message | CD Baby | 2001-07-05 02:12:59 | Re: PostgreSQL ports post-installation gives core dump? |