[GENERAL] pg_operator corrupted... Any ideas?

Hi all: This is the third time I am writing to the list asking for help; the two first ones nobody bothered to answer (admittedly, they were questions answered in the documentation, but nobody even bothered to say "RTFM"), so let's see if this time I've got a bit more of luck... I

[GENERAL] Postgresql equivalent for nvl

Hi guys Sorry for hitting the button soon but whats the postgresql equivalent for Oracle's nvl(). I tried using ifnull() but then postgresql is cribbing that the function doesnt exist.. Thanx for the help Anand

RE: [GENERAL] entity-relationship diagram software

Try: http://www.htc.honeywell.com/DoME It is not strictly ERD but a VERY reasonable CASE with above other things Coad-Yourdon OOA that can be easily extended to ERD denotations. The best choice (because of licencing) is precompiled version. Regards, Andrzej Mazurkiewicz www.mazurkiewicz.org >

RE: [GENERAL] entity-relationship diagram software

On Mon, 08 May 2000, Andrzej Mazurkiewicz wrote: > Try: > > http://www.htc.honeywell.com/DoME > > It is not strictly ERD but a VERY reasonable CASE with above other things > Coad-Yourdon OOA that can be easily extended to ERD denotations. The best > choice (because of licencing) is precompiled v

[GENERAL] Recovering data from binary files?

Hi all: Well, after my earlier post regarding pg_operator being corrupted, I received a mail from one of the Postgres developers (I think) talking about one of the system indexes (pg_attribute_relid_attnum_index) being corrupted, so I gave it a try and copied said file from the template1

RE: [GENERAL] Recovering data from binary files?

> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of Paulo Jan > Sent: Tuesday, May 09, 2000 12:00 AM > To: [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED] > Subject: [GENERAL] Recovering data from binary files? > > > Hi all: > > Well, after my earlie

[GENERAL] Miracle

> > Oh it seems almost same as pg_upgrade. > However you should probably copy pg_log and pg_variable to > $PGDATA as pg_upgrade does. > In addtion if postmaster is running,you should shutdown before > processing 2). > > Regards. > Well. It worked!!! The database was succesfully recover

[GENERAL] SSL

In the pgsql-hackers list, its been stated that SSL can be used on the client/backend connection. Where is this documented if I want to try it? Or, can anyone just tell me know? -- Robert B. Easter [EMAIL PROTECTED]

[GENERAL] NOTICE from vacuum

I am getting the following NOTICE from vacuum: NOTICE: Index tag_surveys_d_field_survey__key: NUMBER OF INDEX' TUPLES (6475) IS NOT THE SAME AS HEAP' (6474) How does such a thing come about? Do I just drop the index and remake it? Is the index or the heap correct? Thanks for your help. Che

Re: [GENERAL] Re: [HACKERS] You're on SecurityFocus.com forthe cleartext passwords.

Stephan Richter wrote: > > At 07:08 PM 5/7/00 -0400, Robert B. Easter wrote: > >My understanding is that what you get from crypt(pw, salt) = > > > > $1$$ That's for DES crypt (and without the $$) - Hannu