Re: Bug#146689: [BUGS] [Fwd: Bug#146689: postgresql-client: 'GRANT DELETE'

Your patch has been added to the PostgreSQL unapplied patches list at:

http://candle.pha.pa.us/cgi-bin/pgpatches

I will try to apply it within the next 48 hours.

---------------------------------------------------------------------------

Oliver Elphick wrote:
[ There is text before PGP section. ]

This message was created automatically by mail delivery software (Exim).

A message that you sent could not be delivered to one or more of its
recipients. This is a permanent error. The following address(es) failed:

pgman@candle.pha.pa.us
SMTP error from remote mailer after MAIL FROM:<olly@lfix.co.uk>:
host candle.pha.pa.us [216.55.132.35]: 550 5.0.0 Delivery blocked --- Previous SPAM received from your mail server

------ This is a copy of the message, including all the headers. ------

Return-path: <olly@lfix.co.uk>
Received: from lfix.demon.co.uk ([158.152.59.127] helo=linda.lfix.co.uk)
by anchor-post-32.mail.demon.net with esmtp (Exim 3.35 #1)
id 17GYE6-000HRz-0W
for pgman@candle.pha.pa.us; Sat, 08 Jun 2002 05:53:22 +0100
Received: from localhost
([127.0.0.1] helo=localhost.localdomain ident=olly)
by linda.lfix.co.uk with esmtp (Exim 3.35 #1 (Debian))
id 17GYEJ-0004QJ-00
for <pgman@candle.pha.pa.us>; Sat, 08 Jun 2002 05:53:35 +0100
Subject: Re: Bug#146689: [BUGS] [Fwd: Bug#146689: postgresql-client: 'GRANT
DELETE' autocompletion follows syntax for 'DELETE']
From: Oliver Elphick <olly@lfix.co.uk>
To: Bruce Momjian <pgman@candle.pha.pa.us>
In-Reply-To: <200206080244.g582iZ022111@candle.pha.pa.us>
References: <200206080244.g582iZ022111@candle.pha.pa.us>
Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature";
boundary="=-/ToVJCeHv4xMQqxbxMbb"
X-Mailer: Ximian Evolution 1.0.5
Date: 08 Jun 2002 05:53:34 +0100
Message-Id: <1023512015.26291.7983.camel@linda>
Mime-Version: 1.0

--=-/ToVJCeHv4xMQqxbxMbb
Content-Type: text/plain
Content-Transfer-Encoding: quoted-printable

On Sat, 2002-06-08 at 03:44, Bruce Momjian wrote:

=20
Current sources don't have the patch, and I can't see it in my mailbox.
Would you send it to me.
=20
-------------------------------------------------------------------------=

--

=20
test=3D> GRANT <TAB>
ALL DELETE INSERT RULE SELECT UPDATE =20
test=3D> GRANT DELETE <TAB> FROM=20

--- postgresql-7.2.1.orig/src/bin/psql/tab-complete.c
+++ postgresql-7.2.1/src/bin/psql/tab-complete.c
@@ -495,10 +495,11 @@
=20
/*
* Complete DELETE with FROM (only if the word before that is
not "ON"
-        * (cf. rules) or "BEFORE" or "AFTER" (cf. triggers) )
+        * (cf. rules) or "BEFORE" or "AFTER" (cf. triggers) or GRANT)
*/
else if (strcasecmp(prev_wd, "DELETE") =3D=3D 0 &&
!(strcasecmp(prev2_wd, "ON") =3D=3D 0 ||
+                          strcasecmp(prev2_wd, "GRANT") =3D=3D 0 ||
strcasecmp(prev2_wd, "BEFORE") =3D=3D 0 ||
strcasecmp(prev2_wd, "AFTER") =3D=3D 0))
COMPLETE_WITH_CONST("FROM");

--=20
Oliver Elphick Oliver.Elphick@lfix.co.uk
Isle of Wight http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C

"Fear not, for I am with thee; be not dismayed,=20
for I am thy God. I will strengthen thee and I will=20
help thee; yea, I will uphold thee with the right hand
of my righteousness." Isaiah 41:10=20

--=-/ToVJCeHv4xMQqxbxMbb
Content-Type: application/pgp-signature; name=signature.asc
Content-Description: This is a digitally signed message part

-- Start of PGP signed section.
-- End of PGP signed section, PGP failed!

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026