Re: [BUGS] Conversion errors for datetime fields

2001-01-01 Thread Bruce Momjian
> Looking at Page 166 of "SQL-99 Complete, Really" by Peter Gulutzan & > Trudy Peltzer, R&D Books, ISBN 0-87930-568-1, 1st bullet: That is a strange name for a book. :-) -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 853-3000 +

Re: [BUGS] AIX 4.3.1, 7.0.3 build annoyances: C++ comments, make all, macro problem

2001-01-01 Thread Tom Lane
"Travis W. Pouarz" <[EMAIL PROTECTED]> writes: > I loaded a pg_dumpall from a small 7.0.3 database into this 7.1 build > and ran a query and didn't observe anything out of the ordinary. Running the regression tests (src/test/regress) would be a more thorough test that things are working.

Re: [BUGS] AIX 4.3.1, 7.0.3 build annoyances: C++ comments, make all, macro problem

2001-01-01 Thread Travis W. Pouarz
On Fri, 29 Dec 2000, Tom Lane wrote: > [EMAIL PROTECTED] writes: > > AIX 4.3.1, 7.0.3 build annoyances: C++ comments, make all, macro problem > > I believe current sources (7.1-to-be) build cleanly on AIX, though I'm > not sure whether our main AIX beta tester checks ODBC very often. > Would yo

Re: [BUGS] Table corruption on drop

2001-01-01 Thread Tom Lane
"Robert A. Weiler" <[EMAIL PROTECTED]> writes: > [rotweiler@pss5 schema]$ psql < postgresql.sql > NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index 'domain_pkey' for table >'domain' > NOTICE: mdopen: couldn't open unique_id: No such file or directory > NOTICE: RelationIdBuildRelation

Re: [BUGS] update and tcl/tk

2001-01-01 Thread Tom Lane
[EMAIL PROTECTED] writes: > [ via libpgtcl, the given query updates no rows ] > If I update directly > set datestyle to 'postgres, european'; update cheque set ok='x' where num_cpte=8 and >date='09-11-2000' and nb_cheq=4919351 and lib like 'gynéco' and ok='' and deb=200.00 >and cred=0.0 > It's w

Re: [BUGS] vacuum analyze fails with latest cvs version

2001-01-01 Thread Tom Lane
Jukka Honkela <[EMAIL PROTECTED]> writes: > I didn't compile the thingy with --enable-debug, I can try with that > too, if required? Yes, please. Evidently it's dying while doing comparisons to determine the minimum and maximum values of one of the text columns. It'd be useful to try to determi

Re: [BUGS] vacuum analyze fails with latest cvs version

2001-01-01 Thread Tom Lane
[EMAIL PROTECTED] writes: > Problem 1: "vacuum messages;" works but "vacuum analyze messages;" > kills the backend. We have absolutely no hope of responding to a bug report with only that amount of information. How about a backtrace from the core file? How about telling us the schema for the ta