summaryrefslogtreecommitdiff
path: root/src
AgeCommit message (Collapse)Author
2000-05-15Fix createlang -l dbname so it works, update sgml.Bruce Momjian
2000-05-15*** empty log message ***Michael Meskes
2000-05-14That psql option should be --no-readline (as it used to be), not --noreadline.Peter Eisentraut
2000-05-14Finally fix LISTEN problem.Bruce Momjian
2000-05-14Fix create user for pgaccess.Bruce Momjian
2000-05-13Tweak selectivity for area-based operators. Still a crock...Tom Lane
2000-05-12Fix the off by one errors in ResultSet from 6.5.3, and more.Bruce Momjian
I'm including a diff of postgresql-7.0/src/interfaces/jdbc/org/postgresql/jdbc2/ResultSet.java. I've clearly marked all the fixes I did. Would *someone* who has access to the cvs please put this in? Joseph Shraibman
2000-05-12This is the second time I've answered this exact same problem in twoBruce Momjian
days. It seems to be a FAQ, and I think I know why. When creating a 'c' language function, CREATE FUNCTION is fed the shared object filename, and seems to succeed. Only when trying to use the function is an error thrown, by which time the coder thinks something's wrong with executing the code, not with loading it. I think I once saw it proposed to load shared objects at function creation time, but that idea was shot down on the grounds of resident memory bloat, ISTR. Here's a patch for a compromise: all it does is stat() the file, just like the loader code does, so that the errors caused by non existent files, and no directory 'x' permissions (the most common ones, it seems), get caught while the developer is still thinking about code loading. It doesn't catch all errors (like the code not being readable by the postgres user) but seems to catch the most common, without actually opening the file. What do you think? Ross
2000-05-12Back out -\?. Didn't look good to Peter.Bruce Momjian
2000-05-12/home/peter/commit-msgPeter Eisentraut
2000-05-12Squash some more CLUSTER bugs. Never has worked on multiple-columnTom Lane
indexes, apparently, nor on functional indexes with more than one input column (force of natts = 1 was in the wrong branch of IF statement). Coredumped if source relation contained any uncommitted tuples, due to failure to test for success return from heap_fetch. Fetched tuple was passed directly to heap_insert, which clobbers the TID and commit status in the tuple header it's given, which meant that the source relation's tuples all got trashed as the copy proceeded. Abort partway through, and you're left with a lot of missing tuples. I wonder what else is lurking here ...
2000-05-12this fixes the bug where setting the entry in he process table no longer worksMarc G. Fournier
under FreeBSD ... basically, if setproctitle() exists, use it ... the draw back right now is the PS_SET_STATUS stuff doesn't work, but am looking into that one right now ... at lesat now you can see who is connecting where and from where ...
2000-05-12Add two checks ... one for setproctitle and one for -lutil ...Marc G. Fournier
Don't do anything with them at this time, but am working on that ...
2000-05-12Repair list-vs-node confusion that resulted in failure for INNER JOIN ON.Tom Lane
Make it behave correctly when there are more than two tables being joined, also. Update regression test expected outputs.
2000-05-12Small cleanup of file.Bruce Momjian
2000-05-11More psql help cleanupBruce Momjian
2000-05-11Makefile CFLAGS cleanups.Bruce Momjian
2000-05-11Oops, plpgsql didn't have the datetime->timestamp and timespan->intervalBruce Momjian
mappings. In fact, it had them backward because it was using the 6.5.* code. Copied them from parser/gram.y, so it is fixed now. Looks like our first 7.0.1 fix. Oops, seems Tom has beat me to it as I was typing this.
2000-05-11Fix CLUSTER ... or at least undo the bit-rot it's suffered since 6.5.Tom Lane
It's still pretty fundamentally bogus :-(. Freebie side benefit: ALTER TABLE RENAME works on indexes now.
2000-05-11Display -? as -\? under unix for psql.Bruce Momjian
2000-05-11Add options and cleanup psql \? and -? help displaysBruce Momjian
2000-05-09Update psql \? to show file rather than "fname".Bruce Momjian
2000-05-05Forgot that dumpall's output script should 'delete from pg_group' beforeTom Lane
loading new data, for consistency with its handling of pg_shadow.
2000-05-05psql: suppress warnings about too many arguments if the command is not valid ↵Peter Eisentraut
in the first place
2000-05-05Spello SERIALIZED -> SERIALIZABLE in psql tab completionPeter Eisentraut
2000-05-05ImageViewer transaction fixesPeter Mount
2000-05-05Force initdb because of pg_group index fix.Tom Lane
2000-05-05Make the indexes on pg_group be shared system relations.Tom Lane
2000-05-05Accept pg_group as well as pg_shadow data from dumpall script.Tom Lane
Rearrange handling of VACUUMs so that they are certain to be executed as superuser not some random user; also, do not forget to vacuum template1 itself.
2000-05-05Dump contents of pg_group along with pg_shadow.Tom Lane
2000-05-04Don't leak a file descriptor when updating pg_pwd file. Also, check forTom Lane
failure of rename() call.
2000-05-03Do not try to build libpq++ if class 'string' is not defined in theTom Lane
available C++ header files.
2000-05-03Minor fixes ready for 7.0Peter Mount
2000-05-02Update SCO FAQ. Billy G. AllieBruce Momjian
2000-05-02Modify getdatabaseencoding(), pg_encoding_to_char()Tatsuo Ishii
pg_char_to_encoding() in multibyte disbaled case so that it does not throw an error, rather return HARD CODED default value (currently SQL_ASCII). This would solve the "non-mb backend vs. mb-enabled frontend" problem.
2000-04-30Reset CurrentMemoryContext to TopMemoryContext at the beginning of errorTom Lane
cleanup, ie, as soon as we have caught the longjmp. This ensures that current context will be a valid context throughout error cleanup. Before it was possible that current context was pointing at a context that would get deleted during cleanup, leaving any subsequent pallocs in deep trouble. I was able to provoke an Assert failure when compiled with asserts + -DCLOBBER_FREED_MEMORY, if I did something that would cause an error to be reported by the backend large-object code, because indeed that code operates in a context that gets deleted partway through xact abort --- and CurrentMemoryContext was still pointing at it! Boo hiss.
2000-04-30Remove bogus 'xid loop detected' check, which actually wasn't detectingTom Lane
loops, but just arbitrarily failing at 1000 locks.
2000-04-29Clean up ecpg test files.Bruce Momjian
2000-04-28Update pgeasy examplesBruce Momjian
2000-04-28Update libpgeasy define.Bruce Momjian
2000-04-28Change libpgeasy to take dbname at end like all other interfaces.Bruce Momjian
2000-04-28Setting statistic options from SET PG_OPTIONS caused a backend crashTom Lane
because StatFp never got set in that case. Set it immediately before use to eliminate such problems.
2000-04-28plpgsql RAISE statement was careless about the possibility of a NULLTom Lane
field value being displayed; produced coredump instead of the expected <NULL> display.
2000-04-27Except_Intersect_Rewrite() failed to ignore resjunk targetlist entries,Tom Lane
thus causing failure if one sub-select had resjunk entries that the other did not (cf. bug report from Espinosa 4/27/00).
2000-04-27Update libpgeasy e-mail addressBruce Momjian
2000-04-27Repair problem noted by Elphick: make_rels_by_joins failed to handleTom Lane
cases where joinclauses were present but some joins have to be made by cartesian-product join anyway. An example is SELECT * FROM a,b,c WHERE (a.f1 + b.f2 + c.f3) = 0; Even though all the rels have joinclauses, we must join two of them in cartesian style before we can use the join clause...
2000-04-27-D switch to postmaster should override any PGDATA environment variableTom Lane
that might be hanging about. Now it does ... amazing nobody noticed this before ...
2000-04-26Tweak outUnique to include uniqColIdx[] field in the printout. This doesTom Lane
not cause any compatibility problems because stored rules don't contain plan nodes --- in fact, we don't even have a readfunc for Unique nodes.
2000-04-26On HPUX, shl_load should be called with options BIND_IMMEDIATE ratherTom Lane
than BIND_DEFERRED. That way, if the loaded library has unresolved references, shl_load fails cleanly. As we had it, shl_load would succeed and then the dynlinker would call abort() when we try to call into the loaded library. abort()ing a backend is uncool.
2000-04-26Fix include "" to <>Bruce Momjian