[ADMIN] FW: [GENERAL] shell script when a user logs in

2003-01-10 Thread Campano, Troy
Title: Message I posted this in GENERAL, but figured maybe this might be better place.   -Original Message-From: Campano, Troy [mailto:[EMAIL PROTECTED]] Sent: Friday, January 10, 2003 1:56 PMTo: [EMAIL PROTECTED]Subject: [GENERAL] shell script when a user logs in Is there a shell

[ADMIN] Encrypted Passwords

2003-01-10 Thread Rob Abernethy IV
How does postgres calculate the MD5 version of a password to store in the database during user creation? I am trying to set up a postgres JDBCRealm to work with Tomcat. The problem is that the resulting digest from Java is different then the digest stored in the database for the same word. cl

Re: [ADMIN] Encrypted Passwords

2003-01-10 Thread Rob Abernethy IV
Perl also came up with the same digest as Java. -- Robert Abernethy IV Dynamic Edge, Inc. 734.975.0460 > How does postgres calculate the MD5 version of a password to store > in the database during user creation? I am trying to set up a > postgres JDBCRealm to work with Tomcat. The problem is

Re: [ADMIN] Encrypted Passwords

2003-01-10 Thread Bruce Momjian
Rob Abernethy IV wrote: > How does postgres calculate the MD5 version of a password to store in the > database during user creation? I am trying to set up a postgres JDBCRealm to > work with Tomcat. The problem is that the resulting digest from Java is > different then the digest stored in the

[ADMIN] sequence

2003-01-10 Thread Roberto Benitez
I have a field of serial type. for some reason, the sequence skips numbers every now and then. does anyone know why? --thanks --roberto c. benitez __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com --

Re: [ADMIN] repair table? database? how ? neccessary?

2003-01-10 Thread philo vivero
On Mon, 2003-01-06 at 17:21, mitchell laks wrote: > The main issue I had with Access was that as the database got larger, My > application began to fail regularly, and I began to need to do "repair" of > the database almost on a daily or other daily basis. . . . > the Postgresql database is curr

[ADMIN] auto stop postmaster on cygwin

2003-01-10 Thread somphong s.
i use postgresql 7.3 on cygwin on windows xp home. i have found somebody suggestion to start pg process as service on XP. i try and succesful on start as service , and auto start when start PC. but i must manually stop the postmaster before i shutdown or restart PC. if not the file postmaster.pid w

[ADMIN] journaling

2003-01-10 Thread Stéphane Akrich
I work with the SGBDR OpenIngres2 which has also a WAL mecanism.More over, I journalise my database in order to recover the data between thesave of the data and the crash.Is it possible to do it with PostgreSQL ?thanks

[ADMIN] error starting PostgreSQL

2003-01-10 Thread Krzysztof Socki
Hello! I was searching the archives of the site and I've found many posts concerning problems with starting the postmaster, but noone reported such a message: StreamServerPort: bind() failed: Cannot assign requested address I'm trying to use TCP/IP connection on port 5432. No other proceses use thi

Re: [ADMIN] restore/dup OIDs HELP!

2003-01-10 Thread Jack Flak
Stephan, That's very interesting! I didn't even know about these other "hidden" fields. How many others are there? You're right about the xmin value. It's the same for all the dups. That could have saved me a lot of work. I built a perl script to locate the dups, pull the data, re-insert

Re: [ADMIN] restore/dup OIDs HELP!

2003-01-10 Thread Jack Flak
Steve, Thanks for the excellent suggestion! Yes, that would have worked. I guess I did it the hard way. I wrote a nice little perl script to locate the dups by OID and then pull the data, re-insert it, and then delete the original dup by OID. It was smart, I could run it as many times as ne

Re: [ADMIN] restore/dup OIDs HELP!

2003-01-10 Thread Stephan Szabo
On Thu, 9 Jan 2003, Jack Flak wrote: > Stephan, > > That's very interesting! I didn't even know about these other "hidden" > fields. How many others are there? Let's see, I think the set is ctid, oid, xmin, cmin, xmax, cmax, tableoid IIRC, ctid is basically like a physical pointer to where t

[ADMIN] is it postgres issue?

2003-01-10 Thread Rajesh Kumar Mallah.
Hi On updating a table i get following ERROR tradein_clients=# begin work; UPDATE eyp_listing set company_id=companies.company_id from companies where eyp_listing.amount > 0 and eyp_listing.email=companies.email; BEGIN ERROR: heap_mark4update: (am)invalid tid is it a postgresql issue? o

Re: [ADMIN] is it postgres issue?

2003-01-10 Thread Tom Lane
"Rajesh Kumar Mallah." <[EMAIL PROTECTED]> writes: > tradein_clients=# begin work; UPDATE eyp_listing set >company_id=companies.company_id from companies where eyp_listing.amount > 0 and > eyp_listing.email=companies.email; > BEGIN > ERROR: heap_mark4update: (am)invalid tid > is it a postgr

Re: [ADMIN] error starting PostgreSQL

2003-01-10 Thread Tom Lane
"Krzysztof Socki" <[EMAIL PROTECTED]> writes: > StreamServerPort: bind() failed: Cannot assign requested address > I'm trying to use TCP/IP connection on port 5432. No other proceses use this > port. I've also tried other port - no effect. Can you help? [ scratches head... ] Maybe you have virtua