Skip site navigation (1) Skip section navigation (2)

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

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Oliver Elphick <elphick(at)klecker(dot)debian(dot)org>
Cc: PostgreSQL-patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: Bug#146689: [BUGS] [Fwd: Bug#146689: postgresql-client: 'GRANT DELETE'
Date: 2002-06-14 04:52:10
Message-ID: 200206140452.g5E4qAZ01312@candle.pha.pa.us (view raw or flat)
Thread:
Lists: 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(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

pgsql-patches by date

Next:From: Bruce MomjianDate: 2002-06-14 05:02:38
Subject: Re: boolean options and postmaster documentation
Previous:From: Bruce MomjianDate: 2002-06-14 04:50:52
Subject: Re: guc.c and postgresql.conf.sample constistency checker

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group