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?

[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 searche

[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 tha

[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 wor

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 alo

[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 Com

Re: [GENERAL] NFS mounted DBs and Vacuum

2000-12-27 Thread Steve Wolfe
> 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? NFS is slow, and very CPU-intensive. On a 1

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 globa

[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 a

[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 it

[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 Asta(www.astatech.co

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 a

[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 d

Re: [GENERAL] How I can join between the other database's tables?

2000-12-27 Thread Adam Haberlach
On Tue, Dec 26, 2000 at 09:24:37PM +0530, Anand Raman wrote: > On Wed, Dec 27, 2000 at 12:15:56AM +0900, Ioseph Kim wrote: > ># createdb a > ># createdb b > ># psql a > >create table a (name text); > >\q > ># psql b > >create table a (name text); > > > >--- > >Now, I want to join table a of da

[GENERAL] phpPgAdmin 2.2.1 Released!

2000-12-27 Thread Dan Wilson
We are pleased to announce the release of phpPgAdmin version 2.2.1. Check us out at our new home @ http://www.greatbridge.org/project/phppgadmin. Feel free to use all the new functionality available through the greatbridge.org site (Thanks GreatBridge!) The new version includes many updates and

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 d

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]

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: Tuesd