From: | Yan Yan Che <yanyan_che(at)yahoo(dot)com(dot)au> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Pls Help me: access problems to tables |
Date: | 2003-03-14 03:10:00 |
Message-ID: | 20030314031000.43425.qmail@web20510.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Dear friends,
I logged on windows as a LAN user (so i'm not a domain user of the computer), then i installed postmaster, initdb and created database all under my LAN logon (which is yanyanc).
All went well! and i was able to run a script that i wrote which basically populates schema and all the tables for the database i just created.
then i tried to run another script which basically 'inserts' many records to the tables in the database that i've just created. but postgres seemed not to allow me to access any relations(tables). i tried select * from <relationname> and the <relationname> is always 'Not Found'. (But i've just inserted the relation and it can be viewed via PgAdmin!!!)
However when i use PGAdmin, and select the table i just created and then go to 'view data' then 'add', then i can add records one by one. However, it still won't allow me to load a script which inserts records.
I am wondering why aren't i allowed to access the tables/relations via 'select' and 'insert' statements while i am the owner of the database cluster, the database and all the tables?
i remembered that i once logged on as a domain/local user of the computer and did the same thing and i can insert records and select them without problem. my question is why would it be different when i create the db as a LAN login user? is there any way around it?
Thank you so much for your time and attention!
yours sincerely,
yan yan che
---------------------------------
Yahoo! Mobile
- Check & compose your email via SMS on your Telstra or Vodafone mobile.
From | Date | Subject | |
---|---|---|---|
Next Message | Joe Hudson | 2003-03-14 03:30:00 | inserts slow on table of about 600K recs |
Previous Message | G. Anthony Reina | 2003-03-14 02:52:52 | Re: Password authentication |