Re: Newbie question on pdAdminIII tool

I had this when I first started out with PGSQL a few years ago - if you have
any upper-case names in schemas or tables, pgAdmin doesn't seem to like it,
and (in my scenario) even if you put the table name in the query in the
correct case, it still wouldn't recognise it.

I've since found it's best to keep it all lower-case.

Andy

> -----Original Message-----
> From: pgsql-admin-owner(at)postgresql(dot)org [mailto:pgsql-admin-
> owner(at)postgresql(dot)org] On Behalf Of Paul J. & Melinda Savoy
> Sent: 11 May 2006 12:56 am
> To: pgsql-admin(at)postgresql(dot)org
> Subject: [ADMIN] Newbie question on pdAdminIII tool
>
> I just downloaded postgres 8.1 and in trying to run the sql script below
> I get the following error:
>
>
> ERROR: schema "dvccntl" does not exist
>
> I created each schema (8) in all and they all exist. I've looked at the
> documentation the way I have this written looks correct but I'm unsure
> why a schema that is there in this database is not being recognized.
>
> Any help or direction would be appreciated. Thanks!!
>
> /*DROP TABLE DVCCNTL.DVCCNTL_MSR;
> DROP TABLE DVCCNTL.DVCCNTL_SAR;
> DROP TABLE DVCCNTL.DVCCNTL_SAR_CODE;
> DROP TABLE DVCCNTL.DVCCNTL_VAR;
> DROP TABLE dbo.DEPT;
> DROP TABLE INVITEM.INVITEM_ITL;
> DROP TABLE INVITVND.INVITVND_VNI;
> DROP TABLE INVITVND.INVITVND_VNI_PRICE;
> DROP TABLE INVMFR.INVMFR_MFR;
> DROP TABLE INVPO.INVPO_NT_FIELDS;
> DROP TABLE INVPO.INVPO_POI;
> DROP TABLE INVPO.INVPO_RQI;
> DROP TABLE INVPO.INVPO_RQM;
> DROP TABLE INVTBLS.INVTBLS_DEL;
> DROP TABLE VENDMSTR.VENDMSTR_SPC;
> DROP TABLE VENDMSTR.VENDMSTR_VNM;
> */
> CREATE TABLE DVCCNTL.DVCCNTL_MSR
> (
> PKEY INT PRIMARY KEY,
> EMAILADDR CHAR(40),
> MASTRKEY CHAR(12),
> LOCKOUTIND CHAR(1),
> DEPTNAME CHAR(40),
> RECRDSTATUSCODE CHAR(1),
> RECRDSTATUSDATE CHAR(8),
> RECRDTYPE CHAR(3),
> DEFLTENTITYCODE CHAR(3),
> USERNAME CHAR(40),
> OPERTRID CHAR(8)
> );
> CREATE TABLE DVCCNTL.DVCCNTL_SAR
> (
> PKEY INT PRIMARY KEY not null,
> RECRDSTATUSCODE CHAR(1),
> RECRDSTATUSDATE CHAR(8),
> ENTITYCODE CHAR(3),
> RECRDTYPE CHAR(3),
> SUBLVLKEY CHAR(25),
> SUBSYSTMNAME CHAR(3),
> LOCKOUTIND CHAR(1),
> OPERTRID CHAR(8),
> LVLNUM CHAR(4)
> );
> CREATE TABLE DVCCNTL.DVCCNTL_SAR_CODE
> (
> AUTHCODE CHAR(6) not null,
> FKEY INT not null
> );
> CREATE TABLE DVCCNTL.DVCCNTL_VAR
> (
> PKEY INT PRIMARY KEY not null,
> RECRDSTATUSDATE CHAR(8),
> RECRDTYPE CHAR(3),
> ENTITYCODE CHAR(3),
> SUBSYSTMNAME CHAR(3),
> VALADDKEY CHAR(30),
> VALADDCODE CHAR(6),
> RECRDSTATUSCODE CHAR(1),
> OPERTRID CHAR(8),
> VALADDDESCR CHAR(64)
> );
> CREATE TABLE dbo.DEPT
> (
> RECRDSTATUSCODE CHAR(1),
> ENTITYCODE CHAR(3),
> DEPTNUM CHAR(4),
> DESCRIPTION CHAR(64)
> );
> CREATE TABLE INVITEM.INVITEM_ITL
> (
> PKEY INT PRIMARY KEY not null,
> CALCDOQIND CHAR(1),
> ITEMNUM CHAR(9),
> CRITICALITEMIND CHAR(1),
> AVGUSECALCDATE CHAR(8),
> NECCODE CHAR(4),
> LASTUSAGEDATE CHAR(8),
> DYNAMCORDRQTY FLOAT,
> PROBLMIND CHAR(1),
> ENTITYCODE CHAR(3),
> LOCATNDEPTCODE CHAR(4),
> ONHANDQTY FLOAT,
> ACTUALUSAGE FLOAT,
> PARLEVEL FLOAT,
> RECRDSTATUSDATE CHAR(8),
> PATIENTCHGIND CHAR(1),
> ISSUEIND CHAR(1),
> REORDRPTVOLUME FLOAT,
> ONORDRQTY FLOAT,
> RECRDTYPE CHAR(3),
> STKIND CHAR(1),
> PURCHSNGDEPTCODE CHAR(4),
> RECRDSTATUSCODE CHAR(1),
> CREATEDATE CHAR(8),
> AUTOREPLNSHIND CHAR(1),
> LOCATNBINCODE CHAR(6),
> CRITICALQTY FLOAT,
> REPLNSHFROMDEPT CHAR(4),
> SAFETYSTKDAYS FLOAT,
> LASTCHGDATE CHAR(8),
> DESIRDINVDAYS FLOAT,
> OWEDQTY FLOAT,
> STKLVL FLOAT
> );
> CREATE TABLE INVITVND.INVITVND_VNI
> (
> PKEY INT PRIMARY KEY not null,
> CREATEDATE CHAR(8),
> PREFRNCECODE CHAR(2),
> ENTITYCODE CHAR(3),
> LEADTIME FLOAT,
> VENDORRANKING CHAR(2),
> MFRCATLGNUM CHAR(16),
> AUTOSUBIND CHAR(1),
> RECRDSTATUSDATE CHAR(8),
> PRIMARYKEY CHAR(20),
> RECRDSTATUSCODE CHAR(1),
> SEQNUM CHAR(3),
> MFRNUM CHAR(9),
> VENDORCATLGNUM CHAR(16),
> VENDORNUM CHAR(10),
> VENDORDESCR CHAR(40),
> RECRDTYPE CHAR(3),
> LASTCHGDATE CHAR(8),
> ORDRMULTINUM FLOAT,
> PURUNITOFMEAS CHAR(7),
> ITEMNUM CHAR(9),
> VENDORCONTRCTNUM CHAR(8),
> MFRCONTRCTNUM CHAR(5)
> );
> CREATE TABLE INVITVND.INVITVND_VNI_PRICE
> (
> PURPRICE FLOAT not null,
> PURPRICEDATE CHAR(8) not null,
> FKEY INT not null
> );
> CREATE TABLE INVMFR.INVMFR_MFR
> (
> PKEY INT PRIMARY KEY not null,
> MFRNAME CHAR(30),
> PARENTEXTRNLNUM CHAR(13),
> MFRNUM CHAR(9),
> PARENTNAME CHAR(30),
> PARENTNUM CHAR(9),
> MFRTYPECODE CHAR(3),
> RECRDSTATUSCODE CHAR(1),
> RECRDTYPE CHAR(3),
> LASTCHGDATE CHAR(8),
> EXTRNLMFRNUM CHAR(13),
> RECRDSTATUSDATE CHAR(8),
> OPERTRID CHAR(8)
> );
> CREATE TABLE INVPO.INVPO_NT_FIELDS
> (
> ID INT PRIMARY KEY not null,
> APRVDT CHAR(8) not null,
> APRVTM CHAR(8) not null,
> ENTITYCODE CHAR(3),
> NXTACT CHAR(10) not null,
> RECRDTYPE CHAR(3),
> REQNNUM CHAR(8)
> );
> CREATE TABLE INVPO.INVPO_POI
> (
> PKEY INT PRIMARY KEY not null,
> CAPEXPNSREQSTNUM CHAR(20),
> PATIENTENCNTRNUM CHAR(20),
> CHANGETKTNUM CHAR(10),
> CREATEDATE CHAR(8),
> PHYSNNAME CHAR(20),
> DELIVRTODEPTCODE CHAR(4),
> EDIDOWNLOADDATE CHAR(8),
> PURUNITOFMEAS CHAR(7),
> EDIDOWNLOADTIME CHAR(6),
> EOMIND CHAR(1),
> QTYRECVD FLOAT,
> INVCEFLAGIND CHAR(1),
> UNITPRICE FLOAT,
> RECRDTYPE CHAR(3),
> OPERTRID CHAR(8),
> NECCODE CHAR(4),
> REQNNUM CHAR(8),
> NEEDDATE CHAR(8),
> GLACCTNUM CHAR(8),
> SRCELOCATN CHAR(4),
> PATIENTNAME CHAR(20),
> PROMSDDATE CHAR(8),
> REQNTYPECODE CHAR(1),
> DELIVRTOINDIV CHAR(24),
> RECRDSTATUSCODE CHAR(1),
> VENDORNUM CHAR(10),
> RECRDSTATUSDATE CHAR(8),
> MFGCATLGNUM CHAR(9),
> VENDORCATLGNUM CHAR(10),
> REQNTOTL FLOAT,
> STATIND CHAR(1),
> APRVTM CHAR(8),
> CHRGTODEPTCODE CHAR(4),
> QTYORDRD FLOAT,
> BACKORDRQTY FLOAT,
> VERIFYDATE CHAR(8),
> APRVDT CHAR(8),
> ENTITYCODE CHAR(3),
> RQILINK CHAR(12),
> COMMNLIST CHAR(10),
> MODELSERIALNUM CHAR(20),
> EDIBATCHNUM CHAR(5),
> NXTACT CHAR(10),
> EDISTATUS CHAR(3),
> ORIGNLVENDORCATNUM CHAR(16),
> REQNDATE CHAR(8),
> PURCHDEPTCODE CHAR(4),
> PONUM CHAR(10),
> VENDORCATLGCHGIND CHAR(1),
> VENDORCATLGCHGDATE CHAR(8),
> LASTCHGDATE CHAR(8),
> ITEMNUM CHAR(9),
> POTYPECODE CHAR(3),
> NXTLVL CHAR(1),
> ITEMDESCR1 CHAR(40),
> ITEMDESCR2 CHAR(40),
> ITEMDESCR3 CHAR(40)
> );
> CREATE TABLE INVPO.INVPO_RQI
> (
> PKEY INT PRIMARY KEY not null,
> UNITOFMEAS CHAR(7),
> LASTCHGDATE CHAR(8),
> LOCATNBINCODE CHAR(6),
> CREATEDATE CHAR(8),
> LOGONID CHAR(8),
> DELIVRTODEPTCODE CHAR(4),
> FILLDTIME CHAR(8),
> ORIGQTYORDRD CHAR(5),
> ENTITYCODE CHAR(3),
> GLACCTNUM CHAR(8),
> ORDQTY FLOAT,
> LINEITEMCOUNT CHAR(3),
> NECCODE CHAR(4),
> RECRDSTATUSCODE CHAR(1),
> FILLDDATE CHAR(8),
> ITEMNUM CHAR(9),
> REQNNUM CHAR(8),
> QTYRECVD FLOAT,
> RECRDTYPE CHAR(3),
> LOCATNDEPTCODE CHAR(4),
> ORDRDBYDEPTCODE CHAR(4),
> BACKORDRQTY FLOAT,
> FILLDQTY CHAR(5),
> COMMNLIST CHAR(10),
> ISSUEFROMDEPTCODE CHAR(4),
> CHRGTODEPTCODE CHAR(4),
> POILINK CHAR(8),
> RECRDSTATUSDATE CHAR(8),
> UNITPRICE FLOAT,
> ISSUEIND CHAR(1),
> TYPESWITCH CHAR(1)
> );
> CREATE TABLE INVPO.INVPO_RQM
> (
> PKEY INT PRIMARY KEY not null,
> NXTACT CHAR(10) not null,
> ISSUEIND CHAR(1),
> NXTLVL CHAR(1) not null,
> CHANGETKTNUM CHAR(10),
> ORDRDBYDEPTCODE CHAR(4),
> CHRGTODEPTCODE CHAR(4),
> CREATEDATE CHAR(8),
> PATIENTNAME CHAR(20),
> DELIVRTODEPTCODE CHAR(4),
> INVCEFLAGIND CHAR(1),
> RECRDSTATUSDATE CHAR(8),
> APRVDT CHAR(8) not null,
> GLACCTNUM CHAR(8),
> REQNDATE CHAR(8),
> PATIENTENCNTRNUM CHAR(20),
> RECRDSTATUSCODE CHAR(1),
> REQSTDDELIVRYDATE CHAR(8),
> DELIVRTODEPTLOC CHAR(24),
> REQNNUM CHAR(8),
> ISSUEFROMDEPTCODE CHAR(4),
> REQNTOTLAMT FLOAT,
> RECRDTYPE CHAR(3),
> CAPEXPNSREQST CHAR(20),
> SCHEDDELIVRYDATE CHAR(8),
> COMMNLIST CHAR(10),
> ENTITYCODE CHAR(3),
> APRVTM CHAR(8) not null,
> MODELSERIALNUM CHAR(20),
> OPERTRID CHAR(8),
> REVSDDELIVRYDATE CHAR(8),
> CHGDELIVRYIND CHAR(1),
> PHYSNNAME CHAR(20),
> TYPESWITCH CHAR(1)
> );
> CREATE TABLE INVTBLS.INVTBLS_DEL
> (
> PKEY INT PRIMARY KEY not null,
> LASTCHGDATE CHAR(8),
> LOCATNDESCR CHAR(35),
> ENTITYCODE CHAR(3),
> LOCATNNAME CHAR(30),
> RECRDSTATUSCODE CHAR(1),
> RECRDSTATUSDATE CHAR(8),
> DEPTNUM CHAR(5),
> LOGINID CHAR(8),
> RECRDTYPE CHAR(3)
> );
> CREATE TABLE VENDMSTR.VENDMSTR_SPC
> (
> PKEY INT PRIMARY KEY not null,
> VENDORNUM CHAR(10),
> VENDORNAME CHAR(30),
> RECRDSTATUSCODE CHAR(1),
> RECRDTYPE CHAR(3),
> RECRDSTATUSDATE INT
> );
> CREATE TABLE VENDMSTR.VENDMSTR_VNM
> (
> PKEY INT PRIMARY KEY not null,
> VENDORNUM CHAR(10),
> VENDORNAME CHAR(30),
> RECRDSTATUSCODE CHAR(1),
> RECRDTYPE CHAR(3),
> RECRDSTATUSDATE INT
> );
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>
> !DSPAM:14,44627dfc34494000119241!
>