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/src/FAQ.html | 20 +++++++++++--------- 1 file changed, 11 insertions(+), 9 deletions(-) (limited to 'doc/src') diff --git a/doc/src/FAQ.html b/doc/src/FAQ.html index 619d729017a..c118ccb0c34 100644 --- a/doc/src/FAQ.html +++ b/doc/src/FAQ.html @@ -434,10 +434,10 @@ reliability, support, and price.

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 +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 @@ -506,11 +506,11 @@ in our BSD-style license stated above.

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 @@ -522,6 +522,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 @@ -1054,7 +1056,7 @@ you need to dump and reload the database, you need to use pg_dump's -o option or COPY WITH OIDS option to preserve the oids.

For more details, see Bruce Momjian's chapter on -Numbering Rows. +Numbering Rows.

4.16.2) How do I get the back the generated SERIAL value after an insert?

Probably the simplest approach is to to retrieve the next SERIAL value from the sequence object with the nextval() function before inserting and then insert it explicitly. Using the example table in 4.16.1, that might look like this: -- cgit v1.2.3