Re: [GENERAL] creation of tables with warnings
On 9/17/07, SHARMILA JOTHIRAJAH <[EMAIL PROTECTED]> wrote: > Hi > Sometimes when I create a table with the > CREATE TABLE sql command, > it creates a table but with some warnings > > For example, I create this table in Aqua studio as > create table foo(col1 varchar2); > > gives > > Warnings: ---> >W (1): > <--- > 0 record(s) affected > > The table is created. So what does this warnings mean? where and how do i > check them? Are you sure you're using PostgreSQL? Cause in 8.2.4 I get: create table foo(col1 varchar2); ERROR: type "varchar2" does not exist LINE 1: create table foo(col1 varchar2); which is what I expect. Is this a cut and paste or did you copy this by hand. Please cut and paste EXACTLY what you're typing and what postgresql is saying. Also, is this in psql or some other client? ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
Re: [GENERAL] creation of tables with warnings
sorry about that. I copied it.This is proper one create table foo(col1 varchar); i use aqua studio Thanks Scott Marlowe <[EMAIL PROTECTED]> wrote: On 9/17/07, SHARMILA JOTHIRAJAH wrote: > Hi > Sometimes when I create a table with the > CREATE TABLE sql command, > it creates a table but with some warnings > > For example, I create this table in Aqua studio as > create table foo(col1 varchar2); > > gives > > Warnings: ---> >W (1): > <--- > 0 record(s) affected > > The table is created. So what does this warnings mean? where and how do i > check them? Are you sure you're using PostgreSQL? Cause in 8.2.4 I get: create table foo(col1 varchar2); ERROR: type "varchar2" does not exist LINE 1: create table foo(col1 varchar2); which is what I expect. Is this a cut and paste or did you copy this by hand. Please cut and paste EXACTLY what you're typing and what postgresql is saying. Also, is this in psql or some other client? - Fussy? Opinionated? Impossible to please? Perfect. Join Yahoo!'s user panel and lay it on us.
Re: [GENERAL] creation of tables with warnings
On 9/17/07, SHARMILA JOTHIRAJAH <[EMAIL PROTECTED]> 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
