Re: [SQL] some error when executing query in pgAdmin tool

2006-05-23 Thread Patrick JACQUOT
Penchalaiah P. wrote: I created one table in pgAdmin tool but when I am executing query it is giving error…. CREATE TABLE "ADV" ( "T-Section_Id" varchar(10) NOT NULL, "CDA_No" varchar(7) NOT NULL, "Imp_Schedule_Id" int4 NOT NULL, "Sanction_No" varchar(20) NOT NULL, "Sanction_Date" date N

Re: [SQL] some error when executing query in pgAdmin tool

2006-05-23 Thread Dave Page
  From: Penchalaiah P. [mailto:[EMAIL PROTECTED] Sent: 23 May 2006 13:18To: Dave PageSubject: RE: [SQL] some error when executing query in pgAdmin tool Hi sir…   I tried like that also … but I am getting same error……I tried like these……   1).Select

Re: [SQL] some error when executing query in pgAdmin tool

2006-05-23 Thread Dave Page
  From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Penchalaiah P.Sent: 23 May 2006 13:11To: pgsql-sql@postgresql.orgSubject: [SQL] some error when executing query in pgAdmin tool   I created one table in pgAdmin tool but when I am executing query

[SQL] some error when executing query in pgAdmin tool

2006-05-23 Thread Penchalaiah P.
  I created one table in pgAdmin tool but when I am executing query it is giving error….   CREATE TABLE "ADV" (   "T-Section_Id" varchar(10) NOT NULL,   "CDA_No" varchar(7) NOT NULL,   "Imp_Schedule_Id" int4 NOT NULL,   "Sanction_No" varchar(20) NOT NULL,   "Sanction_Date" date NOT