Joost Kraaijeveld wrote:
> How can I change that? Why did the Debian encoding change?
It's derived from the locale, so make sure all your locales are set up
correctly.
> Can I
> still use the Debian deb files or must I manually initdb PostgreSQL?
These options are not exclusive.
--
Peter Eis
Erwin Brandstetter wrote:
> I've been reading tons of stuff on locale and postgresql. I am still
> not in the clear about some details, though: how do system locale and
> database locale work together (or not)?
The system locale is more or less ignored. What matters are the locales
set in the da
[EMAIL PROTECTED] wrote:
Erwin Brandstetter wrote:
I've been reading tons of stuff on locale and postgresql. I am still
not in the clear about some details, though: how do system locale and
database locale work together (or not)?
The system locale is more or less ignored. What matter
On Sun, 2006-03-26 at 10:20 +0200, Peter Eisentraut wrote:
> It's derived from the locale, so make sure all your locales are set up
> correctly.
OK, but how is it derived? As far as I know, I did not change anything
in the locales since the previous time I installed PostgreSQL.
My locales are:
[E
Hello,
I'm not sure whether this is the correct place to post this
question, but I will try here first.
According to the documentation, to connect to
the back-end using SSL a special start-up packet (SSLRequest) is required
before the front-end can begin with the SSL hand-shake.
My questi
Erwin Brandstetter <[EMAIL PROTECTED]> writes:
> Wait .. not that great! The system locale is more or less ignored, but
> my sort order will approach randomness?
Peter's point is that a given locale setting will expect a particular
encoding, and if you try to use a different encoding then your so
"Donald Fraser" <[EMAIL PROTECTED]> writes:
> My question is, can this initial request be avoided in any way - is it =
> possible to start with the SSL handshake without the request?
No, sorry. You might consider tunneling to an ssh proxy port that is
redirected to 5432 locally on the database se
Joost Kraaijeveld wrote:
> OK, but how is it derived? As far as I know, I did not change
> anything in the locales since the previous time I installed
> PostgreSQL.
If your locale is POSIX then it will choose SQL_ASCII. So there is
nothing wrong in PostgreSQL, it's just that your locale is not w
Peter Eisentraut wrote:
> Joost Kraaijeveld wrote:
>> OK, but how is it derived? As far as I know, I did not change
>> anything in the locales since the previous time I installed
>> PostgreSQL.
>
> If your locale is POSIX then it will choose SQL_ASCII. So there is
> nothing wrong in PostgreSQL,
Joost Kraaijeveld wrote:
> But I cannot find where I have to configure what locale in the OS to
> get UTF8 as default encoding for the databases. (I read
> http://www.postgresql.org/docs/8.1/static/multibyte.html but that did
> not give me that info). Can you tell me this or give me a pointer to
>
Hi all,
I had the need to find the user permissions of several tables. I figured
out that if I submit the query
SELECT relacl FROM pg_catalog.pg_class WHERE relname = 'tablename';
I get the permissions but for the table name in all schemas and not only
the one I'm interested in. Then I took a
Milen Dzhumerov wrote:
> Unfortunately if I try to submit it, it gives me some
> error.
You need to post your exact input and the exact output. Otherwise we're
just guessing.
> My other
> question is who has access to the pg_catalog.* tables?
Everybody.
> And are these tables per database
> o
In vacuum full output, indexes are listed as having been vacuumed along with their table.
Have I misinterpreted this message saying that vacuum is incapable of vacuuming indexes (and reindex is the only option to do so) please?
On 3/25/06, Tom Lane <[EMAIL PROTECTED]> wrote:
Peter Eisentraut <[EMA
Below is an old message from Tom Lane regarding "Notice Processor hook". I have not been able to contact him to explain it, nor does it appear in the Postgresql.org archives. Would one of you be able to help me to implement this please? We are trying to obtain the output from a vacuum run by automa
Tom Lane <[EMAIL PROTECTED]> writes:
> Jerry Sievers <[EMAIL PROTECTED]> writes:
> > At any rate; I'm wondering what possible causes might be responsible
> > for pg_stat_activity's underlying functions to lose track of the valid
> > process list?
>
> It sounds like the stats collector missed a fe
Hi...
I want to have a database/table with dot(
. ) in its name.But i am unable to create a database with a dot
in the middle of its name..Is there any possibility of doing it?If yes pls tell
me.
Thank you,
Sandhya
On Mon, Mar 27, 2006 at 12:11:40PM +0530, sandhya wrote:
>I want to have a database/table with dot( . ) in its name.But
> i am unable to create a database with a dot in the middle of its
> name..Is there any possibility of doing it?If yes pls tell me.
See the documentation regarding quoted ide
On Mar 27 12:07, adey wrote:
> Below is an old message from Tom Lane regarding "Notice Processor hook".
> ... Would one of you be able to help me to implement
> this please?
Not me, but you can:
[28.10. Notice Processing]
http://www.postgresql.org/docs/current/interactive/libpq-notice-proces
18 matches
Mail list logo
