Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1inMub-0000kx-P5 for pgsql-hackers@arkaria.postgresql.org; Fri, 03 Jan 2020 13:22:46 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1inMuZ-0001Ew-Uo for pgsql-hackers@arkaria.postgresql.org; Fri, 03 Jan 2020 13:22:43 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1inMuZ-0001Ep-He for pgsql-hackers@lists.postgresql.org; Fri, 03 Jan 2020 13:22:43 +0000 Received: from mail-wm1-x32e.google.com ([2a00:1450:4864:20::32e]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1inMuV-0000Re-UG for pgsql-hackers@postgresql.org; Fri, 03 Jan 2020 13:22:42 +0000 Received: by mail-wm1-x32e.google.com with SMTP id d139so6961350wmd.0 for ; Fri, 03 Jan 2020 05:22:39 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=2ndquadrant-com.20150623.gappssmtp.com; s=20150623; h=subject:to:cc:references:from:message-id:date:user-agent :mime-version:in-reply-to:content-transfer-encoding:content-language; bh=tRXyyUETzBFKsPYTrfRZ0fuWj2513uplvL38xEe83Nk=; b=VNqT6Lsn+NqB0NCGNSdEVJFtx4cx5RhoOMPNc5+kcLqLZobUDhuVVsVNzvgGQ+Uv25 Lns9WaOyFiW9/QHpXgqVYcUgM1A3dqg5EJ2K8UaiqGai0uCgCC4YjF1N6qOBBMrMovDB mpTYRexIJnUZaQ8rnPVGD7481OFteVUM//vN5iCkGJfTaXz2JSjIO2QW/7fUkABHmlw0 NydpqbJ0LLBUK/3Mp9gTEj9W0wj4Lo/97f7cIMu/ibTXrFVEpp8GoN+8B5+q5etjFzG/ b0noj5ULGu84zaouLEXC8bkqBjkAJXbGQ5L+FH5T0AOjY4Nbe6soizaIW1gQL2xaCHaV /mkg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:subject:to:cc:references:from:message-id:date :user-agent:mime-version:in-reply-to:content-transfer-encoding :content-language; bh=tRXyyUETzBFKsPYTrfRZ0fuWj2513uplvL38xEe83Nk=; b=YHyX2H5d0KYXFa8nm+qvfz9gSMgg9CpQbS7gGiZO8ugAXvlkv9xSNJOkCKoiUvNHbl +ZXTfOwzqYQgfU/M/6VKJeewala2p/EJNg37WJuVfk96OHHSkiMR9SGf+khe1/HyPfyu MDLfrtrl1+Q4m9Jut8O1dk2sFxysMQkYQdC5qOTbl7RopL9SweOhLqTrjHRcumZaoYSN E27svrmh0boWsorlSYb08Os1+g848DChXxUqtYYyZ9UlX9EWzYBS0Y+/izOOCf38vlHN IzyVOvddXPeEDXTWnYC2bJy1TNxr0J6YBAXgS7SWUDLP2/592CaLEljlnCvAl15E3qOH Pyiw== X-Gm-Message-State: APjAAAWD+E9XMEwWZM1O6zki/slWQ/dTaOM/3h3BDoj0b9gnH6dANmow 98RyLEI7r/Csl8vs7KsToPRqATjXZuFlcbAixT7EEQ8UicJvhnQn1jUwztG4kUkrI/2athVkUV9 8jZlakM2JKNEosYkJs/ISjQZFlnGQFvQywP4wVcaHhfQopfi4EV9d9mthvc4rctk1h2HxMlThs9 BA5IiFplTCmw== X-Google-Smtp-Source: APXvYqxv/lKmoSy7ZTkSKuZ8KWP0gLZEQQJqa2kEXZ5vI3vZfeQty2WTBi8t9Dy38f6qQ5PZZKnFdA== X-Received: by 2002:a7b:cb0a:: with SMTP id u10mr19442014wmj.165.1578057757590; Fri, 03 Jan 2020 05:22:37 -0800 (PST) Received: from [10.8.8.7] ([185.94.189.189]) by smtp.gmail.com with ESMTPSA id a133sm12050261wme.29.2020.01.03.05.22.36 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Fri, 03 Jan 2020 05:22:36 -0800 (PST) Subject: Re: WIP: System Versioned Temporal Table To: Surafel Temesgen Cc: PostgreSQL Hackers References: <3de42e96-45c3-faaa-af20-30f127724601@2ndquadrant.com> <55cf779b-a347-8c21-9a82-ad2030f95d0b@2ndquadrant.com> <9550e917-c370-36a3-277f-2f25bfc1b497@2ndquadrant.com> From: Vik Fearing Message-ID: Date: Fri, 3 Jan 2020 14:22:34 +0100 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:68.0) Gecko/20100101 Thunderbird/68.2.2 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 03/01/2020 11:57, Surafel Temesgen wrote: > > > On Thu, Jan 2, 2020 at 12:12 AM Vik Fearing > > wrote: > > This does not compile against current head (0ce38730ac). > > > gram.y: error: shift/reduce conflicts: 6 found, 0 expected > > > Rebased and conflict resolved i hope it build clean this time > It does but you haven't included your tests file so `make check` fails. It seems clear to me that you haven't tested it at all anyway.  The temporal conditions do not return the correct results, and the syntax is wrong, too.  Also, none of my previous comments have been addressed except for "system versioning" instead of "system_versioning".  Why? -- Vik Fearing