[ADMIN] host hostssl entries in single pg_hba.conf

2004-04-12 Thread A.Bhuvaneswaran
Hi, I am using pgsql 7.3.4 on rh linux 7.3. I wish to have host hostssl entries in single pg_hba.conf file. If ssl is set to true in postgresql.conf, even though we have host entry in pg_hba.conf, ssl connection is established. Is it a bug or am i doing something wrong? Isn't it possible to

Re: [ADMIN] host hostssl entries in single pg_hba.conf

2004-04-12 Thread Tom Lane
A.Bhuvaneswaran [EMAIL PROTECTED] writes: I wish to have host hostssl entries in single pg_hba.conf file. If ssl is set to true in postgresql.conf, even though we have host entry in pg_hba.conf, ssl connection is established. Is it a bug or am i doing something wrong? That is the intended

Re: [ADMIN] Location of a new column

2004-04-12 Thread Robert Treat
On Thu, 2004-04-08 at 09:55, Stephan Szabo wrote: On Thu, 8 Apr 2004, Terry Hampton wrote: I thought this was answered before, but I could not find anything in my saved email. I need to ALTER a table to add a new column. I want the new column to be between two

Re: [ADMIN] Location of a new column

2004-04-12 Thread Tom Lane
Robert Treat [EMAIL PROTECTED] writes: On Thu, 2004-04-08 at 09:55, Stephan Szabo wrote: AFAIK, you can't using add column. It currently does no more than the SQL92/99 spec requires in that respect (which is put the column at the end). IIRC this option is available in 7.5. No, there has

[ADMIN] password accessibility

2004-04-12 Thread Greg Steffensen
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I'm in the process of integrating a jabber server into a postgresql-based web portal. The portal has a separate postgresql user for every registered user of the site. Authentication on the site is easy enough; the site just attempts to connect to the