On 9/17/07, SHARMILA JOTHIRAJAH <sharmi_jo@xxxxxxxxx> wrote: > sorry about that. I copied it.This is proper one > create table foo(col1 varchar); > > i use aqua studio Can you copy the error too? Or is it in some kind of popup that makes it hard to do? It just seems odd that you get a warning with nothing in it. You might wanna try issuing your create table statement from psql and see what it says. Some clients munge the output from postgresql into something other than useful. :) ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend