[HACKERS] clang and LLVM

2010-12-16 Thread Gevik Babakhani
Hi, I was wondering if there has been anyone experimenting to compile PG using LLVM/clang compiler tools. Regards, Gevik. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

[HACKERS] Question about FUNCDETAIL_MULTIPLE

2009-06-04 Thread Gevik Babakhani
foo1(10,10) ^ HINT: Could not choose a best candidate function. You might need to add explicit type casts. - -- Regards, Gevik -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org

Re: [HACKERS] Question about FUNCDETAIL_MULTIPLE

2009-06-04 Thread Gevik Babakhani
Tom Lane wrote: Gevik Babakhani pg...@xs4all.nl writes: I was wondering what the philosophy is behind letting an ambiguous function be created in the first place. Is this for backwards compatibility or perhaps for historical reasons? Neither; it's a feature, and one we quite like

[HACKERS] Question about STRICT

2009-06-03 Thread Gevik Babakhani
is created as STRICT? (This would of course have an impact on checking for NULLs on arguments defaults if the above is implemented.) -- Regards, Gevik

Re: [HACKERS] A humble request

2009-06-03 Thread Gevik Babakhani
Thank you for making this available :) Bruce Momjian wrote: Gevik Babakhani wrote: please, please, please The video is here: http://hosting3.epresence.tv/fosslc/1/watch/121.aspx --- David Fetter wrote

Re: [HACKERS] Question about STRICT

2009-06-03 Thread Gevik Babakhani
) returns void as $$ insert into table1 (col1,col2) values ($1,$2); $$ language sql strict; select * from insert_test(null,'a'); select * from table1; -- Regards, Gevik -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http

Re: [HACKERS] Question about STRICT

2009-06-03 Thread Gevik Babakhani
Greg Stark wrote: On Wed, Jun 3, 2009 at 11:04 AM, Gevik Babakhani pg...@xs4all.nl wrote: The RETURNS NULL ON NULL INPUT is logical and does the above accordingly. But when a function is STRICT you kind of expect to have an notification, perhaps an error if a value for an argument is NULL

Re: [HACKERS] Question about STRICT

2009-06-03 Thread Gevik Babakhani
Tom Lane wrote: Gevik Babakhani pg...@xs4all.nl writes: Perhaps it is an idea to have something like: RAISE ERROR ON NULL INPUT [ shrug... ] There's really been no demand for that. If you want a particular function to do it, you can put suitable tests and error reports into that function

Re: [HACKERS] usability of pg_get_function_arguments

2009-05-26 Thread Gevik Babakhani
Tom Lane wrote: Gevik Babakhani pg...@xs4all.nl writes: I experimented with your example and noticed that pg_get_expr requires a hack --- it insists on having a relation OID argument, because all previous use-cases for it involved expressions that might possibly refer to a particular table. So

[HACKERS] usability of pg_get_function_arguments

2009-05-25 Thread Gevik Babakhani
if pg_get_function_arguments returned the data is some kind of a structure than a blob of string like the above. BTW: The same goes for pg_get_function_identity_arguments. Any thoughts? -- Regards, Gevik -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription

Re: [HACKERS] usability of pg_get_function_arguments

2009-05-25 Thread Gevik Babakhani
. Fortunately the result of pg_get_expr from above is ordered --- Perhaps by doing some find and replace, I can determine to which argument the returned default value belongs to. Thank you for your help :) -- Regards, Gevik -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make

Re: [HACKERS] information_schema.columns changes needed for OLEDB

2009-05-24 Thread Gevik Babakhani
from the standard SQL schema in order to satisfy a certain third party component. If the information_schema does not provide all the information, one could always query the pg_* tables for needed data. -- Regards, Gevik -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org

[HACKERS] pg_class and enum types

2009-05-24 Thread Gevik Babakhani
I was wondering why there is no pg_class record for the enum types. Do we treat the enum types differently? -- Regards, Gevik -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] pg_class and enum types

2009-05-24 Thread Gevik Babakhani
Robert Haas wrote: On Sun, May 24, 2009 at 4:37 PM, Gevik Babakhani pg...@xs4all.nl wrote: I was wondering why there is no pg_class record for the enum types. Do we treat the enum types differently? Because types are stored in pg_type, not pg_class? ...Robert That is certainly

Re: [HACKERS] pg_class and enum types

2009-05-24 Thread Gevik Babakhani
Andrew Dunstan wrote: Gevik Babakhani wrote: I was wondering why there is no pg_class record for the enum types. Do we treat the enum types differently? Why do you think we should? What would the record look like? cheers andrew I am not implying whether we should or we should not. I

Re: [HACKERS] pg_class and enum types

2009-05-24 Thread Gevik Babakhani
Tom Lane wrote: Andrew Dunstan and...@dunslane.net writes: Gevik Babakhani wrote: select * from pg_class where relname='test_type' It's not so much that enum types are handled specially, but that composite types are. :-) Relations (tables) have always had both

[HACKERS] A humble request

2009-05-22 Thread Gevik Babakhani
Hi, For the ones who couldn't attend to How to Get Your PostgreSQL Patch Accepted, could someone please make a summary. (Tom? Bruce?) Thank you. Regards, Gevik. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http

Re: [HACKERS] A humble request

2009-05-22 Thread Gevik Babakhani
please, please, please David Fetter wrote: On Fri, May 22, 2009 at 10:39:13AM +0200, Gevik Babakhani wrote: Hi, For the ones who couldn't attend to How to Get Your PostgreSQL Patch Accepted, could someone please make a summary. (Tom? Bruce?) Thank you. Video will get posted pretty

[HACKERS] question about pg_proc

2009-05-22 Thread Gevik Babakhani
Is there a historical reason why we have a proargtypes and a proallargtypes? It seems that proallargtypes is only set when out parameters exist. Could someone clarify this please? Regards, Gevik. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your

[HACKERS] view columns and pg_depend

2009-04-28 Thread Gevik Babakhani
Hi, I was wondering whether there is a way to see which column in a view depends on which column(s) in a table? If I am not mistaking pg_depend only provides information about which view depends on which tables columns only. (same as view_column_usage) Regards, Gevik. -- Sent via pgsql

[HACKERS] Multiple parameters with the same name for functions.

2009-04-26 Thread Gevik Babakhani
; $$ language plpgsql; Is this a known behavior or a bug? Regards, Gevik. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] Multiple parameters with the same name for functions.

2009-04-26 Thread Gevik Babakhani
No. I meant: create function foo(PAR1 varchar, PAR1 int, PAR1 uuid). Note PAR1 Jaime Casanova wrote: On Sun, Apr 26, 2009 at 3:32 PM, Gevik Babakhani pg...@xs4all.nl wrote: Hi, As I was working on my code generator app, I noticed that one is able to create a function with multiple

[HACKERS] PostgreSQL network discovery

2008-10-29 Thread Gevik Babakhani
thoughts? Regards, Gevik http://www.truesoftware.net/gevik/ -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] PostgreSQL network discovery

2008-10-29 Thread Gevik Babakhani
If I am not mistaken, it only works fine on OSX environments. (I might be very wrong here) -Original Message- From: Magnus Hagander [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 29, 2008 8:47 PM To: Gevik Babakhani Cc: 'PGSQL Hackers' Subject: Re: [HACKERS] PostgreSQL network

Re: [HACKERS] PostgreSQL network discovery

2008-10-29 Thread Gevik Babakhani
8:50 PM To: Gevik Babakhani Cc: 'PGSQL Hackers' Subject: Re: [HACKERS] PostgreSQL network discovery Gevik Babakhani wrote: Hi, There is a nice little feature within MSSQL where it is possible to enumerate all MSSQL servers on the local network. I wonder how this can be made

[HACKERS] Buildfarm Cardinal going down.

2008-10-21 Thread Gevik Babakhani
I am going to do some hardware upgrading on buildfarm Cardinal. It will be down for sometime. Regards, Gevik -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] PostgreSQL future ideas

2008-09-25 Thread Gevik Babakhani
++ish and fully OO, being a mixture in C with some OO taste. Better idea is to start to use C99 in PostgreSQL ;-). I have not investigated this yet. But I am very interested to know what the advantages would be to upgrade the code to C99 standards. Regards, Gevik http://www.truesoftware.net/gevik

[HACKERS] Preserve identifier case

2008-09-24 Thread Gevik Babakhani
). Is this function the correct place to bypass the down casing for all identifiers? http://doxygen.postgresql.org/scansup_8c-source.html#l00129 Regards, Gevik http://www.truesoftware.net/gevik/ -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http

[HACKERS] PostgreSQL future ideas

2008-09-19 Thread Gevik Babakhani
take your M16 and start shooting now) Regards, Gevik -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] PostgreSQL future ideas

2008-09-19 Thread Gevik Babakhani
It might look like an impossible goal to achieve.. But if there is any serious plan/idea/ammo for this, I believe it would be very beneficial to the continuity of PG. Regards, Gevik. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dave Page Sent

Re: [HACKERS] PostgreSQL future ideas

2008-09-19 Thread Gevik Babakhani
. As far as I know, most universities teach some sort of OO programming language like JAVA or C# to help students understand OO programming. I understand that C++ is less popular but JAVA/C# would be the wrong choice for this. Regards, Gevik. -- Jonah H. Harris, Senior DBA myYearbook.com

Re: [HACKERS] PostgreSQL future ideas

2008-09-19 Thread Gevik Babakhani
Already done! http://www.postgresql.org/community/weeklynews/pwn20050401 Yes, yes COBOL :) PostCobolSQL -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] PostgreSQL future ideas

2008-09-19 Thread Gevik Babakhani
I think the better question about all of this is: What is the problem we are trying to solve? Providing solutions that are looking for problems doesn't help us. Sincerely, Perhaps the current codebase and design in C will serve us for years and years to come. In fact there is no doubt about

Re: [HACKERS] PostgreSQL future ideas

2008-09-19 Thread Gevik Babakhani
Thank you all for your opinion. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Dunstan Sent: Saturday, September 20, 2008 12:53 AM To: Gevik Babakhani Cc: 'Joshua Drake'; 'Jonah H. Harris'; 'Dave Page'; 'PGSQL Hackers'; [EMAIL

Re: [HACKERS] Problem with site doc search

2008-03-06 Thread Gevik Babakhani
No, it's still on the TODO. Gevik has also been looking a bit at it (I think - at least he's indicated that he is), and he recently got some new parser code to look at to see if we can use to fix it. I have the new parser code. Next week I have some time reserved to look at it. -- Sent

Re: [HACKERS] UUID data format 4x-4x-4x-4x-4x-4x-4x-4x

2008-02-27 Thread Gevik Babakhani
standard formatting will be accepted into core. IIRC we where also opposed to support java like formatted uuid's back then. This is no different. Regards, Gevik. ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http

Re: [HACKERS] Which MemoryContext?

2008-02-21 Thread Gevik Babakhani
to free my allocated memory before exit. I found the proc_exit hook mechanism but I am not sure where to setup this hook. Given allocating memory in TopMemoryContext is the same as malloc, then I'll just leave my allocated memory to be freed automatically when exit. Thank you :) Regards, Gevik

Re: [HACKERS] TO_DATE behavior!

2008-02-21 Thread Gevik Babakhani
There are quite a few complaints in the archive about to_date's incorrect or questionable behavior. I'm sure this is one of them. This code needs a general, systematic review. I am working on a todo item. I'll report and fix anything I encounter there. Regards, Gevik

[HACKERS] TO_DATE behavior!

2008-02-21 Thread Gevik Babakhani
row) No complains there!(?) The opposite query results the correct date. test: testdb=# select to_char(to_date('mon 21-feb-2008','dy dd-mon-'),'dy dd-mon-'); to_char - thu 21-feb-2008 (1 row) Regards, Gevik ---(end of broadcast

[HACKERS] about date/time parser

2008-02-21 Thread Gevik Babakhani
regarding http://archives.postgresql.org/pgsql-hackers/2008-02/msg00826.php I was wondering why we have a custom written parser to parse the date/time from/to string and vice versa? Is there a historical reason? Would a yacc/lex parser be better? Regards, Gevik ---(end

Re: [HACKERS] about date/time parser

2008-02-21 Thread Gevik Babakhani
Almost certainly neither workable nor an improvement if you did make it work. Datetimes don't have enough structure to make yacc useful, and it's not flexible enough either. Understood. Thank you :) ---(end of broadcast)--- TIP 3: Have you

[HACKERS] Which MemoryContext?

2008-02-20 Thread Gevik Babakhani
perhaps? Any thoughts? Regards, Gevik. ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [HACKERS] Which MemoryContext?

2008-02-20 Thread Gevik Babakhani
? Or does the system release everything allocated in TopMemoryContext automatically when exiting? I looked around and found examples where memory allocated using above is not freed! (datetime.c:3811, uhhh.. a bit confused here) Any thoughts? Regards, Gevik. ---(end

Re: [HACKERS] Which MemoryContext?

2008-02-20 Thread Gevik Babakhani
On backend exit, everything in TopMemoryContext, like all other non-shared memory, is automatically released. So it is safe to not free the allocated memory in TopMemoryContext and leave it to be released on backend exit. Thank you for the help :) Regards, Gevik

Re: [HACKERS] Getting available options

2008-02-19 Thread Gevik Babakhani
I like option 1 the best. Minimally invasive, and probably easier to handle on the client than 2. +1 ---(end of broadcast)--- TIP 6: explain analyze is your friend

[HACKERS] Question regarding TODO item:Allow to_date() and to_timestamp() accept localized month names

2008-02-19 Thread Gevik Babakhani
. In order to know when to return the localized values a DCH_S_TM (=0x10, suffix TM) is provided at dch_date. This is where I want to check the localized array created above. Any thoughts? Regards, Gevik. ---(end of broadcast)--- TIP 3: Have you

Re: [HACKERS] NLS on MSVC strikes back!

2008-02-12 Thread Gevik Babakhani
(now(),'TMDay TMMonth '); 4. The result will be in German and not Spanish as one expects. If handling locale in to_char will remain using gettext then I can start working on a patch to fix this. Regards, Gevik Babakhani PostgreSQL NL http

Re: [HACKERS] NLS on MSVC strikes back!

2008-02-12 Thread Gevik Babakhani
Right, I know that. But I didn't see you trying lc_time as Andrew suggested. Did that too, but no luck :( ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [HACKERS] NLS on MSVC strikes back!

2008-02-12 Thread Gevik Babakhani
Well, that should be considered a bug, not a feature. Perhaps it was fixed in 8.3. This is 8.3 I am testing with. ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

[HACKERS] NLS on MSVC strikes back!

2008-02-12 Thread Gevik Babakhani
I have compiled 8.3 (CVS HEAD) with NLS on a XP box. But it seems that NLS support is broke. Could someone please confirm this. My test: Gevik=# Gevik=# show lc_messages ; lc_messages English_United States.1252 (1 row) Gevik=# Gevik=# set lc_messages

Re: [HACKERS] NLS on MSVC strikes back!

2008-02-12 Thread Gevik Babakhani
Should that not be lc_time you are setting? lc_messages is for, uh, messages. No. The same thing works on 8.2.6 ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [HACKERS] NLS on MSVC strikes back!

2008-02-12 Thread Gevik Babakhani
handling and create a fix for B. Because we do not want to change/maintain our own version of Gettext this would also involve creating a different directory/name structure for Windows. For example share\locale\de would be share\locale\German_Germany. Any thoughts, Regards, Gevik Babakhani

Re: [HACKERS] TODO item:Allow to_date() and to_timestamp() accept localized month names

2008-02-10 Thread Gevik Babakhani
I can't remember anyone asking for more sophisticated solutions so it seems implementing #1 at this point is the best approach. OK. Then I'll start working on the first approach. Regards, Gevik. ---(end of broadcast)--- TIP 7: You can

Re: [HACKERS] TODO item:Allow to_date() and to_timestamp() accept localized month names

2008-02-07 Thread Gevik Babakhani
. Please note that loading another locale category forced by SET LC_* is costly. (look at GetText source). Any thoughts? Regards, Gevik Babakhani PostgreSQL NL http://www.postgresql.nl TrueSoftware BV http://www.truesoftware.nl

Re: [HACKERS] PostgreSQL 8.4 development plan

2008-02-06 Thread Gevik Babakhani
The plan looks great. I am +1 -Original Message- From: [EMAIL PROTECTED] ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org ---(end of

Re: [HACKERS] TODO item:Allow to_date() and to_timestamp() accept localized month names

2008-02-05 Thread Gevik Babakhani
://www.techonthenet.com/oracle/functions/to_date.php) a third parameter to enforce the nls_language is required. Please advice. Regards, Gevik. -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 05, 2008 2:29 AM To: Gevik Babakhani Cc: pgsql-hackers

[HACKERS] path with spaces in config.pl

2008-02-05 Thread Gevik Babakhani
\gettext' everything compiled just fine. Perhaps we should document this. Regards, Gevik. ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [HACKERS] path with spaces in config.pl

2008-02-05 Thread Gevik Babakhani
spaces in include but not in lib Attached is a quick patch that fixed the link error on my machine. Regards, Gevik Babakhani PostgreSQL NL http://www.postgresql.nl TrueSoftware BV http://www.truesoftware.nl

[HACKERS] Possible BUG in MSVC Install.pm in GenerateNLSFiles

2008-02-05 Thread Gevik Babakhani
Hi, Is it only on my system or the Install.pm:GenerateNLSFiles just does not copy any NLS files. It seems that in Install.pm:468:next.po$/); does not let anything through. Can someone please confirm? Regards, Gevik. ---(end of broadcast

Re: [HACKERS] Possible BUG in MSVC Install.pm in GenerateNLSFiles

2008-02-05 Thread Gevik Babakhani
The traces from buildfarm baiji seem to indicate that at least some NLS files are installed. Those three dots are printed as default. (looking at Install.pm:456) Regards, Gevik. ---(end of broadcast)--- TIP 3: Have you checked our

[HACKERS] Where is share\locale dir on Win?

2008-02-05 Thread Gevik Babakhani
Is it my imagination or the share\locale directory for nls support just does not get installed on Windows. (Even with NLS option chosen). It does for 8.2 Regards, Gevik. ---(end of broadcast)--- TIP 6: explain analyze is your friend

[HACKERS] TODO item:Allow to_date() and to_timestamp() accept localized month names

2008-02-04 Thread Gevik Babakhani
. Pass the list to formatting.c:1615:seq_search to parse the string with these localized names list. My questions: Is step 1 acceptable/correct to start with? If yes, what would you recommend for step 2? Regards, Gevik Babakhani PostgreSQL NL

Re: [HACKERS] TODO item:Allow to_date() and to_timestamp() accept localized month names

2008-02-04 Thread Gevik Babakhani
LC_MESSAGES won't help. Regards, Gevik ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org

Re: [HACKERS] How to use VB6 for store image to postgresql?

2008-01-29 Thread Gevik Babakhani
=42957f48bac95dd18ca8bffcf7578dcca ttachmentid=49287d=1152543402 attachmentid=49287d=1152543402 - save the base64 encoded string in the database I hope this helps. Regards, Gevik. _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Premsun Choltanwanich Sent: Tuesday, January

[HACKERS] system catalog constraints question

2008-01-28 Thread Gevik Babakhani
in the code? Regards, Gevik. ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Re: [HACKERS] system catalog constraints question

2008-01-28 Thread Gevik Babakhani
Thank you :) -Original Message- From: Heikki Linnakangas [mailto:[EMAIL PROTECTED] Sent: Monday, January 28, 2008 5:35 PM To: Gevik Babakhani Cc: pgsql-hackers@postgresql.org Subject: Re: [HACKERS] system catalog constraints question Gevik Babakhani wrote: Is there a way

[HACKERS] MSVC Build error

2008-01-27 Thread Gevik Babakhani
\libpgport: Task VCBuild Regards, Gevik Babakhani PostgreSQL NL http://www.postgresql.nl TrueSoftware BV http://www.truesoftware.nl ---(end of broadcast

Re: [HACKERS] MSVC Build error

2008-01-27 Thread Gevik Babakhani
:\pgdev Regards, Gevik Babakhani PostgreSQL NL http://www.postgresql.nl TrueSoftware BV http://www.truesoftware.nl ---(end of broadcast)--- TIP 4

Re: [HACKERS] PostgreSQL Programmer's Guide Books

2008-01-26 Thread Gevik Babakhani
thank you :) -Original Message- From: Robert Treat [mailto:[EMAIL PROTECTED] Sent: Saturday, January 26, 2008 4:29 PM To: pgsql-hackers@postgresql.org Cc: Gevik Babakhani Subject: Re: [HACKERS] PostgreSQL Programmer's Guide Books On Friday 25 January 2008 19:02, Gevik Babakhani

[HACKERS] PostgreSQL Programmer's Guide Books

2008-01-25 Thread Gevik Babakhani
Hi, I was wondering how accurate there books are (perhaps not so much) , if one wants to learn more about the internals? http://www.postgresql.org/docs/7.3/static/programmer.html http://www.cs.helsinki.fi/u/laine/postgresql/programmer/ Regards, Gevik ---(end

Re: [HACKERS] .NET or Mono functions in PG

2007-11-30 Thread Gevik Babakhani
dangerous. I am thinking the started process can stay alive and act as a service of some kind to handle/answer calls form multiple backends and shutdown itself after a period of time being idle. Regards, Gevik Babakhani PostgreSQL NL http

Re: [HACKERS] .NET or Mono functions in PG

2007-11-30 Thread Gevik Babakhani
It would we great. Thank you. Regards, Gevik Babakhani PostgreSQL NL http://www.postgresql.nl TrueSoftware BV http://www.truesoftware.nl -Original Message- From: [EMAIL

[HACKERS] .NET or Mono functions in PG

2007-11-30 Thread Gevik Babakhani
like to have your opinion about this idea. Regards, Gevik Babakhani PostgreSQL NL http://www.postgresql.nl TrueSoftware BV http://www.truesoftware.nl ---(end

Re: [HACKERS] quotas once again

2007-11-29 Thread Gevik Babakhani
in a given tablespace and then limit the size of the tablespace. Gevik Babakhani PostgreSQL NL http://www.postgresql.nl TrueSoftware BV http://www.truesoftware.nl -Original Message- From

[HACKERS] quotas once again

2007-11-28 Thread Gevik Babakhani
Sometime ago there was a discussion about user/database quota and IIRC there was also some patch for this (probably got rejected). Does anyone know to which direction we went for having quotas? Regards, Gevik Gevik Babakhani PostgreSQL NL

Re: [HACKERS] quotas once again

2007-11-28 Thread Gevik Babakhani
. Gevik Babakhani PostgreSQL NL http://www.postgresql.nl TrueSoftware BV http://www.truesoftware.nl Regards Pavel Stehule On 28/11/2007, Gevik Babakhani [EMAIL PROTECTED] wrote

Re: [HACKERS] PG 7.3 is five years old today

2007-11-27 Thread Gevik Babakhani
At some point back, I seem to recall the reason for bothering to backpatch to 7.3 is that it had to be maintained for RedHat anyway, so things might as well be backpatched? If that requirements is gone, I think it's time to drop it. +1 And +1 on pushing out one final end of the tree

Re: [HACKERS] Throw error and ErrorContext question.

2007-11-09 Thread Gevik Babakhani
possible test scenarios I can think of to be sure the implementations is working correctly. Regards, Gevik. Gevik Babakhani PostgreSQL NL http://www.postgresql.nl TrueSoftware BV http://www.truesoftware.nl

[HACKERS] Need for advice and direction (again)

2007-11-09 Thread Gevik Babakhani
SELECT PARAM1.salary * 2 AS salary; -- Would this be correct? SELECT double_salary.PARAM1.salary * 2 AS salary; $$ LANGUAGE SQL; Regards, Gevik. Gevik Babakhani PostgreSQL NL http://www.postgresql.nl TrueSoftware BV

Re: [HACKERS] Feature Request: inline comments

2007-11-08 Thread Gevik Babakhani
Feature freeze was six months ago, and no this wouldn't be a small add even if it was the best idea since sliced bread. +1 ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail

[HACKERS] Throw error and ErrorContext question.

2007-11-07 Thread Gevik Babakhani
(); Gevik Babakhani PostgreSQL NL http://www.postgresql.nl TrueSoftware BV http://www.truesoftware.nl ---(end of broadcast)--- TIP 5: don't forget to increase your free space map

Re: [HACKERS] Throw error and ErrorContext question.

2007-11-07 Thread Gevik Babakhani
of the current function, which funct1 is unknown/ambiguous (the name of the current function was func for example). In the case above I thought I somehow re-throw the error that was originally generated at step 1. Regards, Gevik. Gevik Babakhani

[HACKERS] Opinion / advice needed for TODO: function params ref by name

2007-11-06 Thread Gevik Babakhani
+ new tests pass on Win and RH. Any thoughts? Regards, Gevik. Gevik Babakhani PostgreSQL NL http://www.postgresql.nl TrueSoftware BV http://www.truesoftware.nl

[HACKERS] Slow regression tests on windows

2007-11-05 Thread Gevik Babakhani
I am trying to run regression tests on both windows and RH. It looks like that the tests on windows run slower than linux using two machines with same hardware config. Is this known? Gevik Babakhani PostgreSQL NL http

[HACKERS] Continue [PATCHES] V0.1 patch for TODO Item: SQL-language reference parameters by name.

2007-11-02 Thread Gevik Babakhani
to have a more general solution. Perhaps I did not look well enough, but is there any callback mechanism like the error_context_stack etc... in the parser? ( If not, I guess one has to be created :) ) Thank you. Gevik. ---(end of broadcast

Re: [HACKERS] Proposal TODO Item: SQL-language reference parameters by name

2007-10-31 Thread Gevik Babakhani
Thank you Tom. After running a create function statement (language sql), the final check for a column is done in parse_expr.c:transformColumnRef in case 1. Would this be the correct place to implement functionality for a final match? Regards, Gevik. - Original Message - From: Tom

[HACKERS] Proposal TODO Item: SQL-language reference parameters by name

2007-10-30 Thread Gevik Babakhani
). I guess this can be handeled in fmgr_sql_validator Please let me know your opinion. Regards, Gevik.

Re: [HACKERS] Proposal TODO Item: SQL-language reference parameters by name

2007-10-30 Thread Gevik Babakhani
CreateFunction is called. If the above is correct to implement then the check should have low precedence in order to not break the current functionality (first colnames, then $n params and then parameter names) Regards, Gevik. ---(end of broadcast

[HACKERS] buildfarm fail cardinal

2007-02-05 Thread Gevik Babakhani
Hi, I would like to know why the test stats on pgbuildfarm/cardinal fails? Regards, Gevik xml ... ok test stats... FAILED test tablespace ... ok ---(end of broadcast)--- TIP 7: You can help

[HACKERS] VC2005 build and pthreads

2007-01-26 Thread Gevik Babakhani
Folks, I would like to build pg on VC2005. How do I use pthreads that is mentioned in the README file. Do I need the DLL? Sources? LIB? Where do I install or copy them.. Regards, Gevik ---(end of broadcast)--- TIP 5: don't forget to increase

Re: [HACKERS] VC2005 build and pthreads

2007-01-26 Thread Gevik Babakhani
pthreads in needed to buold PG in vc++ 2005 please read pgsql/src/tools/msvc/README Have a nice day. On Fri, 2007-01-26 at 21:47 +0100, Martijn van Oosterhout wrote: On Fri, Jan 26, 2007 at 09:34:10PM +0100, Gevik Babakhani wrote: Folks, I would like to build pg on VC2005. How do I use

[HACKERS] unused_oids?

2007-01-25 Thread Gevik Babakhani
193 - 199 276 321 - 328 376 432 - 433 820 - 828 1004 1972 - 1973 1980 1998 2003 - 2004 2039 2096 2230 2746 2758 - 2780 2858 - 2859 2922 - Regards, Gevik ---(end of broadcast)--- TIP 6: explain analyze is your friend

[HACKERS] Protocol specs

2006-11-10 Thread Gevik Babakhani
Folks, Does anyone know where I can find information about the PG communication protocol specifications between backend and frontend? Regards, Gevik. ---(end of broadcast)--- TIP 4: Have you searched our list archives? http

[HACKERS] MVCC question

2006-10-23 Thread Gevik Babakhani
Folks, How long are we supporting MVCC? It is from the beginning or is it added later to PG -- Regards, Gevik Babakhani www.postgresql.nl www.truesoftware.nl ---(end of broadcast)--- TIP 6: explain analyze is your friend

[HACKERS] Extending tablespaces

2006-10-19 Thread Gevik Babakhani
and the entire storage system etc..etc.. I very much would like to know the communities opinion and thoughts about this. Would this even be possible? Or I am just dreaming (again) and scaring everyone else. -- Regards, Gevik Babakhani www.postgresql.nl www.truesoftware.nl

Re: [HACKERS] Extending tablespaces

2006-10-19 Thread Gevik Babakhani
Okay, thank you. On Thu, 2006-10-19 at 15:56 -0400, Tom Lane wrote: Gevik Babakhani [EMAIL PROTECTED] writes: Now I am thinking what it would take to give pg the functionality to extend tablespaces automatically. It's called LVM ... and no, we are not interested in reimplementing

[HACKERS] casting to domain problem.

2006-09-28 Thread Gevik Babakhani
to find the appropriate cast record (for the domain). I searched the list for a possible answer but I couldn't find one. Could someone please clarify this? -- Regards, Gevik Babakhani http://www.postgresql.nl http://www.truesoftware.nl ---(end of broadcast

Re: [HACKERS] Row IS NULL question

2006-09-28 Thread Gevik Babakhani
in 8.2, and it'd be good if the semantics of that were right the first time rather than changing later. regards, tom lane ---(end of broadcast)--- TIP 6: explain analyze is your friend -- Regards, Gevik Babakhani http

Re: [HACKERS] Row IS NULL question

2006-09-28 Thread Gevik Babakhani
Thank you for the explanation. On Thu, 2006-09-28 at 12:06 -0400, Tom Lane wrote: Gevik Babakhani [EMAIL PROTECTED] writes: Does this have anything to do with ExecEvalWholeRowVar? Yeah, the construct Seq Scan on int8_tbl x (cost=0.00..1.05 rows=1 width=16) Filter: (x.* IS NULL

Re: [HACKERS] Row IS NULL question

2006-09-28 Thread Gevik Babakhani
map settings Would it be correct to do the null test in ExecEvalNullTest (I would like to learn what happens but somehow I just cannot get the debugger on makeRowNullTest in gram.c) On Thu, 2006-09-28 at 14:38 -0400, Tom Lane wrote: -- Regards, Gevik Babakhani http://www.postgresql.nl http

  1   2   3   >