[DOCS] syntax error with example sql of createtable

[Honda Shigehiro]

Hello,

I got a error when execute below command in 
  http://developer.postgresql.org/docs/postgres/sql-createtable.html

postgres=#  CREATE TABLE array (vector  int[][]);
ERROR:  syntax error at or near "array" at character 14
LINE 1: CREATE TABLE array (vector  int[][]);

 ^
(I tried it on 8.0.0rc2.)

'array' is a reserved word, so it needs quote to create table 
named array:
postgres=#  CREATE TABLE "array" (vector  int[][]);
CREATE TABLE

regards,
-- Shigehiro Honda

---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
  joining column's datatypes do not match

Re: [DOCS] syntax error with example sql of createtable

[Bruce Momjian]

Thanks.  Changed to 'array_int'.

---

Honda Shigehiro wrote:
> Hello,
> 
> I got a error when execute below command in 
>   http://developer.postgresql.org/docs/postgres/sql-createtable.html
> 
> postgres=#  CREATE TABLE array (vector  int[][]);
> ERROR:  syntax error at or near "array" at character 14
> LINE 1: CREATE TABLE array (vector  int[][]);
> 
>  ^
> (I tried it on 8.0.0rc2.)
> 
> 'array' is a reserved word, so it needs quote to create table 
> named array:
> postgres=#  CREATE TABLE "array" (vector  int[][]);
> CREATE TABLE
> 
> regards,
> -- Shigehiro Honda
> 
> ---(end of broadcast)---
> TIP 9: the planner will ignore your desire to choose an index scan if your
>   joining column's datatypes do not match
> 

-- 
  Bruce Momjian|  http://candle.pha.pa.us
  pgman@candle.pha.pa.us   |  (610) 359-1001
  +  If your life is a hard drive, |  13 Roberts Road
  +  Christ can be your backup.|  Newtown Square, Pennsylvania 19073

---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
  subscribe-nomail command to [EMAIL PROTECTED] so that your
  message can get through to the mailing list cleanly

[DOCS] FAQ on oids is out of date.

[Kris Jurka]

http://www.postgresql.org/files/documentation/faqs/FAQ.html#4.16

The FAQ on oids is out of date.  It claims that they are globally unique 
and that no one has ever rolled over the oid counter.  This should be 
changed to actively discourage their use.

Kris Jurka

---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
  joining column's datatypes do not match