Skip site navigation (1) Skip section navigation (2)

Re: [PORTS] Port Bug Report: pg_dump -d database >unload.file; cat unload.file|psql database ARE NOT EQUAL

From: "Thomas G(dot) Lockhart" <lockhart(at)alumni(dot)caltech(dot)edu>
To: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
Cc: karpov(at)allonge(dot)viaduk(dot)net, PostgreSQL-development <hackers(at)postgresql(dot)org>
Subject: Re: [PORTS] Port Bug Report: pg_dump -d database >unload.file; cat unload.file|psql database ARE NOT EQUAL
Date: 1998-03-30 06:42:36
Message-ID: 351F3EDC.FC5ADDD5@alumni.caltech.edu (view raw or flat)
Thread:
Lists: pgsql-hackers
> > create table templ_arg(accii int2,type char,sign float8);
> > create table a1 () inherits (templ_arg);
> > insert into a1 values (9999,'a',1); -- working;
> > insert into a1 values (9999,'a',-1); -- ERROR;
> > insert into a1 values (9999,'a',-1.0); --working
> 
> Yep, the problem gram.y line is:
> 
>         | '-' a_expr %prec UMINUS
>                 {   $$ = makeA_Expr(OP, "-", NULL, $2);}
> 
> This is being executed rather than the code that reads in negative
> integer constants.

Yes. It's a problem because the scanner assigned types to integer and
floating point constants, but does not have a sense of context so the
negative sign must be stripped off since it could be in the middle of a
math expression. We will need to fix this in gram.y or by using the new
type conversion stuff farther back. But, I don't know how much new type
conversion capabilities there will be until I've tried to address most
of the pieces; still working out lingering problems in the function call
portion.

Will put this one on my list of things to look at.

                          - Tom

In response to

pgsql-hackers by date

Next:From: Zeugswetter Andreas SARZDate: 1998-03-30 12:20:42
Subject: AW: [HACKERS] Optimizer fails?
Previous:From: Thomas G. LockhartDate: 1998-03-30 06:32:49
Subject: Re: [HACKERS] Modules

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group