Re: [SQL] strange error message

Hi Tom, Cool. Thanks for your answer. Best Regards, Uwe On 25 November 2011 17:43, Tom Lane wrote: > Uwe Bartels writes: > > I've got a strange error message in our java application. > > > ERROR JDBCTransaction:124 - JDBC commit failed > > *org.postgresql.uti

[SQL] strange error message

Hi, I've got a strange error message in our java application. the only reference to this message i find in http://mingo.info-science.uiowa.edu/eichmann/courses/database/Postgres/programmer.pdf

Re: [SQL] using explain output within pgsql

Hi Pavel, is it posible to get this running even with dynamic sql? I didn't write that. I'm using execute to run this create table best regards, Uwe On 10 July 2011 21:20, Pavel Stehule wrote: > Hello > > > > 2011/7/10 Uwe Bartels : > > Hi, > > >

Re: [SQL] using explain output within pgsql

Hi Pavel, I don't believe it. the second answer on sunday evening within half an hour. and it works. excellent!!! best regards, Uwe On 10 July 2011 21:20, Pavel Stehule wrote: > Hello > > > > 2011/7/10 Uwe Bartels : > > Hi, > > > > I'm starting

Re: [SQL] using explain output within pgsql

Hi Adrian, yes. but this is not the cause for the syntax error. thanks, Uwe On 10 July 2011 21:20, Adrian Klaver wrote: > On Sunday, July 10, 2011 11:54:10 am Uwe Bartels wrote: > > Hi, > > > > I'm starting up a datawarehouse with patitioning. > > my etl p

[SQL] using explain output within pgsql

Hi, I'm starting up a datawarehouse with patitioning. my etl processes write directly into the corresponding partitions instead of using triggers. The reports I run in the datawarehouse are stored in a cache within the same database. Now I'd like to store besides the results the dependencies to t

Re: [SQL] plpgsql exception handling

stupid me. I edited a function with the same name, but different parameter types and tested with the other function. so everything works fine. thanks everybody for help. best regards, Uwe On 10 March 2011 11:53, Uwe Bartels wrote: > same same. > all errors including syntax_error ma

Re: [SQL] plpgsql exception handling

same same. all errors including syntax_error match to others, but I checked it again. and the exception remains. Uwe On 10 March 2011 10:56, Samuel Gendler wrote: > > > On Thu, Mar 10, 2011 at 12:45 AM, Uwe Bartels wrote: > >> Hi, >> >> Yes, of course is this

Re: [SQL] plpgsql exception handling

yes, p_id is a variable in my code which is bigger. so ignore the update statement. Uwe On 10 March 2011 01:20, bricklen wrote: > On Wed, Mar 9, 2011 at 2:08 PM, Samuel Gendler > wrote: > > when I run 'select 1count(*) from table' in my postgres 8.4 installation, > I > > get the exact same err

Re: [SQL] plpgsql exception handling

Assuming the '1count()' function does > exist, perhaps you need to full qualify it with a schema name? > > It looks to me like the query you are passing to the procedure is invalid > and is generating the error. Perhaps the 1 in front of count(*) is a typo? > > >

[SQL] plpgsql exception handling

Hi, I'm trying to run an execute with a dynamic sql command within a function. I need a clean exception handling here, but my version does not work somehow. I want to trap a possible syntax error and write the error code, error message and the sql into a table. the function looks similar to this

[SQL] problem with rules

Hi, i'm trying to reorganize a big table without having a downtime at all. I'm trying to realize this via partitioning and rules. - step 1 preparation create table uglybloatedtable (id bigserial, textfield text, primary key(id)); INSERT INTO uglybloatedtable (textfield) values (''); INSERT INTO u