aboutsummaryrefslogtreecommitdiff
Commit message (Collapse)AuthorAge
* O.K. -Bruce Momjian2000-09-12
| | | | | | | | | | | | | | | | | | | Here's the multibyte aware version of my patch to fix the truncation of the rulename autogenerated during a CREATE VIEW. I've modified all the places in the backend that want to construct the rulename to use the MakeRetrieveViewRuleName(), where I put the #ifdef MULTIBYTE, so that's the only place that knows how to construct a view rulename. Except pg_dump, where I replicated the code, since it's a standalone binary. The only effect the enduser will see is that views with names len(name) > NAMEDATALEN-4 will fail to be created, if the derived rulename clases with an existing rule: i.e. the user is trying to create two views with long names whose first difference is past NAMEDATALEN-4 (but before NAMEDATALEN: that'll error out after the viewname truncation.) In no case will the user get left with a table without a view rule, as the current code does. Ross Reedstrom
* Irix fix:Bruce Momjian2000-09-12
| | | | | | | | | | | | | The regression tests abstime, horology, int2, int4, and tinterval fail by default. They will pass if comparison is made to one of the variant expected/*.out files. (A related problem is that the geometry test fails. This seems to be just a matter of FP precision but more rigorous inspection is needed. No existing expected/geometry-*.out variant matches.) Pete Forman
* Define ZIP rather than GZIP.Thomas G. Lockhart2000-09-12
| | | | Define ZIPSUFFIX to allow substitution of something other than gzip.
* This is temporal place holder for Relation File Node tillVadim B. Mikheev2000-09-10
| | | | reloid.version/unique_id file naming is not implemented
* Update FAQ.Bruce Momjian2000-09-08
|
* Make building scripts kind of consistent in look and feel, kind of immunePeter Eisentraut2000-09-08
| | | | to parallel make, kind of resistent to corruption due to incomplete builds.
* Heap redo/undo (except for tuple moving used by vacuum).Vadim B. Mikheev2000-09-07
|
* Fix psql crash. If MULTIBYTE is enabled, \l+ dumps core due toTatsuo Ishii2000-09-07
| | | | SQL buffer in listAllDbs is just too small.
* A bit of cleanup after SSL patch. Add it to config file, improvePeter Eisentraut2000-09-06
| | | | documentation.
* Code cleanup of user name and user id handling in the backend. The currentPeter Eisentraut2000-09-06
| | | | | | | | | | | user is now defined in terms of the user id, the user name is only computed upon request (for display purposes). This is kind of the opposite of the previous state, which would maintain the user name and compute the user id for permission checks. Besides perhaps saving a few cycles (integer vs string), this now creates a single point of attack for changing the user id during a connection, for purposes of "setuid" functions, etc.
* Added functionsJan Wieck2000-09-05
| | | | | | | | | | | quote_ident(text) returns text quote_literal(text) returns text These are handy to build up properly quoted query strings for the new PL/pgSQL EXECUTE functionality to submit dynamic DDL statements. Jan
* GZIP vs ZIP variable naming messed upPeter Eisentraut2000-09-05
|
* GET DIAGNOSTICS statement to PL/pgSQL to access SPI_processedJan Wieck2000-09-05
| | | | | | and SPI_return values. Patch from Philip Warner. Jan
* Change initdb to not delete PGDATA directory unless it was created byPeter Eisentraut2000-09-01
| | | | initdb itself. Refuse to run on existing but non-empty PGDATA directory.
* Fix relative path references so that make knowns which dependencies referPeter Eisentraut2000-08-31
| | | | | to one another. Sort out builddir vs srcdir variable namings. Remove some now obsoleted make variables.
* Added EXECUTE command to PL/pgSQL for execution ofJan Wieck2000-08-31
| | | | | | dynamic SQL and utility statements. Jan
* AbortOutOfAnyTransaction() just before backend exit, to ensure thatTom Lane2000-08-30
| | | | | resources are cleaned up if the user disconnected mid-transaction. Great thanks to Hiroshi for pointing out what should have been obvious...
* SSL patch from MagnusBruce Momjian2000-08-30
|
* Improve the following.Hiroshi Inoue2000-08-30
| | | | | | | | | | | | | | | | | | | | | =# create table t (id int4 unique); NOTICE: CREATE TABLE/UNIQUE will create implicit index 't_id_key' for table 't' =# begin; query: drop table t; NOTICE: Caution: DROP TABLE cannot be rolled back, so don't abort now NOTICE: Caution: DROP INDEX cannot be rolled back, so don't abort now =# rollback; =# drop table t; NOTICE: mdopen: couldn't open t: No such file or directory NOTICE: RelationIdBuildRelation: smgropen(t): No such file or directory NOTICE: mdopen: couldn't open t: No such file or directory NOTICE: mdopen: couldn't open t: No such file or directory NOTICE: mdopen: couldn't open t_id_key: No such file or directory NOTICE: RelationIdBuildRelation: smgropen(t_id_key): No such file or directory NOTICE: mdopen: couldn't open t: No such file or directory NOTICE: RelationIdBuildRelation: smgropen(t): No such file or directory NOTICE: mdopen: couldn't open t: No such file or directory ERROR: cannot open relation t
* Startup is actually start-up.Bruce Momjian2000-08-29
|
* Include kernel error message in failed-to-open file reports.Tom Lane2000-08-29
|
* Revert removal of signed, volatile, and signal handler arg type tests.Peter Eisentraut2000-08-29
|
* * to_char:Bruce Momjian2000-08-29
| | | | | | | | | | | | | | | | | | | | | | | - full support for IW (ISO week) and vice versa conversion for IW too (the to_char 'week' support is now complete and I hope correct). Thomas, I use for IW code from timestamp.c, for this I create separate function date2isoweek() from original 'case DTK_WEEK:' code in the timestamp_part(). I mean will better use one code for same feature in date_part() and in to_char(). The isoweek2date() is added to timestamp.c too. Right? IMHO in 7.1 will all to_char's features complete. It is cca 41 templates for date/time and cca 21 for numbers. * to_ascii: - gcc, is it correct now? :-) In the patch is documentation for to_char's IW and for to_ascii(). Karel
* This is mostly the same as an earlier patch IBruce Momjian2000-08-29
| | | | | | | | | | | | | | | | | | | didn't hear anything about, but which would have broken with the function manager changes anyway. Well, this patch checks that a unique constraint of some form (unique or pk) is on the referenced columns of an FK constraint and that the columns in the referencing table exist at creation time. The former is to move closer to SQL compatibility and the latter is in answer to a bug report. I also added a basic check of this functionality to the alter table and foreign key regression tests. Stephan Szabo sszabo@bigpanda.com
* Here is a patch against the same cvs tree as the SSL patch (Aug 20).Bruce Momjian2000-08-29
| | | | | | | | | | | | | | | | I hope I didn't mess the SGML up too bad, but somebody should definitly look that over. I tried to steal as much as I could from around :-) This patch updates: * Installation instructions (paragraph on how to compile with openssl) * Documentation of pg_hba.conf (added "hostssl" record docs) * Libpq documentation (added connection option, documentation of PQgetssl() function) * Add section on SSL to "Server Runtime Environment" If you beleive any particular area needs more attention, please let me know. //Magnus
* Update obsolete comments.Tom Lane2000-08-29
|
* Remove bogus use of int4out().Tom Lane2000-08-29
|
* Maybe "shared_buffers" is a slightly better name than "shmem_buffers" for -B.Peter Eisentraut2000-08-28
|
* New configure test for flex, which recognizes only flex but does so in allPeter Eisentraut2000-08-28
| | | | | | incarnations (I hope). When an acceptable flex version is not found, print instructive error messages from both configure and the makefiles, so that users can continue building anyway.
* Clean up callers of AllocateFile and BasicOpenFile to ensure thatTom Lane2000-08-27
| | | | | a reasonable error message (including the kernel errno message) is reported on any file open failure.
* Change ReleaseLruFile() usage so that if we cannot release any moreTom Lane2000-08-27
| | | | | | virtual FDs, we just return the ENFILE/EMFILE error to the caller, rather than immediate elog(). This allows more robust behavior in the postmaster, which uses AllocateFile() but does not want elog().
* Update FAQ.Bruce Momjian2000-08-27
|
* Remove configure tests for `signed', `volatile', and signal handler args;Peter Eisentraut2000-08-27
| | | | the harm potential outweighs the possible benefits.
* Change pg_mblen and pg_encoding_mblen return types from voidTatsuo Ishii2000-08-27
| | | | to int so that they return the number of whcars.
* Update FAQ.Bruce Momjian2000-08-27
|
* Tired of seeing these warnings ...Tom Lane2000-08-26
|
* Rename BITSPERBYTE to BITS_PER_BYTE to avoid conflict with <values.h>Tom Lane2000-08-26
| | | | on some platforms.
* Fix AC_FUNC_ACCEPT_ARGTYPES to accept `const struct sockaddr *' as secondPeter Eisentraut2000-08-26
| | | | | | argument, change the order of tests for the third argument to be safe against missing prototypes, and make it fail hard if none of the combinations succeed.
* This file seems not to have been updated for the mostTom Lane2000-08-26
| | | | recent change to geometry.sql.
* Update platform FAQsPeter Eisentraut2000-08-26
|
* Remove old FAQ files.Bruce Momjian2000-08-26
|
* Update FAQ.Bruce Momjian2000-08-26
|
* Add pg-config utility that stores some configuration parameters otherPeter Eisentraut2000-08-26
| | | | | | | | | | packages can use to configure their build. E.g., $ pg-config --libdir /usr/local/pgsql/lib `pg-config --configure' stores the configure command line.
* Tweak btree insertion to avoid O(N^2) slowdown with large numbers ofTom Lane2000-08-25
| | | | equal keys. See discussion of today's date in pghackers list.
* Avoid creating a TOAST table if we can prove that the maximum tupleTom Lane2000-08-25
| | | | | | | length is < TOAST_TUPLE_THRESHOLD, even with toastable column types present. For example, CREATE TABLE foo (f1 int, f2 varchar(100)) does not require a toast table, even though varchar is a toastable type.
* Fix typos and inconsistancies found by He WeipingThomas G. Lockhart2000-08-25
| | | | | | (aka Henry) <laser@zhangmai.com.cn>. Fix new problems in insert.sgml and create_function.sgml which kept jade from completing.
* Change return type of:Tatsuo Ishii2000-08-25
| | | | | | | pg_mb2wchar(const unsigned char *, pg_wchar *); pg_mb2wchar_with_len(const unsigned char *, pg_wchar *, int); from void to int. Now they return the number of wide chars.
* Make the location of the Kerberos server key file run time configurablePeter Eisentraut2000-08-25
| | | | | | | | | (rather than compile time). For libpq, even when Kerberos support is compiled in, the default user name should still fall back to geteuid() if it can't be determined via the Kerberos system. A couple of fixes for string type configuration parameters, now that there is one.
* Documentation updates to reflect TOAST and new-style fmgr.Tom Lane2000-08-24
|
* Documentation updates to reflect TOAST and new-style fmgr.Tom Lane2000-08-24
|
generated by cgit v1.2.3 (git 2.25.1) at 2025-06-02 23:12:08 +0000