summaryrefslogtreecommitdiff
path: root/src
AgeCommit message (Collapse)Author
1999-12-29Update comment.Bruce Momjian
1999-12-29Update comments.Bruce Momjian
1999-12-28Removed LZTEXT datatype as discussed.Jan Wieck
Jan
1999-12-27Fix length limit, MikeABruce Momjian
1999-12-27Hi, all,Bruce Momjian
This is the patch for the final bit. Sorry that it's separate. Cheers... MikeA
1999-12-27Hi, allBruce Momjian
I finally got around to schlepping through pg_dump, to finish what I started about three months (or more) ago. Attached is a gzipped diff file to apply in the bin/pg_dump directory. This should remove all string length dependencies, except one, which I'm working on. It has been through some rudimentary unit testing, but that's about it, so if any of you would give it a more strenuous run-through, I'd be grateful for the feedback. Cheers... Ansley, Michael
1999-12-26Put back erroneously-removed definition of 'defines' variable.Tom Lane
1999-12-26It turns out that the item size limit for btree indexes is about BLCKSZ/3,Tom Lane
not BLCKSZ/2 as some of us thought. Add check for oversize item so that failure is detected before corrupting the index, not after.
1999-12-24Clean up handling of explicit NULL constants. Cases likeTom Lane
SELECT null::text; SELECT int4fac(null); work as expected now. In some cases a NULL must be surrounded by parentheses: SELECT 2 + null; fails SELECT 2 + (null); OK This is a grammatical ambiguity that seems difficult to avoid. Other than that, NULLs seem to behave about like you'd expect. The internal implementation is that NULL constants are typed as UNKNOWN (like untyped string constants) until the parser can deduce the right type.
1999-12-23*** empty log message ***Michael Meskes
1999-12-22Fix minor bug.Tatsuo Ishii
1999-12-22Add installtion of postmaster.opts.default.Tatsuo Ishii
1999-12-22Add installation of pg_ctlTatsuo Ishii
Locate path of postmaster in a portable way (stolen from initdb) Add postmaster.opts.default.sample which should be copied into $PGLIB in the installtion process. Also, it will be installed into $PGDATA while initdb is running.
1999-12-22to live in a transaction before access to dbHiroshi Inoue
during backend startup.
1999-12-21update_pg_pwd() is an AR trigger. Corrected return type.Jan Wieck
Jan
1999-12-21The first fix is to allow an input file with a relative path and withoutBruce Momjian
a ".pgc " extension. The second patch fixes a coredump when there is more than one input file (in that case, cur and types were not set to NULL before processing the second f ile) The patch below modifies the accepted grammar of ecpg to accept FETCH [direction] [amount] cursor name i.e. the IN|FROM clause becomes optional (as in Oracle and Informix). This removes the incompatibility mentioned in section "Porting From Other RDBMS Packages" p169, PostgreSQL Programmer's Guide. The grammar is modified in such a way as to avoid shift/reduce conflicts. It does not accept the statement "EXEC SQL FETCH;" anymore, as the old grammar did (this seems to be a bug of the old grammar anyway). This patch cleans up the handling of space characters in the scanner; some patte rns require \n to be in {space}, some do not. A second fix is the handling of cpp continuati on lines; the old pattern did not match these. The parser is patched to fix an off-by-one error in the #line directives. The pa rser is also enhanced to report the correct location of errors in declarations in the "E XEC SQL DECLARE SECTION". Finally, some right recursions in the parser were replaced by left-recursions. This patch adds preprocessor directives to ecpg; in particular EXEC SQL IFDEF, EXEC SQL IFNDEF, EXEC SQL ELSE, EXEC SQL ELIF and EXEC SQL ENDIF "EXEC SQL IFDEF" is used with defines made with "EXEC SQL DEFINE" and defines, specified on the command line with -D. Defines, specified on the command line are persistent across multiple input files. Defines can be nested up to a maximum level of 128 (see patch). There is a fair amount of error checking to make sure directives are matched properly. I need preprocessor directives for porting code, that is written for an Informix database, to a PostgreSQL database, while maintaining compatibility with the original code. I decided not to extend the already large ecpg grammar. Everything is done in the scanner by adding some states, e.g. to skip all input except newlines and directives. The preprocessor commands are compatible with Informix. Oracle uses a cpp replacement. Rene Hogendoorn
1999-12-21This patch will avoid SIGFPE on some geo functions , if PostgreSQL is compiledBruce Momjian
with DEC C. DEC C doesn't handle double values greater than DBL_MAX, but some PostgreSQL geo functions assign greater than DBL_MAX values to some vars in some special cases - that couses SIGFPE. I dunno if that is the only place to fix to work well with DEC C. Kirill Nosov.
1999-12-21autoconfBruce Momjian
1999-12-21Clean up qnx template finding.Bruce Momjian
1999-12-21Added empty TOASTER files and corrected some minor glitchesJan Wieck
in regression tests. Jan
1999-12-20tr cleanupBruce Momjian
1999-12-20Required catalog changes for extended LONG attribute storage.Jan Wieck
Jan
1999-12-20Cleanup of effective username test.Bruce Momjian
1999-12-20Finally found a platform which has finite() but nonetheless sets errnoTom Lane
rather than returning a NaN for bogus input to pow(). Namely, HPUX 10.20. I think this is sufficient evidence for what I thought all along, which is that the float.c code *must* look at errno whether finite() exists or not.
1999-12-20Clean up some minor gcc warnings.Tom Lane
1999-12-20Clean up some minor gcc warnings.Tom Lane
1999-12-20Clean up some minor gcc warnings. I'm not touching theTom Lane
major one, though, which is the truly ugly stores into libpq private storage. Can't you find a better way to do this?
1999-12-20Clean up some minor gcc warnings.Tom Lane
1999-12-20Whoever touched this code last doesn't seem to understandTom Lane
what a header file is for :-(
1999-12-20Avoid compiler warnings on systems that have snprintf and/or vsnprintfTom Lane
but do not bother to declare them in <stdio.h>. Seems to be a more common omission than you'd think...
1999-12-18Cleanup --alldb option handling.Bruce Momjian
1999-12-18Cleanup vacuumdbBruce Momjian
1999-12-18> > It would be nice for new users; I think it would make it easierBruce Momjian
> > for them to actually set out and do it. Many new users are > > of the not-so-knowledgable variety, and shell scripting isn't > > something they want to undertake. > > Can someone modify the vacuumdb shell script to do that? i tried it... it seems to work neko@kredit.sth.sz
1999-12-18Finally initdb.sh works. Was problem with assuming EUID was defined.Bruce Momjian
1999-12-18initdb cleanupBruce Momjian
1999-12-18initdb cleanupBruce Momjian
1999-12-18More initdb cleanupBruce Momjian
1999-12-18Cleanup of initdb.sh script to be portable, at least marginally.Bruce Momjian
1999-12-18Add cvs.Bruce Momjian
1999-12-17autoconfBruce Momjian
1999-12-17Lowercase $host for QNX.Bruce Momjian
1999-12-17Remove unused files.Bruce Momjian
1999-12-17Fix MULTIBYTE handling in string by using strcat.Bruce Momjian
1999-12-17Okay, this is how it looks: Please apply the attached patch to the currentJan Wieck
sources, otherwise this whole things fails anyway (fails to create the views). Peter Eisentraut Manually applied - Jan
1999-12-17Re-enable makeAttr() if ENABLE_OUTER_JOINS is defined.Thomas G. Lockhart
Somehow got bracketed with #ifdef NOT_USED instead.
1999-12-17ANother initdb cleanupBruce Momjian
1999-12-17Reverse out nextval patch.Bruce Momjian
1999-12-17initdb.sh fix from Peter.Bruce Momjian
1999-12-17This is my -- hopefully sufficiently portable -- attempt at cleaning outBruce Momjian
initdb. No more obscure dependencies on environment variables or paths. It now finds the templates and the right postgres itself (with cmd line options as fallback). It also no longer depends on $USER (su safe), and doesn't advertise that --username allows you to install the db as a different user, since that doesn't work anyway. Also, recovery and cleanup on all errors. Consistent options, clearer documentation. Please take a look at this and adopt it if you feel it's safe enough. I have simulated all the stupid circumstances I could think of, but you never know with shell scripts. Oh yeah, you can give the postgres user a default password now. -- Peter Eisentraut Sernanders väg 10:115
1999-12-16Clear paren level flag on \r or any backslash command, rather thanBruce Momjian
keeping parenlevel unchanged.