aboutsummaryrefslogtreecommitdiff
path: root/doc/FAQ
diff options
context:
space:
mode:
authorBruce Momjian <bruce@momjian.us>2000-06-24 01:51:14 +0000
committerBruce Momjian <bruce@momjian.us>2000-06-24 01:51:14 +0000
commit3fb8c9d1f9dc28ee185a5e545ac39b146c9063eb (patch)
treeb3ca7ca1a10386cbd249322858401a1a09d7d65d /doc/FAQ
parentc4465095659bb089e08f8c94ce045ba3572a194f (diff)
downloadpostgresql-3fb8c9d1f9dc28ee185a5e545ac39b146c9063eb.tar.gz
postgresql-3fb8c9d1f9dc28ee185a5e545ac39b146c9063eb.zip
Update FAQ.
Diffstat (limited to 'doc/FAQ')
-rw-r--r--doc/FAQ23
1 files changed, 11 insertions, 12 deletions
diff --git a/doc/FAQ b/doc/FAQ
index cff90e0aaed..cb9bfbe2059 100644
--- a/doc/FAQ
+++ b/doc/FAQ
@@ -335,11 +335,11 @@
Features
PostgreSQL has most features present in large commercial
- DBMS's, like transactions, subselects, triggers, views, and
- sophisticated locking. We have some features they don't have,
- like user-defined types, inheritance, rules, and multi-version
- concurrency control to reduce lock contention. We don't have
- foreign key referential integrity or outer joins, but are
+ DBMS's, like transactions, subselects, triggers, views, foreign
+ key referential integrity, and sophisticated locking. We have
+ some features they don't have, like user-defined types,
+ inheritance, rules, and multi-version concurrency control to
+ reduce lock contention. We don't have outer joins, but are
working on them for our next release.
Performance
@@ -396,10 +396,10 @@
2.1) Are there ODBC drivers for PostgreSQL?
- There are two ODBC drivers available, PostODBC and OpenLink ODBC.
+ There are two ODBC drivers available, PsqlODBC and OpenLink ODBC.
- PostODBC is included in the distribution. More information about it
- can be gotten from: http://www.insightdist.com/psqlodbc
+ PsqlODBC is included in the distribution. More information about it
+ can be gotten from: ftp://ftp.postgresql.org/pub/odbc/index.html
OpenLink ODBC can be gotten from http://www.openlinksw.com. It works
with their standard ODBC client software so you'll have PostgreSQL
@@ -410,6 +410,8 @@
commercial-quality support, but a freeware version will always be
available. Questions to postgres95@openlink.co.uk.
+ See also the ODBC chapter of the Programmer's Guide.
+
2.2) What tools are available for hooking PostgreSQL to Web pages?
A nice introduction to Database-backed Web pages can be seen at:
@@ -972,12 +974,9 @@ BYTEA bytea variable-length array of bytes
4.22) How do I create a column that will default to the current time?
- This way always works:
+ Use now():
CREATE TABLE test (x int, modtime timestamp default now() );
- In releases 7.0 and later, you may use:
- create table test (x int, modtime timestamp default 'now');
-
4.23) Why are my subqueries using IN so slow?
Currently, we join subqueries to outer queries by sequential scanning