Simon Riggs wrote:
> pgadmin sneaks a REINDEX into the SQL when you specify a change to the
> fillfactor of an index.
>
> That's not very handy because the Postgres manual says specifically that
> ALTER INDEX doesn't issue a REINDEX. It's a perfectly valid thing to run
> on its own, since it will
Author: dpage
Date: 2007-10-05 21:22:31 +0100 (Fri, 05 Oct 2007)
New Revision: 6716
Revision summary: http://svn.pgadmin.org/cgi-bin/viewcvs.cgi/?rev=6716&view=rev
Log:
Don't reindex after altering an indexes fillfactor, per Simon Riggs.
Modified:
trunk/pgadmin3/pgadmin/dlg/dlgIndex.cpp
-
On Fri, 2007-10-05 at 13:55 +0100, Dave Page wrote:
> Guillaume Lelarge wrote:
> > Simon Riggs a écrit :
> >> It would be great if there was a database-level option so that any new
> >> indexes would default to using CONCURRENTLY.
> >>
> >> This would allow production systems to be changed easily u
Guillaume Lelarge wrote:
> Simon Riggs a écrit :
>> It would be great if there was a database-level option so that any new
>> indexes would default to using CONCURRENTLY.
>>
>> This would allow production systems to be changed easily using the
>> default of CONCURRENTLY, whereas dev systems won't n
Author: guillaume
Date: 2007-10-05 12:09:08 +0100 (Fri, 05 Oct 2007)
New Revision: 6715
Revision summary: http://svn.pgadmin.org/cgi-bin/viewcvs.cgi/?rev=6715&view=rev
Log:
Fix the overwriting the contents of the newly opened file with the contents of
the old buffer, per a report from Kieran M
Simon Riggs a écrit :
> It would be great if there was a database-level option so that any new
> indexes would default to using CONCURRENTLY.
>
> This would allow production systems to be changed easily using the
> default of CONCURRENTLY, whereas dev systems won't need that.
>
> If not, can we j
Author: guillaume
Date: 2007-10-05 11:22:44 +0100 (Fri, 05 Oct 2007)
New Revision: 6714
Revision summary: http://svn.pgadmin.org/cgi-bin/viewcvs.cgi/?rev=6714&view=rev
Log:
Fix arguments signature list, per a report from Rikard Pavelic.
Modified:
trunk/pgadmin3/pgadmin/schema/pgFunction.c
Hi Andrew,
Andrew Lazarus a écrit :
> Wednesday, October 3, 2007, 1:12:52 AM, you wrote:
>
> GL> [EMAIL PROTECTED] a écrit :
>>> to go with INSERT, DELETE, etc.
>
> GL> I don't see much interest in a TRUNCATE script because there's nothing
> GL> more to add on the script. How about a simple "Tru
