summaryrefslogtreecommitdiff
path: root/src
AgeCommit message (Collapse)Author
2000-02-14*** empty log message ***Michael Meskes
2000-02-13Adjusted psql echoing options (-a and -e)Peter Eisentraut
2000-02-13contrib-array.patchBruce Momjian
this is an old patch which I have already submitted and never seen in the sources. It corrects the datatype oids used in some iterator functions. This bug has been reported to me by many other people. contrib-datetime.patch some code contributed by Reiner Dassing <dassing@wettzell.ifag.de> contrib-makefiles.patch fixes all my contrib makefiles which don't work with some compilers, as reported to me by another user. contrib-miscutil.patch an old patch for one of my old contribs. contrib-string.patch a small change to the c-like text output functions. Now the '{' is escaped only at the beginning of the string to distinguish it from arrays, and the '}' is no more escaped. elog-lineno.patch adds the current lineno of CopyFrom to elog messages. This is very useful when you load a 1 million tuples table from an external file and there is a bad value somehere. Currently you get an error message but you can't know where is the bad data. The patch uses a variable which was declared static in copy.c. The variable is now exported and initialized to 0. It is always cleared at the end of the copy or at the first elog message or when the copy is canceled. I know this is very ugly but I can't find any better way of knowing where the copy fails and I have this problem quite often. plperl-makefile.patch fixes a typo in a makefile, but the error must be elsewhere because it is a file generated automatically. Please have a look. tprintf-timestamp.patch restores the original 2-digit year format, assuming that the two century digits don't carry much information and that '000202' is easier to read than 20000202. Being only a log file it shouldn't break anything. Please apply the patches before the next scheduled code freeze. I also noticed that some of the contribs don't compile correcly. Should we ask people to fix their code or rename their makefiles so that they are ignored by the top makefile? -- Massimo Dal Zotto
2000-02-132. trigger.c fails to compile due to a syntax error. It containsBruce Momjian
a switch statement that has an empty default label. A label of a switch statement must be followed by a statement (or a label which is followed by a statement (or a label which ...)). 3. Files include stringinfo.h failed to compile. The macro, 'appendStringInfoCharMacro' is implemented with a '?:' operation that returns a void expression for the true part and a char expresion for the false part. Both the true and false parts of the '?:' oper- ator must return the same type. Billy G. Allie
2000-02-10Default argument for createdbPeter Eisentraut
Changed EXIT_ON_ERROR to ON_ERROR_STOP in psql
2000-02-10Add btree indexing of boolean valuesBruce Momjian
Don Baccus
2000-02-10Improve default compile ops.Bruce Momjian
2000-02-10Add no CVS to make_mkid.Bruce Momjian
2000-02-10Prevent tags files in cvs directory.Bruce Momjian
2000-02-09Here is the patch to add plperl to droplang.Bruce Momjian
Mark Hollomon
2000-02-09I checked the WinNT port yesterday (a few days old snapshot from CVS) and IBruce Momjian
am including a patch to get it compile. changes to psql: - added less as default pager when compiling on Cygwin - need to declare "filename_completion_function" because it is not exported from readline -> added to include/port/win.h changes to pg_id: - include of <getopt.h> - add .exe when installing I think there is a problem with calling the regress tests on WinNT - it should be called with PORTNAME not HOST as the parameter to regress.sh or the check when to add "-h localhost" to psql has to be changed. Now it is checked against the PORTNAME. The results of the regress tests were OK with expected failures ;-) Daniel Horak
2000-02-09Enable backward sequential scan even after reaching EOF.Hiroshi Inoue
2000-02-09Fixed broken initdb --show patchPeter Eisentraut
2000-02-09Ooops ... 'char c' can hold a char, but it can't hold EOF ...Tom Lane
2000-02-08 yesterday I had a problem with initdb. I set bad environment valuesBruce Momjian
and initdb crashs (I set pglib path to PG 6.5.3 directory instead to 7.0 and initdb take this BKI old templates ... (initdb not check BKI version and BKI files not has any version comments (TODO?)) This patch add to the initdb --show option which show setting of all initdb's values. It spare developers time if in setting is bug. Karel ---------------------------------------------------------------------- Karel Zak <zakkr@zf.jcu.cz> http://home.zf.jcu.cz/~zakkr/
2000-02-08 I'm sending patch with new version of to_char numbers formatting.Bruce Momjian
The PostgreSQL's to_char() is very compatible with Oracle's to_char now. I hope that to_char's 3000 rows of source is without bugs, but will good if anyone test it, for me it works very well :-) Karel ---------------------------------------------------------------------- Karel Zak <zakkr@zf.jcu.cz> http://home.zf.jcu.cz/~zakkr/
2000-02-07Fixed psql double quoting of SQL idsPeter Eisentraut
Fixed libpq printing functions
2000-02-07Mask removal of network_ops in 7.0.Bruce Momjian
2000-02-07Enabled MATCH <unspecified>Jan Wieck
Jan
2000-02-07Added complete MATCH <unspecified> support contributed by Don Baccus.Jan Wieck
Jan
2000-02-07Disable/reenable triggers for data only dump.Jan Wieck
Jan
2000-02-07Repair planning bugs caused by my misguided removal of restrictinfo linkTom Lane
fields in JoinPaths --- turns out that we do need that after all :-(. Also, rearrange planner so that only one RelOptInfo is created for a particular set of joined base relations, no matter how many different subsets of relations it can be created from. This saves memory and processing time compared to the old method of making a bunch of RelOptInfos and then removing the duplicates. Clean up the jointree iteration logic; not sure if it's better, but I sure find it more readable and plausible now, particularly for the case of 'bushy plans'.
2000-02-07change copyright year 1999->2000Tatsuo Ishii
Minor fix
2000-02-07Allow SELECT .. FOR UPDATE in PL/pgSQL.Hiroshi Inoue
2000-02-07Remove ugly call ImmediateSharedRelationCacheInvalidate()Hiroshi Inoue
from md.c.
2000-02-06Removed special hack causing ON UPDATE NO ACTION trigger toJan Wieck
be suppressed. Jan
2000-02-06Solaris has always had problems with 1947 in theBruce Momjian
regression tests so I prepared a set of expected files to make things look OK. There's also a file to account for minor variations in the geopmetry output and a resultmap patch to pull them all together. With these changes PostgreSQL, from CVS, builds and regression tests (runcheck) cleanly. Keith Parks.
2000-02-06Rename same() to sameseti() to have a slightly less generic name. MoveTom Lane
nonoverlap_sets() and is_subset() to list.c, where they should have lived to begin with, and rename to nonoverlap_setsi and is_subseti since they only work on integer lists.
2000-02-06Fix a bug when specfying -D option.Tatsuo Ishii
fix suggested by Keith Parks.
2000-02-05Replace nth() calls in inner loops with traversal of the list viaTom Lane
lnext, to eliminate O(N^2) behavior with lots of indexquals.
2000-02-05Further cleanup for OR-of-AND WHERE-clauses. orindxpath can now handleTom Lane
extracting from an AND subclause just those opclauses that are relevant for a particular index. For example, we can now consider using an index on x to process WHERE (x = 1 AND y = 2) OR (x = 2 AND y = 4) OR ...
2000-02-05Change function name PQclientencoding to PQclientEncoding sinceTatsuo Ishii
it seems more suitable for the naming convention in libpq. New function PQsetClientEncoding added. It makes possible to change the client encoding on the fly without setting PGCLIENTENCODING.
2000-02-05Change function name PQclientencoding to PQclientEncoding sinceTatsuo Ishii
it seems more suitable for the naming convention in libpq.
2000-02-05Enabling automatic primary key detection for self-referencingJan Wieck
FOREIGN KEY constraint during CREATE TABLE. Tnx to Stephan. Jan
2000-02-04Small bugfix for DROP TABLE if table is self-referenced byJan Wieck
a FOREIGN KEY constraint. Jan
2000-02-04Added ALTER TABLE ... ADD CONSTRAINT (provided by Stephan Szabo).Jan Wieck
Added constraint dumping capability to pg_dump (also from Stephan) Fixed DROP TABLE -> RelationBuildTriggers: 2 record(s) not found for rel error. Fixed little error in gram.y I made the last days. Jan
2000-02-04Made prototypes for yyerror() consistent with Bruce's last changesJan Wieck
Jan
2000-02-04Squash longstanding memory leak: when catcache.c copied a tuple intoTom Lane
the cache context, it didn't bother to free the tuple that CatalogIndexFetchTuple had allocated in the transaction context. Do enough cache lookups in the same xact, and you start to notice...
2000-02-03Make EXPLAIN results for Append, Group, Agg, Unique nodes more plausible.Tom Lane
Group and Unique use an arbitrary assumption that there will be about 10% as many groups as input tuples --- perhaps someday we can refine this.
2000-02-03Repair relation refcount leakage caused by SELECT FOR UPDATE.Tom Lane
2000-02-02Inconsistency in CREATE CONSTRAINT TRIGGER with theJan Wieck
actions performed by analyse.c when creating table constraints. Jan
2000-02-02*** empty log message ***Peter Eisentraut
2000-01-31Fixed bug in NO ACTION trigger proc entries.Jan Wieck
Jan
2000-01-31Fix problems seen in parallel regress tests when SI buffer overruns (causingTom Lane
syscache and relcache flushes). Relcache entry rebuild now preserves original tupledesc, rewrite rules, and triggers if possible, so that pointers to these things remain valid --- if these things change while relcache entry has positive refcount, we elog(ERROR) to avoid later crash. Arrange for xact-local rels to be rebuilt when an SI inval message is seen for them, so that they are updated by CommandCounterIncrement the same as regular rels. (This is useful because of Hiroshi's recent changes to process our own SI messages at CommandCounterIncrement time.) This allows simplification of some routines that previously hacked around the lack of an automatic update. catcache now keeps its own copy of tupledesc for its relation, rather than depending on the relcache's copy; this avoids needing to reinitialize catcache during a cache flush, which saves some cycles and eliminates nasty circularity problems that occur if a cache flush happens while trying to initialize a catcache. Eliminate a number of permanent memory leaks that used to happen during catcache or relcache flush; not least of which was that catcache never freed any cached tuples! (Rule parsetree storage is still leaked, however; will fix that separately.) Nothing done yet about code that uses tuples retrieved by SearchSysCache for longer than is safe.
2000-01-31Hmm, equalfuncs didn't know about SortClause or GroupClauseTom Lane
nodes...
2000-01-30Added numeric and int8 types.Byron Nikolaidis
Bug fix for LongVarBinary -- begin transaction
2000-01-29Delete unused and long-dead header file.Tom Lane
2000-01-29Modify uses of RelationFlushRelation and RelationCacheInvalidate so thatTom Lane
we *always* rebuild, rather than deleting, an invalidated relcache entry that has positive refcount. Otherwise an SI cache overrun leads to dangling Relation pointers all over the place!
2000-01-29A few minor psql enhancementsPeter Eisentraut
Initdb help correction Changed end/abort to commit/rollback and changed related notices Commented out way old printing functions in libpq Fixed a typo in alter table / alter column
2000-01-29Attached is a uuencoded tarball that containsBruce Momjian
3 new files and two patches for the plperl subdir. These changes add the ability for plperl functions to call 'elog'. It also sets up the frame work to allow me to add access to the SPI functions. -- Mark Hollomon