I solved this issue creating the functions again using the script
pldbgapi.sql in
http://pgfoundry.org/frs/download.php/1916/edb-debugger-0.93.tgz
thanks for your support
josep
2010/3/17 josep porres
>
> Hi guys,
>
>
> I cannot debug with pgadmin 1.10.2, I get an error in
plugin_debugger', 'plpgsql_oid_debug'
LANGUAGE 'c' VOLATILE STRICT
COST 1;
ALTER FUNCTION plpgsql_oid_debug(oid) OWNER TO postgres;
Do I have to exec any script to have the correct functions or something like
that?
What's going wrong? Could you give me any tip?
Thanks
Josep Porres
So, what's the point of the alias in the documentation?
-> http://www.postgresql.org/docs/current/static/sql-update.html
2009/4/24 Filip Rembiałkowski
>
>
> 2009/4/24 josep porres
>
>> Hello,
>>
>> I am migrating a database to pg and modifying the app.
&
ok, it's working without the alias inside the SET
thanks
2009/4/24 Filip Rembiałkowski
>
>
> 2009/4/24 josep porres
>
>> Hello,
>>
>> I am migrating a database to pg and modifying the app.
>> In that process I found an error and i don't see the r
Hello,
I am migrating a database to pg and modifying the app.
In that process I found an error and i don't see the reason.
It's happening when executing the next update sentence
Do you see what's wrong?
The server is pg8.3.7 for w32
___
by the way, after upgrading, i get the same behaviour
even executing the function in a query window created after setting the
breakpoint.
2009/3/24 josep porres
> i've just upgraded the server to 8.3.7 holding the same data directory
>
> select * from pldbg_get_proxy_info();
>
GCC) 3.4.2
(mingw-special)",80300,3,2948
is it ok for testing your dll's?
2009/3/24 Dave Page
> On Tue, Mar 24, 2009 at 7:50 AM, josep porres wrote:
> > Ooops, I haven't realized the second schema, I've found the function.
> > Here you are your test log.
>
good morning,
I have a demo database, but it's empty.
if you tell me where is the creation script, I will try it
2009/3/23 Dave Page
> On Mon, Mar 23, 2009 at 1:56 PM, josep porres wrote:
> > well, now a log with only trying to debug setting a breakpoint
>
> Hmmm - do you
in the previous action, first of all I made a breakpoint and called the
function from a query window.
nothing happened, the only thing i got: the result.
All actions are in the previous log.
Is it what you want?
2009/3/23 Dave Page
> On Mon, Mar 23, 2009 at 1:41 PM, josep porres wr
"serverversionstr","serverversionnum","proxyapiver","serverprocessid"
"PostgreSQL 8.3devel on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.4.2
(mingw-special)",80300,3,4220
2009/3/23 Dave Page
> On Mon, Mar 23, 2
it is Postgres Plus 8.3
Postgres 8.3.4 build 1400
2009/3/23 josep porres
> yes, i have:
> shared_preload_libraries = '$libdir/plugins/plugin_debugger.dll'#
> (change requires restart)
>
>
> 2009/3/23 Dave Page
>
> On Mon, Mar 23, 2009 at 12:40 PM, jo
yes, i have:
shared_preload_libraries = '$libdir/plugins/plugin_debugger.dll'#
(change requires restart)
2009/3/23 Dave Page
> On Mon, Mar 23, 2009 at 12:40 PM, josep porres wrote:
> > mmm... my database schema have the pldbg functions.
>
> Do you have so
mmm... my database schema have the pldbg functions.
2009/3/23 Glyn Astill
>
>
> --- On Mon, 23/3/09, josep porres wrote:
>
> > A lot of time since the last debugging activity.
> > I don't remember how to debug. I thought I had to set a
> > breaking point
Hi all
A lot of time since the last debugging activity.
I don't remember how to debug. I thought I had to set a breaking point in
the function i want to debug,
and then call that function.
I'm doing this, and from another query window, i call the function. But it
returns me the result, but it does
No problems here.
create table regions (id integer, name varchar);
alter table regions alter column name set default 'bavaria';
PostgreSQL 8.3.1 vc++ build 1400 xp sp2
# - Memory -
shared_buffers = 32MB# min 128kB or max_connections*16kB
# (change requires rest
from tmp_claus_prova
^
** Error **
ERROR: no existe la columna «clau»
Estado SQL:42703
Caracter: 188
The question is:
Is it a normal behaviour? Because I think that if the query is wrong,
wouldn't be better to raise an error?
Regards,
Josep Porres
thanks Tony,
I'm going to take a look to it tomorrow morning.
Josep Porres
2008/4/7, Tony Caduto <[EMAIL PROTECTED]>:
>
> josep porres wrote:
>
> >
> > 2008/4/7, Dave Page <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>>:
> >
> >On Mon,
if I try to close the parameter window using X button instead of Cancel,
it's the same.
It's a bit annoying when I finnish debugging, but I can debug, so it's fine
:)
I will be looking forward new versions.
thanks again Dave
Josep Porres
2008/4/7, Dave Page <[EMAIL PROTECTED]
fo(
'16439', 'o' ) t , pg_namespace n, pg_language l, pg_proc p, pg_type y
where n.oid = t.schema and l.oid = t.targetlang and p.oid = t.target
and y.oid = t.returntype
2008-04-07 11:05:08 QUERY : SELECT version();
thanks dave
Josep Porres
2008/4/7, Dave Page <[EMAIL PROT
I downloaded it from:
http://www.postgresql.org/ftp/pgadmin3/release/v1.8.2/win32/
spaninsh http mirror
http://wwwmaster.postgresql.org/download/mirrors-ftp?file=%2Fpgadmin3%2Frelease%2Fv1.8.2%2Fwin32%2Fpgadmin3-1.8.2-2.zip
Is this version wrong?
Josep Porres
2008/4/7, Dave Page <[EM
ok, thx,
I can debug from server pgadmin which ships with pg8.3 (1.8.2 rev 7030),
because it runs on windows,
but in the client side, running pgadmin1.8.2 rev 7050 it seems to hang, it
freezes.
Do I need to config anything?
thx
Josep Porres
2008/4/7, Dave Page <[EMAIL PROTECTED]>:
>
ight?
thx
Josep Porres
hh ok
greatest()/least()
2008/4/1, josep porres <[EMAIL PROTECTED]>:
>
> I cannot find predefined functions to find minimum and maximum of at least
> two values.
> Aren't there any?
>
> select min(3,6)
> 3
>
> select max(3,6)
> 6
>
>
>
> Josep Porres
>
I cannot find predefined functions to find minimum and maximum of at least
two values.
Aren't there any?
select min(3,6)
3
select max(3,6)
6
Josep Porres
maybe you don't need PL/Java...
You are trying to connect using JDBC, right?
Take a look at http://jdbc.postgresql.org/doc.html
Which errors do you get?
Is the server listening on standard port?
anyway, you have to provide more information.
Josep
2008/3/30, Vismaster46 <[EMAIL PROTECTED]>:
>
>
maybe this?
select value, max(id) as id, max(order_field) as order_field
from mytable
group by value
order by 3
2008/3/28, Stanislav Raskin <[EMAIL PROTECTED]>:
>
> Hello everybody,
>
>
>
> I have a table like this one:
>
>
>
> id value order_field
>
> 1 103
>
> 2
Hi guys,
Is there any other online place, apart from
http://www.postgresql.org/docs/8.3/static/plpgsql.html ,
to get a reference or a wider explanation of PL/pgSQL ?
Do you recommend any book?
thx
Josep Porres
same as a field,
not good, I changed it.
So now it's working perfectly!!!
Thanks a lot guys!
Josep Porres
ot;f2_facturar" line 437 at EXECUTE statement
I'm going to try your suggestion, however it's a bit annoying because this
table has a lot of fields.
maybe i'm lazy to write all of them :P ...
well... hands on it!!!
thx
Josep
2008/3/26, Raymond O'Do
the table
f2_tempfac? Can I use the execute command for that?
Thanks!
Josep Porres
DECLARE
row_tfa f2_tarifa_a%rowtype;
row_tempff2_tempfac%rowtype;
...
BEGIN
...
BEGIN
EXECUTE 'SELECT * FROM F2_TARIFA_A
WHERE (TIPUS = ' || q
row using that string?
something like this
s:='PREU1';
row_tfa.s := x;
anyway, I a completely newbie in pgplsql, and I see my way of thinking is
not pgplsql
thanks
Josep Porres
2008/3/13, Craig Ringer <[EMAIL PROTECTED]>:
>
> josep porres wrote:
>
> > but the mo
Hi everyone,
I'm trying to port some vb6 code to pgplsql (PostgreSQL 8.3 winxp)
that code is
Const f2_MAX_TRAMS = 5
Dim f2_rTarifaA as new ADODB.Recordset
Dim Mpa(f2_MAX_TRAMS) As Double ' preu aigua
Dim Ma(f2_MAX_TRAMS) As Long' m3 aigua tarifa
Dim i As Integer, j As
Hi everyone,
I'm trying to port some vb6 code to pgplsql (PostgreSQL 8.3 winxp)
that code is
Const f2_MAX_TRAMS = 5
Dim f2_rTarifaA as new ADODB.Recordset
Dim Mpa(f2_MAX_TRAMS) As Double ' preu aigua
Dim Ma(f2_MAX_TRAMS) As Long' m3 aigua tarifa
Dim i As Integer, j As
Hi everyone,
I'm trying to port some vb6 code to pgplsql (PostgreSQL 8.3 winxp)
that code is
Const f2_MAX_TRAMS = 5
Dim f2_rTarifaA as new ADODB.Recordset
Dim Mpa(f2_MAX_TRAMS) As Double ' preu aigua
Dim Ma(f2_MAX_TRAMS) As Long' m3 aigua tarifa
Dim i As Integer, j As
34 matches
Mail list logo
