aboutsummaryrefslogtreecommitdiff
path: root/src
Commit message (Collapse)AuthorAge
...
* Update /contrib for "autocommit TO 'on'".Bruce Momjian2002-10-18
| | | | | | | | | | Create objects in public schema. Make spacing/capitalization consistent. Remove transaction block use for object creation. Remove unneeded function GRANTs.
* Fix in updateable result sets to handle binding null values correctlyBarry Lind2002-10-17
| | | | | | | Patch submitted by Kris Jurka (applied with some modifications) Modified Files: jdbc/org/postgresql/jdbc2/AbstractJdbc2ResultSet.java
* Fix free-slot search in PgSetResultId so it actually works.Tom Lane2002-10-17
|
* Improve formatting of error message.Tom Lane2002-10-17
|
* Fixed support in jdbc for 7.3 server autocommit. With these changes theBarry Lind2002-10-17
| | | | | | | | jdbc regression tests pass for both autocommit on and autocommit off Modified Files: jdbc/org/postgresql/jdbc1/AbstractJdbc1Connection.java jdbc/org/postgresql/test/jdbc2/ConnectionTest.java
* Make pg_dump save for autocommit = off.Bruce Momjian2002-10-16
|
* Fix from Joe on timeout code.Bruce Momjian2002-10-16
|
* Improve appearance of SET command.Bruce Momjian2002-10-16
|
* Fix script to handle autocommit = 'off' by prepending autocommit 'on' toBruce Momjian2002-10-16
| | | | | | the start of the psql commandline. This is better than adding BEGIN/END because it handles multiple queries well, and allows the return code for psql to return the proper value.
* Fix connection_timeout to use time() and handle timeout == 1.Bruce Momjian2002-10-16
| | | | Code cleanup.
* Fix unintentional breakage of COPY TO/FROM stdin. Mea culpa.Tom Lane2002-10-15
|
* Fix Linux dynloader code for pre-HAVE_DLOPEN systems, which evidentlyTom Lane2002-10-15
| | | | are still in use out there. Per report from Brendan LeFebvre.
* Fix psql to cope with autocommit off, at least during startup.Tom Lane2002-10-15
| | | | | Behavior of backslash commands (especially for large objects) may still require some thought.
* Fix libpq startup code to work correctly in autocommit off mode.Tom Lane2002-10-15
| | | | | In passing, fix breakage for case where PGCLIENTENCODING is set in environment.
* Make SPI's execution of querystrings follow the rules agreed to forTom Lane2002-10-14
| | | | | | | command status at the interactive level. SPI_processed, etc are set in the same way as the returned command status would have been set if the same querystring were issued interactively. Per gripe from Michael Paesold 25-Sep-02.
* Adjust handling of command status strings in the presence of rules,Tom Lane2002-10-14
| | | | | as per recent pghackers discussions. initdb forced due to change in fields of stored Query nodes.
* Add missing entries for bit<->int4 and bit<->int8 conversions.Tom Lane2002-10-14
|
* Translation updatesPeter Eisentraut2002-10-14
|
* Mention that resetting the timeout may be wrong on select retry.Bruce Momjian2002-10-14
|
* Restore ptmp_timeout for cases where no timeout is passed.Bruce Momjian2002-10-14
|
* libpq connection_timeout doesn't do subsecond timing, so make the codeBruce Momjian2002-10-14
| | | | clear on that point.
* Arrange to copy relcache's trigdesc structure at the start of anyTom Lane2002-10-14
| | | | | | | | | | | | query that uses it. This ensures that triggers will be applied consistently throughout a query even if someone commits changes to the relation's pg_class.reltriggers field meanwhile. Per crash report from Laurette Cisneros. While at it, simplify memory management in relcache.c, which no longer needs the old hack to try to keep trigger info in the same place over a relcache entry rebuild. (Should try to fix rd_att and rewrite-rule access similarly, someday.) And make RelationBuildTriggers simpler and more robust by making it build the trigdesc in working memory and then CopyTriggerDesc() into cache memory.
* As Niel so nicely pointed out this morning, the output of EXPLAINBruce Momjian2002-10-14
| | | | | | | | | | ANALYZE is not quite clear when branches of the query are never executed. So this tiny patch fixes that. The patch is attached and can also be found at: http://svana.org/kleptog/pgsql/pgsql-explain.patch Martijn van Oosterhout
* I have attached two patches as per:Bruce Momjian2002-10-14
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 1) pltcl: Add SPI_freetuptable() calls to avoid memory leaks (Me + Neil Conway) Change sprintf()s to snprintf()s (Neil Conway) Remove header files included elsewhere (Neil Conway) 2)plpython: Add SPI_freetuptable() calls to avoid memory leaks Cosemtic change to remove a compiler warning Notes: I have tested pltcl.c for a) the original leak problem reported for the repeated call of spi_exec in a TCL fragment and b) the subsequent report resulting from the use of spi_exec -array in a TCL fragment. The plpython.c patch is exactly the same as that applied to make revision 1.23, the plpython_schema.sql and feature.expected sections of the patch are also the same as last submited, applied and subsequently reversed out. It remains untested by me (other than via make check). However, this should be safe provided PyString_FromString() _copies_ the given string to make a PyObject. Nigel J. Andrews
* Make SET really not start a transaction.Tom Lane2002-10-13
|
* Make macaddr_in reject trailing garbage (except whitespace).Tom Lane2002-10-13
| | | | Per gripe from Patrick Welche, 13-Oct-2002.
* psql thought that backslash is an escape character inside double quotes.Tom Lane2002-10-12
| | | | It isn't.
* Fix for bug #795: two clauses that seem redundant are not really, ifTom Lane2002-10-12
| | | | one is pushed down into an outer join and the other is not.
* Compute version number for docs on the fly.Peter Eisentraut2002-10-12
|
* Add tv_sec change for connection timeout suggested by author.Bruce Momjian2002-10-11
|
* Oops, back out newNode changes. We are not ready for that yet.Bruce Momjian2002-10-11
|
* Prevent tv_sec from becoming negative in connection timeout code.Bruce Momjian2002-10-11
|
* Lock on the rule relation wasn't removed after adding the comment.Bruce Momjian2002-10-09
| | | | | | Added Tom's patch fix for heap_close. Rod Taylor
* > > > > and mb conversions (pg_ascii2mic and pg_mic2ascii notBruce Momjian2002-10-09
| | | | | | | | | | | | | | | | | | | | | | | | > > > > found in the postmaster and not included from elsewhere) > > > > shared libs on AIX need to be able to resolve all symbols at linkage time. > > Those two symbols are in backend/utils/SUBSYS.o but not in the postgres > > executable. > > They are defined in backend/utils/mb/conv.c and declared in > include/mb/pg_wchar.h. They're also linked into the > postmaster. I don't see anything unusual. Attached is a patch to fix the mb linking problems on AIX. As a nice side effect it reduces the duplicate symbol warnings to linking libpq.so and libecpg.so (all shlibs that are not postmaster loadable modules). Please apply to current (only affects AIX). The _LARGE_FILES problem is unfortunately still open, unless Peter has fixed it per his recent idea. Zeugswetter Andreas SB SD
* > Alvaro Herrera <alvherre@atentus.com> writes:Bruce Momjian2002-10-09
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | > > I'm looking at pg_dump/common.c:flagInhAttrs() and suspect that it can > > be more or less rewritten completely, and probably should to get rigth > > all the cases mentioned in the past attisinherited discussion. Is this > > desirable for 7.3? It can probably be hacked around and the rewrite > > kept for 7.4, but I think it will be much simpler after the rewrite. > > If it's a bug then it's fair game to fix in 7.3. But keep in mind that > pg_dump has to behave at least somewhat sanely when called against older > servers ... will your rewrite behave reasonably if the server does not > offer attinhcount values? Nah. I don't think it's worth it: I had forgotten that older versions should be supported. I just left the code as is and added a version-specific test. This patch allows pg_dump to dump correctly local definition of columns. In particular, CREATE TABLE p1 (f1 int, f2 int); CREATE TABLE p2 (f1 int); CREATE TABLE c () INHERITS (p1, p2); ALTER TABLE ONLY p1 DROP COLUMN f1; CREATE TABLE p3 (f1 int); CREATE TABLE c2 (f1 int) INHERITS (p3); Will be dumped as CREATE TABLE p1 (f2 int); CREATE TABLE p2 (f1 int); CREATE TABLE c (f1 int) INHERITS (p1, p2); CREATE TABLE c2 (f1 int) INHERITS (p3); (Previous version will dump CREATE TABLE c () INHERITS (p1, p2) CREATE TABLE c2 () INHERITS (p3) ) Alvaro Herrera
* Have SET not start transaction when autocommit off, with doc updates.Bruce Momjian2002-10-09
|
* Again improve MemSet comments.Bruce Momjian2002-10-08
|
* Update MemSet comments.Bruce Momjian2002-10-08
|
* Move responsibility for setting QuerySnapshot for utility statementsTom Lane2002-10-08
| | | | | | into postgres.c; make sure it happens for all cases that seem to need it. Perhaps it would be better to explicitly exclude just a few utility statement types from setting a snapshot?
* fixed missing apostropheDave Cramer2002-10-08
|
* Change order of operations during XLogFlush so that we try to includeTom Lane2002-10-07
| | | | | | | in our write/flush operation any WAL entries that got queued while we were waiting to get the WALWriteLock. This improves throughput when transactions are small enough that several can be committed per WAL write (ie, per disk revolution).
* Clarify comment.Bruce Momjian2002-10-06
|
* Restrict CREATE OPERATOR CLASS to superusers, per discussion some weeksTom Lane2002-10-04
| | | | ago.
* Require superuser privilege to create a binary-compatible cast, perTom Lane2002-10-04
| | | | | | discussion some weeks ago. Also, add a check that two types to be binary-equivalenced match as to typlen, typbyval, and typalign; if they don't then it's surely a mistake to equivalence them.
* Fix a couple of grammatical errors in error messages.Tom Lane2002-10-04
|
* Tweak a few of the most heavily used function call points to zero outTom Lane2002-10-04
| | | | | | | | | | just the significant fields of FunctionCallInfoData, rather than MemSet'ing the whole struct to zero. Unused positions in the arg[] array will thereby contain garbage rather than zeroes. This buys back some of the performance hit from increasing FUNC_MAX_ARGS. Also tweak tuplesort.c code for more speed by marking some routines 'inline'. All together these changes speed up simple sorts, like count(distinct int4column), by about 25% on a P4 running RH Linux 7.2.
* Hack to make it possible to load CREATE CONSTRAINT TRIGGER commands thatTom Lane2002-10-03
| | | | | are missing the FROM clause (due to a long-ago pg_dump bug). Patch by Stephan Szabo, minor tweaking by Tom Lane.
* In a bootstrap process or standalone backend, set MaxBackends = 1Tom Lane2002-10-03
| | | | to avoid unnecessary consumption of semaphores.
* Avoid palloc(0) when MaxBackends = 1.Tom Lane2002-10-03
|
* Restore NOTICEs that were mistakenly removed from triggers regressionTom Lane2002-10-03
| | | | | test expected output. Tweak contrib/spi Makefile so that refint.so is by default built with appropriate NOTICE support for regression testing.
generated by cgit v1.2.3 (git 2.25.1) at 2025-07-31 02:34:07 +0000