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

2002-06-05 Thread Bruce Momjian
Yes, autocomplete is only smart about the first word or two; very hard to fix this. --- Oliver Elphick wrote: Checking application/pgp-signature: FAILURE -- Start of PGP signed section. > -Forwarded Message- > >

Re: [BUGS] drop tempoary table VERY slow

2002-06-05 Thread Sam Liddicott
> -Original Message- > From: Andrew McMillan [mailto:[EMAIL PROTECTED]] > Sent: 05 June 2002 12:58 > To: Sam Liddicott > Cc: [EMAIL PROTECTED] > Subject: RE: [BUGS] drop tempoary table VERY slow > > Interesting. Those are pretty long times to take for a > vacuum on those > tables - if

Re: [BUGS] drop tempoary table VERY slow

2002-06-05 Thread Sam Liddicott
> -Original Message- > From: Andrew McMillan [mailto:[EMAIL PROTECTED]] > Sent: 02 June 2002 11:52 > To: Sam Liddicott > Cc: [EMAIL PROTECTED] > Subject: Re: [BUGS] drop tempoary table VERY slow > > > On Fri, 2002-05-31 at 22:28, Sam Liddicott wrote: > > And when I do drop a table CPU

Re: [BUGS] drop tempoary table VERY slow

2002-06-05 Thread Andrew McMillan
On Wed, 2002-06-05 at 21:02, Sam Liddicott wrote: > > > > When did you last do a vacuum? If you are adding and > > dropping temporary > > tables a lot, perhaps you should vacuum pg_class and > > pg_attribute often > > as well. > > I do a vacuum analyse every night on that whole DB, cron logs

[BUGS] Bug #682: current_timestamp reporting time incorrectly

2002-06-05 Thread pgsql-bugs
Colin Mangiagalli ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description current_timestamp reporting time incorrectly Long Description Postgresql Version: PostgreSQL 7.2.1 on i686-pc-cygwin, compiled by GCC 2.95.3-5 Cygwin dll: 1.3.10