[ADMIN] table test

2001-11-28 Thread Manuel Trujillo
Hi. I need to know howto make a test for know the best accuracy of two types of tables: 1- a table with three fields, and with seven registers or more, and 2- a table with ten fields, and two registers. Like my language is very poor, I illustrate this: Table One: Table Two:

[ADMIN] ODBC password crypting support

2001-11-28 Thread sulik_pbem
When trying to connect to the postgreSQL database through ODBC, I get an error "Unknown username or password. Password crypt authentication not supported. (errcode 13095)" I can assume ODBC do not support password crypting. Does that mean I cannot connect through ODBC, or there's another way? --

[ADMIN] éèàïîù Problem

2001-11-28 Thread Vincent . Gaboriau
Hi all, I had curious problem with the characters like " éèàïîù... " (refer to my first mail "[ADMIN] character sequence problem" for more information). My database was encoding with UNICODE. I have created another one with LATIN1 encoding, and I have'nt anymore those problems! Can any one explai

Re: [ADMIN] [HACKERS] upper and lower doesn't work with german

2001-11-28 Thread Vincent . Gaboriau
Tom Lane a écrit : > [EMAIL PROTECTED] writes: > >> You might be able to get it by looking through the > >> /global/pg_control file, but it's a binary file so you'll have > >> to search for it. > > > I had found it, but I don't know speak fluent binary language ;-) > > Does a way exist to "dec

Re: [ADMIN] Creating schema in postgres

2001-11-28 Thread Stephan Szabo
On Wed, 28 Nov 2001, Jyoti Patil wrote: > Hi, > > I would like to know how can we create a schema in postgres. You can't yet. Hopefully it'll be in 7.3. ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.

Re: [ADMIN] Creating schema in postgres

2001-11-28 Thread Andrew G. Hammond
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 2001 November 28 05:35 am, Jyoti Patil wrote: > I would like to know how can we create a schema in postgres. There are graphical front end tools available that will do this for you, but it all comes down to CREATE statements in SQL. You can comm

Re: [ADMIN] [HACKERS] upper and lower doesn't work with german

2001-11-28 Thread Tom Lane
[EMAIL PROTECTED] writes: > But I have This in my pg_control file: > # od -c pg_control > 000 \0 \0 \0 \0 001 \0 \0 \0 \0 \0 \0 \0 \b \0 \0 \0 > 020 ¤ 006 004 < 004 \0 \0 \0 \0 \0 \0 \0 \0 002 \0 > 040 ± Õ ë \v \0 \0 \0 \0 \0 \0 \0 \0 \0

Re: [ADMIN] [HACKERS] upper and lower doesn't work with german

2001-11-28 Thread Vincent . Gaboriau
Tom Lane a écrit : > [EMAIL PROTECTED] writes: > > But I have This in my pg_control file: > > > # od -c pg_control > > 000 \0 \0 \0 \0 001 \0 \0 \0 \0 \0 \0 \0 \b \0 \0 \0 > > 020 ¤ 006 004 < 004 \0 \0 \0 \0 \0 \0 \0 \0 002 \0 > > 040 ± Õ ë \v

Re: [ADMIN] [HACKERS] upper and lower doesn't work with german

2001-11-28 Thread Tom Lane
[EMAIL PROTECTED] writes: >> Er ... *what* version did you say you were running? That doesn't look >> like a 7.1 pg_control to me. > No, I have an 7.0.2 on Linux Mandrake 7.2. Time to update then. 7.0 doesn't freeze the LC_COLLATE setting at initdb, which means that you can corrupt your indexe

Re: [ADMIN] [HACKERS] upper and lower doesn't work with german

2001-11-28 Thread Vincent . Gaboriau
> > The sources of postgres have been deleted, so I can't find this "contrib"! > > So I surch another way to know if postgres have been installed with the local > > configuration. > > Can anyone help me? > > You might be able to get it by looking through the > /global/pg_control file, but it's a b

[ADMIN] Clustering high-availability

2001-11-28 Thread Miguel Gonzalez
Dear all, I am wondering if someone could tell me any experience of building architecture of load balancing for PostgreSQL. I am interested in clustering and a high-availability server. Is that possible? Which tool should I use? Many thanks in advance Miguel --

[ADMIN] Creating schema in postgres

2001-11-28 Thread Jyoti Patil
Hi, I would like to know how can we create a schema in postgres. Many thanks Jyoti. ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are

Re: [ADMIN] [HACKERS] upper and lower doesn't work with german

2001-11-28 Thread Tom Lane
[EMAIL PROTECTED] writes: >> You might be able to get it by looking through the >> /global/pg_control file, but it's a binary file so you'll have >> to search for it. > I had found it, but I don't know speak fluent binary language ;-) > Does a way exist to "decompile" it or to get informations o

[ADMIN] can posgreSQL store data using raw device?

2001-11-28 Thread Ming Du - Sun Microsystems
>From the document, I haven't found it can do this. Does anybody know how to store data to raw device? Thanks. ming du ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMA

Re: [ADMIN] ODBC password crypting support

2001-11-28 Thread Bruce Momjian
> When trying to connect to the postgreSQL database through ODBC, I get an error > "Unknown username or password. Password crypt authentication not supported. > (errcode 13095)" > I can assume ODBC do not support password crypting. Does that mean I cannot > connect through ODBC, or there's anoth

[ADMIN] how often should I run Vacuum

2001-11-28 Thread Leong, Fushan
Hi : Want to get some idea about Vaccum function... How often would you suggest to run Vaccum command? Should I schedule to run in non-busy time like midnight? Vaccum all or Vacuum for each individual table Any tips for Vaccum? thanks Fushan ---(end of broadcast)---