Skip site navigation (1) Skip section navigation (2)

Re: Correcting Error message

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jaime Casanova <jcasanov(at)systemguards(dot)com(dot)ec>
Cc: Michael Glaesemann <grzm(at)seespotcode(dot)net>, Piyush Newe <piyush(dot)newe(at)enterprisedb(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Correcting Error message
Date: 2010-02-27 06:16:34
Message-ID: 16236.1267251394@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
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 SomasundaramDate: 2010-02-27 06:43:49
Subject: Re: Lock Wait Statistics (next commitfest)
Previous:From: Jaime CasanovaDate: 2010-02-27 06:08:39
Subject: Re: Correcting Error message

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group