From mboxrd@z Thu Jan 1 00:00:00 1970 Path: news.gmane.io!.POSTED.blaine.gmane.org!not-for-mail From: Nicolas Martyanoff Newsgroups: gmane.emacs.devel Subject: Re: [PATCH] sql: add missing postgresql types Date: Mon, 17 Apr 2023 12:18:11 +0200 Message-ID: <87jzyavml8.fsf@valhala.localdomain> References: <20230416133843.74970-1-nicolas@n16f.net> <87ttxeeutb.fsf@gmail.com> Mime-Version: 1.0 Content-Type: multipart/mixed; boundary="=-=-=" Injection-Info: ciao.gmane.io; posting-host="blaine.gmane.org:116.202.254.214"; logging-data="20532"; mail-complaints-to="usenet@ciao.gmane.io" User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/28.2 (gnu/linux) Cc: Nicolas Martyanoff , emacs-devel@gnu.org To: Robert Pluim Original-X-From: emacs-devel-bounces+ged-emacs-devel=m.gmane-mx.org@gnu.org Mon Apr 17 12:19:08 2023 Return-path: Envelope-to: ged-emacs-devel@m.gmane-mx.org Original-Received: from lists.gnu.org ([209.51.188.17]) by ciao.gmane.io with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1poLwy-00058s-FT for ged-emacs-devel@m.gmane-mx.org; Mon, 17 Apr 2023 12:19:08 +0200 Original-Received: from localhost ([::1] helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1poLwE-0003Ey-4j; Mon, 17 Apr 2023 06:18:22 -0400 Original-Received: from eggs.gnu.org ([2001:470:142:3::10]) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1poLwB-0003Ek-22 for emacs-devel@gnu.org; Mon, 17 Apr 2023 06:18:19 -0400 Original-Received: from mail-wm1-x32c.google.com ([2a00:1450:4864:20::32c]) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1poLw7-0005Qi-2y for emacs-devel@gnu.org; Mon, 17 Apr 2023 06:18:18 -0400 Original-Received: by mail-wm1-x32c.google.com with SMTP id 5b1f17b1804b1-3f16b99b936so7194495e9.3 for ; Mon, 17 Apr 2023 03:18:14 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=n16f-net.20221208.gappssmtp.com; s=20221208; t=1681726693; x=1684318693; h=mime-version:user-agent:message-id:in-reply-to:date:references :subject:cc:to:from:from:to:cc:subject:date:message-id:reply-to; bh=fxVJL8FK9Zv8K1Rr0RfP4UmWh8Ojd1Gj2cHEDeBJWu8=; b=e/AW6cqjJbKG9Mj1l6CoMbFeJ6LqiuZf3KEcE/pt2Wsv0sIOJDQVDbYubWmg79eEJU edORv4tpi5TH12NSLT249FOk1cZzkENhbwgLWfq9MjPv73ojvmApNVLZdTfqZZHKcidM D7OXWpLWDPo+wYuDy4CckYaBBctAgjjcgiJVTWhwK15IjGRwbfcPl9HvtmdNmLpHZ+lg q66M4niyekxx9QQE//EXDc3YXb1XgXyydYYw7ePkCRiUGN3FzY4eEfth0G5qYznBxEaR 7mmSAOFWcOHhgCYsihbP+iCq5zsWzUfgkLOHKbQSUapfm5C0NY60k+Lc3AQ+miLPzA5v rHrQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1681726693; x=1684318693; h=mime-version:user-agent:message-id:in-reply-to:date:references :subject:cc:to:from:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=fxVJL8FK9Zv8K1Rr0RfP4UmWh8Ojd1Gj2cHEDeBJWu8=; b=Om4flaQhvQ/uJXJP6SvTOOPZ9BZn/2IhSNaNKjqZxnS/3a5I81FwTDVmitcT8YIbMN iGq5x7Gh3+llw5iVdOInpoQz7tAE/zdK3gzgeoq5+391dGw3FSJyR/L9DWfjUZf64DC3 B5F6rB3KdqYcHCllwDB8MqjWsml1umXrcs5t/7gwfTKR48zRdoYAMRC9IG8dhGQDg2cc SNWBfRQuC28ufNSA+AOFwzxV23Z2K1O0glmBYsUbk7bznHbnKn4PEoZgncEaK5WwIr/z SS+S8krrL/dB/SvGnZtWCWV+s3Q0/SPbJhg7p1aVIxZff4ba0I+iJ+G5JZoB2deuxJui gwDg== X-Gm-Message-State: AAQBX9f/QErAfA4h8RoFjtS04x86kYzhgZCqRVfuXV+6aCjv+D1STabe ULprqbyI7169RvOTVUnwE9ExX8xK2iijb5oZDGHDPw== X-Google-Smtp-Source: AKy350ZvI8p3nWyj2deLyCGvrF0bbJdZ3GSRrdD9Hz8rZJYvyr4vuTvYCj7sr1b0FJA/bb8rQ9R9CA== X-Received: by 2002:a5d:4ac8:0:b0:2f5:6fb1:c8e5 with SMTP id y8-20020a5d4ac8000000b002f56fb1c8e5mr4131805wrs.25.1681726692666; Mon, 17 Apr 2023 03:18:12 -0700 (PDT) Original-Received: from valhala (2a01cb04000943008cd04fe2c793033e.ipv6.abo.wanadoo.fr. [2a01:cb04:9:4300:8cd0:4fe2:c793:33e]) by smtp.gmail.com with ESMTPSA id f24-20020a1cc918000000b003ee63fe5203sm11503431wmb.36.2023.04.17.03.18.11 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 17 Apr 2023 03:18:12 -0700 (PDT) In-Reply-To: <87ttxeeutb.fsf@gmail.com> (Robert Pluim's message of "Mon, 17 Apr 2023 11:12:32 +0200") Received-SPF: pass client-ip=2a00:1450:4864:20::32c; envelope-from=nicolas@n16f.net; helo=mail-wm1-x32c.google.com X-Spam_score_int: -18 X-Spam_score: -1.9 X-Spam_bar: - X-Spam_report: (-1.9 / 5.0 requ) BAYES_00=-1.9, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, RCVD_IN_DNSWL_NONE=-0.0001, SPF_HELO_NONE=0.001, SPF_PASS=-0.001, T_SCC_BODY_TEXT_LINE=-0.01 autolearn=ham autolearn_force=no X-Spam_action: no action X-BeenThere: emacs-devel@gnu.org X-Mailman-Version: 2.1.29 Precedence: list List-Id: "Emacs development discussions." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-devel-bounces+ged-emacs-devel=m.gmane-mx.org@gnu.org Original-Sender: emacs-devel-bounces+ged-emacs-devel=m.gmane-mx.org@gnu.org Xref: news.gmane.io gmane.emacs.devel:305362 Archived-At: --=-=-= Content-Type: text/plain Robert Pluim writes: > You have 'bigserial' in there twice. Good catch. Updated patch attached. --=-=-= Content-Type: text/x-patch Content-Disposition: attachment; filename=0001-sql-add-missing-postgresql-types.patch >From dd6076f341a9fa479c520353bb6196ea3d46ff78 Mon Sep 17 00:00:00 2001 From: Nicolas Martyanoff Date: Sun, 16 Apr 2023 15:30:47 +0200 Subject: [PATCH] sql: add missing postgresql types * lisp/progmodes/sql.el: Add multiple missing PostgreSQL types: bigserial, smallserial, macaddr8, jsonb, jsonpath, built-in range types, object identifier types (oid & co). --- lisp/progmodes/sql.el | 19 +++++++++++-------- 1 file changed, 11 insertions(+), 8 deletions(-) diff --git a/lisp/progmodes/sql.el b/lisp/progmodes/sql.el index d8bd6bc2685..c6667c075f6 100644 --- a/lisp/progmodes/sql.el +++ b/lisp/progmodes/sql.el @@ -2192,14 +2192,17 @@ sql-mode-postgres-font-lock-keywords ;; Postgres Data Types (sql-font-lock-keywords-builder 'font-lock-type-face nil -"bigint" "bigserial" "bit" "bool" "boolean" "box" "bytea" "char" -"character" "cidr" "circle" "date" "decimal" "double" "float4" -"float8" "inet" "int" "int2" "int4" "int8" "integer" "interval" "line" -"lseg" "macaddr" "money" "name" "numeric" "path" "point" "polygon" -"precision" "real" "serial" "serial4" "serial8" "sequences" "smallint" "text" -"time" "timestamp" "timestamptz" "timetz" "tsquery" "tsvector" -"txid_snapshot" "unknown" "uuid" "varbit" "varchar" "varying" "without" -"xml" "zone" + "bigint" "bigserial" "bit" "bool" "boolean" "box" "bytea" "char" "character" +"cidr" "circle" "date" "daterange" "decimal" "double" "float4" "float8" "inet" +"int" "int2" "int4" "int4range" "int8" "int8range" "integer" "interval" +"jsonb" "jsonpath" "line" "lseg" "macaddr" "macaddr8" "money" "name" "numeric" +"numrange" "oid" "path" "point" "polygon" "precision" "real" "regclass" +"regcollation" "regconfig" "regdictionary" "regnamespace " "regoper" +"regoperator" "regproc" "regprocedure" "regrole" "regtype" "sequences" +"serial" "serial4" "serial8" "smallint" "smallserial" "text" "time" +"timestamp" "timestamptz" "timetz" "tsquery" "tsrange" "tstzrange" "tsvector" +"txid_snapshot" "unknown" "uuid" "varbit" "varchar" "varying" "without" "xml" +"zone" ))) "Postgres SQL keywords used by font-lock. -- 2.39.2 --=-=-= Content-Type: text/plain -- Nicolas Martyanoff https://n16f.net nicolas@n16f.net --=-=-=--