I cannot create views in postgreSQL 6.3.2

I have been working for a short while with postgreSQL 6.3.2
and it mostly works OK. (I have trouble creating views.
I have tried posting questions on ...questions, but from what I
can tell, they are not answered there.)

For example, part of a database is as follows:

stocks=> \d ticker

Table = ticker
+----------------------------------+----------------------------------+-------+

| Field |
Type | Length|
+----------------------------------+----------------------------------+-------+

| ticker_f_date | datetime not null
| 8 |
| ticker_l_date | datetime not null
| 8 |
| ticker_company_id | int4 not null
| 4 |
| ticker_symbol | text
| var |
+----------------------------------+----------------------------------+-------+

stocks=> \d ibd

Table = ibd
+----------------------------------+----------------------------------+-------+

| Field | Type |
Length|
+----------------------------------+----------------------------------+-------+

| ibd_date | datetime not null
| 8 |
| ibd_company_id | int4 not null
| 4 |
| ibd_eps | int2
| 2 |
| ibd_rs | int2
| 2 |
| ibd_acc_dst | char
| 1 |
+----------------------------------+----------------------------------+-------+

When I do:

stocks=> CREATE VIEW ug5 AS
stocks-> SELECT ticker_symbol, ibd_eps, ibd_rs, ibd_acc_dst
stocks-> FROM ticker, ibd
stocks-> WHERE ticker_company_id = ibd_company_id;

I get:

ERROR: pg_rewrite: Permission denied.
stocks=>

This does not seem to care what relations I use or what I
make the view look like.
Seems to be a permission problem. It would work in 6.4
postgreSQL, but I could not make indices or primary keys
work with that one and inferred that 6.4 was a development
version, and went to 6.3.2. I am running Red Hat 5.0 with kernel
2.0.35 on a PC if that makes any difference.

Since I can be super-user on this machine, and since I am
the postgreSQL system administrator as well
(one-man-machine), I can do anything I want if I know what I
want. What permission would I be lacking and how do I grant
it to myself?

--
Windows is not the answer. Windows is the question. The answer is No.

Jean-David Beyer
Shrewsbury, New Jersey