Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1maHpK-00035m-D5 for pgsql-www@arkaria.postgresql.org; Tue, 12 Oct 2021 13:28:18 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1maHpJ-0006W9-BH for pgsql-www@arkaria.postgresql.org; Tue, 12 Oct 2021 13:28:17 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1maHg0-0002ZA-QY for pgsql-www@lists.postgresql.org; Tue, 12 Oct 2021 13:18:40 +0000 Received: from mail-ua1-x92b.google.com ([2607:f8b0:4864:20::92b]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1maHfy-0005PK-9c for pgsql-www@postgresql.org; Tue, 12 Oct 2021 13:18:39 +0000 Received: by mail-ua1-x92b.google.com with SMTP id i15so14252349uap.0 for ; Tue, 12 Oct 2021 06:18:38 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=mime-version:references:in-reply-to:reply-to:from:date:message-id :subject:to; bh=8pia3Ns3qqLVow96NUacu3BEh3djkbUCePRSDUsWQj0=; b=WHiXuZqM7eNuqLiYL0Qgvcg9jGt4RHMD40SsUL8iTApdKRND1IYfkTHbvYHS3MD6D3 gzTB3SoZcZXcB2E/yNbOTi7vwM7p/Q2SnCwF624wTHDff1gtt2K1QV4eQ7uHnsjwGmhA C1VE8mnAYkyRwIgpHXnzgd/87YG5S75DDiSy5I6+3rO1mQybnjC+nSejHh9254thJK/p IDErMibUlQfjBw6N0LLBjqpYo7Nj6Jbel/zW9BHyINcgPPkd9XcUjNTGsViPpNymtggW DNCUz91eOFQtvgiJ9nLHjXNBfSYZAPVDhPf7JLc5iJckzQtAvzrUuDZTnrPZvq/Fgw68 U+1A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:mime-version:references:in-reply-to:reply-to :from:date:message-id:subject:to; bh=8pia3Ns3qqLVow96NUacu3BEh3djkbUCePRSDUsWQj0=; b=v+kaV1H9R8hBq7VHvrk5eeR57fTHAK5cPRK8jbyOwWDKN3TYo9c9WCDmGwAhJftG0D +U+NtBB2BIl1rJ/dbYT2B8uDUcgfC82n7uEk3sdlxM7gUtd0pYYX3H+lEEaqfiiIMT0G OESqNGuNrOFyzO86PJxEAc/tYZCJ/QykcwNfK2Xj/LIfXUMp6ZQTkg5Wq5lh0YIvPXcU m4fQyftn6etTq+p6Afnj2BJ+Ybvec17i1BMhh2sXnk8Lt/ewGGw2n5gyF6xzUXJMyWOc 0x4mJJk6nJD09G43/IGqhZ5fL2JUNPxGzmChdJ1Qew+apcJWJb++r5JaHR0BBOpRkAI+ 2D7Q== X-Gm-Message-State: AOAM531Mt6kz9HlyRCfvzeNQWWFwW4Aadhg3ptcgt8prkW7YEjHv/62W YicPhR3q93O+P+V6xik67COx4tsn6Q5sAGo+WKYWibFaeZ4= X-Google-Smtp-Source: ABdhPJwHy6T9wszfNg5rIOEMWHjp8/uM97srVfUUAOrMjFofF7BLGJQ4HusM1oTZfYl6r+/X0FWw2GmSW7bote1FfQc= X-Received: by 2002:ab0:6089:: with SMTP id i9mr11467384ual.91.1634044716964; Tue, 12 Oct 2021 06:18:36 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: Reply-To: sircompo@gmail.com From: Dave Compton Date: Tue, 12 Oct 2021 14:18:26 +0100 Message-ID: Subject: Re: Wiki editor request To: pgsql-www@postgresql.org Content-Type: multipart/alternative; boundary="000000000000e6deb505ce27ae19" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000e6deb505ce27ae19 Content-Type: text/plain; charset="UTF-8" Wrong wrong wrong! I jumped the gun there. Not sure what I was thinking. Looks like collprovider was introduced in PG10 so that'll be my problem (trying to run that query on 9.3!). Sorry to waste your time, please disregard my request. On Tue, 12 Oct 2021 at 13:52, Dave Compton wrote: > I would like editor access to the wiki, my username is sircompo and I > would like to modify "Locale data changes". > > I believe there's a comma where it shouldn't be; > > SELECT indrelid::regclass::text, indexrelid::regclass::text, collname, pg_get_indexdef(indexrelid) > > should be : > > SELECT indrelid::regclass::text, indexrelid::regclass::text collname, pg_get_indexdef(indexrelid) > > > Regards, > Dave. > --000000000000e6deb505ce27ae19 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Wrong wrong wrong!
I jumped the gun there. Not sure what I was thin= king.
Looks like=C2=A0collprovider=C2=A0was introduced in PG10 so that'll be my = problem (trying to run that query on 9.3!).

Sorry to wa= ste your time, please disregard my request.


On Tue, 12 Oct 2021 at = 13:52, Dave Compton <sircompo@gmai= l.com> wrote:
I would like editor access to the wiki, my username = is sircompo and I would like to modify "Locale data changes".<= div>
I believe there's a comma where it shouldn't be;
<= pre style=3D"font-family:monospace,monospace;color:rgb(0,0,0);background-co= lor:rgb(248,249,250);border:1px solid rgb(234,236,240);padding:1em;white-sp= ace:pre-wrap;line-height:1.1em;font-size:12.7px">SELECT indrelid::regclass:= :text, indexrelid::regclass::text, collname, pg_get_indexdef(indexrelid)=20
s= hould be :
SELECT in=
drelid::regclass::text, indexrelid::regclass::text collname, pg_get_indexde=
f(indexrelid)=20

Regards,
Dave.
--000000000000e6deb505ce27ae19--