"Akmal Akmalhojaev" <[EMAIL PROTECTED]> writes:
> I have the following question: where role privileges on working with tables,
> data bases and so on are stored in PostgreSQL (In what system catalogs?)?
Privileges are attached to the target objects, eg pg_class.relacl for
relations. Look for colu
The pgstats subsystem does not correctly account for the effects of
failed transactions. Note the live/dead tuple counts in this example:
regression=# create table foo (f1 int);
CREATE TABLE
regression=# insert into foo select x from generate_series(1,1000) x;
INSERT 0 1000
-- wait a second for s
Hello.
I have the following question: where role privileges on working with tables,
data bases and so on are stored in PostgreSQL (In what system catalogs?)?
Thanks.
Akmal.
On 5/25/07, Bernd Helmle <[EMAIL PROTECTED]> wrote:
--On Freitag, Mai 25, 2007 00:02:06 + Jaime Casanova
<[EMAIL PROTECTED]> wrote:
>>
>
> sounds good. can we see the new patch?
Attached tablespace.c.diff shows my current changes to use an OID lookup
list.
>
+ if (source >= PGC_S_I
On 5/25/07, Tom Lane <[EMAIL PROTECTED]> wrote:
Bernd Helmle <[EMAIL PROTECTED]> writes:
> --On Freitag, Mai 25, 2007 10:49:29 + Jaime Casanova
> <[EMAIL PROTECTED]> wrote:
>> No, because the RemovePgTempFiles() call in PostmasterMain() will
>> remove all tmp files at startup.
I believe we d
Bernd Helmle <[EMAIL PROTECTED]> writes:
> --On Freitag, Mai 25, 2007 10:49:29 + Jaime Casanova
> <[EMAIL PROTECTED]> wrote:
>> No, because the RemovePgTempFiles() call in PostmasterMain() will
>> remove all tmp files at startup.
> Hmm isn't RemovePgTempFiles() called on postmaster startup on
--On Freitag, Mai 25, 2007 00:02:06 + Jaime Casanova
<[EMAIL PROTECTED]> wrote:
the original patch is from Albert Cervera =)
Ah, missed that, thanks ;)
sounds good. can we see the new patch?
Attached tablespace.c.diff shows my current changes to use an OID lookup
list.
the
--On Freitag, Mai 25, 2007 10:49:29 + Jaime Casanova
<[EMAIL PROTECTED]> wrote:
No, because the RemovePgTempFiles() call in PostmasterMain() will
remove all tmp files at startup.
Hmm isn't RemovePgTempFiles() called on postmaster startup only? What will
happen if a temp tablespace is out
Andrew Dunstan <[EMAIL PROTECTED]> writes:
> do { (t)++; (tlen)--} while ((*(t) & 0xC0) == 0x80 && tlen > 0)
The while *must* test those two conditions in the other order.
(Don't laugh --- we've had reproducible bugs before in which the backend
dumped core because of running off the end of memo
"Zeugswetter Andreas ADI SD" <[EMAIL PROTECTED]> writes:
>> You have to be on a first byte before you can meaningfully
>> apply NextChar, and you have to use NextChar or else you
>> don't count characters correctly (eg "__" must match 2 chars
>> not 2 bytes).
> Well, for utf8 NextChar could adv
[EMAIL PROTECTED] wrote:
Is it worth the effort to pre-process the pattern?
For example:
%% -> %
This is already done, required by spec.
%_ -> _%
If applied recursively, this would automatically cover:
%_% -> _%
_%_ -> __%
The 'benefit' would be that the pattern
Zeugswetter Andreas ADI SD wrote:
You have to be on a first byte before you can meaningfully
apply NextChar, and you have to use NextChar or else you
don't count characters correctly (eg "__" must match 2 chars
not 2 bytes).
Well, for utf8 NextChar could advance to the next char even
On 5/25/07, Tom Lane <[EMAIL PROTECTED]> wrote:
"Jaime Casanova" <[EMAIL PROTECTED]> writes:
> On 5/24/07, Alvaro Herrera <[EMAIL PROTECTED]> wrote:
>> What happens if you create a cursor that stores something (sort
>> intermediate results?) in a temp tablespace, FETCH some from it, then
>> someo
> > However, I have just about convinced myself that we don't need
> > IsFirstByte for matching "_" for UTF8, either preceded by "%" or
not,
> > as it should always be true. Can anyone come up with a counter
example?
>
> You have to be on a first byte before you can meaningfully
> apply NextCh
On 5/25/07, Hitoshi Harada <[EMAIL PROTECTED]> wrote:
It's not only about Japanese. When you search "phrase" for text in English,
the same logic above will be needed. I don't research about tsearch2 but is
there any problem?? Also, in some case int-array inverted index needs the
entry positions a
15 matches
Mail list logo