RE: [HACKERS] min() and max() causing aborts

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 .. failed
int4 .. failed
geometry .. failed
triggers .. 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(at)candle(dot)pha(dot)pa(dot)us]
Sent: Sunday, March 21, 1999 11:59 AM
To: tgl(at)sss(dot)pgh(dot)pa(dot)us
Cc: pgsql-hackers(at)postgreSQL(dot)org
Subject: 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
in
their tree. It should not be ther.

--
Bruce Momjian | http://www.op.net/~candle
maillist(at)candle(dot)pha(dot)pa(dot)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 >>