Hello,
On Wed, 2017-08-23 at 17:23 +0200, Frank Foerster wrote:
>
>
>
> But the created statement looks syntax-wise identical to the pgadmin-
> statement (except for the forced error of course):
>
> select * from api_dev.add_texts_to_item( 444, array['PGADM1',
> 'PGADM2'] );
>
>
>
I don't
Thanks, that was it. I did not commit as i was calling "only" a
select-statement.
Thanks
2017-08-23 18:20 GMT+02:00 Daniele Varrazzo :
> On Wed, Aug 23, 2017 at 4:23 PM, Frank Foerster
> wrote:
>
> > Any ideas ?
>
> commit?
>
> -- Daniele
>
On Wed, Aug 23, 2017 at 4:23 PM, Frank Foerster wrote:
> Any ideas ?
commit?
-- Daniele
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Wed, Aug 23, 2017 at 8:23 AM, Frank Foerster wrote:
>
> sql = "select * from api_dev.add_texts_to_item( %s, %s ); x x"
> i get the following python-error:
> psycopg2.ProgrammingError: FEHLER: Syntaxfehler bei »s«
> LINE 1: ...dd_texts_to_item( 1234,
Hi,
i have the following question:
Given an empty database with only schema api_dev in it, a table and a
function is created as follows:
CREATE TABLE api_dev.item_texts
(
item_id integer,
item_text text
)
WITH (
OIDS=FALSE
);
CREATE OR REPLACE FUNCTION api_dev.add_texts_to_item(