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(at)candle(dot)pha(dot)pa(dot)us
> SMTP error from remote mailer after MAIL FROM:<olly(at)lfix(dot)co(dot)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(at)lfix(dot)co(dot)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(at)candle(dot)pha(dot)pa(dot)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(at)candle(dot)pha(dot)pa(dot)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(at)lfix(dot)co(dot)uk>
> To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
> In-Reply-To: <200206080244(dot)g582iZ022111(at)candle(dot)pha(dot)pa(dot)us>
> References: <200206080244(dot)g582iZ022111(at)candle(dot)pha(dot)pa(dot)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(dot)26291(dot)7983(dot)camel(at)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(dot)Elphick(at)lfix(dot)co(dot)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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026