|Subject: [PATCH] adding SYS_TIME just for fun.
|
|Hi,
|
|Whilst I was playing round with the European dates patch I noticed the sysfunc()
|that allows you to do :-
|
|create table test ( da date);
|insert into test values (SYS_DATE);
|
|and have the current system date inserted.
|
|So I thought it would be nice to have the SYS_TIME facility too.
|
|I've cloned the function and changed a few things and there you have it,
|you can now do:
|
|create table test2 ( ti time);
|insert into test2 values (SYS_TIME);

Wrap it in an #ifndef to prevent this

from a #define to a run-time option '-e'

Man page was updated to reflect new option

be #ifdef'd into psql.c itself

From what I can tell, if USE_READLINE is true or false, psql works under
FreeBSD, without configure.  Now to test it *again* under sparc_solaris
with configure and see if it works...

Added a README.readline file until configure is integrated to *try* and
explain the way things stand.

Removed a stray configure .in file

Add some code to make psql happy with a system where there is *no*
history code available, but there is readline code...

history.h doesn't...previously, it was assumed that both existed, or
didn't exist...but this assumption fails on the one sparc_solaris box
that I have access to, and could exist in other circumstances

bug causes compilation to fail on alpha, the second causes a compiler
in this environment

to reflect what configure is going to define when the time comes

basis, as its only specific to certain OSs

Developers can add it to their Makefile.custom...again, it causes sooooo many
more problems then its worth, from an end-user standpoint.

See message to hackers@ mailing list concerning this...

Fixed them, and am re-committing

for switch over to configure

#if defined(aix)
#define TERMIOS_H_LOCATION <termios.h>
#else
#define TERMIOS_H_LOCATION <sys/termios.h>
#endif

libpq/fe-exec.c modified so that location of termios.h is determined
by whether HAVE_TERMIOS_H is defined or not, in preparation for switch
to configure

to be committed...

Cleaned out alot of the #define that can be auto-detect'd by
configure from config.h...

the ports section of Makefile.global as a result.

Right now, it only auto-detects FreeBSD, and the rest still get set
to UNDEFINED, but its a step in the right direction, no?

Autoconf bin/psql/Makefile

readline and associated libraries...

configure, thereby reducing the ports dependencies in it :)

in v6.0 does...