[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
On Sat, 27 Dec 2003, A E wrote: Hi, I was wondering if a solution was ever found to the error: wrong record type supplied in RETURN NEXT when executing a function that returns the Record datatype? I have seen a couple of previous post from Tom Lane and others, but no real resolution.

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

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

2005-06-21 Thread Pavel Stehule
On Sun, 19 Jun 2005, Neil Conway wrote: Pavel Stehule wrote: DECLARE excpt EXCEPTION [= 'SQLSTATE'] What would this default to? (i.e. if no '= SQLSTATE' is specified) I wont to prohibit synonyms in exception (every exception has unique sqlstate). If I need better control for sqlstate

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
On Tue, 21 Jun 2005, Andrew Dunstan wrote: Neil Conway said: In PL/PgSQL, END LOOP is used to terminate loop blocks, and END IF is used to terminate IF blocks. This is needlessly verbose: we could simply accept END in both cases without syntactic ambiguity. I'd like to make this change,

[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
in protocol3 files will be minimal. I wont to do prototype. Pavel Dave On 28-Jun-05, at 10:36 AM, Pavel Stehule wrote: 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

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
What do you mean? There are already 10 levels for elog, including five levels of DEBUG. How many more do you want? sometimes I need show only some text. Now I get stack info. lighter elog ~ sending text, not. proc, stack info. 2. multi result sets. This is necessery for support

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
for my task I need little different form :-( create function a(..) returns setof tables but SQL2003 needs type table, and this can be solution You want a function return entire tables at a time? Why bother when you can just return rows and signal when the next table starts? what is

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

Re: [HACKERS] Delphi+pqsql

2005-01-08 Thread Pavel Stehule
Regards Pavel Stehule ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

[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
I think we discussed this last year and decided that it would be a bad idea to use those names because Oracle's use of them is not exactly compatible with our error codes and messages. SQLCODE in particular is not compatible at all --- it's an integer in Oracle, isn't it? There is more

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
Well, yes, but I don't think we should break compatibility arbitrarilly. I guess it could be argued that this is a missing feature in PL/SQL and its Ada parent - implementing GOTO just to handle this case seems unnecessary. Yes. I din't use goto 5 years :-). Continue stmt is more

[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
Andrej Ricnik-Bay wrote: Has anyone here seen this one before? Do the values appear realistic? http://www.sqlite.org/cvstrac/wiki?p=SpeedComparison Some of the particularly bad test results for PostgreSQL may be related to using the default memory configuration and never having run ANALYZE.

[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
I seem to recall someone proposing extending the syntax of the UNIQUE constraints themselves, but there really isn't enough use-case to justify it AFAICS. Especially not when you can always use CREATE UNIQUE INDEX. I can always use second unique index. But it's redundant. This problem

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
I think you mean updated not actualized right? In any case, I've changed the url in cvs, it should appear on the next site build. yes, I am sorry. Thank you btw, I hope that site is running postgresql as a backend :-) Not yet :-(. I had big problems get good free hosting with php5. And

[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

[HACKERS] Wrong plan for simple join with index on FK

2006-05-16 Thread Pavel Stehule
on f1 (cost=0.00..187.00 rows=1 width=4) - Index Scan using xxx on f2 (cost=0.00..4319.77 rows=14 width=4) (5 rows) PostgreSQL 8.1, Linux Regards Pavel Stehule _ Citite se osamele? Poznejte nekoho vyjmecneho diky

Re: [HACKERS] Wrong plan for simple join with index on FK

2006-05-16 Thread Pavel Stehule
Can we seen an EXPLAIN ANALYZE output to see where the miscalculation lies. Is it underestimating the cost of the index scan, or overestimating the cost of the hash join. postgres= explain analyze select count(*) from f1 join f2 on pk=fk;

Re: [HACKERS] Wrong plan for simple join with index on FK

2006-05-16 Thread Pavel Stehule
These are all minor abberations though, on the whole the estimates are pretty good. Perhaps you need to tweak the values of random_page_cost and similar variables. Thank You, It's general problem or only mine? I have 100% standard current PC. Pavel

Re: [HACKERS] Wrong plan for simple join with index on FK

2006-05-16 Thread Pavel Stehule
These are all minor abberations though, on the whole the estimates are pretty good. Perhaps you need to tweak the values of random_page_cost and similar variables. Thank You, It's general problem or only mine? I have 100% standard current PC. The default random_page_cost assumes some

[HACKERS] array constructor can't construct empty array

2003-09-01 Thread Pavel Stehule
with '{}'. What is coorect style? Thank You Pavel Stehule ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])

  1   2   3   4   5   6   7   8   9   10   >