Re: [HACKERS] Temporal features in PostgreSQL

2015-01-21 Thread Bruce Momjian
On Fri, Jan 16, 2015 at 09:58:22AM -0700, pe...@vanroose.be wrote: > What's the current status of this topic? > Has someone worked on temporal tables for PostgreSQL since 2012 ? > > I'm giving a presentation on Fosdem later this month in Brussels, on the > topic of temporal tables, and would like

Re: [HACKERS] Temporal features in PostgreSQL

2015-01-16 Thread pe...@vanroose.be
What's the current status of this topic? Has someone worked on temporal tables for PostgreSQL since 2012 ? I'm giving a presentation on Fosdem later this month in Brussels, on the topic of temporal tables, and would like to give all possibly relevant information to the audience! -- Peter Van

Re: [HACKERS] Temporal features in PostgreSQL

2013-03-13 Thread Jim Nasby
On 2/13/13 10:06 PM, Vlad Arkhipov wrote: - I don't need to deal with update conflicts, because I use clock_timestamp() instead of current_timestamp. You can still come across a conflict even with clock_timestamp(). What if clocks go back during the time synchronization? Even if you have

Re: [HACKERS] Temporal features in PostgreSQL

2013-02-17 Thread Vlad Arkhipov
Hi, On 02/15/2013 10:46 PM, Cédric Villemain wrote: Hello, I'm also interested in this topic. > > I'm also interested in this topic and work on system-time temporal > > extension. Here I wrote down design of my solution few months ago > > https://wiki.postgresql.org/wiki/SQL2011Temporal. Th

Re: [HACKERS] Temporal features in PostgreSQL

2013-02-15 Thread Cédric Villemain
Hello, I'm also interested in this topic. > > I'm also interested in this topic and work on system-time temporal > > extension. Here I wrote down design of my solution few months ago > > https://wiki.postgresql.org/wiki/SQL2011Temporal. The idea is > > basically the same as in your solution wi

Re: [HACKERS] Temporal features in PostgreSQL

2013-02-13 Thread Vlad Arkhipov
On 02/04/2013 07:40 PM, Miroslav Šimulčík wrote: Hi Vlad, I'm also interested in this topic and work on system-time temporal extension. Here I wrote down design of my solution few months ago https://wiki.postgresql.org/wiki/SQL2011Temporal. The idea is basically the same as in your solution w

Re: [HACKERS] Temporal features in PostgreSQL

2013-02-04 Thread Miroslav Šimulčík
Hi Vlad, I'm also interested in this topic and work on system-time temporal extension. Here I wrote down design of my solution few months ago https://wiki.postgresql.org/wiki/SQL2011Temporal. The idea is basically the same as in your solution with some minor differences. For example: - I use

[HACKERS] Temporal features in PostgreSQL

2012-12-25 Thread Vlad Arkhipov
Hi all, Currently I'm working on a large enterprise project that heavily uses temporal features. We are using PostgreSQL database for data storage. Now we are using PL/pgSQL trigger-based and application-based solutions to handle with temporal data. However we would like to see this functiona