From 3fb8c9d1f9dc28ee185a5e545ac39b146c9063eb Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Sat, 24 Jun 2000 01:51:14 +0000 Subject: Update FAQ. --- doc/FAQ | 23 +++++++++++------------ 1 file changed, 11 insertions(+), 12 deletions(-) (limited to 'doc/FAQ') 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 -- cgit v1.2.3