[SQL] Activity count problem
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? Please help me out with this. Thanks, Dino -- Sent via pgsql-sql mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
Re: [SQL] Tweak sql result set... ?
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. / Axe -- Sent via pgsql-sql mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
[SQL] Problems when copy data from dump file
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" and the text? I have tried to make both tab and single space but I get the same error both times. SQL error: ERROR: syntax error at or near "5" LINE 2: 5 Slitasje og vedlikehold PRAKTISKE OPPLYSNINGER\r\n\r\nSn&#... ^ COPY artikkel (id, tittel, tekst) FROM stdin; 5Slitasje og vedlikeholdPRAKTISKE OPPLYSNINGER\r\n\r\nSnø og is.\r\nSnør...and more text... \. Does anyone have some tips to an solution? The postgresql version is 7.4.17.
[SQL] Problems when copy data from dump file
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" and the text? I have tried to make both tab and single space but I get the same error both times. SQL error: ERROR: syntax error at or near "5" LINE 2: 5 Slitasje og vedlikehold PRAKTISKE OPPLYSNINGER\r\n\r\nSn&#... ^ COPY artikkel (id, tittel, tekst) FROM stdin; 5Slitasje og vedlikeholdPRAKTISKE OPPLYSNINGER\r\n\r\nSnø og is.\r\nSnør...and more text... \. Does anyone have some tips to an solution? The postgresql version is 7.4.17.
[SQL] Create table command fails with permission denied
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)); ERROR: could not create relation "test": Permission denied Thanks in advance, Venkat
Re: [SQL] Create table command fails with permission denied
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 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)); ERROR: could not create relation "test": Permission denied Thanks in advance, Venkat -- Sent via pgsql-sql mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
