[EMAIL PROTECTED] writes:
> When I try to insert in a field of the type timestamp value 2002-10-13 00:00:00
>occurs this value is modified for 2002-10-12 23:00:00
(a) what timezone are you running in?
(b) does it happen on only that date? If so, is that a daylight-savings
transition day in y
Jéfferson R. Zuchi ([EMAIL PROTECTED]) reports a bug with a severity of 3
The lower the number the more severe it is.
Short Description
Error when inserting timestamp 2002-10-13 00:00:00
Long Description
When I try to insert in a field of the type timestamp value 2002-10-13 00:00:00
occurs t
Is their any way to know if an index is a unique constraint from within the
dependency checker? In testing with pg_dump I've noted that it seems to
know (I assume from contype in pg_constraint) if the index is just a unique
index or a constraint.
How about this:
Cannot drop unique constraint (
"Tim Knowles" <[EMAIL PROTECTED]> writes:
> ... I do though think the error message could do with a slight change
> of wording from:
> ERROR: Cannot drop index t1_pkey because constraint c1 on table t1 requires
> it
> You may drop constraint c1 on table t1 instead
> to:
> ERROR: Cannot
Thanks Tom, I understand now the thinking behind disallowing the drop index
... cascade. If only I'd spent a little bit more time thinking it thru
properly! I do though think the error message could do with a slight change
of wording from:
ERROR: Cannot drop index t1_pkey because constraint c1
