aboutsummaryrefslogtreecommitdiff
Commit message (Collapse)AuthorAge
* Add check of 'SET DateStyle TO DEFAULT'.Tom Lane2000-09-22
|
* Replace brain-dead Autoconf macros AC_ARG_{ENABLE,WITH} with somethingPeter Eisentraut2000-09-21
| | | | | | | that's actually useful, robust, consistent. Better plan to generate aclocal.m4 as well: use m4 include directives, rather than cat.
* *** empty log message ***Michael Meskes2000-09-21
|
* Fix coredump in copyCommentStmt().Tom Lane2000-09-20
|
* *** empty log message ***Michael Meskes2000-09-20
|
* Make sure that FlushRelationBuffers() is invoked by all paths throughTom Lane2000-09-19
| | | | vacuum.c. This is needed to make the world safe for pg_upgrade.
* Fix GEQO optimizer to work correctly with new outer-join-capableTom Lane2000-09-19
| | | | | | | query representation. Note that GEQO_RELS setting is now interpreted as the number of top-level items in the FROM list, not necessarily the number of relations in the query. This seems appropriate since we are only doing join-path searching over the top-level items.
* Implement differentiation between CURRENT_USER and SESSION_USER as per SQL.Peter Eisentraut2000-09-19
| | | | | | There is still no effective difference but it will kick in once setuid functions exist (not included here). Make old getpgusername() alias for current_user.
* *** empty log message ***Michael Meskes2000-09-19
|
* Make rule lister use aliases from FROM clause when a table column hasTom Lane2000-09-18
| | | | been given an alias. Otherwise, results are incorrect.
* Move contrib/odbc/odbc.sql together with odbc driver, remove old files;Peter Eisentraut2000-09-18
| | | | | revise ODBC "installation instructions"; update some other outdated documentation; update contrib documentation
* Only retrieve view definition if relation is a view (case statement)Philip Warner2000-09-18
|
* Uses column select expressions to get object object owners and tests for ↵Philip Warner2000-09-18
| | | | blank names
* Parse JOIN/ON conditions with the proper visibility of input columns,Tom Lane2000-09-17
| | | | | | | | ie, consider only the columns coming from the JOIN clause's sub-clauses. Also detect attempts to reference columns belonging to other tables (which would still be possible using an explicitly-qualified name). I'm not sure this implements the spec's semantics 100% accurately, but at least it gives plausible behavior.
* Add a blurb about what tools are required to build.Peter Eisentraut2000-09-17
|
* psql forgot to close connection before re-issuing password prompt.Peter Eisentraut2000-09-17
| | | | ([BUGS] psql can crash the backend on login, 2000-09-03)
* Improve error message for dumpRules() failureTom Lane2000-09-17
|
* Support for DESTDIR make variable. This is used as in `make installPeter Eisentraut2000-09-17
| | | | | | | | | | | | | | | | | | | | | | | | | | DESTDIR=/else/where' and prepends the value of DESTDIR to the full installation paths (e.g., /else/where/usr/local/pgsql/bin). This allows users to install the package into a location different from the one that was configured and hard-coded into various scripts, e.g., for creating binary packages. DESTDIR is in many cases preferrable over `make install prefix=/else/where' because a) `prefix' affects the path that is hard-coded into the files, which can lead to a `make install prefix=xxx' (as done by the regression test driver) corrupting the files in the source tree with wrong paths. b) it doesn't work at all if a directory was overridden to not depend on `prefix', e.g., --sysconfdir=/etc. (Updating the regression test driver to use DESTDIR is a separate undertaking.) See also autoconf@gnu.org, From: Akim Demaille <akim@epita.fr>, Date: 08 Sep 2000 12:48:59 +0200, Message-ID: <mv4em2vb1lw.fsf@nostromo.lrde.epita.fr>, Subject: Re: HTML format documentation.
* Add ILIKE operators ~~*, !~~* to documentation.Tom Lane2000-09-15
|
* Variant horology resultfiles are inconsistent with the test, again.Tom Lane2000-09-15
|
* Reimplement LIKE/ESCAPE as operators so that indexscan optimizationTom Lane2000-09-15
| | | | | can still work, per recent discussion on pghackers. Correct some bugs in ILIKE implementation.
* Allow PL/pgSQL accept non ascii identifiersTatsuo Ishii2000-09-15
|
* Minor code cleanup (cast away const-ness)Philip Warner2000-09-15
|
* - Support for relkind = RELKIND_VIEW.Philip Warner2000-09-15
| | | | | | | | | | | - Use symbols for tests on relkind (ie. use RELKIND_VIEW, not 'v') - Fix bug in support for -b option (== --blobs). - Dump views as views (using 'create view'). - Remove 'isViewRule' since we check the relkind when getting tables. - Now uses temp table 'pgdump_oid' rather than 'pg_dump_oid' (errors otherwise). - Added extra param for specifying handling of OID=0 and which typename to output. - Fixed bug in SQL scanner when SQL contained braces. (in rules) - Use format_type function wherever possible
* Move a few specific tests to isolate homogenous type tests intoThomas G. Lockhart2000-09-14
| | | | | | | | | regression tests for specific types, and move a few others to the cross-type "horology" test. Rearrange the test order slightly, and move the abstime test to the "parallel safe" area. Hand-patch the results for "1947" and for "solaris", so those may not be exactly correct.
* Add new FAQ's.Bruce Momjian2000-09-14
|
* rename README.CharsetsBruce Momjian2000-09-14
|
* typo fixBruce Momjian2000-09-12
|
* First cut at full support for OUTER JOINs. There are still a few looseTom Lane2000-09-12
| | | | | ends to clean up (see my message of same date to pghackers), but mostly it works. INITDB REQUIRED!
* typo fixBruce Momjian2000-09-12
|
* datatype -> data type.Bruce Momjian2000-09-12
|
* Fix relation-to-view conversion so that it doesn't try to convert a plainTom Lane2000-09-12
| | | | relation to a view when you create an ON INSERT/UPDATE/DELETE rule ...
* Update expected/horology-no-DST-before-1970.out for new horology test.Tom Lane2000-09-12
| | | | There are still two out-of-date variants for horology; shame shame.
* Clean up compiler warning.Tom Lane2000-09-12
|
* Suppress compile warnings caused by failure to use PG_RETURN macro.Tom Lane2000-09-12
|
* As if my JDBC patch hasn't already caused enough grief, there is now aBruce Momjian2000-09-12
| | | | | | | | | | | | | | one-line change necessary. Due to the Mark Holloman "New Relkind for Views" patch, my support for views in the driver will need to be updated to match. The change to DatabaseMetaData.getTableTypes[][] is as follows: - {"VIEW", "(relkind='r' and relhasrules='t' and relname !~ '^pg_' and relname !~ '^xinv')"}, + {"VIEW", "(relkind='v' and relname !~ '^pg_' and relname !~ '^xinv')"}, Christopher Cain
* Remove incorrect extra heap_close when deleting a builtin function.Tom Lane2000-09-12
|
* Update FAQ.Bruce Momjian2000-09-12
|
* Btree WAL records.Vadim B. Mikheev2000-09-12
|
* Add regression tests for date, time, and time with time zone types.Thomas G. Lockhart2000-09-12
| | | | | | Modify date->timestamp conversion to use mktime(). This should do better than before around Daylight Savings Time transitions.
* Modify date->timestamp conversion to use mktime().Thomas G. Lockhart2000-09-12
| | | | | This should do better than before around Daylight Savings Time transitions.
* Consolidate FAQ and README info on character sets into new chapter.Thomas G. Lockhart2000-09-12
|
* Update to refer to more recent stylesheets in my home directory.Thomas G. Lockhart2000-09-12
| | | | These stylesheets are pretty old, but the 15x series crashes FreeBSD jade.
* Clean up markup to be more correct.Thomas G. Lockhart2000-09-12
| | | | From "He Weiping (Laser Henry)" <laser@zhengmai.com.cn>.
* Fix inconsistancies in field names. From Tom Samplonius <tom@sdf.com>.Thomas G. Lockhart2000-09-12
|
* Attached is a patch that prevents a NullPointerException in the JDBCBruce Momjian2000-09-12
| | | | | | | | | | | | driver if the translations files have not been properly installed. (We carefully avoided installing the translations file in a controlled environment here specifically to test for such a bug. :-) See attached description for more details. William -- William Webber william@peopleweb.net.au
* This patch implements the following command:Bruce Momjian2000-09-12
| | | | | | | | | | ALTER TABLE <tablename> OWNER TO <username> Only a superuser may execute the command. -- Mark Hollomon mhh@mindspring.com
* Attached are a patch to allow the charset encoding used by the JDBCBruce Momjian2000-09-12
| | | | | | | | | driver to be set, and a description of said patch. Please refer to the latter for more information. William -- William Webber william@peopleweb.net.au
* Applied to jdbc1 and jdbc2.Bruce Momjian2000-09-12
| | | | | | | | | | | This is a patch which lets the DatabaseMetaData return the object type when getTables(....) is called. It does not really fix any bug, but it fills in some functionality that should be there anyway. The diff included here is off of the CVS as of just now :) ---------------------------------------------------------------- Travis Bauer | CS Grad Student | IU |www.cs.indiana.edu/~trbauer ----------------------------------------------------------------
* This patch implements a different "relkind"Bruce Momjian2000-09-12
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | for views. Views are now have a "relkind" of RELKIND_VIEW instead of RELKIND_RELATION. Also, views no longer have actual heap storage files. The following changes were made 1. CREATE VIEW sets the new relkind 2. The executor complains if a DELETE or INSERT references a view. 3. DROP RULE complains if an attempt is made to delete a view SELECT rule. 4. CREATE RULE "_RETmytable" AS ON SELECT TO mytable DO INSTEAD ... 1. checks to make sure mytable is empty. 2. sets the relkind to RELKIND_VIEW. 3. deletes the heap storage files. 5. LOCK myview is not allowed. :) 6. the regression test type_sanity was changed to account for the new relkind value. 7. CREATE INDEX ON myview ... is not allowed. 8. VACUUM myview is not allowed. VACUUM automatically skips views when do the entire database. 9. TRUNCATE myview is not allowed. THINGS LEFT TO THINK ABOUT o pg_views o pg_dump o pgsql (\d \dv) o Do we really want to be able to inherit from views? o Is 'DROP TABLE myview' OK? -- Mark Hollomon
generated by cgit v1.2.3 (git 2.25.1) at 2025-07-16 01:02:28 +0000