summaryrefslogtreecommitdiff
path: root/src
AgeCommit message (Collapse)Author
2003-09-25Forget to update the real source of the regression test results afterPeter Eisentraut
message editing.
2003-09-25Message editing: remove gratuitous variations in message wording, standardizePeter Eisentraut
terms, add some clarifications, fix some untranslatable attempts at dynamic message building.
2003-09-24Fix creation of temporary sequences in ecpg, per report from Edmund Bacon.Bruce Momjian
2003-09-24Repair some REINDEX problems per recent discussions. The relcache isTom Lane
now able to cope with assigning new relfilenode values to nailed-in-cache indexes, so they can be reindexed using the fully crash-safe method. This leaves only shared system indexes as special cases. Remove the 'index deactivation' code, since it provides no useful protection in the shared- index case. Require reindexing of shared indexes to be done in standalone mode, but remove other restrictions on REINDEX. -P (IgnoreSystemIndexes) now prevents using indexes for lookups, but does not disable index updates. It is therefore safe to allow from PGOPTIONS. Upshot: reindexing system catalogs can be done without a standalone backend for all cases except shared catalogs.
2003-09-23Issue CREATE SCHEMA as the originally connecting user, with anTom Lane
AUTHORIZATION clause to specify the desired owner. This allows a superuser to restore schemas owned by users without CREATE-SCHEMA permissions (ie, schemas originally created by a superuser using AUTHORIZATION). --no-owner can be specified to suppress the AUTHORIZATION clause if need be.
2003-09-23pg_dump/pg_restore now always use SET SESSION AUTHORIZATION, not \connect,Tom Lane
to control object ownership. The use-set-session-authorization and no-reconnect switches are obsolete (still accepted on the command line, but they don't do anything). This is a precursor to fixing handling of CREATE SCHEMA, which will be a separate commit.
2003-09-23Tweak generic_type_consistency routines to avoid loss of functionalityTom Lane
since 7.3: 'select array_dims(histogram_bounds) from pg_stats' used to work and still should. Problem was that code wouldn't take input of declared type anyarray as matching an anyarray argument. Allow this case as long as we don't need to determine an element type (which in practice means as long as anyelement isn't used in the function signature).
2003-09-23_SPI_cursor_operation forgot to check for failure return fromTom Lane
_SPI_begin_call. Per gripe from Tomasz Myrta.
2003-09-23- Changed struct definition handling so "struct foo {}" always gets defined.Michael Meskes
2003-09-23Fix to properly handle timezone offsets that are partial hours. If the offsetBarry Lind
was a partial hour and less than gmt (i.e. -02:30) the code would corrupt the minutes part. Modified Files: jdbc/org/postgresql/jdbc1/AbstractJdbc1Statement.java
2003-09-23A fix for jdbc regression test submitted yesterday by Kim Ho at RedhatBarry Lind
Modified Files: ResultSetTest.java
2003-09-23Putting back the previous change must be the first thing.Hiroshi Inoue
ALso put back a #ifndef ENABLE_REINDEX_NAILED_RELATIONS which was removed about a year ago.
2003-09-22- Fixed order mismatch in processing "using" arguments.Michael Meskes
- Fixed some minor things in test cases. - Use defines for Informix error codes.
2003-09-22Additional jdbc regression tests submitted by Oliver Jowett. Some tests areBarry Lind
currently commented out, pending fixes for the bugs these tests uncovered. Modified Files: jdbc/org/postgresql/test/jdbc2/Jdbc2TestSuite.java jdbc/org/postgresql/test/jdbc2/ServerPreparedStmtTest.java Added Files: jdbc/org/postgresql/test/jdbc2/CursorFetchTest.java
2003-09-22Applied jdbc patch from Kim Ho at RedHat to improve boolean support, as wellBarry Lind
as some additional regression tests for this an other recent changes. Modified Files: jdbc/org/postgresql/jdbc1/AbstractJdbc1ResultSet.java jdbc/org/postgresql/test/jdbc2/DateTest.java jdbc/org/postgresql/test/jdbc2/ResultSetTest.java jdbc/org/postgresql/test/jdbc2/TimeTest.java jdbc/org/postgresql/test/jdbc2/TimestampTest.java
2003-09-22HeapTupleSatisfiesVacuum() needs to be more careful about theTom Lane
difference between INSERT_IN_PROGRESS and DELETE_IN_PROGRESS for tuples inserted and then deleted by a concurrent transaction. Example of bug: regression=# create table foo (f1 int); CREATE TABLE regression=# begin; BEGIN regression=# insert into foo values(1); INSERT 195531 1 regression=# delete from foo; DELETE 1 regression=# insert into foo values(1); INSERT 195532 1 regression=# create unique index fooi on foo(f1); ERROR: could not create unique index DETAIL: Table contains duplicated values.
2003-09-22Translation updatesPeter Eisentraut
2003-09-22Message wording improvementsPeter Eisentraut
2003-09-21Arrange to align shared disk buffers on at least 32-byte boundaries,Tom Lane
not just MAXALIGN boundaries. This makes a noticeable difference in the speed of transfers to and from kernel space, at least on recent Pentiums, and might help other CPUs too. We should look at making this happen for local buffers and buffile.c too. Patch from Manfred Spraul.
2003-09-21Fix some ill-considered ifdefs, per report from Hans-JÏrgen SchÎnig.Tom Lane
2003-09-20Apply ranlib(1) after installing a static (.a) library on Darwin.Tom Lane
Per past complaints --- verified to still be a problem on OS X 10.2.6.
2003-09-20Attaching -lpq to LDFLAGS doesn't work, because the generated commandTom Lane
puts that before the .c file name.
2003-09-20Fix a batch of speling misteaks identified by Peter's spell-checker tool.Tom Lane
2003-09-20- Renamed my own strndup() function because of a name clash.Michael Meskes
2003-09-20- Applied some bug fixing patches by Dave Cramer <dave@fastcrypt.com>.Michael Meskes
- Added protecting defines to include files.
2003-09-19pg_dump missed comments attached to primary key or unique constraintsTom Lane
(as distinct from their underlying indexes). Per bug report from Hiroshi Saito.
2003-09-19Disallow foreign-key references from temp tables to permanent tables.Tom Lane
Per recent discussion, this does not work because other backends can't reliably see tuples in a temp table and so cannot run the RI checks correctly. Seems better to disallow this case than go back to accessing temp tables through shared buffers. Also, disallow FK references to ON COMMIT DELETE ROWS tables. We already caught this problem for normal TRUNCATE, but the path used by ON COMMIT didn't check.
2003-09-19Latest version of gcc from Apple does not work well with -traditional-cppTom Lane
(it rejects some system header files...). Use -no-cpp-precomp instead. I think it is okay to change this unconditionally, but if we hear complaints from people still using very old compilers on Darwin, we could put in a test to see which switch the compiler likes.
2003-09-19Seems like a bad idea that REINDEX TABLE supports (or thinks it does)Tom Lane
reindexing system tables without ignoring system indexes, when the other two varieties of REINDEX disallow it. Make all three act the same, and simplify downstream code accordingly.
2003-09-19One small typo in preprocessor.Michael Meskes
2003-09-19Removed superfluous return statement in get_data.Michael Meskes
2003-09-18- Accept output variables for FETCH in DECLARE statement.Michael Meskes
- Synced parser. - Allowed C variables to carry the name of prepared statements. - Added Informix handling of datatype converion errors.
2003-09-18Applied patch from Oliver Jowett to clean up some instances where the wrongBarry Lind
type was being reported for PREPAREs. Modified Files: jdbc/org/postgresql/jdbc1/AbstractJdbc1Statement.java jdbc/org/postgresql/test/jdbc2/ServerPreparedStmtTest.java
2003-09-18Small jdbc patch from Kim Ho at RedHat to fix some boolean problemsBarry Lind
Modified Files: jdbc/org/postgresql/jdbc1/AbstractJdbc1ResultSet.java
2003-09-18A minor fix to jdbc regression testsBarry Lind
Modified Files: jdbc/org/postgresql/test/jdbc2/DatabaseMetaDataPropertiesTest.java
2003-09-17Disallow converting a table to a view if it has triggers, indexes, orTom Lane
child tables --- all cases that will trip various sanity checks elsewhere in the system, as well as cases that should not occur in the only intended use of this feature, namely coping with ancient pg_dump representation of views. Per bug report from Chris Pizzi.
2003-09-17Applied patch to jdbc from Kim Ho at RedHat, fixing improper handling of ↵Barry Lind
empty queries under the V3 protocol Modified Files: jdbc/org/postgresql/core/QueryExecutor.java
2003-09-17Applied patch for jdbc from Kim Ho at RedHat to more correctly deal with ↵Barry Lind
boolean values Modified Files: jdbc/org/postgresql/jdbc1/AbstractJdbc1ResultSet.java
2003-09-17Fixed jdbc to correctly report that constraints are supportedBarry Lind
Modified Files: jdbc/org/postgresql/jdbc1/AbstractJdbc1DatabaseMetaData.java
2003-09-17Applied patch from Fernando Nasser of RedHat to fix some error messagesBarry Lind
that would not get correctly looked up in the translation files for jdbc Modified Files: jdbc/org/postgresql/errors.properties jdbc/org/postgresql/jdbc2/AbstractJdbc2ResultSet.java
2003-09-17Applied patch from Kim Ho at redhat to improve boolean and bit handlingBarry Lind
in the jdbc driver Modified Files: jdbc/org/postgresql/jdbc1/AbstractJdbc1Statement.java jdbc/org/postgresql/jdbc3/AbstractJdbc3Statement.java
2003-09-17Fix typo in commentTatsuo Ishii
2003-09-16Make psql correctly track the effects of SET CLIENT_ENCODING commands.Tom Lane
I thought I'd fixed this earlier, but I didn't get it right ...
2003-09-16fix typo in a commentTatsuo Ishii
2003-09-16I don't care whether it's informix-compatible or not: #defining a wordTom Lane
like 'date' in a public header file is a damn fool idea.
2003-09-16Fix some problems with dropped columns in plpython trigger functions.Tom Lane
2003-09-16Since SPI_modifytuple's natts argument is the number of attributes to beTom Lane
changed, it should allow a zero value (implying no changes to make).
2003-09-15Fix LISTEN/NOTIFY race condition reported by Gavin Sherry. While aTom Lane
really general fix might be difficult, I believe the only case where AtCommit_Notify could see an uncommitted tuple is where the other guy has just unlistened and not yet committed. The best solution seems to be to just skip updating that tuple, on the assumption that the other guy does not want to hear about the notification anyway. This is not perfect --- if the other guy rolls back his unlisten instead of committing, then he really should have gotten this notify. But to do that, we'd have to wait to see if he commits or not, or make UNLISTEN hold exclusive lock on pg_listener until commit. Either of these answers is deadlock-prone, not to mention horrible for interactive performance. Do it this way for now. (What happened to that project to do LISTEN/NOTIFY in memory with no table, anyway?)
2003-09-15Update regression test for message change.Tom Lane
2003-09-15Improve a couple of error messages per suggestions from Alvaro Herrera.Tom Lane
generated by cgit v1.2.3 (git 2.46.0) at 2025-08-31 10:47:47 +0000