[GENERAL] to_char(date '2001-04-01', 'dd') results in 31 -- why?

2001-01-14 Thread Fred Yankowski
risons in a WHERE clause between 'date' and 'timestamp' values? I have a case where I want to select all calendar events whose date is the current date or later. The date of the calendar item/row is given by a daStart column of type 'date', and I've been doing

[GENERAL] Re: Unknown Type 'ame' [urgent]

2001-01-16 Thread Fred Yankowski
following error: > "ERROR: Error: unknown type 'ame'." still with this version. Clearly > something is wrong. Does anyone have any ideas? -- Fred Yankowski [EMAIL PROTECTED] tel: +1.630.879.1312 Principal Consultant www.OntoSys.com fax: +1.630.

[GENERAL] Re: Unknown Type 'ame' [urgent]

2001-01-16 Thread Fred Yankowski
I see that the genbki.sh file in backend/catalog has some sed strings like these: -e "s/[ ]NameData/\ name/g" \ -e "s/^NameData/\name/g" \ Those look bogus to me. I wonder if that '\n' becomes newline for some versions of shell and/or sed? -- F

[GENERAL] no more regression test errors on NT with latest CVS version

2001-01-20 Thread Fred Yankowski
configuration that caused the regression test data files to be interpreted in 'textmode', thereby causing spurious differences. -- Fred Yankowski [EMAIL PROTECTED] tel: +1.630.879.1312 Principal Consultant www.OntoSys.com fax: +1.630.879.1370 OntoSys, Inc 38W24

[GENERAL] Re: CygIPC 1.08 Source Code : Where ?

2001-02-03 Thread Fred Yankowski
http://www.neuro.gatech.edu/users/cwilson/cygutils/V1.1/cygipc/index.html -- Fred Yankowski [EMAIL PROTECTED] tel: +1.630.879.1312 Principal Consultant www.OntoSys.com fax: +1.630.879.1370 OntoSys, Inc 38W242 Deerpath Rd, Batavia, IL 60510, USA

[GENERAL] Re: startup Postgres on NT

2001-02-06 Thread Fred Yankowski
ipc-daemon so that it can install and run itself directly as an NT service. I've also thought about hacking postgres to run directly as an NT service, but that plan got only a tepid response when I proposed it to the 'hackers' list, so I'm shelving it for now. -- Fred Ya

[GENERAL] Re: startup Postgres on NT

2001-02-12 Thread Fred Yankowski
d .bashrc files won't apply to the service since it isn't run in the context of bash/sh. The Cygwin /usr/bin (or /bin) folder should be in PATH too so that postmaster/postgres can call system() on utilities like 'rm' and 'cp'. -- Fred Yankowski [EMAIL P

[GENERAL] Re: Error by starting postmaster

2001-02-15 Thread Fred Yankowski
\usr\local\pgsql\bin\postgres.exe: *** > recreate_mmaps_after_fork_failed -- Fred Yankowski [EMAIL PROTECTED] tel: +1.630.879.1312 Principal Consultant www.OntoSys.com fax: +1.630.879.1370 OntoSys, Inc 38W242 Deerpath Rd, Batavia, IL 60510, USA