[SQL] Problem with query on history table

Hi all! I don't know if there's a standard solution to the kind of problem I'm trying to solve, but I will appreciate your thougts(and maybe solution:) on this problem of mine: I have 2 tables: hist and curr which hold numbers for "history-data" and "current-data" respectivly. Here is a simpli

[SQL] Dump/restore comments only?

Folks, There have been a number of times when I've wanted to ignore everything in a dump file apart from comments. I am interested not just in comments for tables/views/columns but constraints, indices and functions as well. Many of my comments are multi-line and often resemble manpages, so a si

[SQL] Disabling triggers/constraints pg<8.1

Folks, Questions about disabling/enabling triggers/constraints "through the back door" in pg versions that do not support DISABLE|ENABLE of such things? Background: pg 8.1 has the ability to DISABLE/ENABLE a particular trigger, and it looks like we'll be getting DISABLE/ENABLE CONSTRAINT stat

Re: [SQL] Relation 0 does not exist

Alvaro Thak you for your quick reply. > Hmm. Who knows which one of the data-corrupting unfixed > known bugs in this ancient version caused this particular Is this the 'unfixed know bugs' of 7.2.X ? It means the solution is only upgrading PotgreSQL to 7.3.X ot 7.4.X ? One more information.