lrotger wrote:
I read some of the logs up until 7.3 (from my old 7.2.1); I should
benefit from upgrading but there are issues to consider, for example, I
see 'timestamp' was changed from with to without time zone in 7.3, I'll
have to follow these changes carefully to upgrade without problems.
Tom Lane wrote:
Yes, you should. Someday one of those bugs will eat your data. The
fact that it hasn't happened yet does not mean you're not at risk;
a lot of them are simply race conditions with very small windows.
regards, tom lane
I read some of the logs up until
lrotger wrote:
> Well it probably would, changelogs are scary and I really appreciate the
> work of the postgres hackers, but you know the old adage: "if it's not
> broken, don't fix it";
The problem is that it _is_ broken, so it needs fixing. You have just
been lucky, or haven't yet detected
lrotger <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> Egad, don't tell me you're still using 7.2.1 for anything important :-(
> Well it probably would, changelogs are scary and I really appreciate the
> work of the postgres hackers, but you know the old adage: "if it's not
> broken, don't fix
Tom Lane wrote:
lrotger <[EMAIL PROTECTED]> writes:
I forgot to mention that my version is 7.2.1.
Egad, don't tell me you're still using 7.2.1 for anything important :-(
The list of bugs fixed since then would curl your toes.
http://developer.postgresql.org/docs/postgres/release.html
lrotger <[EMAIL PROTECTED]> writes:
> I forgot to mention that my version is 7.2.1.
Egad, don't tell me you're still using 7.2.1 for anything important :-(
The list of bugs fixed since then would curl your toes.
http://developer.postgresql.org/docs/postgres/release.html
re
Tom Lane wrote:
lrotger <[EMAIL PROTECTED]> writes:
I know I could dig this out of the manuals so don't be too hard on me,
I'd like to know how to query the actual text of the expression of a
constraint. I know the name of the constraint and of the table.
Something like this:
regression=#
lrotger <[EMAIL PROTECTED]> writes:
> I know I could dig this out of the manuals so don't be too hard on me,
> I'd like to know how to query the actual text of the expression of a
> constraint. I know the name of the constraint and of the table.
Something like this:
regression=# create table t1
Hi,
I know I could dig this out of the manuals so don't be too hard on me,
I'd like to know how to query the actual text of the expression of a
constraint. I know the name of the constraint and of the table.
Thanks,
L Rotger
---(end of broadcast)--
