Min() and max() are now working, thank you. Create User causes the back end
to abort:
select * from pg_shadow; usename
|usesysid|usecreatedb|usetrace|usesuper|usecatupd|passwd|valuntil
--------+--------+-----------+--------+--------+---------+------+-----------
----------------- postgres| 501|t |t |t |t |
|Fri Jan 30 23:00:00 2037 MST (1 row)
create user kari;
ERROR: Bad abstime external representation ''
select * from pg_shadow;
NOTICE: (transaction aborted): queries ignored until END
*ABORT STATE*
Interesting to note that with 6.4.2 everything worked last night. This
morning, all ODBC client get a permission denied message. I can log using
psql but not with any ODBC client. The only change I made was installing a
new printer.
Still some regression test failures:
int2 .. failedint4 .. failedgeometry .. failedtriggers .. failed
I am not sure I have the cvs update thing correct. I had to cd into the
directory containing nodeAgg.c and do a cvs update to get this downloaded.
How come a cvs update from my pgsql/src directory did not pull all updated
sources?
Thanks, Michael
-----Original Message-----From: Bruce Momjian [SMTP:maillist@candle.pha.pa.us]Sent: Sunday, March 21, 1999 11:59
AMTo: tgl@sss.pgh.pa.usCc: pgsql-hackers@postgreSQL.orgSubject: Re: [HACKERS] min() and max() causing aborts
> Yesterday evening (after you partially backed out that patch) I
updated> and rebuilt and ran regression test. I didn't see any regress
failures> involving aggregates, and a quick hand smoke-test of max and min
looks> OK:
I am attaching the patch I BACKED HOW, so the user can see if it is
intheir tree. It should not be ther.
-- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610)
853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel
Hill,Pennsylvania
19026 << File: /wrk/tmp2/nodeAgg.c.diff >> << File: ATT26249.ATT >>