Re: [BUGS] index on function confuses drop table cascade on child

2010-11-02 Thread Dimitri Fontaine
Tom Lane writes: > Any thoughts out there? Color me slow, but I don't understand what allows an index creation on a table to not systematically add a dependency entry for the index that references the table. Regards, -- Dimitri Fontaine http://2ndQuadrant.fr PostgreSQL : Expertise, Formatio

Re: [BUGS] index on function confuses drop table cascade on child

2010-11-02 Thread Kevin Grittner
Tom Lane wrote: > 3. Or, perhaps we could change recordDependencyOnSingleRelExpr so > that it generates a whole-table dependency on the target relation > even if there are no Vars in the expression. This would make it > act much more like the regular-query context that > find_expr_references_wa

Fwd: ***SPAM*** Re: [BUGS] BUG #5739: postgresql will not start

2010-11-02 Thread Kevin Grittner
[Forwarding to the list. Please keep the list copied; for one thing, there is likely to be someone there who has heard of Arch Linux or pacman, which I have not. This is more of a question regarding how the packagers for that distro intend for upgrades to occur, not a bug in PostgreSQL itself.]

Re: [BUGS] index on function confuses drop table cascade on child

2010-11-02 Thread Tom Lane
"Kevin Grittner" writes: > Tom Lane wrote: >> 3. Or, perhaps we could change recordDependencyOnSingleRelExpr so >> that it generates a whole-table dependency on the target relation >> even if there are no Vars in the expression. This would make it >> act much more like the regular-query context

[BUGS] BUG #5741: syslog line length

2010-11-02 Thread heasley
The following bug has been logged online: Bug reference: 5741 Logged by: heasley Email address: h...@shrubbery.net PostgreSQL version: 8.4 Operating system: solaris Description:syslog line length Details: * Max string length to send to syslog(). Note that this does

Re: [BUGS] ecpg preprocessor regression in 9.0

2010-11-02 Thread Michael Meskes
On Mon, Nov 01, 2010 at 03:47:04PM +0200, Heikki Linnakangas wrote: > On closer look, it's quite obvious: the code added to > ECPGdump_a_type thinks that ECPGt_const is a variable type, and > tries to look up the variable. The straightforward fix is this: > ... > But I wonder if there is a better w

Re: [BUGS] ecpg preprocessor regression in 9.0

2010-11-02 Thread Korry Douglas
On closer look, it's quite obvious: the code added to ECPGdump_a_type thinks that ECPGt_const is a variable type, and tries to look up the variable. The straightforward fix is this: ... But I wonder if there is a better way to identify variable-kind of ECPGttypes than list the ones that are not. T

[BUGS] BUG #5740: contrib/spi/moddatetime.c doesn't work with timezones.

2010-11-02 Thread Dirk Heinrichs
The following bug has been logged online: Bug reference: 5740 Logged by: Dirk Heinrichs Email address: dirk.heinri...@altum.de PostgreSQL version: 8.4.5 Operating system: Linux Description:contrib/spi/moddatetime.c doesn't work with timezones. Details: The moddateti

Re: [BUGS] ecpg preprocessor regression in 9.0

2010-11-02 Thread Heikki Linnakangas
On 02.11.2010 19:39, Michael Meskes wrote: On Mon, Nov 01, 2010 at 03:47:04PM +0200, Heikki Linnakangas wrote: On closer look, it's quite obvious: the code added to ECPGdump_a_type thinks that ECPGt_const is a variable type, and tries to look up the variable. The straightforward fix is this: ...

Re: [BUGS] ecpg preprocessor regression in 9.0

2010-11-02 Thread Korry Douglas
On closer look, it's quite obvious: the code added to ECPGdump_a_type thinks that ECPGt_const is a variable type, and tries to look up the variable. The straightforward fix is this: ... But I wonder if there is a better way to identify variable-kind of ECPGttypes than list the ones that are not. T

Re: [BUGS] [PERFORM] typoed column name, but postgres didn't grump

2010-11-02 Thread Kevin Grittner
Jon Nelson wrote: > If I saw this behavior ( a.b also meaning b(a) ) in another SQL > engine, I would consider it a thoroughly unintuitive wart I think the main reason it has been kept is the converse -- if you define a function "b" which takes record "a" as its only parameter, you have effect

Re: [BUGS] BUG #5740: contrib/spi/moddatetime.c doesn't work with timezones.

2010-11-02 Thread Dimitri Fontaine
"Dirk Heinrichs" writes: > The moddatetime function provided by this module only works on columns of > type "timestamp without time zone". Would be nice if it could also provide > an analogous function moddatetime_tz which provides the same functionality > for columns of type "timestamp with time

Re: [BUGS] [PERFORM] typoed column name, but postgres didn't grump

2010-11-02 Thread Jon Nelson
On Tue, Nov 2, 2010 at 4:34 PM, Kevin Grittner wrote: > Jon Nelson wrote: > >> If I saw this behavior ( a.b also meaning b(a) ) in another SQL >> engine, I would consider it a thoroughly unintuitive wart > > I think the main reason it has been kept is the converse -- if you > define a function "b