Re: [PATCHES] [HACKERS] Behavior of GENERATED columns per SQL2003

2007-05-08 Thread Tom Lane
Zoltan Boszormenyi [EMAIL PROTECTED] writes: Tom Lane írta: * There is no GENERATED BY DEFAULT AS (expr) in the spec. Yes, and because it already exists and called DEFAULT. No, plain DEFAULT isn't a substitute, because it can't reference the values of other columns. I think there is a

Re: [PATCHES] small patch for guc issues

2007-05-08 Thread Peter Eisentraut
Am Freitag, 4. Mai 2007 18:21 schrieb Joachim Wieland: The appended patch addresses the outstanding issues of the recent guc patch. It makes PGCLIENTENCODING work again and uses bsearch() instead of iterating over the array of guc variables in guc_get_index(). Applied. -- Peter Eisentraut

Re: [PATCHES] [WIP] GUC for temp_tablespaces

2007-05-08 Thread Peter Eisentraut
Am Samstag, 5. Mai 2007 16:40 schrieb Jaime Casanova: On 5/5/07, Bruce Momjian [EMAIL PROTECTED] wrote: Your patch has been added to the PostgreSQL unapplied patches list at: This is final version of the patch (i hope), at least it fixes the problem i had yesterday. What I have been missing

Re: [PATCHES] Hash function for numeric (WIP)

2007-05-08 Thread Neil Conway
On Sun, 2007-06-05 at 21:30 -0400, Tom Lane wrote: It'd be a good idea if you repeat the previous number-of-collisions experiment on this code. I repeated the same experiment, and got essentially the same number of collisions (829 collisions on ~2 million randomly generated numerics, with 273

Re: [PATCHES] [HACKERS] Patch: Allocation of kind codes for spatial type.

2007-05-08 Thread Tom Lane
Ale Raza [EMAIL PROTECTED] writes: Attached is the modified pg_statistic.h file for this patch. As you mentioned 200 - 299 is reserved for ESRI st_geometry type. Out of these values I am using code 200 for st_geometry. Done. For future reference, what people normally mean by a patch is diff

Re: [PATCHES] [WIP] GUC for temp_tablespaces

2007-05-08 Thread Jaime Casanova
On 5/8/07, Peter Eisentraut [EMAIL PROTECTED] wrote: Am Samstag, 5. Mai 2007 16:40 schrieb Jaime Casanova: On 5/5/07, Bruce Momjian [EMAIL PROTECTED] wrote: Your patch has been added to the PostgreSQL unapplied patches list at: This is final version of the patch (i hope), at least it fixes