List metadata tags (was Re: [GENERAL] Auto Increment)

2000-12-27 Thread Peter Eisentraut
Tom Lane writes: At one time Marc was arranging for the list bot to append automatic tags to all postings. I'd be in favor of an automatic tag that read something like list administrivia: [EMAIL PROTECTED] Postgres FAQs: http://... Suggestions anyone? (Keep

[GENERAL] This locale setting will prevent use of index optimization for LIKE and regexp searches. (sl_SI.ISO_8859-2)

2000-12-27 Thread Tomaz Borstnar
Hello! Installed 7.1beta1, set LC_ALL to sl_SI.ISO_8859-2 and initialized the database with initdb and got this: NOTICE: Initializing database with sl_SI.ISO_8859-2 collation order. This locale setting will prevent use of index optimization for LIKE and regexp

[GENERAL] SSL

2000-12-27 Thread Alvaro Herrera
Hi I wanted to use SSL with Postgres, and while searching through the maillists I found a very old post (1998) Brett McCormick. I found his patch in chicken.org, but it seems to be somewhat old (it's for PGSQL 6.3.2; I'm using 7.0.3). I wrote him directly ([EMAIL PROTECTED]), but the MTA said

[GENERAL] postgres JDBC Serialize()

2000-12-27 Thread Jarek
I have problems with using Serialize class from postgres JDBC API. Can anybody tell me what should be done in order to serialize objects into postgres data base ? -- MS is not the answer. MS is the question. NO (or Linux) is the answer. :) Jarek (:

Re: [GENERAL] SSL

2000-12-27 Thread Tom Lane
Alvaro Herrera [EMAIL PROTECTED] writes: I couldn't find any other info about using SSL with PostgreSQL. http://www.postgresql.org/devel-corner/docs/postgres/ssl-tcp.htm I seem to recall hearing that the SSL code was broken in 7.0.*. If so, you may want to try 7.1beta.

Re: [GENERAL] NEXTVAL function Bug

2000-12-27 Thread Tom Lane
"Dan Wilson" [EMAIL PROTECTED] writes: test_db=# insert into "mixed_Case" (mix_id, mix_var) values (nextval('mixed_Case_mix_id_seq'), 'not working'); ERROR: Relation 'mixed_case_mix_id_seq' does not exist You need to do it like this: nextval('"mixed_Case_mix_id_seq"') IMHO it's

[GENERAL] RE: PQsetnonblocking

2000-12-27 Thread Tim Barnard
Never mind. I figured it out via the src code. Thanks anyway! Tim S.E. Mgr. Hartford Communications

[GENERAL] LD_LIBRARY_PATH

2000-12-27 Thread Chris Hayner
hello all. I suppose I should introduce myself, since I am new around here, and as such will probably be asking a lot of silly questions. I apologize for that in advance. My name is Chris Hayner and I work for Temple University doing various work on all flavors of UNIX. My current task is to

Re: [GENERAL] LD_LIBRARY_PATH

2000-12-27 Thread Larry Rosenman
* Chris Hayner [EMAIL PROTECTED] [001227 11:41]: hello all. I suppose I should introduce myself, since I am new around here, and as such will probably be asking a lot of silly questions. I apologize for that in advance. My name is Chris Hayner and I work for Temple University doing

[GENERAL] Re: Permissions on Stored Procedures == current_user

2000-12-27 Thread jmoschet
After re-reading my original *idea* about using rules to grant access to stored procedures, I think the better way would be not to implement the code as stored procedures/functions at all. Leave that for the more complex low-level add-ons to database functionality . Using rules and views

[GENERAL] NFS mounted DBs and Vacuum

2000-12-27 Thread Webb Sprague
I have a server for which PG_DATA = /home/maxtor, an NFS mounted disk. Normally it works great, but when I try to vacuum, it takes FOREVER. Should I not even try to use remote storage like this? Has anybody else run into a similar problem? Thanks in advance, -- Webb Sprague Programmer O1

Re: [GENERAL] LD_LIBRARY_PATH

2000-12-27 Thread Robert B. Easter
I guess this is a little off topic, but anyhow... See: man 8 ld.so man 8 ldconfig LD_LIBRARY_PATH is generally harmless. Set inside a user's .profile, it allows a user to have user-specific searchable lib directories in addition to global lib directories kept in /etc/ld.so.conf and/or a

[GENERAL] Re: SSL

2000-12-27 Thread drevil
I would also like to use SSL, or better SSH, with Postgres. I know I could use SSH tunneling, but it would be even better if it were integrated. Does anyone know if this is possible? Thanks

Re: [GENERAL] LD_LIBRARY_PATH

2000-12-27 Thread Mike Castle
On Wed, Dec 27, 2000 at 01:40:09PM -0500, Robert B. Easter wrote: See: man 8 ld.so man 8 ldconfig LD_LIBRARY_PATH is generally harmless. Set inside a user's .profile, it Coming from a linux world? hawkeye:/export/home/b015414$ ls /etc/ld* /etc/ld*: No such file or directory Linux acts

[GENERAL] Functions in Postgre

2000-12-27 Thread Uro Gruber
Hi! I have 2 questions. 1. I want to store some data in database (8 different fields) and then check some other thig and if something is ok i wan't to update some data. I think i have to use function for this, because i don't want to send so many queries over the net. But now i'm confused. Is

[GENERAL] PostgreSQL on AIX

2000-12-27 Thread Rick Vlahov
I am interested in using PostgreSQL on IBM AIX 4.1 4.3 I am using it to post from legacy(non- SQL based) applications on the AIX that I will have access to the source code. The applications work great and I'm looking only to add functionality(Web access). I will be using

Re: [GENERAL] LD_LIBRARY_PATH

2000-12-27 Thread Peter Eisentraut
Mike Castle writes: Linux acts somewhat differently with respect to LD_* variables when compared to other systems. Not really. Speaking of administrative nightmares, did I read correctly that 7.1 now users -R by default when linking? Ack! Doesn't that make it nearly impossible for an

[GENERAL] Re: Auto Increment

2000-12-27 Thread postgres
I had looked everywhere to find the answer to this question. Now that I look at the FAQ again I see it in there. I tryed searching the FAQ for "auto increment" when it turns out to be "auto-increment" on the FAQs page. Being a MySQL user who was dead ended and had no choice but to find a new

Re: [GENERAL] Tuning Database

2000-12-27 Thread Joseph Shraibman
Anand Raman wrote: there is a white paper present on the great bridge site (http://www.greatbridge.com/) where u can find some tuning tips . Where, persactly? -- Joseph Shraibman [EMAIL PROTECTED] Increase signal to noise ratio. http://www.targabot.com

Re: [GENERAL] LD_LIBRARY_PATH

2000-12-27 Thread Robert B. Easter
On Wednesday 27 December 2000 15:09, Mike Castle wrote: On Wed, Dec 27, 2000 at 01:40:09PM -0500, Robert B. Easter wrote: Just think if you have to move all users from one version to another. You would prefer to edit each person's .profile rather than one central one? When I set it up, I did

Re: [GENERAL] Tuning Database

2000-12-27 Thread Kevin Lo
Joseph Shraibman wrote: Anand Raman wrote: there is a white paper present on the great bridge site (http://www.greatbridge.com/) where u can find some tuning tips . Where, persactly? http://www.greatbridge.com/download/gbpg70wp2.pdf -- Joseph Shraibman [EMAIL PROTECTED] Increase

Re: [GENERAL] User Privileges

2000-12-27 Thread W. van den Akker
How do I retrieve this privilages? I want to disable menu-options within a program. For that I have to retrieve the privilages for some tables. gr, Willem - Original Message - From: "Dan Wilson" [EMAIL PROTECTED] To: "Niral Trivedi" [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday,