From ca71c6619086ac3b6e3787c2826363faeab02ac9 Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Thu, 15 Feb 2001 22:21:23 +0000 Subject: Update FAQ. --- doc/src/FAQ/FAQ.html | 43 ++++++++++++++++++++++++++++++++----------- 1 file changed, 32 insertions(+), 11 deletions(-) (limited to 'doc/src') diff --git a/doc/src/FAQ/FAQ.html b/doc/src/FAQ/FAQ.html index 59ad51047f8..61d955211ed 100644 --- a/doc/src/FAQ/FAQ.html +++ b/doc/src/FAQ/FAQ.html @@ -127,15 +127,17 @@ TID?
4.18) What is the meaning of some of the terms used in PostgreSQL?
- 4.19) How do I tell what PostgreSQL version I + 4.19) Why do I get the error "ERROR: + Memory exhausted in AllocSetAlloc()?"
+ 4.20) How do I tell what PostgreSQL version I am running?
- 4.20) My large-object operations get + 4.21) My large-object operations get invalid large obj descriptor. Why?
- 4.21) How do I create a column that will + 4.22) How do I create a column that will default to the current time?
- 4.22) Why are my subqueries using + 4.23) Why are my subqueries using IN so slow?
- 4.23) How do I perform an outer join?
+ 4.24) How do I perform an outer join?
@@ -147,7 +149,7 @@ and functions to PostgreSQL?
5.3) How do I write a C function to return a tuple?
- 5.4) I have changed a source file. Why does the + 5.3) I have changed a source file. Why does the recompile not see the change?
@@ -1132,13 +1134,32 @@ BYTEA bytea variable-length byte array (null-safe)

A list of general database terms can be found at: http://www.comptechnews.com/~reaster/dbdesign.html

-

4.19) How do I tell what PostgreSQL version +

4.19) Why do I get the error "ERROR: + Memory exhausted in AllocSetAlloc()?"
+

+ +

It is possible you have run out of virtual memory on your + system, or your kernel has a low limit for certain resources. Try + this before starting the postmaster:

+
+    ulimit -d 262144
+    limit datasize 256m
+
+ Depending on your shell, only one of these may succeed, but it will + set your process data segment limit much higher and perhaps allow + the query to complete. This command applies to the current process, + and all subprocesses created after the command is run. If you are + having a problem with the SQL client because the + backend is returning too much data, try it before starting the + client. + +

4.20) How do I tell what PostgreSQL version I am running?

From psql, type select version();

-

4.20) My large-object operations get +

4.21) My large-object operations get invalid large obj descriptor. Why?

@@ -1155,7 +1176,7 @@ BYTEA bytea variable-length byte array (null-safe)

If you are using a client interface like ODBC you may need to set auto-commit off.

-

4.21) How do I create a column that will +

4.22) How do I create a column that will default to the current time?

@@ -1165,7 +1186,7 @@ BYTEA bytea variable-length byte array (null-safe) -

4.22) Why are my subqueries using +

4.23) Why are my subqueries using IN so slow?

@@ -1188,7 +1209,7 @@ BYTEA bytea variable-length byte array (null-safe) We hope to fix this limitation in a future release. -

4.23) How do I perform an outer join?
+

4.24) How do I perform an outer join?

PostgreSQL 7.1 and later supports outer joins using the SQL -- cgit v1.2.3