Looks to me as though you are not the owner of the schema nor superuser
nor in a role with permission to create tables in said schema. See the
DBA if it's not you. If it is sign on as postgres (superuser) and grant
yourself some access rights.
Venkateswara Rao Bondada wrote:
Hi,
I’m new t
Hi,
I'm new to PostgreSQL, and currently facing an issue with PostgreSQL 7.4
database. I'm getting the following error when tried to create a table. Please
let me know the steps (with queries) that I should take care to resolve this
issue.
cms=# create table test(id character varying(80));
ERRO
I get an error when I'm trying to fill my table with data. I have a
postgresql dump file and copy-paste the text from the file into my
webbased phppgadmin interface. I have created my tables correctly.
Down here I have post the error message I get. I suppose it's something
with the tab between "5"
I get an error when I'm trying to fill my table with data. I have a
postgresql dump file and copy-paste the text from the file into my
webbased phppgadmin interface. I have created my tables correctly.
Down here I have post the error message I get. I suppose it's something
with the tab between
It seems not trivial to acheive what I wanted so I have decided to
move on
to get a grip of the smarty object that is also around but after the
blackbox
of scripts has run instead of before. This obejct can be parsed and is
generic
enough for my purposes.
Thanks for your time and suggestions.
/ A
Hi All,
Is there a way I can get activity count of previously run sql to do
some quick error checks.
Say like I ran a select query on an error table and if the activity
count shows that the select query resulted in 10 rows, I want the
process to show failure status. Can this be tracked in pgsql?