Jaime Casanova <jcasanov(at)systemguards(dot)com(dot)ec> writes:
> On Fri, Feb 26, 2010 at 7:12 PM, Michael Glaesemann <grzm(at)seespotcode(dot)net> wrote:
>> In any event, I couldn't get your example to work on Postgres 8.4 regardless
>> due to the varchar2 type. Which version of Postgres are you using?
>>
>> test=# CREATE TABLE footable(id int4, name varchar2(10));
>> ERROR: type "varchar2" does not exist
> it;s probably postgres plus (the enterprisedb fork),
Yeah, particularly given the OP's address ;-). The example goes through
fine in standard Postgres if you use varchar, or indeed any other
datatype.
regards, tom lane
In response to
pgsql-hackers by date
| Next: | From: Gokulakannan Somasundaram | Date: 2010-02-27 06:43:49 |
| Subject: Re: Lock Wait Statistics (next commitfest) |
| Previous: | From: Jaime Casanova | Date: 2010-02-27 06:08:39 |
| Subject: Re: Correcting Error message |