Re: Bug#146689: [BUGS] [Fwd: Bug#146689: postgresql-client: 'GRANT DELETE' - Mailing list pgsql-patches

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