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 jmpor...@gmail.com
Hi guys,
I cannot debug with pgadmin 1.10.2, I get an error in both
', '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
ok, it's working without the alias inside the SET
thanks
2009/4/24 Filip Rembiałkowski plk.zu...@gmail.com
2009/4/24 josep porres jmpor...@gmail.com
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
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
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 plk.zu...@gmail.com
2009/4/24 josep porres jmpor...@gmail.com
Hello,
I am migrating a database to pg and modifying the app
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 dp...@pgadmin.org
On Mon, Mar 23, 2009 at 1:56 PM, josep porres jmpor...@gmail.com wrote:
well, now a log with only trying to debug setting a breakpoint
Hmmm
your dll's?
2009/3/24 Dave Page dp...@pgadmin.org
On Tue, Mar 24, 2009 at 7:50 AM, josep porres jmpor...@gmail.com wrote:
Ooops, I haven't realized the second schema, I've found the function.
Here you are your test log.
OK, I think we've tracked down the problem. Can I send you some
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 jmpor...@gmail.com
i've just upgraded the server to 8.3.7 holding the same data directory
select * from pldbg_get_proxy_info
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
mmm... my database schema have the pldbg functions.
2009/3/23 Glyn Astill glynast...@yahoo.co.uk
--- On Mon, 23/3/09, josep porres jmpor...@gmail.com 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
yes, i have:
shared_preload_libraries = '$libdir/plugins/plugin_debugger.dll'#
(change requires restart)
2009/3/23 Dave Page dp...@pgadmin.org
On Mon, Mar 23, 2009 at 12:40 PM, josep porres jmpor...@gmail.com wrote:
mmm... my database schema have the pldbg functions.
Do you have
it is Postgres Plus 8.3
Postgres 8.3.4 build 1400
2009/3/23 josep porres jmpor...@gmail.com
yes, i have:
shared_preload_libraries = '$libdir/plugins/plugin_debugger.dll'#
(change requires restart)
2009/3/23 Dave Page dp...@pgadmin.org
On Mon, Mar 23, 2009 at 12:40 PM, josep
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 dp...@pgadmin.org
On Mon, Mar 23, 2009 at 12:50 PM, josep porres jmpor...@gmail.com wrote:
yes, i have
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 dp...@pgadmin.org
On Mon, Mar 23, 2009 at 1:41 PM, josep
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
^
** 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
Josep Porres
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]:
On Mon, Apr
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 [EMAIL
, 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 PROTECTED]:
On Mon, Apr 7, 2008 at 9:40 AM
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]:
On Mon, Apr 7
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, Apr 7, 2008 at 10:21 AM, josep porres [EMAIL PROTECTED]
mailto:[EMAIL
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]:
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
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 12
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 = ' || quote_literal(f2_Mtar
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'Donnell [EMAIL PROTECTED]:
On 26/03/2008 11:59, josep porres wrote:
row_tempf.field1 := value1
as a field,
not good, I changed it.
So now it's working perfectly!!!
Thanks a lot guys!
Josep Porres
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 most important is how can I reference the fields inside de
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
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
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
34 matches
Mail list logo
