Re: [SQL] Changing auth type in pg_hba.conf ineffective. Why?

2005-11-24 Thread Bryce Nesbitt
IPv6? Really? That new fangled thing? That's enabled on my machine by default? Whadda know. That's it. Thanks. Tom Lane wrote: > Bryce Nesbitt <[EMAIL PROTECTED]> writes: > >> I've renamed pg_hba.conf temporarily, just to verify that postmaster >> won't start without it. So I'm editing the rig

Re: [SQL] Changing auth type in pg_hba.conf ineffective. Why?

2005-11-24 Thread Bryce Nesbitt
In that case I get: ***Exception: org.postgresql.util.PSQLException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections Alvaro Herrera wrote: > What message do you get if you try to connect while postmaster is down? > I'm just

Re: [SQL] Changing auth type in pg_hba.conf ineffective. Why?

2005-11-24 Thread Tom Lane
Bryce Nesbitt <[EMAIL PROTECTED]> writes: > I've renamed pg_hba.conf temporarily, just to verify that postmaster > won't start without it. So I'm editing the right file, and restarting > postmaster correctly. Any clues why I'm still getting 'auth' method > authentication? Well, have you checked

Re: [SQL] Changing auth type in pg_hba.conf ineffective. Why?

2005-11-24 Thread Alvaro Herrera
Bryce Nesbitt wrote: > I've renamed pg_hba.conf temporarily, just to verify that postmaster > won't start without it. So I'm editing the right file, and restarting > postmaster correctly. Any clues why I'm still getting 'auth' method > authentication? What message do you get if you try to conne

[SQL] Changing auth type in pg_hba.conf ineffective. Why?

2005-11-24 Thread Bryce Nesbitt
I'm struggling to resolve a login error. It seems that I'm getting "ident" authentication, no mater what I set pg_hba.conf to. Here's a log file: LOG: next transaction ID: 602; next OID: 17232 LOG: database system is ready ... FATAL: Ident authentication failed for user "bryce" L

[SQL] Updatable views: any decent front-ends?

2005-11-24 Thread Bath, David
(As this seems to be the general pg list, I'm posting here even though it is a front-end issue. Apologies.) While I can happily create rules on views to allow inserts, updates and deletes, I can't find a GUI front-end that understands that the view allows record edits that I can run on linux (whe

[SQL] does indexes need statistics?

2005-11-24 Thread Mauricio Fernandez A.
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hello everybody, Is it necesary the statistics be enabled when I create indexes or to use them? thanks Mauricio Fernández A. Ingeniero de Sistemas U. Autónoma de Manizales -BEGIN PGP SIGNATURE- Version: PGPfreeware 6.0.2i iQA/AwUBQ4X7u84irm

Re: [SQL]

2005-11-24 Thread Achilleus Mantzios
O Oliver Elphick έγραψε στις Nov 24, 2005 : > On Wed, 2005-11-23 at 23:23 -0500, Ken Winter wrote: > > In PL/pgSQL, is there a way to put a *variable* column-name in a dot > > notation reference to a RECORD column? You can do it with a C function. (See dbmirror's pending.c for a reference) > -

Re: [SQL]

2005-11-24 Thread Oliver Elphick
On Wed, 2005-11-23 at 23:23 -0500, Ken Winter wrote: > In PL/pgSQL, is there a way to put a *variable* column-name in a dot > notation reference to a RECORD column? > > For example, suppose I want to write a function like the following, which is > to be called by a "BEFORE INSERT" trigger: > > CR

[SQL] Index wonder

2005-11-24 Thread Leif B. Kristensen
I just wanted to share my revelation on how an index can do wonders for a query: pgslekt=> explain select child_fk, get_coparent(570,child_fk), get_pbdate(child_fk) as pbd from relations where parent_fk = 570 order by pbd; QUERY PLAN --