From user-return-12250-archive-asf-public=cust-asf.ponee.io@cayenne.apache.org Mon Oct 22 23:38:52 2018 Return-Path: X-Original-To: archive-asf-public@cust-asf.ponee.io Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by mx-eu-01.ponee.io (Postfix) with SMTP id D9F7A18064A for ; Mon, 22 Oct 2018 23:38:51 +0200 (CEST) Received: (qmail 99155 invoked by uid 500); 22 Oct 2018 21:38:50 -0000 Mailing-List: contact user-help@cayenne.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@cayenne.apache.org Delivered-To: mailing list user@cayenne.apache.org Received: (qmail 99143 invoked by uid 99); 22 Oct 2018 21:38:50 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd2-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 22 Oct 2018 21:38:50 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd2-us-west.apache.org (ASF Mail Server at spamd2-us-west.apache.org) with ESMTP id C5C791A3C07 for ; Mon, 22 Oct 2018 21:38:49 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd2-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 1.988 X-Spam-Level: * X-Spam-Status: No, score=1.988 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, HTML_MESSAGE=2, RCVD_IN_DNSWL_NONE=-0.0001, RCVD_IN_MSPIKE_H2=-0.001, SPF_PASS=-0.001, T_DKIMWL_WL_MED=-0.01] autolearn=disabled Authentication-Results: spamd2-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=giaccone-org.20150623.gappssmtp.com Received: from mx1-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd2-us-west.apache.org [10.40.0.9]) (amavisd-new, port 10024) with ESMTP id Z5EVK9lbZsoZ for ; Mon, 22 Oct 2018 21:38:48 +0000 (UTC) Received: from mail-oi1-f194.google.com (mail-oi1-f194.google.com [209.85.167.194]) by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with ESMTPS id E5BAA5F1CF for ; Mon, 22 Oct 2018 21:38:47 +0000 (UTC) Received: by mail-oi1-f194.google.com with SMTP id e17-v6so33495372oib.4 for ; Mon, 22 Oct 2018 14:38:47 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=giaccone-org.20150623.gappssmtp.com; s=20150623; h=mime-version:from:date:message-id:subject:to; bh=8VaHMt3jnjWYleU4NHXisPqIU4Ee8TlRxBNyMS+ri80=; b=Vip4sh3xfQ2A8Ct5BWkXPtdRA+jC8GArQdReuZeFJB64/Ie1OxmDgS8LLjqL5yuGZy t5d6UR24cbMA7f4DIGTUtUUuS2A6+YPhNcwOjo1iyNJHYCKKuIa/O8U27EB6ldGAOvzQ aqNqswsHWGnC91tkzTgJ+BRtBdcYnw8osILfw+vkC8v1eokStIvRoe7Mho3cZ68d4bcw h0Lfp6iA0D7tahfBXhS+QZKaS5tUaOnz9ehkK5VzQe8g2RKaskVnYfvnmBxP6gMLj9I8 VY1jEqRIweVmPt+1dh3JC8eKsAIeuK67Y7r0DKkSiOVY7D3RfaZDo7T/BsJ9K637s2jn irnQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:from:date:message-id:subject:to; bh=8VaHMt3jnjWYleU4NHXisPqIU4Ee8TlRxBNyMS+ri80=; b=ActFZmUnzvHrpyIx+JwCH2K31KR16dbDViQbSo3iNjY7C3dUxE0uMMYqRsxI6Un+8w Zj1cuJSyOD5JaomahDxnQUYLhJfpWjm8hc7LT3U2nsuXV780JyAtnID75LkUFtA6h7Fo 4ltmTNw96jYIkDg/AgEzx1hV0A33CzgX841/2TbRcrrFqOmzfpMCBoCSoiS3t4Ii74N5 Zfe4hAIpEi+/4RUvfm8ciBwP+1htk+ewASQ9+tRVDpc+HrvgTCJeUmlfAPVlJMoXDS3z dMRFaFY5TpXVjKGqRmVbiDUnwubk8zqmbAt0xtkJleepaKRcWWdYeZFSL886dVLi3TeX m6Qg== X-Gm-Message-State: ABuFfoitw4bi+XISzN8YytClI4gCznfFZfZVZ9p0F11Uvctfkc2dybdG neiU4bW/AYlb1ifPRqeK0co+N0e0TrIXSgKCzIBs5X/ooxEgzA== X-Google-Smtp-Source: ACcGV613q/GCyd6mzzUBxFZNuL6P8hdQRHBgQK7IhQ3JKTPqyQQvW+5QAL2anYwlexL/GR4on/hLGrtaTWL8EnHRqVI= X-Received: by 2002:aca:f084:: with SMTP id o126-v6mr25924890oih.21.1540244326240; Mon, 22 Oct 2018 14:38:46 -0700 (PDT) MIME-Version: 1.0 From: Tony Giaccone Date: Mon, 22 Oct 2018 17:38:34 -0400 Message-ID: Subject: Generation of primary keys To: user@cayenne.apache.org Content-Type: multipart/alternative; boundary="000000000000eef7950578d813e7" --000000000000eef7950578d813e7 Content-Type: text/plain; charset="UTF-8" I understand that the kind of PK support that Cayenne uses depends on the adaptor you use. When you use: org.apache.cayenne.dba.postgres.PostgresAdapter you get sequences, not the pk_auto table. I see where you can pick the adaptor as part of a database schema generation. What's less clear to me, is what adaptor is used if cayenne detects that a schema needs to be generated. Or more generally what causes a dba adaptor to end up in the stack. Is there some kind of database detection that determines which adaptor get used? I didn't think we were explicitly setting it to PostgresAdapter, and yet we still ended up with sequences. Of course it's possible that someone on the team did, so I don't want to rule that out as a possibility, but it occurs to me that there might be some kind of detection especially in cases where the schema is being generated "automatically". Tony Giaccone --000000000000eef7950578d813e7--