|
1 | 1 |
|
2 | 2 | Frequently Asked Questions (FAQ) for PostgreSQL |
3 | 3 |
|
4 | | - Last updated:Wed Sep1 19:26:40 EDT 1999 |
| 4 | + Last updated:Tue Sep28 01:06:15 EDT 1999 |
5 | 5 |
|
6 | 6 | Current maintainer: Bruce Momjian (maillist@candle.pha.pa.us) |
7 | 7 |
|
|
95 | 95 | 4.20) How do I tell what PostgreSQL version I am running? |
96 | 96 | 4.21) My large-object operations get invalid large obj descriptor. |
97 | 97 | Why? |
| 98 | + 4.22) How do I create a column that will default to the current time? |
98 | 99 |
|
99 | 100 | Extending PostgreSQL |
100 | 101 |
|
|
196 | 197 | The database server is now working on Windows NT using the Cygnus |
197 | 198 | Unix/NT porting library. See pgsql/doc/README.NT in the distribution. |
198 | 199 |
|
199 | | - There is another port using U/Win at |
200 | | - http://surya.wipro.com/uwin/ported.html. |
| 200 | + There is also a web page at |
| 201 | + http://members.tripod.com/~kevlo/postgres/portNT.html. There is |
| 202 | + another port using U/Win at http://surya.wipro.com/uwin/ported.html. |
201 | 203 |
|
202 | 204 | 1.5) Where can I get PostgreSQL? |
203 | 205 |
|
|
254 | 256 |
|
255 | 257 | 1.7) What is the latest release of PostgreSQL? |
256 | 258 |
|
257 | | - The latest release of PostgreSQL is version 6.5. |
| 259 | + The latest release of PostgreSQL is version 6.5.2. |
258 | 260 |
|
259 | 261 | We plan to have major releases every four months. |
260 | 262 |
|
|
580 | 582 | You need to increase the postmaster's limit on how many concurrent |
581 | 583 | backend processes it can start. |
582 | 584 |
|
583 | | - In Postgres 6.5, the default limit is 32 processes. You can increase |
| 585 | + In Postgres 6.5.*, the default limit is 32 processes. You can increase |
584 | 586 | it by restarting the postmaster with a suitable -N value. With the |
585 | 587 | default configuration you can set -N as large as 1024; if you need |
586 | 588 | more, increase MAXBACKENDS in include/config.h and rebuild. You can |
@@ -903,6 +905,18 @@ BYTEA bytea variable-length array of bytes |
903 | 905 |
|
904 | 906 | If you are using a client interface like ODBC you may need to set |
905 | 907 | auto-commit off. |
| 908 | + |
| 909 | + 4.22) How do I create a column that will default to the current time? |
| 910 | + |
| 911 | + The tempation is to do: |
| 912 | + create table test (x int, modtime timestamp default 'now'); |
| 913 | + |
| 914 | + but this makes the column default to the time of table creation, not |
| 915 | + the time of row insertion. Instead do: |
| 916 | + create table test (x int, modtime timestamp default text 'now'); |
| 917 | + |
| 918 | + The casting of the value to text prevents the default value from being |
| 919 | + computed at table creation time, and delays it until insertion time. |
906 | 920 | _________________________________________________________________ |
907 | 921 |
|
908 | 922 | Extending PostgreSQL |
|