aboutsummaryrefslogtreecommitdiff
path: root/src
Commit message (Collapse)AuthorAge
...
* Make psql's \df display functions that return sets as having return typeTom Lane2002-10-19
| | | | | 'setof something'; formerly you could not tell at all that the function returns set.
* Invert logic in pg_exec_query_string() so that we set a snapshot forTom Lane2002-10-19
| | | | | | | all utility statement types *except* a short list, per discussion a few days ago. Add missing SetQuerySnapshot calls in VACUUM and REINDEX, and guard against calling REINDEX DATABASE from a function (has same problem as VACUUM).
* Fix rewrite code so that rules are in fact executed in order by name,Tom Lane2002-10-19
| | | | | | | | | | rather than being reordered according to INSTEAD attribute for implementation convenience. Also, increase compiled-in recursion depth limit from 10 to 100 rewrite cycles. 10 seems pretty marginal for situations where multiple rules exist for the same query. There was a complaint about this recently, so I'm going to bump it up. (Perhaps we should make the limit a GUC parameter, but that's too close to being a new feature to do in beta.)
* Back out Alvaro's patch until regression tests pass.Bruce Momjian2002-10-19
|
* Fix range-query estimation to not double-exclude NULLs, per gripe fromTom Lane2002-10-19
| | | | | | | | Ray Ontko 28-June-02. Also, fix prefix_selectivity for NAME lefthand variables (it was bogusly assuming binary compatibility), and adjust make_greater_string() to not call pg_mbcliplen() with invalid multibyte data (this last per bug report that I can't find at the moment, but it was in July '02).
* Fix compile failure caused by new patch.Bruce Momjian2002-10-19
|
* Remove mention of utils/getopt.c. Not used anymore.Bruce Momjian2002-10-19
|
* > Huh, I don't know where I got the idea you were (or someone else was?)Bruce Momjian2002-10-19
| | | | | | | | | | | | | | > in the position that attislocal should be reset. I'll clean everything > up and submit the patch I had originally made. All right, this is it. This patch merely checks if child tables have the column. If atttypid and atttypmod are the same, the attributes' attinhcount is incremented; else the operation is aborted. If child tables don't have the column, recursively add it. attislocal is not touched in any case. Alvaro Herrera
* This patch adds some missing functions for float8 math operations,Bruce Momjian2002-10-19
| | | | | | | | specifically ceil(), floor(), and sign(). There may be other functions that need to be added, but this is a start. I've included some simple regression tests. Neil Conway
* Make regression tests safe for autocommit = 'off'.Bruce Momjian2002-10-19
|
* Add missing #include <errno.h>.Tom Lane2002-10-19
|
* Fix psql's \copy to accept table names containing schemas, as well asTom Lane2002-10-19
| | | | | | | a column list. Bring its parsing of quoted names and quoted strings somewhat up to speed --- I believe it now handles all non-error cases the same way the backend would, but weird boundary conditions are not necessarily done the same way.
* Improve formatting of --help output.Peter Eisentraut2002-10-18
|
* Fix breakage that had crept into setlocale() usage: once again we'veTom Lane2002-10-18
| | | | | | been bit by the fact that the locale functions return pointers to modifiable variables. I added some comments that might help us avoid the mistake in future.
* Make 'dummy' declarations in header files be 'extern int no_such_variable'Tom Lane2002-10-18
| | | | | instead of 'extern int errno'; the latter is unsafe according to the ANSI C standard, as well as in practice on some platforms.
* Un-break createlang build.Tom Lane2002-10-18
|
* 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
generated by cgit v1.2.3 (git 2.25.1) at 2025-06-19 15:56:48 +0000