Re: [ADMIN] two databases

2002-05-28 Thread Jean-Michel POURE
p://pgadmin.postgresql.org -> pgAdmin2 interface Cheers, Jean-Michel POURE ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[ADMIN] UTF-8 safe ascii() function

2002-05-18 Thread Jean-Michel POURE
ten an ascii UTF-8 safe wrapper to ascii() function? If yes, would you be so kind to publish this function on the list. 2) Are there plans to add an ascii() UTF-8 safe function to PostrgeSQL? Best regards, Jean-Michel POURE ---(end of broadcast)--- T

[ADMIN] HOWTO - Random character generation for primary key

2002-05-02 Thread Jean-Michel POURE
Le Jeudi 2 Mai 2002 04:01, Alan Wayne a écrit : > In foxpro, I've been using the provided 10-character > random generator to provide for the primary keys on my > data files. As far as I can tell, PostgreSQL only uses > an auto-incrementing serial field for its primary > keys. So as far as I can se

Re: [ADMIN] postgresql authentication

2002-05-01 Thread Jean-Michel POURE
Le Mercredi 1 Mai 2002 21:55, Hal Lynch a écrit : > Can some kind soul give me a clue how to do it, or where to look > for instructions? Did you restart PostgreSQL service to reload pg_hba.conf? "service postgresql restart" Just my two cents, Jean-Michel POURE ---

[ADMIN] Performance HOWTO - pseudo counter example

2002-04-29 Thread Jean-Michel POURE
Le Jeudi 25 Avril 2002 20:54, S Grannis a écrit : > I think our work-around for now will be to SELECT the column we wish to > analyze into a flat file and then run a Perl script to do the actual > counting. Dear all, I wrote a small howto to solve S Grannis performance questions on Count() func

Re: [ADMIN] RPMS

2002-04-28 Thread Jean-Michel POURE
rs; even with all libraries installed. From then, I always used the --target i586 flag. Cheers, Jean-Michel POURE ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [ADMIN] access is denied completely from postgresql!!

2002-03-23 Thread Jean-Michel POURE
se, you can also have a look at pgAdmin2 (http://pgadmin.postgresql.org). pgAdmin2 takes advantage of the lastest 7.2 improvements. Regards, Jean-Michel POURE ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html

Re: [ADMIN] access is denied completely from postgresql!!

2002-03-23 Thread Jean-Michel POURE
what is going on. 1) What is the version of you PostgreSQL installed (rpm -q postgresql)? Alternatively, what is your linux distribution? 2) Do you have a backup of your database (schema + data)? 3) What do the logs say when you try to start the database (probably with 'service postgresql st

Re: [ADMIN] which site i download postsql

2002-03-21 Thread Jean-Michel POURE
cludes odbc drivers). Best regards, Jean-Michel POURE ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html

Re: [ADMIN] to --enable-locale or not to --enable-locale?

2002-03-17 Thread Jean-Michel POURE
ITH ENCODING 'Unicode'; - SET CLIENT_ENCODING = 'Latin9' (=ISO-8859-15) = Latin1 + euro symbol. In pgAdmin2, we plan to take advantage of these new features to : - change client encoding on the fly, - display multi-byte text. Cheers, Jean-Michel POURE ---(end of

Re: [ADMIN] Dependence beetwen Function

2002-03-13 Thread Jean-Michel POURE
Le Mercredi 13 Mars 2002 16:11, Gaetano Mendola a écrit : > But of course I should use it with the version 7.2 for use this feature. > Or not ? Yes, CREATE OR REPLACE FUNCTION is only available from PostgreSQL 7.2+. ---(end of broadcast)--- TIP 1: s

Re: [ADMIN] Dependence beetwen Function

2002-03-13 Thread Jean-Michel POURE
Gaetano Dear Gaetano, pgAdmin2 (http://www.pgadmin.org) support CREATE OR REPLACE FUNCTION. Also, the CVS latest version offers pseudo modification of views and triggers (binaries available in CVS). Regards, Jean-Michel POURE ---(end of broadcast)--

Re: [ADMIN] Linux Distributions

2002-03-07 Thread Jean-Michel POURE
> I'm wondering if there is a specific Linux distribution for the x86 that > will provide a better PostgreSQL server than the other ones? > Thanks, > Peter Darley Dear Peter, PostgreSQL will only be PostgreSQL and there is no real difference, except compilation choices and RPM package names. I

Re: [ADMIN] PHP ODBC conflict

2002-03-01 Thread Jean-Michel POURE
Le Vendredi 1 Mars 2002 15:40, Gary Stainburn a écrit : > Thanks for the comments, but I don't think that I made myself clear. > I am connecting using the native PHP pg support.  The only bit I'm using > ODBC for is the Windows/Delphi stuff. > BTW, the Delphi app can connect/disconnect as often as

Re: [ADMIN] PHP ODBC conflict

2002-03-01 Thread Jean-Michel POURE
re are many available for PHP : ADODB (ADO port under PHP), PEARDB (http://pear.php.net) available from PHP cvs, etc... Best regards, Jean-Michel POURE ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command

Re: [ADMIN] problems with PgAdmin and database encoding.

2002-02-26 Thread Jean-Michel POURE
> An incredible amount of thank's for you and the PgAdmin Team ;) > All work fine now. Thank you for your quickly answer, and for you and > the rest of the team for the great work with PgAdmin. > Thank you. Manuel Trujillo > Have a nice day ;-) > TooManySecrets You are welcome. Jean-Michel -

[ADMIN] UTF-8 lenght of a string

2002-02-22 Thread Jean-Michel POURE
Dear all, How can I calculate the real lenght a an utf-8 string? Is there a server-side function available? Best regards, Jean-Michel POURE ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[ADMIN] fmgr_info: function 20071: cache lookup failed

2002-02-21 Thread Jean-Michel POURE
Dear all, After migration to PostgreSQL 7.2, modifying a function with CREATE OR REPLACE foo, and running the function, backend returns : fmgr_info: function 20071: cache lookup failed. Any idea? Best regards, Jean-Michel POURE ---(end of broadcast

Re: [ADMIN] [pgadmin-hackers] Hebrew support

2002-02-19 Thread Jean-Michel POURE
> Jean-Michel.. if you are reading, have you had any more thoughts on this? > If we knock up a test app, can you test on any of you machines? We could at > least then allow the pgAdmin user to select the font, and have them > download a suitable one if required. Dear Dave, It is not a problem of

Re: [ADMIN] Locale support

2002-02-14 Thread Jean-Michel POURE
rowser has Japanese fonts installed. Visit Japan Yahoo, this should suffice as a test. Hope this is enough, Cheers, Jean-Michel POURE ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html

[ADMIN] ALTER / DROP information for pgAdmin2

2002-02-13 Thread Jean-Michel POURE
surprise some of you. This was just my 0.02 cents. The overall quality of PostgreSQL is excellent, so don't flame me for this mail. We only need more information from hackers to make a better pgAdmin2. Cheers, Jean-Michel POURE ---(end of broadcast)--

Re: [ADMIN] Where can i get PgAccess installable software

2002-02-12 Thread Jean-Michel POURE
Cheers, Jean-Michel POURE ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html

[ADMIN] CREATE OR REPLACE VIEW / TRIGGER

2002-01-17 Thread Jean-Michel POURE
-Michel POURE ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly

Re: [ADMIN] [Solution] PG 7.1.3 & MacOS X (10.1)

2001-11-12 Thread Jean-Michel POURE
At 10:26 12/11/01 -0600, you wrote: >Something completely different: I believe GreatBridge is no longer. Who is >the driving force behind the further development of PostGreSQL right now - >and if some of you guys do this full time, what is your motivation and how >do you survive? PostgreSQL is