Re: [HACKERS] GSoC - proposal - Materialized Views in PostgreSQL

2010-04-20 Thread Pavel
that's been broken into those two major chunks. Anyway thanks for all of your advices and help. best regards, Pavel Baros -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

[HACKERS] Snapshot Materialized Views - GSoC

2010-05-20 Thread Pavel
First of all, I really appreciate you gave me change to participate on GSoC. It's great chance for me. For this summer I have plan to make patch inplementing snapshot materialized views (MV). I believe it will not be end of effort to implement more of MV. But I / we need discuss MV syntax and

Re: [HACKERS] GSoC - code of implementation of materialized views

2010-07-08 Thread Pavel
Dne 8.7.2010 12:33, Robert Haas napsal(a): 2010/6/29 Pavel Barošbaro...@seznam.cz: Yeah, it is my fault, I did not mentioned that this patch is not final. It is only small part of whole implementation. I wanted to show just this, because I think that is the part that should not change much

[HACKERS] why I need col. def. list with setof record?

2003-12-05 Thread Pavel Stehule
, 2, idv, VARCHAROID, -1, 0, false); Why I have to duplicate to? Thank You Pavel Stehule ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your

Re: [HACKERS] Error with returning SETOF Record

2003-12-29 Thread Pavel Stehule
! end;' LANGUAGE 'plpgsql' VOLATILE; Regards Pavel ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])

[HACKERS] Problems with insert rule called from plpython

2003-02-14 Thread Pavel Hanak
not member of any postgresql mailing list. Thanks. -- Pavel Hanak ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])

Re: [HACKERS] Nested Transactions, Abort All

2004-07-09 Thread Pavel Stehule
, is good idea use keywords begin sub and end sub? Programmers like me will be an problems with reading and writing SP, because begin sub and mostly end sub are keywords from visual basic with different sense. BEGIN SUBTRANSACTION and END SUBTRANSACTION is longer but more readable regards Pavel

[HACKERS] too short string for SQL in pg_stat_backend_activity

2004-08-17 Thread Pavel Stehule
is, becouse I can see only begin of queries in pg_stat_activity, and in this view is text of query cut on 1Kb. Can I set somewhere an long for text, which is in current_query in pg_catalog.pg_stat_activity? Regards Pavel Stehule ---(end of broadcast

[HACKERS] Add TODO, plpgsql exception, others, variables sqlcode and sqlerrm

2004-08-24 Thread Pavel Sthule
Hello Exceptions are very usefull and nice, thanks. But, I didn't find any possibility to get any information about exception when I use EXCEPTION WHEN OTHERS THEN. Oracle has two wariables SQLCODE and SQLERRM. Regards Pavel Stehule ---(end of broadcast

Re: [HACKERS] PROPOSAL - User's exception in PL/pgSQL

2005-06-21 Thread Pavel Stehule
On Tue, 21 Jun 2005, Tom Lane wrote: Pavel Stehule [EMAIL PROTECTED] writes: I wont to prohibit synonyms in exception (every exception has unique sqlstate). I don't think that's a particularly good idea --- maybe if SQL had been designed according to your worldview, it'd be like

Re: [HACKERS] pl/pgsql: END verbosity

2005-06-22 Thread Pavel Stehule
forms if they like. Hello, I prefer actual syntax too, Neil. The reason isn't compatibility with Oracle, but better readibility - it's mean more work with finishing code but less with debugging Regards Pavel ---(end of broadcast)--- TIP 3

[HACKERS] pl/pgsql: END verbosity [patch]

2005-06-26 Thread Pavel Stehule
Hello this patch allows optional using label with END and END LOOP. Ending label has only informational value, but can enhance readability large block and enhance likeness with Oracle. mainLOOP ... ... END LOOPmain; Regards Pavel Stehule diff -c -r --new-file pgsql/doc/src/sgml/plpgsql.sgml

Re: [HACKERS] pl/pgsql: END verbosity

2005-06-26 Thread Pavel Stehule
can adapt gram.y plpgsql to psm Regards Pavel Stehule ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [HACKERS] Implementing SQL/PSM for PG 8.2

2005-06-26 Thread Pavel Stehule
statements, with efectivity evaluation of expr, but parser is clean (in my opinion). what have to be rewriten? Regards Pavel Stehule ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] Implementing SQL/PSM for PG 8.2 - debugger

2005-06-28 Thread Pavel Stehule
On Tue, 28 Jun 2005, Dave Cramer wrote: One thing bytecode would allow us to do is to write a debugger with break points etc. We can write debugger with breakpoints without bytecode. Every stmt rec can have flag if has breakpoints. No problem. I don't see any advance of bytecode. Maybe,

Re: [HACKERS] Implementing SQL/PSM for PG 8.2 - debugger

2005-06-28 Thread Pavel Stehule
What do you think you need for enhanced protocol ? What I need? Some like synchronous elog(NOTICE,''), which can return some user's interaction, if it's possible. I didn't find how I do it with current set of messages. But my knowleadges of protocol are minimal. Pavel

Re: [HACKERS] Implementing SQL/PSM for PG 8.2 - debugger

2005-06-28 Thread Pavel Stehule
On Tue, 28 Jun 2005, Tom Lane wrote: Pavel Stehule [EMAIL PROTECTED] writes: What do you think you need for enhanced protocol ? What I need? Some like synchronous elog(NOTICE,''), which can return some user's interaction, if it's possible. I didn't find how I do it with current set

Re: [HACKERS] Implementing SQL/PSM for PG 8.2 - debugger

2005-06-28 Thread Pavel Stehule
On Tue, 28 Jun 2005, Dave Cramer wrote: Pavel, I am in agreement with Tom here, we should use a separate port, and protocol specifically designed for this. My understanding is that this protocol would be synchronous, and be used for transferring state information, variables, etc back

Re: [HACKERS] Implementing SQL/PSM for PG 8.2 - debugger

2005-06-28 Thread Pavel Stehule
I lean with you and Tom. While running it over the same libpq protocol would be helpful in some ways, it would have a lot of drawbacks and would really change the function of libpq. I think a separate debugging protocol is in order. One message? I can't belive :). work on it (ANTLR

Re: [HACKERS] Implementing SQL/PSM for PG 8.2 - debugger

2005-06-28 Thread Pavel Stehule
There's going to be a painful period later this year when Mysqueel is able to claim that their production db has more ansi compatability than PG (at least for triggers and stored procs). MySQL5 is really comparable with Pg8, but Firebird2 or SQLlite3 too. But from my perspective procedural

[HACKERS] Proposal: associative arrays for plpgsql (concept)

2005-06-29 Thread Pavel Stehule
); delete(x, key); index is accessable only from PL/pgSQL. Associative arrays can be spec PostgreSQL type or clasic arrays with hash index. Comments, notes? Regards Pavel Stehule ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner

[HACKERS] problem with plpgsql

2005-06-29 Thread Pavel Stehule
NOTICE: 3486004 NOTICE: 419 NOTICE: 420 NOTICE: 421 NOTICE: 157207208 NOTICE: 16 Can you help me, what I do wrong? Thank You Pavel Stehule ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate

Re: [HACKERS] Proposal: associative arrays for plpgsql (concept)

2005-06-29 Thread Pavel Stehule
On Wed, 29 Jun 2005, Josh Berkus wrote: Pavel, The concept is from Oracle 9i, but with some changes. http://www.oracle-10g.de/oracle_10g_documentation/appdev.101/b10807/05_coll s.htm#i35672 How does this match the SQL2003 spec? I don't know. What I can read about it, it's

Re: [HACKERS] Proposal: associative arrays for plpgsql (concept)

2005-06-29 Thread Pavel Stehule
have procedure witch operate over big arrays of numbers(prices) and I need save somewhere this arrays if I don't wont to read them again and again. And if I have in data identification by key, I everytime have to find key, and translate it into number Regards Pavel Stehule

[HACKERS] Qustions about timestampz

2005-08-04 Thread Pavel Stehule
19:00:00+01 or ??? There are somewhere some rules about behavior timestamp with time zone? Thenk You Pavel Stehule _ Citite se osamele? Poznejte nekoho vyjmecneho diky Match.com. http://www.msn.cz/ ---(end

[HACKERS] when started century? PostgreSQL vs Oracle diff

2005-09-16 Thread Pavel Stehule
Hello I am testing comformity between PostgreSQL and Oracle. I found one difference. Century started 1900-01-01 for Oracle and 1901-01-01 for PostgreSQL. What value is good? Best regards Pavel Stehule _ Chcete sdilet sve

[HACKERS] SQL/XML public functions documentation for PostgreSQL 8.2

2005-09-22 Thread Pavel Stehule
Hello, I did patch http://archives.postgresql.org/pgsql-patches/2005-09/msg00050.php SQL/XML public functions. Can somebody help me with documentation? Or can somebody write doc.. Regards Pavel Stehule _ Najdete si svou lasku

[HACKERS] current_user versus current_role

2005-10-05 Thread Pavel Stehule
possibility get identity of user without impact of change of role? (default role?) thank you Pavel Stehule _ Chcete sdilet sve obrazky a hudbu s prateli? http://messenger.msn.cz/ ---(end of broadcast

Re: [HACKERS] current_user versus current_role SOLVED

2005-10-06 Thread Pavel Stehule
session_user for this. -- it's exactly it what I want. Thank You Pavel Stehule _ Najdete si svou lasku a nove pratele na Match.com. http://www.msn.cz/ ---(end of broadcast)--- TIP 9

[HACKERS] some interes. doc about job scheduling

2005-10-20 Thread Pavel Stehule
Hello I found relative good thesis about job scheduling http://hristov.com/master_thesis_final.pdf it's implementation j.s. for mysql5. It's can be usefull for somebody best regards Pavel Stehule _ Citite se osamele? Poznejte

[HACKERS] I can't get row type from tuple (SPI)

2005-11-06 Thread Pavel Stehule
)); = ((1,2,3)) Can I get inner tupdesc without lookup_rowtype_tupdesc? Thank you very much Pavel Stehule _ Citite se osamele? Poznejte nekoho vyjmecneho diky Match.com. http://www.msn.cz/ ---(end of broadcast

Re: [HACKERS] Supporting NULL elements in arrays

2005-11-08 Thread Pavel Stehule
isHash? So, hash array can be in line array-null array-hash array or flag for nor regular array (sparse array), not type unique arrays (array can contains different types) Regards Pavel Stehule _ Citite se osamele? Poznejte nekoho

Re: [HACKERS] Function with Variable number of parameters

2005-11-08 Thread Pavel Stehule
) Regards Pavel Stehule _ Chcete sdilet sve obrazky a hudbu s prateli? http://messenger.msn.cz/ ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send

[HACKERS] request for enhancement of protocol

2005-11-19 Thread Pavel Stehule
steps (example): generate view, select from view. This is difference between procedures and functions. Function have to have exactly defined interface. Procedures can't. 3. easy porting from databases which support this style. sorry for my wrong english. best regards Pavel Stehule

Re: [HACKERS] request for enhancement of protocol

2005-11-19 Thread Pavel Stehule
which support this style. Ok, valid point. Interesting points all, but they seem to be more backend related than protocol related. I spent some time for looking way for implementing this into plpgsql. I didn't find it. It's part of SPI too. Pavel

Re: [HACKERS] Returning multiple result sets

2005-11-19 Thread Pavel Stehule
Consider: create function a(anyrecord) returns anyrecord; create function b(int4) returns anyrecord; select a(b(2)); for my task I need little different form :-( create function a(..) returns setof tables but SQL2003 needs type table, and this can be solution

Re: [HACKERS] Returning multiple result sets

2005-11-20 Thread Pavel Stehule
temptab2; a := true; end; I don't have better words :-). I am sorry. I don't wont to complicate internal structure of planer, executor, etc ... Procedures are different than functions, and can be executed different, Isn't possible using procedure in params list. Nice day Pavel

Re: [HACKERS] Returning multiple result sets

2005-11-20 Thread Pavel Stehule
in code. I think, this need bigger changes and support next class of stored objects. best regards Pavel Stehule _ Emotikony a pozadi programu MSN Messenger ozivi vasi konverzaci. http://messenger.msn.cz

Re: [HACKERS] MS SQL Server compatibility functions

2005-11-23 Thread Pavel Stehule
Hello DB2, MySQL and MsSQL has shared group of function (date, time, strings). You can do it a bit complex - use variable which direct behavior, but there isn't bigger differences, I hope. Please (for start), use mycode, orafunc from pgfoundry. Regards Pavel Stehule From: Christopher

Re: [HACKERS] NVL vs COALESCE

2005-11-24 Thread Pavel Stehule
When we're having an alias discussion, I'd really like to see NVL in postgres. Not because of porting from oracle as much as just spelling that without the reference manual is completely impossible. Best regards, Marcus You can found NVL in orafunc on pgfoundry. Regards Pavel Stehule

[HACKERS] Delphi+pqsql

2005-01-08 Thread Ales Pavel
I want make some components for pqsql + Delphi, exists some PQ API ? Thanks Aldik Czech Republic ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that

Re: [HACKERS] Delphi+pqsql

2005-01-08 Thread Pavel Stehule
On Sat, 8 Jan 2005, Ales Pavel wrote: I want make some components for pqsql + Delphi, exists some PQ API ? Thanks Aldik Czech Republic Hello yes, comercial http://www.vitavoom.com/Products/ dbexpress driver, clasic ODBC or postgresdac http://www.sharewareconnection.com/postgresdac.htm

[HACKERS] Slow PL/pgSQL 8.0.RC5 (7.4.6. 3times faster)

2005-01-13 Thread Pavel Stehule
, int) RETURNS int AS ' DECLARE a integer; b integer; BEGIN a := $1; b := $2; WHILE a b LOOP IF a b THEN a := a - b; ELSE b := b - a; END IF; END LOOP; RETURN a; END; ' LANGUAGE plpgsql; Regards Pavel Stehule ---(end of broadcast)--- TIP 1

Re: [HACKERS] Slow PL/pgSQL 8.0.RC5 (7.4.6. 3times faster)

2005-01-13 Thread Pavel Stehule
and what can be impacts on speed for my aplication. Iam not sure if I understand well. Pavel Stehule ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL

Re: [HACKERS] Slow PL/pgSQL 8.0.RC5 (7.4.6. 3times faster)

2005-01-13 Thread Pavel Stehule
and some basic arithmetic operations. On Thu, 13 Jan 2005, Michael Fuhr wrote: On Thu, Jan 13, 2005 at 05:05:00PM -0500, Tom Lane wrote: Pavel Stehule [EMAIL PROTECTED] writes: And? (ie, what test case are you talking about?) This test is function for searching max factor

Re: [HACKERS] Slow PL/pgSQL 8.0.RC5 (7.4.6. 3times faster)

2005-01-14 Thread Pavel Stehule
Hello, with IMMUTABLE or STABLE function is only 7% slowly. It can be usefull add into documentation so default flag is immutable, but if its not necessary its recommended IMMUTABLE or STABLE flag. Regards Pavel Stehule ---(end of broadcast

[HACKERS] slow SP with temporary tables, any idea of solution?

2005-02-09 Thread Pavel Stehule
EXECUTE command. But all is inpossible now. Can you help me other possibilities? Thank you Pavel Stehule ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] slow SP with temporary tables, PLPGSQL problems

2005-02-10 Thread Pavel Stehule
Pavel Stehule [EMAIL PROTECTED] writes: Can you help me other possibilities? Create the temp table only once per connection (you can use ON COMMIT DELETE ROWS instead of ON COMMIT DROP to clean it out). Then you won't need to use EXECUTE. I am not sure so it's possible. I use persistent

Re: [HACKERS] slow SP with temporary tables, PLPGSQL problems

2005-02-13 Thread Pavel Stehule
FROM. It's not true for small temp tables. On my computer TRUNCATE needs 100ms and DELETE 8ms. It's general or any exception? Thank You Pavel Stehule ---(end of broadcast)--- TIP 6: Have you searched our list archives? http

Re: [HACKERS] SQL99 Hierarchical queries

2005-02-27 Thread Pavel Stehule
hello, I tested you patch, and it's good work. I would all methods in PostgreSQL. I found query which kill backand WITH t AS ( SELECT 0::int AS i UNION ALL SELECT i + 1 FROM t WHERE i 100) SELECT * FROM t; Regards Pavel Stehule ---(end of broadcast

Re: [HACKERS] SQL99 Hierarchical queries

2005-02-28 Thread Pavel Stehule
support all syntax H.Q. Is more easy created question via Oracle syntax, and processing is faster (maybe better optimalisation now), than ANSI WITH syntax. Can You add support for clausule VALUE? Pavel Stehule ---(end of broadcast)--- TIP 2: you can

Re: [HACKERS] Exception ERROR Code

2005-03-05 Thread Pavel Stehule
Hello, It's no possible now. But I prepared small patch which implemented variables sqlcode and sqlerrm for plpgsql. I can send it tomorrow. regards Pavel Stehule On Sat, 5 Mar 2005, Ali Baba wrote: Hi , I am looking for the way to get the error code corresponding to the exception

[HACKERS] Implementation of SQLCODE and SQLERRM variables for PL/pgSQL

2005-03-06 Thread Pavel Stehule
trap_exceptions - (1 row) DROP FUNCTION Regards, Pavel Stehule -- -- Test of built variables SQLERRM and SQLCODE -- create or replace function trap_exceptions() returns void as $_$ begin begin raise exception 'first exception'; exception when others then raise

Re: [HACKERS] Implementation of SQLCODE and SQLERRM variables for

2005-03-06 Thread Pavel Stehule
able create documentation - my english is poor. I will change diff's format and send patch again. Thank you Pavel ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister

Re: [HACKERS] custome exception handling support ?

2005-03-20 Thread Pavel Stehule
-structures.html#PLPGSQL-ERROR-TRAPPING But in this time is inpossible get details about exception. Regards Pavel Stehule ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [HACKERS] Proposal: OUT parameters for plpgsql

2005-03-21 Thread Pavel Stehule
command for variables DECLARE b integer; SELECT fce(10, b); fce --- t SELECT b; b -- 10 This is (I think) more standard behavior. Regards Pavel Stehule ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command

Re: [HACKERS] Foreign keys on array elements

2005-04-20 Thread Pavel Stehule
]; IF NOT FOUND THEN RAISE EXCEPTION '..'; END IF; END LOOP; RETURN NEW; END; $$ LANGUAGE plpgsql; CREATE TRIGGER foo BEFORE INSERT OR UPDATE ON ... FOR EACH ROW EXECUTE PROCEDURE check_(); Regards Pavel Stehule ---(end of broadcast

Re: [HACKERS] bitmapscan test, no success, again

2005-04-26 Thread Pavel Stehule
of constant contains equals values. Is possible remove it? explain analyze select count(*) from foo where v in (11,11,11,12) Regards Pavel Stehule ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] bitmapscan test, no success, bs is not faster

2005-04-27 Thread Pavel Stehule
On Tue, 26 Apr 2005, Tom Lane wrote: Pavel Stehule [EMAIL PROTECTED] writes: I tested bitmap scan and maybe I didnt find good examples, but with bitmap scan is slower than hashjoin. Only when I use non otiptimized SELECT bps was little bit faster. All my SELECTs are equal. Bitmap

Re: [pgsql-advocacy] [HACKERS] Increased company involvement

2005-05-03 Thread Pavel Stehule
for 2PC, hiearch queries, and ... PostgreSQL isn't only sw for me, it's more like idol :-) Best Regards, Pavel Stehule ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's

[HACKERS] PROPOSAL - User's exception in PL/pgSQL

2005-06-16 Thread Pavel Stehule
Pavel Stehule Regres test: create function innerfx() returns integer as $$ declare my_excpt exception = 'U0001'; begin -- using msgtext as one param of exception raise exception my_excpt '%', CURRENT_TIMESTAMP; return 1; end $$ language plpgsql; psql:regres.sql:6: ERROR: Invalid class

[HACKERS] Proposal - Continue stmt for PL/pgSQL

2005-06-16 Thread Pavel Stehule
, but via last discussion I have opinion so Oracle compatibility isn't main objective PL/pgSQL. There is some less/bigger diferencess: SQLSTATE, EXCEPTION from my last proposal, atd. What do you think about it? Regards Pavel Stehule ---(end of broadcast

Re: [HACKERS] PROPOSAL - User's exception in PL/pgSQL

2005-06-16 Thread Pavel Stehule
On Thu, 16 Jun 2005, Josh Berkus wrote: Pavel, o User can specify SQLSTATE only from class 'U1' o Default values for SQLSTATE usr excpt are from class 'U0' o Every exception's variable has unique SQLSTATE o User's exception or system's exception can be raised only with level

Re: [HACKERS] Proposal - Continue stmt for PL/pgSQL

2005-06-16 Thread Pavel Stehule
On Thu, 16 Jun 2005, Josh Berkus wrote: Pavel, Statement CONTINUE isn't in PL/SQL too, I know it, but Oracle PL/SQL has statement GOTO. I don't need GOTO statement, but 'continue' can be very usefull for me. I have to do some ugly trick now. With little change, we can enhance stmt

Re: [HACKERS] Proposal - Continue stmt for PL/pgSQL

2005-06-16 Thread Pavel Stehule
On Thu, 16 Jun 2005, Tom Lane wrote: Pavel Stehule [EMAIL PROTECTED] writes: BEGIN CONTINUE WHEN i = 10; RAISE NOTICE '---1---'; END; I find that really ugly and confusing. If we add a CONTINUE it's only sensible to allow it inside a loop --- otherwise it's just

Re: [HACKERS] Proposal - Continue stmt for PL/pgSQL

2005-06-16 Thread Pavel Stehule
stmt means relative big changes in source code. Pavel I agree with Tom that it should only be allowed inside a loop. cheers andrew ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

[HACKERS] space for optimalization: DISTINCT without index

2005-12-12 Thread Pavel Stehule
Hello I did some test and I can see so DISTINCT works well on indexed columns, but is slow on derived tables without indexes. If I use without distinct group by I get much better times. SELECT DISTINCT a, b FROM tab SELECT a,b FROM tab GROUP BY a, b. Can You Explain it. Thank You Pavel

[HACKERS] ANSI SQL, CASE expression Conformance F262, F263 any info

2005-12-14 Thread Pavel Stehule
Hello I can't find any information of syntax for ANSI Conformance F262, F263. Has somebody any information about this points: Extended CASE expression, comma separated predicates in simple case expression Thank You Pavel Stehule

Re: [HACKERS] ANSI SQL, CASE expression Conformance F262, F263 any info

2005-12-14 Thread Pavel Stehule
Pavel Stehule [EMAIL PROTECTED] writes: I can't find any information of syntax for ANSI Conformance F262, F263. Has somebody any information about this points: Extended CASE expression, comma separated predicates in simple case expression There are no such feature IDs listed in either

[HACKERS] PL/pgSQL proposal: using list of scalars in assign stmts, fore and fors stmts

2005-12-22 Thread Pavel Stehule
FOR _r IN SELECT generate_series AS x, generateseries + 1 AS y FROM generate_series(1,4)LOOP _rc := _rc + 1; ROW(_x,_y) := _r; RETURN NEXT; END LOOP; RETURN; END; $$ LANGUAGE plpgsql; any comments? Regards Pavel Stehule

Re: [HACKERS] Fixing row comparison semantics

2005-12-26 Thread Pavel Stehule
2)' Can we save current behave (with small modification) with other operator, like * (1,1) * (1,2) = true (1,2) * (2,1) is NULL (2,3) * (1,2) = false it's usefull for multicriterial optimalisation Regards Pavel Stehule

Re: [HACKERS] Fixing row comparison semantics

2005-12-26 Thread Pavel Stehule
Huh? The only current behavior with other operators is failure: you didn't understand me. I know so operator * isn't supported now. I prefere SQL spec behave too. But what I wont: a * b ~ ai = bi and one ai bi = true ; if one ai bi = NULL; else false but this behave is from some views

Re: [HACKERS] Oracle PL/SQL Anonymous block equivalent in postgres

2005-12-27 Thread Pavel Stehule
temp functions. Regards Pavel Stehule _ Najdete si svou lasku a nove pratele na Match.com. http://www.msn.cz/ ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [HACKERS] sending mail from Postgres

2005-12-27 Thread Pavel Stehule
Hello, it depend on your possibilities. Simply, use PL/Perl or PL/sh. Regards Pavel Stehule or use PgSendMail http://sourceforge.net/project/showfiles.php?group_id=35804 Hi there, How can i send mail form postgresql. any suggestion. thanx regards aftab ---(end

Re: [HACKERS] system triggers

2006-02-01 Thread Pavel Stehule
Hello, Propably not. But You can use this patch http://gorda.di.uminho.pt/community/pgsqlhooks/ regards Pavel Stehule HEY!!! Are You going to implement some system triggers like in ORACLE i.e. on login trigger ?? -- Best regards LaroG ---(end of broadcast

[HACKERS] slow information schema with thausand users, seq.scan pg_authid

2006-02-06 Thread Pavel Stehule
? best regards Pavel Stehule _ Chcete sdilet sve obrazky a hudbu s prateli? http://messenger.msn.cz/ ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [HACKERS] slow information schema with thausand users, seq.scan pg_authid

2006-02-06 Thread Pavel Stehule
: (pg_authid.oid = outer.relowner) - Materialize (cost=1.05..1.10 rows=5 width=68) (actual time=0.007..0.032 rows=5 loops=5) - Seq Scan on pg_namespace n (cost=0.00..1.05 rows=5 width=68) (actual time=0.008..0.028 rows=5 loops=1$ Total runtime: 1.294 ms Regards Pavel Stehule

Re: [HACKERS] Expression index with function based on current_user?

2006-02-08 Thread Pavel Stehule
depend only on their arguments and never on any outside influence. ... And your function is vollatile = you can't to do expression index. Regards Pavel Stehule _ Emotikony a pozadi programu MSN Messenger ozivi vasi konverzaci. http

Re: [HACKERS] SpeedComparison

2006-02-12 Thread Pavel Stehule
space for PostgreSQL force. When I did test for self join 4 tables, PostgreSQL was better then MySQL and Firebird Pavel _ Najdete si svou lasku a nove pratele na Match.com. http://www.msn.cz/ ---(end

[HACKERS] how solve diff of API counstruct_md_array between 8.1 and 8.2?

2006-02-16 Thread Pavel Stehule
don't want to have two versions of source code. Thank you Pavel Stehule _ Citite se osamele? Poznejte nekoho vyjmecneho diky Match.com. http://www.msn.cz/ ---(end of broadcast

[HACKERS] Request: set opclass for generated unique and primary key indexes

2006-02-22 Thread Pavel Stehule
Hello There isn't possibility change opclass for generated UNIQUE indexes. I found syntax for CREATE TABLE command USING INDEX TABLESPACE ..., This form can be enhanced to USING INDEX [TABLESPACE ..] [OPCLASS ..] What do you think about it? Regards Pavel Stehule

Re: [HACKERS] Request: set opclass for generated unique and primary key indexes

2006-02-22 Thread Pavel Stehule
unique index. But it's redundant. This problem is related to using nonC locale. Regards Pavel Stehule _ Najdete si svou lasku a nove pratele na Match.com. http://www.msn.cz/ ---(end of broadcast

Re: [HACKERS] Request: set opclass for generated unique and primary key indexes

2006-02-22 Thread Pavel Stehule
values with some prefix - op Like and on primary key can't to use std. index. Pavel _ Express yourself instantly with MSN Messenger! Download today - it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01

Re: [HACKERS] Request: set opclass for generated unique and primary key indexes

2006-02-22 Thread Pavel Stehule
type PRIMARY KEY | UNIQUE [USING INDEX [TABLESPACE ...] [OPERATOR CLASS opclass] CREATE CONSTRAINT name PRIMARY KEY | UNIQUE '(' colname opt_class, I don't think so this need big patch. What do you think? Regards, nice a day Pavel Stehule

[HACKERS] Function's final statement must not be a SELECT

2006-03-10 Thread Pavel Stehule
Hello, I want do sql wrap for woid plpgsql function. But void SQL function must not finish SELECT cmd. I don't know any others command which I can use. Can You help me? Thank You Pavel Stehule _ Najdete si svou lasku a nove

Re: [HACKERS] Function's final statement must not be a SELECT

2006-03-11 Thread Pavel Stehule
From: Jaime Casanova [EMAIL PROTECTED] To: Pavel Stehule [EMAIL PROTECTED] CC: pgsql-hackers@postgresql.org Subject: Re: [HACKERS] Function's final statement must not be a SELECT Date: Sat, 11 Mar 2006 12:42:15 -0500 On 3/10/06, Pavel Stehule [EMAIL PROTECTED] wrote: Hello, I want do sql

[HACKERS] Intersession communication is available, please test it

2006-03-19 Thread Pavel Stehule
packages too. plvdate is one from widespread solutions for weakdays calculations. I appreciate the comments Regards Pavel Stehule _ Citite se osamele? Poznejte nekoho vyjmecneho diky Match.com. http://www.msn.cz

Re: [HACKERS] SQL/XML extension

2006-03-20 Thread Pavel Stehule
Hello, This patch is well, I hope. I didn't look on it half year. Contains: SQL/XML support + doc by D.Fetter http://candle.pha.pa.us/mhonarc/patches_hold/msg00134.html regards Pavel Stehule _ Najdete si svou lasku a nove

[HACKERS] proposal - plpgsql: execute using into

2006-03-27 Thread Pavel Stehule
/pgSQL knows three dynamic statements. All will be enhanced. Some examples: EXECUTE 'SELECT :name||:sp||:surname' USING 'Pavel',' ','Stehule'; EXECUTE e'SELECT \':name :surname' USING 'Pavel','Stehule'; EXECUTE 'SELECT * FROM :tabname' USING 'xb'::regclass; EXECUTE 'SELECT * FROM :base:num USING

[HACKERS] commit callback, request

2006-04-05 Thread Pavel Stehule
function. Whole dbms_alert package is similar our LISTEN/NOTIFY. Difference is dbms_alert is server side solution and L/N is client side. Is any chance so this interface will be in 8.2? Regards Pavel Stehule _ Don’t just search

Re: [HACKERS] commit callback, request

2006-04-05 Thread Pavel Stehule
Pavel Stehule [EMAIL PROTECTED] writes: Is possible make transaction commit trigger without patching code now? You can get pretty close with a deferred trigger. I don't think there's any way to have a guaranteed at commit trigger --- as soon as (1) there are two of them and (2) one can get

[HACKERS] request: muting notice CREATE TABLE will create implicit sequence

2006-04-05 Thread Pavel Stehule
Hello I am working on general functions accessable from console too. I create tempory tables from functions. Is necessary print notice about using serial type? I think actually we don't need print it, becouse DROP TABLE use dependencies. Regards Pavel Stehule

Re: [HACKERS] commit callback, request, SOLVED

2006-04-05 Thread Pavel Stehule
Refered triggers works well, better than I expected. It's not equal NOTIFY, but it works. Thank You Pavel Stehule CREATE OR REPLACE FUNCTION dbms_alert._defered_signal() RETURNS trigger AS $$ BEGIN PERFORM dbms_alert._signal(NEW.event, NEW.message); DELETE FROM ora_alerts WHERE id=NEW.id

[HACKERS] please actualize FAQ, broken urls

2006-04-07 Thread Pavel Stehule
Hello 1.11) How can I learn SQL? ... There is also a nice tutorial at http://www.intermedia.net/support/sql/sqltut.shtm, at http://ourworld.compuserve.com/homepages/graeme_birchall/HTM_COOK.HTM, and at http://sqlcourse.com. first link is broken, second moved Regards Pavel Stehule

Re: [HACKERS] please actualize FAQ, broken urls

2006-04-13 Thread Pavel Stehule
David Fetter dir patch two days ago Pavel From: Bruce Momjian pgman@candle.pha.pa.us To: Pavel Stehule [EMAIL PROTECTED] CC: pgsql-hackers@postgresql.org Subject: Re: [HACKERS] please actualize FAQ, broken urls Date: Thu, 13 Apr 2006 08:09:40 -0400 (EDT) Pavel Stehule wrote: Hello 1.11

[HACKERS] pgfoundry - news - is working?

2006-04-20 Thread Pavel Stehule
Hello yesterday I did one news notice on my orafunc page. But it isn't on main page yet. Why? Can someboody explain mechanism of publishing messages on pgfoundry? Regards Pavel Stehule _ Citite se osamele? Poznejte nekoho

[HACKERS] please change url for czech postgresql site

2006-04-20 Thread Pavel Stehule
Hello, please change url on http://www.postgresql.org/community/international from postgresql.ok.cz to http://postgresql.interweb.cz I actualized content for 8.1 and migrated to wiki and new site. Older site exists still, but isn't actualized. Thank you Pavel Stehule

Re: [HACKERS] please change url for czech postgresql site

2006-04-20 Thread Pavel Stehule
. And I know only one reason for change backend from mysql to postgresql - tsearch2. It's supported now? What about spead? And my provider has 7.4 still. Maybe next version :-), it's shame Pavel _ Citite se osamele? Poznejte nekoho

[HACKERS] plpgsql cant to set role from function. is bug?

2006-04-28 Thread Pavel Stehule
| no| no | no| no limit| (1 row) postgres=# WARNING: role x is not a member of role root REVOKE ROLE postgres=# what is wrong? Regards Pavel Stehule p.s. root is postgresql superuser _ Chcete sdilet sve obrazky a hudbu s prateli? http

[HACKERS] plpgsql cant to set role from function. is bug?, SOLVED

2006-04-28 Thread Pavel Stehule
Hello I am stupid. 1) I don't call function. I am sorry Regards Pavel Stehule _ Najdete si svou lasku a nove pratele na Match.com. http://www.msn.cz/ ---(end of broadcast)--- TIP 2

  1   2   3   4   5   6   7   8   9   10   >