
Hi all!

PostgreSQL 7.3 beta5
Debian GNU/Linux 2.2r5  ( x86 )
.............

All regression tests passed, except geometry.
The differences don't seem to be big. I think the test can be
validated, but i'm not absolutely sure. So i've attached the diff.

.............

On the other hand, in psql , tab-completion doesn't seem to
work for certain commands :

   ALTER DATABASE ; ALTER TRIGGER ; CHECKPOINT ; CREATE CAST ;
   CREATE CONSTRAINT TRIGGER ; CREATE CONVERSION ; CREATE DOMAIN ;
   CREATE LANGUAGE ; DEALLOCATE ; DROP CAST ; DROP CONVERSION ; 
   DROP DOMAIN ; DROP LANGUAGE ; EXECUTE ; PREPARE

( this could be considered a low priority todo item , though ) 
.............

Regards,

Adrian Maier
(am@fx.ro)




Tue, 12 Nov 2002 03:20:52 +0200
am@fx.ro
geometry test failed (beta5 on Debian)
On Tue, Nov 12, 2002 at 03:20:52AM +0200, am@fx.ro wrote:
> validated, but i'm not absolutely sure. So i've attached the diff.

Oops , forgot to attach it in the first message.
This is the diff.
Tue, 12 Nov 2002 03:26:40 +0200
am@fx.ro
Re: geometry test failed (beta5 on Debian)
Clean up psql:

Add simple ALTER DATABASE, ALTER TRIGGER, CHECK POINT, CREATE
CONVERSION, CREATE DOMAIN, CREATE LANGUAGE, DEALLOCATE, DROP CONVERSION,
DROP DOMAIN, DROP LANGUAGE, EXECUTE, PREPARE

Complete CAST in CREATE CAST and DROP CAST but doesn't suggest what
should follow.

Add many more SET / SHOW variables to the list.  Taken from SHOW ALL
output.

Complete a case sensitive search to allow \dD, \dd, \dS, \ds, \h, \H to
complete properly.  But there are no matches, then try a case
insensitive search to allow case conversion.  Add all missing help
options.

\Q<tab>    -> \q
\dD<tab>   -> \dD 
\dd<tab>   -> \dd
\D<tab><tab><tab> -> \d (with listing of \d? commands)
sel<tab>   -> SELECT


> On the other hand, in psql , tab-completion doesn't seem to
> work for certain commands :
> 
>    ALTER DATABASE ; ALTER TRIGGER ; CHECKPOINT ; CREATE CAST ;
>    CREATE CONSTRAINT TRIGGER ; CREATE CONVERSION ; CREATE DOMAIN ;
>    CREATE LANGUAGE ; DEALLOCATE ; DROP CAST ; DROP CONVERSION ; 
>    DROP DOMAIN ; DROP LANGUAGE ; EXECUTE ; PREPARE
> 
> ( this could be considered a low priority todo item , though )

-- 
  Rod Taylor
11 Nov 2002 23:40:12 -0500
Rod Taylor <rbt@rbt.ca>
psql tab completion

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

	http://momjian.postgresql.org/cgi-bin/pgpatches

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

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


Rod Taylor wrote:
> Clean up psql:
> 
> Add simple ALTER DATABASE, ALTER TRIGGER, CHECK POINT, CREATE
> CONVERSION, CREATE DOMAIN, CREATE LANGUAGE, DEALLOCATE, DROP CONVERSION,
> DROP DOMAIN, DROP LANGUAGE, EXECUTE, PREPARE
> 
> Complete CAST in CREATE CAST and DROP CAST but doesn't suggest what
> should follow.
> 
> Add many more SET / SHOW variables to the list.  Taken from SHOW ALL
> output.
> 
> Complete a case sensitive search to allow \dD, \dd, \dS, \ds, \h, \H to
> complete properly.  But there are no matches, then try a case
> insensitive search to allow case conversion.  Add all missing help
> options.
> 
> \Q<tab>    -> \q
> \dD<tab>   -> \dD 
> \dd<tab>   -> \dd
> \D<tab><tab><tab> -> \d (with listing of \d? commands)
> sel<tab>   -> SELECT
> 
> 
> > On the other hand, in psql , tab-completion doesn't seem to
> > work for certain commands :
> > 
> >    ALTER DATABASE ; ALTER TRIGGER ; CHECKPOINT ; CREATE CAST ;
> >    CREATE CONSTRAINT TRIGGER ; CREATE CONVERSION ; CREATE DOMAIN ;
> >    CREATE LANGUAGE ; DEALLOCATE ; DROP CAST ; DROP CONVERSION ; 
> >    DROP DOMAIN ; DROP LANGUAGE ; EXECUTE ; PREPARE
> > 
> > ( this could be considered a low priority todo item , though )
> 
> -- 
>   Rod Taylor

[ Attachment, skipping... ]

> 
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
> 
> http://www.postgresql.org/users-lounge/docs/faq.html

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

Tue, 12 Nov 2002 22:15:52 -0500 (EST)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: psql tab completion

Nice comprehensive patch applied.  Thanks.

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


Rod Taylor wrote:
> Clean up psql:
> 
> Add simple ALTER DATABASE, ALTER TRIGGER, CHECK POINT, CREATE
> CONVERSION, CREATE DOMAIN, CREATE LANGUAGE, DEALLOCATE, DROP CONVERSION,
> DROP DOMAIN, DROP LANGUAGE, EXECUTE, PREPARE
> 
> Complete CAST in CREATE CAST and DROP CAST but doesn't suggest what
> should follow.
> 
> Add many more SET / SHOW variables to the list.  Taken from SHOW ALL
> output.
> 
> Complete a case sensitive search to allow \dD, \dd, \dS, \ds, \h, \H to
> complete properly.  But there are no matches, then try a case
> insensitive search to allow case conversion.  Add all missing help
> options.
> 
> \Q<tab>    -> \q
> \dD<tab>   -> \dD 
> \dd<tab>   -> \dd
> \D<tab><tab><tab> -> \d (with listing of \d? commands)
> sel<tab>   -> SELECT
> 
> 
> > On the other hand, in psql , tab-completion doesn't seem to
> > work for certain commands :
> > 
> >    ALTER DATABASE ; ALTER TRIGGER ; CHECKPOINT ; CREATE CAST ;
> >    CREATE CONSTRAINT TRIGGER ; CREATE CONVERSION ; CREATE DOMAIN ;
> >    CREATE LANGUAGE ; DEALLOCATE ; DROP CAST ; DROP CONVERSION ; 
> >    DROP DOMAIN ; DROP LANGUAGE ; EXECUTE ; PREPARE
> > 
> > ( this could be considered a low priority todo item , though )
> 
> -- 
>   Rod Taylor

[ Attachment, skipping... ]

> 
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
> 
> http://www.postgresql.org/users-lounge/docs/faq.html

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

Thu, 14 Nov 2002 22:08:01 -0500 (EST)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: psql tab completion