Hello,
Can anyone please throw some light on the behavior of postgres when it comes
to permission issues... I'm using enterprisedb 8.3 on opensuse linux 10.3
and 11 (2 machines).
This is what i have understood so far:
Lets say user user1 is a non-root user. I login to the machine as root and
> Now during installation, the user 'postgres' will be created if it doesnt
> already exist. And these 2 users (user1, postgres) will have write
> permissions to each other's home directories.
>
>
> Please tell me if my understanding so far is correct and if you can
> enlighten me further.
I thin
I found this problem, where 'ã' MUST be ILIKE 'Ã' (PostgreSQL 8.2.12, RedHat
x86_64):
brd2=# SET client_encoding TO unicode;
SET
brd2=# SELECT 'ã' LIKE 'ã';
?column?
--
t
(1 registro)
brd2=# SELECT UPPER('ã') LIKE UPPER('ã');
?column?
--
t
(1 registro)
brd2=# SELECT 'Ã' LIKE
Daniel Cristian Cruz writes:
> I found this problem, where 'ã' MUST be ILIKE 'Ã' (PostgreSQL 8.2.12, RedHat
> x86_64):
Is your database encoding iso88591? IIRC, 8.2 will try to warn you if
the encoding doesn't match the locale setting, but it doesn't completely
refuse nonsensical combinations.