[ADMIN] CREATE OR REPLACE VIEW / TRIGGER

2002-01-17 Thread Jean-Michel POURE
Dear community, dear friends, I know it is feature freeze, so forgive me for this (ancien) question : would it possible to add CREATE OR REPLACE VIEW and CREATE OR REPLACE TRIGGER in current PostgreSQL 7.2 release? Otherwise, it will take another year before these long-needed features are adde

Re: [ADMIN] client connection problem

2002-01-17 Thread Rasmus Mohr
Bullseye! Packet filtering was the problem, and was solved by allowing packets destined to port 5432 in ipchains. thanx a lot! -Oprindelig meddelelse- Fra: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]På vegne af Tom Lane Sendt: 16. januar 2002 16:52 Til: [EMAIL PROTECTED] Cc: Rasmus Mohr

Re: [ADMIN] finding file names

2002-01-17 Thread omid omoomi
hi, You can use COPY command to make a text file for any table. regards Omid Omoomi >From: [EMAIL PROTECTED] (Srinivasa Rao Chava) >To: [EMAIL PROTECTED] >Subject: [ADMIN] finding file names >Date: 16 Jan 2002 15:15:24 -0800 > >In Postgresql the data file are created and named in numeric format,

Re: [ADMIN] finding file names

2002-01-17 Thread omid omoomi
At the moment I am using an old PG version on my machine. and it shows all the file names by their real name under : /usr/local/psql/data/base/mydatabasename/ Having pgdump or copy commands, why one might need to know the relation between the numbers and the names at all? Data base recovery or

Re: [ADMIN] CREATE OR REPLACE VIEW / TRIGGER

2002-01-17 Thread Tom Lane
Jean-Michel POURE <[EMAIL PROTECTED]> writes: > I know it is feature freeze, so forgive me for this (ancien) question : would > it possible to add CREATE OR REPLACE VIEW and CREATE OR REPLACE TRIGGER in > current PostgreSQL 7.2 release? No. RC1 is *tomorrow*, and we're not pushing it back to ad

[ADMIN] IDENT auth. problem

2002-01-17 Thread Graham Vickrage
Hi All, I am experiencing strange behaviour with psql. I normally log with authentication type: ident sameuser I have just exited from a psql session where I dropped a table and then immediately logged back in and now I am getting: - IDENT authentication failed for user 'postgres' I have check

Re: [ADMIN] IDENT auth. problem

2002-01-17 Thread Tom Lane
"Graham Vickrage" <[EMAIL PROTECTED]> writes: > I have just exited from a psql session where I dropped a table and then > immediately logged back in and now I am getting: - > IDENT authentication failed for user 'postgres' > I have checked all the usual; ph_hba.conf, pg_shadow, restarting postma