Re: default attstattarget

Tom Lane will apply this as part of the DROP COLUMN merging.

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

Neil Conway wrote:
> Hi all,
>
> The attached patch implements the pg_attribute.attstattarget scheme
> discussed on -hackers today. A value of "-1" in this column indicates
> that ANALYZE should use the compiled-in default value. This allows
> pg_dump to record and restore any changes made by the DBA to this
> value using ALTER TABLE ALTER COLUMN SET STATISTICS.
>
> I made another small behavioral change: IMHO, silently changing
> stat target values we deem inappropriate (< 0, > 1000) without
> warning the user is a bad idea. I changed the < 0 case to be a
> elog(ERROR) and added an elog(WARNING) for the > 1000, and
> documented the upper bound.
>
> Unless anyone sees any problems, please apply.
>
> Cheers,
>
> Neil
>
> --
> Neil Conway <neilconway(at)rogers(dot)com>
> PGP Key ID: DB3C29FC

[ Attachment, skipping... ]

>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)

--
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