We have been using 7.3.3 on several different applications and have
discovered an anomaly.
Backups are done nightly using "pg_dump --attribute-inserts -f
att.dump.`dcode` spdb";
Dump files are used to restore and test. This test method has been used
successfully on
all previous versions. However
this worked in 7.2.3
"select sum(cr) from ar where date(tdate) = now() -1 "
but not in 7.3.3
What's the proper syntax for 7.3.3???
thanks
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
When updating from 7.2.3 to 7.3.3 we have lost the ability to see the
passwords in pg_shadow. Is there a way to decrypt the passwords?
thanks
--
A. R. Van Hook
Honeywell Federal Manufacturing & Technologies
IT System Engineer
City of Lake Lotawana MO
Mayor
---
I have a simple script to automate sql statements: q " select * from
tablename" where q is an alias to echo "$@ ; " | psql imdb
Turning on security breaks this script since is need s password.
the new one works a before: q "select *..." passwd where q is now
an expect script:
#!/usr/bin/
