[SQL] Activity count problem

2009-08-03 Thread dino
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?

Re: [SQL] Tweak sql result set... ?

2009-08-03 Thread Axe
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

[SQL] Problems when copy data from dump file

2009-08-03 Thread Klas Stockhem
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

[SQL] Problems when copy data from dump file

2009-08-03 Thread Klas Stockhem
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"

[SQL] Create table command fails with permission denied

2009-08-03 Thread Venkateswara Rao Bondada
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

Re: [SQL] Create table command fails with permission denied

2009-08-03 Thread Rob Sargent
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