On Sun, 17 Sep 2000, Tom Lane wrote:
> >> Postgres has an 'ascii' function that converts
> >> characters to ascii, values, but it appears to be a
> >> one way street. I can't find a way to convert ascii
> >> values to characters, like 'chr' in Oracle. Anyone
> >> know how to do this?
>
> ichar
Hannu Krosing <[EMAIL PROTECTED]> writes:
> I get the following on untuned Linux (Redhat 6.2) using stock 7.0.2
> rpm-s
> NOTICE: RegisterSharedInvalid: SI buffer overflow
> NOTICE: InvalidateSharedInvalid: cache state reset
> Actually I get many of them ;(
AFAIK, these are just noise in 7.0.
At 16:29 17/09/00 -0400, Tom Lane wrote:
>As somebody pointed out a few days ago, pg_dump silently loses tables
>whose owners can't be identified.
This is now fixed in CVS. The owner of all objects are now retrieved by
using column select expressions.
If you can recall where it was, I'd be int
At 12:48 18/09/00 +1000, Philip Warner wrote:
>>
>>You should be able to fix the latter problem by doing an outer join,
>>though it doesn't quite work yet in current sources. pg_get_userbyid()
>>offers a different solution, although it won't return NULL for unknown
>>IDs, which might be an easier
At 16:29 17/09/00 -0400, Tom Lane wrote:
>
>getTables(): SELECT failed. Explanation from backend: 'ERROR: cache
lookup of attribute 1 in relation 400384 failed
>'.
>
>This is just about entirely useless as an error message, wouldn't you
>say?
I agree but the is representative of the error handl
> backend/regex/regcomp.c cause the problem. I compiled only this file
> with -funsigned-char option and the problem gone away !
> Also, I know that in case of --enable-multibyte I dont' have any problem,
> so in principle it's enough to look into
> #ifdef MULTIBYTE sections in backend/regex/regc
I get the following on untuned Linux (Redhat 6.2) using stock 7.0.2
rpm-s
NOTICE: RegisterSharedInvalid: SI buffer overflow
NOTICE: InvalidateSharedInvalid: cache state reset
Actually I get many of them ;(
I'm running a script that does a bunch of mixed INSERTS, UPDATES,
DELETES and SELECTS.
Okay, so this will happen then...
Peter Eisentraut writes:
> Is there a compelling reason to continue to ship a "pre-7" version of the
> ODBC catalog extension in contrib/odbc?
>
> If not, could we not instead move the odbc.sql file into interfaces/odbc
> and install it with the odbc driver? ("
I was experimenting today with pg_dump's reaction to missing
dependencies, such as a rule that refers to a no-longer-existing
table. It's pretty bad. For example:
create table test (f1 int);
create view v_test as select f1+1 as f11 from test;
drop table test;
then run pg_dump:
getTables(): SE
On Sun, 17 Sep 2000, Tatsuo Ishii wrote:
> Date: Sun, 17 Sep 2000 11:05:42 +0900
> From: Tatsuo Ishii <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED]
> Subject: Re: [HACKERS] broken locale in 7.0.2 without multibyte support (FreeBSD
>4.1-
Well,
with the help of Tatsuo I found the problem is in backend/regex/regcomp.c
I'll look for more details and probably could make a fix.
quick question: is there in sources locale-aware strncmp function
or I need to write myself ?
As for the compiler option I think we should'nt use any
"-funsi
Thomas Lockhart <[EMAIL PROTECTED]> writes:
>> AFAIK hardly anyone actually uses CURRENT, and I've been thinking of
>> proposing that we eliminate it to make the world safe for constant-
>> folding timestamp operations. (Thomas, any comments here?)
> Well, it is a feature from "the old days". Pr
>> Postgres has an 'ascii' function that converts
>> characters to ascii, values, but it appears to be a
>> one way street. I can't find a way to convert ascii
>> values to characters, like 'chr' in Oracle. Anyone
>> know how to do this?
ichar(). Since that's part of the "oracle_compatibility"
Peter Eisentraut <[EMAIL PROTECTED]> writes:
> Where were we on this? Yes/No/Maybe?
>>
Instead, when fmgr is setting up to call a setuid function, have it
insert an extra level of function handler that does the
save/setup/restore of current UID.
>>
>> I don't quite understand. Do
Peter Eisentraut <[EMAIL PROTECTED]> writes:
> I think that the problem might rather be that lower_text (and various
> other arrays) are not declared as unsigned char in the first place. That
> would also explain why -funsigned-chars fixes it. Because calling
> toupper() etc. with a signed char ar
Where were we on this? Yes/No/Maybe?
Peter Eisentraut writes:
> Tom Lane writes:
>
> > > Btw., FunctionCallInvoke() would look to be the most prominent place to
> > > hook in the "setuid" feature. For that purpose I'd make the macro an
> > > inline function instead.
> >
> > Ugh. The performan
Tom Lane writes:
> - if (isascii((unsigned char)lower_text[i]) && isupper(lower_text[i]))
> + if (isascii((int)lower_text[i]) && isupper((int) lower_text[i]))
> Peter, I suppose what you were trying to clean up is a "char used as
> array subscript" kind of warning?
Yep.
> I
On Sat, 16 Sep 2000, Alex Sokoloff wrote:
> Postgres has an 'ascii' function that converts
> characters to ascii, values, but it appears to be a
> one way street. I can't find a way to convert ascii
> values to characters, like 'chr' in Oracle. Anyone
> know how to do this?
Interesting for me
It might be that `make depend' is broken in one way or another. What you
want to do is rm `find . -name depend` and then ./configure
--enable-depend. Or you could try to rerun make depend then. I have a
feeling what is causing this but it's too weird to explain but I'll try to
look at it. ;-)
Mic
Zeugswetter Andreas SB writes:
> Imho it is fine to get rid of the usesysid in our internal
> authorization system, but we should not get rid of the only field that
> can tie a db user to an os user. Imho we should not do a "by name"
> lookup and eliminate the field.
Um, well, the only possible
20 matches
Mail list logo
