From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
---|---|
To: | Greg Stark <stark(at)mit(dot)edu>, Peter Geoghegan <pg(at)heroku(dot)com> |
Cc: | Matthew Kelly <mkelly(at)tripadvisor(dot)com>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>, Matthew Spilich <mspilich(at)tripadvisor(dot)com> |
Subject: | Re: Collations and Replication; Next Steps |
Date: | 2014-09-17 18:15:37 |
Message-ID: | 5419CFC9.2060701@gmx.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On 9/17/14 10:46 AM, Greg Stark wrote:
> You could have a problem if you have an expression index on (timestamp
> AT TIME ZONE '...'). I may have the expression slightly wrong but I
> believe it is posisble to write an immutable expression that depends
> on the tzdata data as long as it doesn't depend on not the user's
> current time zone (which would be stable but not immutable). The
> actual likelihood of that situation might be much lower and the
> ability to avoid it higher but in theory I think Peter's right that
> it's the same class of problem.
I was thinking of something like a text column with "natural" input of
time stamp information, and and index on that_column::timestamp.
> Generally speaking we try to protect against most environment
> dependencies that lead to corrupt databases by encoding them in the
> control file. Obviously we can't encode an entire collation in the
> controlfile though. We could conceivably have a corpus of
> representative strings that we sort and then checksum in the
> controlfile. It wouldn't be foolproof but if we collect interesting
> examples as we find them it might be a worthwhile safety check.
I think it could be useful in a number of situations if a type could
stick some arbitrary additional information into a new column in
pg_type, such as versions of libraries it depends on or storage format
versions.
Then again, collation isn't actually a property of any single type.
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2014-09-17 18:20:04 | Re: Collations and Replication; Next Steps |
Previous Message | Peter Eisentraut | 2014-09-17 18:08:34 | Re: Collations and Replication; Next Steps |