Re: [PATCHES] [PATCH] WIP: Create shell-types explicitly
Martijn van Oosterhout kleptog@svana.org writes: The first line creates public.text, but the drop tries to delete pg_catalog.text. This is not particularly specific to (or relevant to) shell types. regards, tom lane ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [PATCHES] [PATCH] WIP: Create shell-types explicitly
On Mon, Feb 20, 2006 at 10:13:39AM -0500, Tom Lane wrote: Martijn van Oosterhout kleptog@svana.org writes: The first line creates public.text, but the drop tries to delete pg_catalog.text. This is not particularly specific to (or relevant to) shell types. So this is not a show stopper and not something we're particularly concerned about? Thanks, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a tool for doing 5% of the work and then sitting around waiting for someone else to do the other 95% so you can sue them. signature.asc Description: Digital signature
Re: [PATCHES] [PATCH] WIP: Create shell-types explicitly
Martijn van Oosterhout kleptog@svana.org writes: On Mon, Feb 20, 2006 at 10:13:39AM -0500, Tom Lane wrote: Martijn van Oosterhout kleptog@svana.org writes: The first line creates public.text, but the drop tries to delete pg_catalog.text. This is not particularly specific to (or relevant to) shell types. So this is not a show stopper and not something we're particularly concerned about? I'm not concerned about it. If you're using the default search path, you'd see the same behavior anytime you created any object with the same name as a pg_catalog object. It's been like that since 7.3, and I don't recall seeing any complaints from users (as distinct from people trying to break things ;-)) so I'm not very worried. regards, tom lane ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings