[HACKERS] client encodings

2003-06-15 Thread Dennis Björklund
I've fixed the problems in psql that was there before: * psql alters the strings in a PQresult * psql sends non validating strings to server This is however not the solution to the general problem with client encodings. When you normally run psql in a terminal, the encoding used by that

Re: [HACKERS] Pre-allocation of shared memory ...

2003-06-15 Thread Shridhar Daithankar
On 14 Jun 2003 at 16:38, Andrew Dunstan wrote: Summary: don't take shortcuts looking for this - Read the Source, Luke. It's important not to give people false expectations. For now, I'm leaning in Tom's direction of advising people to avoid Linux for mission-critical situations that could run

Re: [HACKERS] Pre-allocation of shared memory ...

2003-06-15 Thread Andrew Dunstan
Alan Cox has written to me thus: It got dropped for RH9 and some errata kernels because of clashes between the old stuff and the rmap vm and other weird RH patches andrew - Original Message - From: Andrew Dunstan [EMAIL PROTECTED] To: Tom Lane [EMAIL PROTECTED] Cc: Kurt Roeckx [EMAIL

[HACKERS] Data recovery - URGENT

2003-06-15 Thread Peter Galantha
Hello, is there a way to recover data from a damaged database if a.) we have some but not all datafiles b.) we have all datafiles but system tables are currupted The situation is extremely critical so we're interested in all possible solutions even if it's time consuming or if we need to pay

[HACKERS] sa_family_t in cygwin compile of cvs + regression failure

2003-06-15 Thread deststar
On cygwin sa_family_t was undeclared, adding the following line: typedef unsigned short sa_family_t; to both: src/port/getaddrinfo.c src/include/libpq/pqcomm.h seemed to compile ok but with make check there was one regression failure in test privileges (doesn't look realted, but I'm not sure).

[HACKERS] exit status 512

2003-06-15 Thread Peter Galantha
Hi hackers, there was a hardware failure 'couse we had to turn off the computer manually. After the hardware change, the database reports exit status 512. Can anybody help me what 'Startup proc 850 exited with status 512' mean? how can I solve this problem? Peter Galantha argosz at tensa.net

Re: [HACKERS] exit status 512

2003-06-15 Thread Tom Lane
Peter Galantha [EMAIL PROTECTED] writes: Hi hackers, there was a hardware failure 'couse we had to turn off the computer manually. After the hardware change, the database reports exit status 512. Can anybody help me what 'Startup proc 850 exited with status 512' mean? You're showing us the

Re: [HACKERS] UTF8 and KOI8 mini-howto

2003-06-15 Thread Markus Bertheau
, 13.06.2003, 20:02, Oleg Bartunov : Hi there, I've managed to get postgresql working with UTF8 and KOI8. Here is some mini-howto: http://www.sai.msu.su/~megera/postgres/utf8.html The correct name for UTF-8 locales is xx_XX.UTF-8, not upper case and the minus. -- Markus Bertheau.

Re: [HACKERS] UTF8 and KOI8 mini-howto

2003-06-15 Thread Markus Bertheau
, 15.06.2003, 21:08, Markus Bertheau : The correct name for UTF-8 locales is xx_XX.UTF-8, not upper case and s/not/note/ the minus. -- Markus Bertheau. Berlin, Berlin. Germany. ---(end of

Re: [HACKERS] UTF8 and KOI8 mini-howto

2003-06-15 Thread Markus Bertheau
, 13.06.2003, 20:02, Oleg Bartunov : Hi there, I've managed to get postgresql working with UTF8 and KOI8. Here is some mini-howto: http://www.sai.msu.su/~megera/postgres/utf8.html select lower(''); returns '' with this setup here, any idea why this is the case? -- Markus Bertheau.

Re: [HACKERS] UTF8 and KOI8 mini-howto

2003-06-15 Thread Oleg Bartunov
Markus, I have used ru_RU.utf8 which recognized by system, at least that name was generated by localedef program. Oleg On Sun, 15 Jun 2003, Markus Bertheau wrote: , 15.06.2003, 21:08, Markus Bertheau : The correct name for UTF-8 locales is xx_XX.UTF-8, not upper case and

Re: [GENERAL] [HACKERS] UTF8 and KOI8 mini-howto

2003-06-15 Thread Oleg Bartunov
On Sun, 15 Jun 2003, Markus Bertheau wrote: , 13.06.2003, 20:02, Oleg Bartunov : Hi there, I've managed to get postgresql working with UTF8 and KOI8. Here is some mini-howto: http://www.sai.msu.su/~megera/postgres/utf8.html select lower(''); returns '' with this setup here, any

Re: [GENERAL] [HACKERS] UTF8 and KOI8 mini-howto

2003-06-15 Thread Oleg Bartunov
Marcus, I suspect lower,upper will not works with Unicode. Read thread http://fts.postgresql.org/db/msg.html?mid=1070198 Tatsuo is the right person to ask. Oleg On Mon, 16 Jun 2003, Oleg Bartunov wrote: On Sun, 15 Jun 2003, Markus Bertheau wrote: , 13.06.2003, 20:02, Oleg

Re: [GENERAL] [HACKERS] UTF8 and KOI8 mini-howto

2003-06-15 Thread Markus Bertheau
, 16.06.2003, 01:26, Oleg Bartunov : Markus, I suspect lower,upper will not works with Unicode. It doesn't work with KOI8-R here, too. -- Markus Bertheau. Berlin, Berlin. Germany. ---(end of broadcast)--- TIP 2: you can get off all lists at

Re: [HACKERS] Data recovery - URGENT

2003-06-15 Thread Jan Wieck
Peter Galantha wrote: Hello, is there a way to recover data from a damaged database if a.) we have some but not all datafiles b.) we have all datafiles but system tables are currupted The situation is extremely critical so we're interested in all possible solutions even if it's time consuming

Re: [HACKERS] security flaw

2003-06-15 Thread Christopher Kings-Lynne
Since schemas provide a simple way to limit your own view, they provide for that function. Can phppgadmin be programmed to only use certain search paths in the schema? Not at the moment. The only control you have is 'show only owned databases'. 'Show only owned schemas' is also quite easy.

Re: [HACKERS] Groups and roles

2003-06-15 Thread Christopher Kings-Lynne
1. Do we want to someday allow groups to have groups as members? (Seems reasonable to me.) I agree. I think the other requirement of roles is that they are able to own objects. ie. we need to allow groups to own objects. Chris ---(end of

Re: [HACKERS] Groups and roles

2003-06-15 Thread Tom Lane
Christopher Kings-Lynne [EMAIL PROTECTED] writes: I think the other requirement of roles is that they are able to own objects. ie. we need to allow groups to own objects. Hm. That seems to be another reason to unify usesysid and grosysid into a single unique something-id. Which probably

Re: [HACKERS] enumeration type?

2003-06-15 Thread Christopher Kings-Lynne
There is no such thing as an enumeration type. What there is is the char type with a CHECK constraint. MySQL made up ENUMs out of whole cloth...they should copy our way, not us theirs... Chris - Original Message - From: Andrew Dunstan [EMAIL PROTECTED] To: PostgreSQL Hackers Mailing

Re: [HACKERS] Groups and roles

2003-06-15 Thread Christopher Kings-Lynne
Christopher Kings-Lynne [EMAIL PROTECTED] writes: I think the other requirement of roles is that they are able to own objects. ie. we need to allow groups to own objects. Hm. That seems to be another reason to unify usesysid and grosysid into a single unique something-id. Which probably

Re: [GENERAL] [HACKERS] UTF8 and KOI8 mini-howto

2003-06-15 Thread Oleg Bartunov
On Mon, 16 Jun 2003, Markus Bertheau wrote: , 16.06.2003, 01:26, Oleg Bartunov : Markus, I suspect lower,upper will not works with Unicode. It doesn't work with KOI8-R here, too. What ? It works for me for years ! Did you check your system locale ? Regards,