Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commite5f2155

Browse files
committed
Update FAQ from Ian Barwick.
1 parentb4b3e34 commite5f2155

File tree

2 files changed

+12
-11
lines changed

2 files changed

+12
-11
lines changed

‎doc/FAQ‎

Lines changed: 6 additions & 5 deletions
Original file line numberDiff line numberDiff line change
@@ -1,7 +1,7 @@
11

22
Frequently Asked Questions (FAQ) for PostgreSQL
33

4-
Last updated: FriMay 30 22:24:56 EDT 2003
4+
Last updated: FriJun 6 18:20:23 EDT 2003
55

66
Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us)
77

@@ -252,7 +252,7 @@
252252

253253
1.7) What is the latest release?
254254

255-
The latest release of PostgreSQL is version 7.3.2.
255+
The latest release of PostgreSQL is version 7.3.3.
256256

257257
We plan to have major releases every four months.
258258

@@ -265,8 +265,9 @@
265265
There are two PostgreSQL books available online at
266266
http://www.PostgreSQL.org/docs/awbook.html and
267267
http://www.commandprompt.com/ppbook/. There is a list of PostgreSQL
268-
books available for purchase at http://www.ca.PostgreSQL.org/books/.
269-
There is also a collection of PostgreSQL technical articles at
268+
books available for purchase at
269+
http://techdocs.PostgreSQL.org/techdocs/bookreviews.php. There is also
270+
a collection of PostgreSQL technical articles at
270271
http://techdocs.PostgreSQL.org/.
271272

272273
psql has some nice \d commands to show information about types,
@@ -671,7 +672,7 @@
671672
BEGIN;
672673
ALTER TABLE tab ADD COLUMN new_col new_data_type;
673674
UPDATE tab SET new_col = CAST(old_col AS new_data_type);
674-
ALTER TABLE DROP COLUMN old_col;
675+
ALTER TABLEtabDROP COLUMN old_col;
675676
COMMIT;
676677

677678
You might then want to do VACUUM FULL tab to reclaim the disk space

‎doc/src/FAQ/FAQ.html‎

Lines changed: 6 additions & 6 deletions
Original file line numberDiff line numberDiff line change
@@ -10,7 +10,7 @@
1010
alink="#0000ff">
1111
<H1>Frequently Asked Questions (FAQ) for PostgreSQL</H1>
1212

13-
<P>Last updated: FriMay 30 22:24:56 EDT 2003</P>
13+
<P>Last updated: FriJun 6 18:20:23 EDT 2003</P>
1414

1515
<P>Current maintainer: Bruce Momjian (<Ahref=
1616
"mailto:pgman@candle.pha.pa.us">pgman@candle.pha.pa.us</A>)<BR>
@@ -323,7 +323,7 @@ <H4><A name="1.6">1.6</A>) Where can I get support?</H4>
323323

324324
<H4><Aname="1.7">1.7</A>) What is the latest release?</H4>
325325

326-
<P>The latest release of PostgreSQL is version 7.3.2.</P>
326+
<P>The latest release of PostgreSQL is version 7.3.3.</P>
327327

328328
<P>We plan to have major releases every four months.</P>
329329

@@ -340,7 +340,7 @@ <H4><A name="1.8">1.8</A>) What documentation is available?</H4>
340340
"http://www.commandprompt.com/ppbook/">http://www.commandprompt.com/ppbook/</A>.
341341
There is a list of PostgreSQL books available for purchase at<A
342342
href=
343-
"http://www.ca.PostgreSQL.org/books/">http://www.ca.PostgreSQL.org/books/</A>.
343+
"http://techdocs.postgresql.org/techdocs/bookreviews.php">http://techdocs.PostgreSQL.org/techdocs/bookreviews.php</A>.
344344
There is also a collection of PostgreSQL technical articles at<A
345345
href=
346346
"http://techdocs.PostgreSQL.org/">http://techdocs.PostgreSQL.org/</A>.</P>
@@ -505,7 +505,7 @@ <H4><A name="1.15">1.15</A>) How can I financially assist
505505

506506
<P>Also, if you have a success story about PostgreSQL, please submit
507507
it to our advocacy site at<ahref="http://advocacy.postgresql.org">
508-
http://advocacy.postgresql.org</a>.
508+
http://advocacy.postgresql.org</a>.</P>
509509

510510

511511
<H2align="center">User Client Questions</H2>
@@ -612,7 +612,7 @@ <H4><A name="3.3">3.3</A>) When I try to start <I>postmaster</I>, I
612612
<I>postmaster</I>. For most systems, with default numbers of
613613
buffers and processes, you need a minimum of ~1 MB. See the<A
614614
href=
615-
"http://www.PostgreSQL.org/docs/view.php?version=current&idoc=1&file=kernel-resources.html">PostgreSQL
615+
"http://www.PostgreSQL.org/docs/view.php?version=current&amp;idoc=1&amp;file=kernel-resources.html">PostgreSQL
616616
Administrator's Guide</A> for more detailed information about
617617
shared memory and semaphores.</P>
618618

@@ -856,7 +856,7 @@ <H4><A name="4.4">4.4</A>) How do you remove a column from a
856856
BEGIN;
857857
ALTER TABLE tab ADD COLUMN new_col<i>new_data_type</i>;
858858
UPDATE tab SET new_col = CAST(old_col AS<i>new_data_type</i>);
859-
ALTER TABLE DROP COLUMN old_col;
859+
ALTER TABLEtabDROP COLUMN old_col;
860860
COMMIT;
861861
</PRE>
862862
<P>You might then want to do<I>VACUUM FULL tab</I> to reclaim the

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp