Tom Lane wrote: >IIRC, there were some problems with sequences going backwards after a >crash in 7.2. If you are on 7.2.x for x < 3, you are running a version >with serious known bugs; you should update before complaining too much >...
Crazy question, but how do I determine the version number? If I run "postmaster --version", I get told "postmaster (PostgreSQL) 7.2". Does that really mean "7.2"? We were under the impression that we'd upgraded these boxes to 7.2.1 earlier this summer, so we're wondering if the minor version number is perhaps not being displayed. All of the shell scripts in .../pgsql/bin/ contain the word "7.2" -- no mention of minor version numbers such as "7.2.0", "7.2.1", etc. (Next time we'll skip the binaries and download & compile the source ourself so we know for certain what we're using!) Best regards, Stephane Charette ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster