Type info of geography columns incomplete - pg_dump output wrong

[tider]

Steps to reproduce (using interactive psql):

test=# CREATE table test (geom geography(GEOMETRY,4326)); CREATE TABLE test=# \d test

Table "public.test"

Column | Type | Modifiers

---

geom | geography(4326) |

Note the wrong type "geography(4326)", it should be "geography(GEOMETRY,4326)". This type info is used by pg_dump as well, resulting in a failing CREATE TABLE statement.

[tider]

Again, nicer:

Steps to reproduce (using interactive psql):

---

test=# CREATE table test (geom geography(GEOMETRY,4326));
CREATE TABLE
test=# \d test
         Table "public.test"
 Column |      Type       | Modifiers 
--------+-----------------+-----------
 geom   | geography(4326) | 

---

Note the wrong type "geography(4326)", it should be "geography(GEOMETRY,4326)". This type info is used by pg_dump as well, resulting in a failing CREATE TABLE statement.

[pramsey]

The idea was that geography(geometry,4326) and geography(4326) would be equivalent. I will look and see if it's possible to make the create table statement more liberal.

[pramsey]

Does this help?

[pramsey]

Fixed in r7248 in trunk and r7247 in 1.5 branch