- 13 9月, 2000 7 次提交
-
-
由 Bruce Momjian 提交于
-
由 Tom Lane 提交于
relation to a view when you create an ON INSERT/UPDATE/DELETE rule ...
-
由 Tom Lane 提交于
There are still two out-of-date variants for horology; shame shame.
-
由 Tom Lane 提交于
-
由 Tom Lane 提交于
-
由 Bruce Momjian 提交于
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
-
由 Tom Lane 提交于
-
- 12 9月, 2000 22 次提交
-
-
由 Bruce Momjian 提交于
-
由 Vadim B. Mikheev 提交于
-
由 Thomas G. Lockhart 提交于
Modify date->timestamp conversion to use mktime(). This should do better than before around Daylight Savings Time transitions.
-
由 Thomas G. Lockhart 提交于
This should do better than before around Daylight Savings Time transitions.
-
由 Thomas G. Lockhart 提交于
-
由 Thomas G. Lockhart 提交于
These stylesheets are pretty old, but the 15x series crashes FreeBSD jade.
-
由 Thomas G. Lockhart 提交于
From "He Weiping (Laser Henry)" <laser@zhengmai.com.cn>.
-
由 Thomas G. Lockhart 提交于
-
由 Bruce Momjian 提交于
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
-
由 Bruce Momjian 提交于
ALTER TABLE <tablename> OWNER TO <username> Only a superuser may execute the command. -- Mark Hollomon mhh@mindspring.com
-
由 Bruce Momjian 提交于
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
-
由 Bruce Momjian 提交于
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 ----------------------------------------------------------------
-
由 Bruce Momjian 提交于
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
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
souce directory of OpenSSL as argument to the --with-openssl - argument. ./configure --with-openssl=/tmp/openssl-0.9.5/ - the libcrypto.a is in the "base" directory, not lib/. Also, there's 2-3 typo fixes to the documentation for SSL - it should be "server.crt", not "server.cert". Dominic J. Eidson
-
由 Bruce Momjian 提交于
Here is a patch against CVS (without my earlier patch) to disallow LOCK x if x is a view. It does not use the SPI interface. -- Mark Hollomon
-
由 Bruce Momjian 提交于
* Disallow LOCK on view src/backend/commands/command.c is the only affected file -- Mark Hollomon
-
由 Bruce Momjian 提交于
7.0.2 release. Sorry, if that's fixed ages ago - I don't track development versions of PostgreSQL. Patch is just a little bit tested (some valid functions created and successfully run as well as some erroneous ones created and emitted proper error messages when used). My platform is FreeBSD 5.0-CURRENT (with perl 5.6.0 provided in the base system). Alex Kapranoff
-
由 Bruce Momjian 提交于
encountered while getting my reporting tool up and running with the driver. All changes are in the DatabaseMetaData class. Problem: The getDatabaseProductVersion() method was returning "6.5.2" Resolution: Changed it to return "7.0.2" Problem: A call to getTables() with an unsupported table type (in the String array) resulted in a malformed SQL statement and subsequent parsing error Resolution: Unsupported table types are now ignored without error Problem: In a getTables() call, tables and views were both returned by the "TABLE" table type, and the "VIEW" table type was unsupported Resolution: Changed the "TABLE" type to return only physical tables and added support for the "VIEW" table type (returning only views) Problem: The getIdentifierQuoteString() method was returning null Resolution: This method now returns a double-quote Christopher Cain
-
由 Bruce Momjian 提交于
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
-
由 Bruce Momjian 提交于
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
-
由 Thomas G. Lockhart 提交于
Define ZIPSUFFIX to allow substitution of something other than gzip.
-
- 10 9月, 2000 1 次提交
-
-
由 Vadim B. Mikheev 提交于
reloid.version/unique_id file naming is not implemented
-
- 09 9月, 2000 2 次提交
-
-
由 Bruce Momjian 提交于
-
由 Peter Eisentraut 提交于
to parallel make, kind of resistent to corruption due to incomplete builds.
-
- 07 9月, 2000 3 次提交
-
-
由 Vadim B. Mikheev 提交于
-
由 Tatsuo Ishii 提交于
SQL buffer in listAllDbs is just too small.
-
由 Peter Eisentraut 提交于
documentation.
-
- 06 9月, 2000 3 次提交
-
-
由 Peter Eisentraut 提交于
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.
-
由 Jan Wieck 提交于
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
-
由 Peter Eisentraut 提交于
-
- 05 9月, 2000 1 次提交
-
-
由 Jan Wieck 提交于
and SPI_return values. Patch from Philip Warner. Jan
-
- 01 9月, 2000 1 次提交
-
-
由 Peter Eisentraut 提交于
initdb itself. Refuse to run on existing but non-empty PGDATA directory.
-