From: | Michael J Davis <michael(dot)j(dot)davis(at)tvguide(dot)com> |
---|---|
To: | "'Thomas Lockhart'" <lockhart(at)alumni(dot)caltech(dot)edu>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-hackers(at)postgreSQL(dot)org |
Subject: | RE: [HACKERS] GROUP BY fixes committed |
Date: | 1999-05-03 17:57:01 |
Message-ID: | 93C04F1F5173D211A27900105AA8FCFC145466@lambic.prevuenet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
I believe the insert statement below worked in 6.5 as of early April (before
4/5). When I pulled new code toward the end of April it stopped working.
> -----Original Message-----
> From: Thomas Lockhart [SMTP:lockhart(at)alumni(dot)caltech(dot)edu]
> Sent: Monday, May 03, 1999 11:23 AM
> To: Tom Lane
> Cc: pgsql-hackers(at)postgreSQL(dot)org
> Subject: Re: [HACKERS] GROUP BY fixes committed
>
> > Also, the problem Michael Davis reported on 4/29 seems to be in the
> > parser:
> > insert into si_tmpVerifyAccountBalances select invoiceid+3, memberid, 1,
> > TotShippingHandling from InvoiceLineDetails where TotShippingHandling <>
> 0
> > and InvoiceLinesID <= 100 group by invoiceid+3, memberid,
> > TotShippingHandling;
> > ERROR: INSERT has more expressions than target columns
> > since that error message appears only in the parser. Thomas, did you
> > change anything recently in parsing of INSERT ... SELECT?
>
> Not that I know of. And I'm not sure what you mean by "recently". I've
> looked at the CVS logs but those don't help much because, especially
> for patches submitted by others, there is a generic description
> entered into the log which can't possibly describe the fixes in the
> particular file. *sigh*
>
> Anyway, I'd lost the thread. Did Michael say that this is a
> recently-introduced problem?
>
> - Tom
>
> --
> Thomas Lockhart lockhart(at)alumni(dot)caltech(dot)edu
> South Pasadena, California
From | Date | Subject | |
---|---|---|---|
Next Message | JT Kirkpatrick | 1999-05-03 18:03:19 | error message |
Previous Message | Oleg Bartunov | 1999-05-03 17:35:55 | adate::Date is equiv. to adate if adate is type of Date ? |