OSDN Git Service
Peter Eisentraut [Mon, 25 Sep 2000 22:34:20 +0000 (22:34 +0000)]
When the RI triggers lock the PK table, temporarily switch the current user
id to the owner of the PK table, to avoid permission problems.
Peter Eisentraut [Mon, 25 Sep 2000 22:23:01 +0000 (22:23 +0000)]
Revise Tcl/Tk configuration. Make missing Tcl after --with-tcl an error,
add --without-tk option to disable Tk. We don't need the AC_PATH_XTRA
test because tkConfig.sh already contains all the information about how to
compile and link with X. Also make sure that libpq is up to date for
libpgtcl. Remove executable bits from pgaccess.sh, but add it to pgaccess.
Tom Lane [Mon, 25 Sep 2000 18:38:39 +0000 (18:38 +0000)]
Correct error in grammar for subselect-in-FROM: SQL spec does not allow
omission of alias_clause for a subselect.
Tom Lane [Mon, 25 Sep 2000 18:14:55 +0000 (18:14 +0000)]
Use variable aliases, if supplied, rather than real column names in
complaints about ungrouped variables. This is for consistency with
behavior elsewhere, notably the fact that the relname is reported as
an alias in these same complaints. Also, it'll work with subselect-
in-FROM where old code didn't.
Tom Lane [Mon, 25 Sep 2000 18:09:28 +0000 (18:09 +0000)]
System neglected to complain about ungrouped variables passed to
sublinks when outer query contained aggregates but no GROUP clause.
Tom Lane [Mon, 25 Sep 2000 16:36:36 +0000 (16:36 +0000)]
Karel missed an ichar->chr ...
Bruce Momjian [Mon, 25 Sep 2000 14:40:27 +0000 (14:40 +0000)]
Change // to /*.
Bruce Momjian [Mon, 25 Sep 2000 12:58:47 +0000 (12:58 +0000)]
the patch include:
- rename ichar() to chr() (discussed with Tom)
- add docs for oracle compatible routines:
btrim()
ascii()
chr()
repeat()
- fix bug with timezone in to_char()
- all to_char() variants return NULL instead textin("")
if it's needful.
The contrib/odbc is without changes and contains same routines as main
tree ... because I not sure how plans are Thomas with this :-)
Karel
---------------------------------------------------------------------------
This effectively one line patch should fix the fact that
foreign key definitions in create table were erroring if
a primary key was defined. I was using the columns
list to get the columns of the table for comparison, but
it got reused as a temporary list inside the primary key
stuff.
Stephan Szabo
Bruce Momjian [Mon, 25 Sep 2000 12:43:24 +0000 (12:43 +0000)]
disable plperl again.
Tom Lane [Mon, 25 Sep 2000 04:11:09 +0000 (04:11 +0000)]
Acquire read lock on a buffer while writing it out, to prevent
concurrent modifications to the page by other backends.
Tom Lane [Sun, 24 Sep 2000 04:07:11 +0000 (04:07 +0000)]
Tweak resultmap so that geometry regress test selects the right comparison
file on LinuxPPC, which is identified by config.guess as
powerpc-unknown-linux-gnu (not ...-gnulibc1).
Tom Lane [Sat, 23 Sep 2000 22:40:12 +0000 (22:40 +0000)]
Clean up some ugly coding (hardwired constants) in index_formtuple.
Peter Eisentraut [Sat, 23 Sep 2000 00:42:36 +0000 (00:42 +0000)]
These are obsolete.
Peter Eisentraut [Fri, 22 Sep 2000 23:02:00 +0000 (23:02 +0000)]
Don't free() the result of getpwuid().
Discovered by Jason Tishler <Jason.Tishler@dothill.com>.
Tom Lane [Fri, 22 Sep 2000 15:34:31 +0000 (15:34 +0000)]
SetPGVariable() crashed on SET DateStyle TO DEFAULT and related cases.
Tom Lane [Fri, 22 Sep 2000 15:33:31 +0000 (15:33 +0000)]
Add check of 'SET DateStyle TO DEFAULT'.
Peter Eisentraut [Thu, 21 Sep 2000 20:17:43 +0000 (20:17 +0000)]
Replace brain-dead Autoconf macros AC_ARG_{ENABLE,WITH} with something
that's actually useful, robust, consistent.
Better plan to generate aclocal.m4 as well: use m4 include directives,
rather than cat.
Michael Meskes [Thu, 21 Sep 2000 11:56:08 +0000 (11:56 +0000)]
*** empty log message ***
Tom Lane [Wed, 20 Sep 2000 15:28:01 +0000 (15:28 +0000)]
Fix coredump in copyCommentStmt().
Michael Meskes [Wed, 20 Sep 2000 13:25:52 +0000 (13:25 +0000)]
*** empty log message ***
Tom Lane [Tue, 19 Sep 2000 19:30:03 +0000 (19:30 +0000)]
Make sure that FlushRelationBuffers() is invoked by all paths through
vacuum.c. This is needed to make the world safe for pg_upgrade.
Tom Lane [Tue, 19 Sep 2000 18:42:34 +0000 (18:42 +0000)]
Fix GEQO optimizer to work correctly with new outer-join-capable
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.
Peter Eisentraut [Tue, 19 Sep 2000 18:18:04 +0000 (18:18 +0000)]
Implement differentiation between CURRENT_USER and SESSION_USER as per SQL.
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.
Michael Meskes [Tue, 19 Sep 2000 11:47:16 +0000 (11:47 +0000)]
*** empty log message ***
Tom Lane [Mon, 18 Sep 2000 20:14:23 +0000 (20:14 +0000)]
Make rule lister use aliases from FROM clause when a table column has
been given an alias. Otherwise, results are incorrect.
Peter Eisentraut [Mon, 18 Sep 2000 20:11:37 +0000 (20:11 +0000)]
Move contrib/odbc/odbc.sql together with odbc driver, remove old files;
revise ODBC "installation instructions"; update some other outdated
documentation; update contrib documentation
Philip Warner [Mon, 18 Sep 2000 06:47:46 +0000 (06:47 +0000)]
Only retrieve view definition if relation is a view (case statement)
Philip Warner [Mon, 18 Sep 2000 03:24:03 +0000 (03:24 +0000)]
Uses column select expressions to get object object owners and tests for blank names
Tom Lane [Sun, 17 Sep 2000 22:21:27 +0000 (22:21 +0000)]
Parse JOIN/ON conditions with the proper visibility of input columns,
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.
Peter Eisentraut [Sun, 17 Sep 2000 20:35:27 +0000 (20:35 +0000)]
Add a blurb about what tools are required to build.
Peter Eisentraut [Sun, 17 Sep 2000 20:33:45 +0000 (20:33 +0000)]
psql forgot to close connection before re-issuing password prompt.
([BUGS] psql can crash the backend on login, 2000-09-03)
Tom Lane [Sun, 17 Sep 2000 20:01:28 +0000 (20:01 +0000)]
Improve error message for dumpRules() failure
Peter Eisentraut [Sun, 17 Sep 2000 13:02:52 +0000 (13:02 +0000)]
Support for DESTDIR make variable. This is used as in `make install
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.
Tom Lane [Fri, 15 Sep 2000 20:20:11 +0000 (20:20 +0000)]
Add ILIKE operators ~~*, !~~* to documentation.
Tom Lane [Fri, 15 Sep 2000 19:37:49 +0000 (19:37 +0000)]
Variant horology resultfiles are inconsistent with the test, again.
Tom Lane [Fri, 15 Sep 2000 18:45:31 +0000 (18:45 +0000)]
Reimplement LIKE/ESCAPE as operators so that indexscan optimization
can still work, per recent discussion on pghackers. Correct some bugs
in ILIKE implementation.
Tatsuo Ishii [Fri, 15 Sep 2000 11:59:40 +0000 (11:59 +0000)]
Allow PL/pgSQL accept non ascii identifiers
Philip Warner [Fri, 15 Sep 2000 04:57:09 +0000 (04:57 +0000)]
Minor code cleanup (cast away const-ness)
Philip Warner [Fri, 15 Sep 2000 04:35:16 +0000 (04:35 +0000)]
- Support for relkind = RELKIND_VIEW.
- 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
Thomas G. Lockhart [Thu, 14 Sep 2000 15:55:07 +0000 (15:55 +0000)]
Move a few specific tests to isolate homogenous type tests into
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.
Bruce Momjian [Thu, 14 Sep 2000 02:21:31 +0000 (02:21 +0000)]
Add new FAQ's.
Bruce Momjian [Thu, 14 Sep 2000 02:17:28 +0000 (02:17 +0000)]
rename README.Charsets
Bruce Momjian [Tue, 12 Sep 2000 21:12:45 +0000 (21:12 +0000)]
typo fix
Tom Lane [Tue, 12 Sep 2000 21:07:18 +0000 (21:07 +0000)]
First cut at full support for OUTER JOINs. There are still a few loose
ends to clean up (see my message of same date to pghackers), but mostly
it works. INITDB REQUIRED!
Bruce Momjian [Tue, 12 Sep 2000 20:58:14 +0000 (20:58 +0000)]
typo fix
Bruce Momjian [Tue, 12 Sep 2000 20:52:08 +0000 (20:52 +0000)]
datatype -> data type.
Tom Lane [Tue, 12 Sep 2000 20:38:09 +0000 (20:38 +0000)]
Fix relation-to-view conversion so that it doesn't try to convert a plain
relation to a view when you create an ON INSERT/UPDATE/DELETE rule ...
Tom Lane [Tue, 12 Sep 2000 20:11:23 +0000 (20:11 +0000)]
Update expected/horology-no-DST-before-1970.out for new horology test.
There are still two out-of-date variants for horology; shame shame.
Tom Lane [Tue, 12 Sep 2000 19:41:40 +0000 (19:41 +0000)]
Clean up compiler warning.
Tom Lane [Tue, 12 Sep 2000 19:39:42 +0000 (19:39 +0000)]
Suppress compile warnings caused by failure to use PG_RETURN macro.
Bruce Momjian [Tue, 12 Sep 2000 18:56:04 +0000 (18:56 +0000)]
As if my JDBC patch hasn't already caused enough grief, there is now a
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 [Tue, 12 Sep 2000 16:48:55 +0000 (16:48 +0000)]
Remove incorrect extra heap_close when deleting a builtin function.
Bruce Momjian [Tue, 12 Sep 2000 15:47:20 +0000 (15:47 +0000)]
Update FAQ.
Vadim B. Mikheev [Tue, 12 Sep 2000 06:07:52 +0000 (06:07 +0000)]
Btree WAL records.
Thomas G. Lockhart [Tue, 12 Sep 2000 05:42:20 +0000 (05:42 +0000)]
Add regression tests for date, time, and time with time zone types.
Modify date->timestamp conversion to use mktime().
This should do better than before around Daylight Savings Time
transitions.
Thomas G. Lockhart [Tue, 12 Sep 2000 05:41:37 +0000 (05:41 +0000)]
Modify date->timestamp conversion to use mktime().
This should do better than before around Daylight Savings Time
transitions.
Thomas G. Lockhart [Tue, 12 Sep 2000 05:37:09 +0000 (05:37 +0000)]
Consolidate FAQ and README info on character sets into new chapter.
Thomas G. Lockhart [Tue, 12 Sep 2000 05:36:06 +0000 (05:36 +0000)]
Update to refer to more recent stylesheets in my home directory.
These stylesheets are pretty old, but the 15x series crashes FreeBSD jade.
Thomas G. Lockhart [Tue, 12 Sep 2000 05:34:28 +0000 (05:34 +0000)]
Clean up markup to be more correct.
From "He Weiping (Laser Henry)" <laser@zhengmai.com.cn>.
Thomas G. Lockhart [Tue, 12 Sep 2000 05:30:06 +0000 (05:30 +0000)]
Fix inconsistancies in field names. From Tom Samplonius <tom@sdf.com>.
Bruce Momjian [Tue, 12 Sep 2000 05:18:25 +0000 (05:18 +0000)]
Attached is a patch that prevents a NullPointerException in the JDBC
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 [Tue, 12 Sep 2000 05:09:57 +0000 (05:09 +0000)]
This patch implements the following command:
ALTER TABLE <tablename> OWNER TO <username>
Only a superuser may execute the command.
--
Mark Hollomon
mhh@mindspring.com
Bruce Momjian [Tue, 12 Sep 2000 04:58:50 +0000 (04:58 +0000)]
Attached are a patch to allow the charset encoding used by the JDBC
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 [Tue, 12 Sep 2000 04:51:43 +0000 (04:51 +0000)]
Applied to jdbc1 and jdbc2.
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 [Tue, 12 Sep 2000 04:49:17 +0000 (04:49 +0000)]
This patch implements a different "relkind"
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 [Tue, 12 Sep 2000 04:43:21 +0000 (04:43 +0000)]
autoconf
Bruce Momjian [Tue, 12 Sep 2000 04:41:17 +0000 (04:41 +0000)]
Attached is a small patch that fixes a small "bug" with specifying the
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 [Tue, 12 Sep 2000 04:33:18 +0000 (04:33 +0000)]
Previous patch backed out.
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 [Tue, 12 Sep 2000 04:30:08 +0000 (04:30 +0000)]
This patch is for the TODO item
* Disallow LOCK on view
src/backend/commands/command.c is the only affected file
--
Mark Hollomon
Bruce Momjian [Tue, 12 Sep 2000 04:28:30 +0000 (04:28 +0000)]
This patch, when applied in src/pl will unbreak plperl in
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 [Tue, 12 Sep 2000 04:16:59 +0000 (04:16 +0000)]
This patch for the 7.0.2 JDBC interface addresses four issues I
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 [Tue, 12 Sep 2000 04:15:58 +0000 (04:15 +0000)]
O.K. -
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 [Tue, 12 Sep 2000 04:12:47 +0000 (04:12 +0000)]
Irix fix:
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 [Tue, 12 Sep 2000 03:47:36 +0000 (03:47 +0000)]
Define ZIP rather than GZIP.
Define ZIPSUFFIX to allow substitution of something other than gzip.
Vadim B. Mikheev [Sun, 10 Sep 2000 00:06:52 +0000 (00:06 +0000)]
This is temporal place holder for Relation File Node till
reloid.version/unique_id file naming is not implemented
Bruce Momjian [Fri, 8 Sep 2000 19:15:23 +0000 (19:15 +0000)]
Update FAQ.
Peter Eisentraut [Fri, 8 Sep 2000 18:29:28 +0000 (18:29 +0000)]
Make building scripts kind of consistent in look and feel, kind of immune
to parallel make, kind of resistent to corruption due to incomplete builds.
Vadim B. Mikheev [Thu, 7 Sep 2000 09:58:38 +0000 (09:58 +0000)]
Heap redo/undo (except for tuple moving used by vacuum).
Tatsuo Ishii [Thu, 7 Sep 2000 04:55:27 +0000 (04:55 +0000)]
Fix psql crash. If MULTIBYTE is enabled, \l+ dumps core due to
SQL buffer in listAllDbs is just too small.
Peter Eisentraut [Wed, 6 Sep 2000 19:54:52 +0000 (19:54 +0000)]
A bit of cleanup after SSL patch. Add it to config file, improve
documentation.
Peter Eisentraut [Wed, 6 Sep 2000 14:15:31 +0000 (14:15 +0000)]
Code cleanup of user name and user id handling in the backend. The current
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 [Tue, 5 Sep 2000 20:25:14 +0000 (20:25 +0000)]
Added functions
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 [Tue, 5 Sep 2000 18:45:38 +0000 (18:45 +0000)]
GZIP vs ZIP variable naming messed up
Jan Wieck [Tue, 5 Sep 2000 09:02:18 +0000 (09:02 +0000)]
GET DIAGNOSTICS statement to PL/pgSQL to access SPI_processed
and SPI_return values. Patch from Philip Warner.
Jan
Peter Eisentraut [Fri, 1 Sep 2000 13:15:27 +0000 (13:15 +0000)]
Change initdb to not delete PGDATA directory unless it was created by
initdb itself. Refuse to run on existing but non-empty PGDATA directory.
Peter Eisentraut [Thu, 31 Aug 2000 16:12:35 +0000 (16:12 +0000)]
Fix relative path references so that make knowns which dependencies refer
to one another. Sort out builddir vs srcdir variable namings. Remove some
now obsoleted make variables.
Jan Wieck [Thu, 31 Aug 2000 13:26:16 +0000 (13:26 +0000)]
Added EXECUTE command to PL/pgSQL for execution of
dynamic SQL and utility statements.
Jan
Tom Lane [Wed, 30 Aug 2000 20:30:06 +0000 (20:30 +0000)]
AbortOutOfAnyTransaction() just before backend exit, to ensure that
resources are cleaned up if the user disconnected mid-transaction.
Great thanks to Hiroshi for pointing out what should have been obvious...
Bruce Momjian [Wed, 30 Aug 2000 14:54:24 +0000 (14:54 +0000)]
SSL patch from Magnus
Hiroshi Inoue [Wed, 30 Aug 2000 08:48:55 +0000 (08:48 +0000)]
Improve the following.
=# 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
Bruce Momjian [Tue, 29 Aug 2000 20:02:09 +0000 (20:02 +0000)]
Startup is actually start-up.
Tom Lane [Tue, 29 Aug 2000 16:40:19 +0000 (16:40 +0000)]
Include kernel error message in failed-to-open file reports.
Peter Eisentraut [Tue, 29 Aug 2000 09:36:51 +0000 (09:36 +0000)]
Revert removal of signed, volatile, and signal handler arg type tests.
Bruce Momjian [Tue, 29 Aug 2000 04:41:48 +0000 (04:41 +0000)]
* to_char:
- 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
Bruce Momjian [Tue, 29 Aug 2000 04:20:47 +0000 (04:20 +0000)]
This is mostly the same as an earlier patch I
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
Bruce Momjian [Tue, 29 Aug 2000 04:15:43 +0000 (04:15 +0000)]
Here is a patch against the same cvs tree as the SSL patch (Aug 20).
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
Tom Lane [Tue, 29 Aug 2000 02:00:38 +0000 (02:00 +0000)]
Update obsolete comments.
Tom Lane [Tue, 29 Aug 2000 00:57:21 +0000 (00:57 +0000)]
Remove bogus use of int4out().
Peter Eisentraut [Mon, 28 Aug 2000 11:57:41 +0000 (11:57 +0000)]
Maybe "shared_buffers" is a slightly better name than "shmem_buffers" for -B.
Peter Eisentraut [Mon, 28 Aug 2000 11:53:23 +0000 (11:53 +0000)]
New configure test for flex, which recognizes only flex but does so in all
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.