- 25 Sep, 2003 2 commits
-
-
Peter Eisentraut authored
terms, add some clarifications, fix some untranslatable attempts at dynamic message building.
-
Bruce Momjian authored
-
- 24 Sep, 2003 6 commits
-
-
Bruce Momjian authored
-
Tom Lane authored
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.
-
Marc G. Fournier authored
another totally benign, test commit
-
Marc G. Fournier authored
test 2, benign, no change
-
Marc G. Fournier authored
not change, just added a space to test something
-
Tom Lane authored
Christopher Kings-Lynne. Also fix a couple more schema-awareness issues.
-
- 23 Sep, 2003 11 commits
-
-
Tom Lane authored
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.
-
Tom Lane authored
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.
-
Bruce Momjian authored
> * Allow LISTEN/NOTIFY to store info in memory rather than tables
-
Bruce Momjian authored
* Allow major upgrades without dump/reload, perhaps using pg_upgrade
-
Tom Lane authored
-
Tom Lane authored
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).
-
Tom Lane authored
_SPI_begin_call. Per gripe from Tomasz Myrta.
-
Michael Meskes authored
-
Barry Lind authored
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
-
Barry Lind authored
Modified Files: ResultSetTest.java
-
Hiroshi Inoue authored
ALso put back a #ifndef ENABLE_REINDEX_NAILED_RELATIONS which was removed about a year ago.
-
- 22 Sep, 2003 8 commits
-
-
Teodor Sigaev authored
The 'word' variable there is initialised from the prs->words array, but immediately after, that array may be reallocated, thus leaving word pointing to unallocated memory.
-
Michael Meskes authored
- Fixed some minor things in test cases. - Use defines for Informix error codes.
-
Barry Lind authored
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
-
Barry Lind authored
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
-
Tom Lane authored
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.
-
Peter Eisentraut authored
-
Peter Eisentraut authored
-
Peter Eisentraut authored
-
- 21 Sep, 2003 2 commits
-
-
Tom Lane authored
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.
-
Tom Lane authored
-
- 20 Sep, 2003 5 commits
-
-
Tom Lane authored
Per past complaints --- verified to still be a problem on OS X 10.2.6.
-
Tom Lane authored
puts that before the .c file name.
-
Tom Lane authored
-
Michael Meskes authored
-
Michael Meskes authored
- Added protecting defines to include files.
-
- 19 Sep, 2003 6 commits
-
-
Tom Lane authored
(as distinct from their underlying indexes). Per bug report from Hiroshi Saito.
-
Tom Lane authored
-
Tom Lane authored
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.
-
Tom Lane authored
(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.
-
Tom Lane authored
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.
-
Michael Meskes authored
-