summaryrefslogtreecommitdiff
path: root/src
AgeCommit message (Collapse)Author
2002-10-19Make psql's \df display functions that return sets as having return typeTom Lane
'setof something'; formerly you could not tell at all that the function returns set.
2002-10-19Invert logic in pg_exec_query_string() so that we set a snapshot forTom Lane
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).
2002-10-19Fix rewrite code so that rules are in fact executed in order by name,Tom Lane
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.)
2002-10-19Back out Alvaro's patch until regression tests pass.Bruce Momjian
2002-10-19Fix range-query estimation to not double-exclude NULLs, per gripe fromTom Lane
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).
2002-10-19Fix compile failure caused by new patch.Bruce Momjian
2002-10-19Remove mention of utils/getopt.c. Not used anymore.Bruce Momjian
2002-10-19> Huh, I don't know where I got the idea you were (or someone else was?)Bruce Momjian
> 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
2002-10-19This patch adds some missing functions for float8 math operations,Bruce Momjian
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
2002-10-19Make regression tests safe for autocommit = 'off'.Bruce Momjian
2002-10-19Add missing #include <errno.h>.Tom Lane
2002-10-19Fix psql's \copy to accept table names containing schemas, as well asTom Lane
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.
2002-10-18Improve formatting of --help output.Peter Eisentraut
2002-10-18Fix breakage that had crept into setlocale() usage: once again we'veTom Lane
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.
2002-10-18Make 'dummy' declarations in header files be 'extern int no_such_variable'Tom Lane
instead of 'extern int errno'; the latter is unsafe according to the ANSI C standard, as well as in practice on some platforms.
2002-10-18Un-break createlang build.Tom Lane
2002-10-18Update /contrib for "autocommit TO 'on'".Bruce Momjian
Create objects in public schema. Make spacing/capitalization consistent. Remove transaction block use for object creation. Remove unneeded function GRANTs.
2002-10-17Fix in updateable result sets to handle binding null values correctlyBarry Lind
Patch submitted by Kris Jurka (applied with some modifications) Modified Files: jdbc/org/postgresql/jdbc2/AbstractJdbc2ResultSet.java
2002-10-17Fix free-slot search in PgSetResultId so it actually works.Tom Lane
2002-10-17Improve formatting of error message.Tom Lane
2002-10-17Fixed support in jdbc for 7.3 server autocommit. With these changes theBarry Lind
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
2002-10-16Make pg_dump save for autocommit = off.Bruce Momjian
2002-10-16Fix from Joe on timeout code.Bruce Momjian
2002-10-16Improve appearance of SET command.Bruce Momjian
2002-10-16Fix script to handle autocommit = 'off' by prepending autocommit 'on' toBruce Momjian
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.
2002-10-16Fix connection_timeout to use time() and handle timeout == 1.Bruce Momjian
Code cleanup.
2002-10-15Fix unintentional breakage of COPY TO/FROM stdin. Mea culpa.Tom Lane
2002-10-15Fix Linux dynloader code for pre-HAVE_DLOPEN systems, which evidentlyTom Lane
are still in use out there. Per report from Brendan LeFebvre.
2002-10-15Fix psql to cope with autocommit off, at least during startup.Tom Lane
Behavior of backslash commands (especially for large objects) may still require some thought.
2002-10-15Fix libpq startup code to work correctly in autocommit off mode.Tom Lane
In passing, fix breakage for case where PGCLIENTENCODING is set in environment.
2002-10-14Make SPI's execution of querystrings follow the rules agreed to forTom Lane
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.
2002-10-14Adjust handling of command status strings in the presence of rules,Tom Lane
as per recent pghackers discussions. initdb forced due to change in fields of stored Query nodes.
2002-10-14Add missing entries for bit<->int4 and bit<->int8 conversions.Tom Lane
2002-10-14Translation updatesPeter Eisentraut
2002-10-14Mention that resetting the timeout may be wrong on select retry.Bruce Momjian
2002-10-14Restore ptmp_timeout for cases where no timeout is passed.Bruce Momjian
2002-10-14libpq connection_timeout doesn't do subsecond timing, so make the codeBruce Momjian
clear on that point.
2002-10-14Arrange to copy relcache's trigdesc structure at the start of anyTom Lane
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.
2002-10-14As Niel so nicely pointed out this morning, the output of EXPLAINBruce Momjian
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
2002-10-14I have attached two patches as per:Bruce Momjian
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
2002-10-13Make SET really not start a transaction.Tom Lane
2002-10-13Make macaddr_in reject trailing garbage (except whitespace).Tom Lane
Per gripe from Patrick Welche, 13-Oct-2002.
2002-10-12psql thought that backslash is an escape character inside double quotes.Tom Lane
It isn't.
2002-10-12Fix for bug #795: two clauses that seem redundant are not really, ifTom Lane
one is pushed down into an outer join and the other is not.
2002-10-12Compute version number for docs on the fly.Peter Eisentraut
2002-10-11Add tv_sec change for connection timeout suggested by author.Bruce Momjian
2002-10-11Oops, back out newNode changes. We are not ready for that yet.Bruce Momjian
2002-10-11Prevent tv_sec from becoming negative in connection timeout code.Bruce Momjian
2002-10-09Lock on the rule relation wasn't removed after adding the comment.Bruce Momjian
Added Tom's patch fix for heap_close. Rod Taylor
2002-10-09> > > > and mb conversions (pg_ascii2mic and pg_mic2ascii notBruce Momjian
> > > > 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.46.0) at 2025-10-14 01:15:51 +0000