Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1g6cTV-0003Kn-Mn for pgsql-hackers@arkaria.postgresql.org; Sun, 30 Sep 2018 14:13:33 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1g6cTT-0007sr-Du for pgsql-hackers@arkaria.postgresql.org; Sun, 30 Sep 2018 14:13:31 +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_SHA384:256) (Exim 4.89) (envelope-from ) id 1g6cTS-0007sk-Tv for pgsql-hackers@lists.postgresql.org; Sun, 30 Sep 2018 14:13:31 +0000 Received: from mail-yb1-xb41.google.com ([2607:f8b0:4864:20::b41]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1g6cTL-0007kd-UU for pgsql-hackers@lists.postgresql.org; Sun, 30 Sep 2018 14:13:29 +0000 Received: by mail-yb1-xb41.google.com with SMTP id w7-v6so4566779ybm.7 for ; Sun, 30 Sep 2018 07:13:23 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=2ndquadrant-com.20150623.gappssmtp.com; s=20150623; h=from:subject:to:references:message-id:date:user-agent:mime-version :in-reply-to:content-transfer-encoding:content-language; bh=HTyxel64DBIxAm+XEbPU6RBip0g+YJPmfJNw1M2Q08U=; b=I4w0GArHIh5c7xerY7P6Fgxv4Dh4jyWG8CtoDiaaRRRKpei0sejPcBPc0EeCuHyrbD EheAS/9fG0YU4z2+BISbu7eB1vzJhzcoaq08xVfnMPAo8aOfktryWL3TKUrF2bz4tb3t 4UwTvwwF60vgZSNAO2SW4GXI29c6XCNSlrHWbo4dogCtfM2RRWZmTFa10qnVecekELoE DfBzOcz37deLwhBBDR/bqcf25qqEaVmkELLnL8MWMuiycjlCmiU4OOIq1HBzH793sUsJ stcyKklsEEflguc60o5cMrOsfzFk/xTRPDI8l+ZlvCGvyzUkWXIoPCzQKQstCpvLj53j 1mqQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:from:subject:to:references:message-id:date :user-agent:mime-version:in-reply-to:content-transfer-encoding :content-language; bh=HTyxel64DBIxAm+XEbPU6RBip0g+YJPmfJNw1M2Q08U=; b=PP4B/F68ayCAEIeBJujfuQcH5126e5uxHdkEB6xo5wLFNazckBZzl2LtVN4s+IY/kB +zAtb19ZBK1gV4wbZJsVTQKb01rKP6GwJqJf9f/PiJPCpBFr8B6jrRakwdhSnnBGgBVO ZAexK8kqYAUVbGIPDObGUGRFNWjPoD9W8xmMJONciPK9guwgQaQFE2nrk8x3Zeb8u3nm C9FdSdbuixNiDeppLMpchZuWMB3efPXl38DbGbznRj/46IRQ1pRoBSTJCvbenVrGKfp2 0zred/sZ937XsklNwbz6caIHO8uUhMfILuk31QNZ5j3FjWnAyNasfB/JFQ1iH9V9EXhZ YJTQ== X-Gm-Message-State: ABuFfogAX6RjBclODDMzeKRN1v93GUEMKJ4iyrd2C9gW+3cdFH5cpy3Y +Uk0pMRDhg8yjJu0igCeaFDDr0b1q9FXVtAiR5cXUekfMMwrac9p0VOTCtPGXuHvEBN7So02CkL tANHaeN7uF0BD7B5bo78HKapcWuLF8mdiqklq4f8dlg1S6jR/FLjt0s6qxkqcISDvncRKOK6hKi gJZajxMd18HEYY0h5IGN66 X-Google-Smtp-Source: ACcGV62ohFDTapwzo4tw0RVHVO8j1a+MsiAXbzEHj6julArvO1+dcpl85lqVGNtgxnRDuqfJOhhZVQ== X-Received: by 2002:a25:7c83:: with SMTP id x125-v6mr3628984ybc.195.1538316800860; Sun, 30 Sep 2018 07:13:20 -0700 (PDT) Received: from [192.168.10.146] ([98.122.175.38]) by smtp.gmail.com with ESMTPSA id l6-v6sm4720571ywb.15.2018.09.30.07.13.20 (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Sun, 30 Sep 2018 07:13:20 -0700 (PDT) From: Andrew Dunstan X-Google-Original-From: Andrew Dunstan Subject: Re: Cygwin linking rules To: Marco Atzeri , pgsql-hackers@lists.postgresql.org References: <1056.1538235347@sss.pgh.pa.us> <86419508-9d36-36a9-93ff-2a051af7d2e4@2ndQuadrant.com> <257c24fc-effb-871d-4529-e3ff2ea0d436@gmail.com> Message-ID: Date: Sun, 30 Sep 2018 10:13:19 -0400 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101 Thunderbird/52.4.0 MIME-Version: 1.0 In-Reply-To: <257c24fc-effb-871d-4529-e3ff2ea0d436@gmail.com> Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit Content-Language: en-MW List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 09/29/2018 02:13 PM, Marco Atzeri wrote: > > building from git and using the attached patch that is used for all > cygwin packages on latest cygwin > > $ uname -svrm > CYGWIN_NT-10.0 2.11.1(0.329/5/3) 2018-09-05 10:24 x86_64 > > I do not see the problem > > ============== creating database "contrib_regression" ============== > CREATE DATABASE > ALTER DATABASE > ============== running regression test queries ============== > test paths                        ... ok > test dblink                       ... ok > ============== shutting down postmaster ============== > > >  $ objdump -x usr/lib/postgresql/dblink.dll |grep "DLL Name:" >         DLL Name: postgres.exe >         DLL Name: cygpq-5.dll >         DLL Name: cygwin1.dll >         DLL Name: KERNEL32.dll > Yes. So there are a couple of things here. First, the dll has SO_MAJORVERSION in the name. And second it stops building any static libraries and instead builds windows import libraries with names like lippq.a. I've tested this on both HEAD and REL9_3_STABLE and it works fine. I think we should apply this to HEAD. If it's not too late it would probably be a good thing for release 11 - would need a release note. cheers andrew -- Andrew Dunstan https://www.2ndQuadrant.com PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services