[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

Re: [HACKERS] Question about FUNCDETAIL_MULTIPLE

2009-06-04 Thread Gevik Babakhani
Tom Lane wrote: Gevik Babakhani 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. For exa

[HACKERS] Question about FUNCDETAIL_MULTIPLE

2009-06-04 Thread Gevik Babakhani
n foo1(integer, integer) is not unique LINE 15: select * from foo1(10,10) ^ HINT: Could not choose a best candidate function. You might need to add explicit type casts. ----- -- Regards, Gevik -- Sent

Re: [HACKERS] Question about STRICT

2009-06-03 Thread Gevik Babakhani
Tom Lane wrote: Gevik Babakhani 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 functio

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 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. Uhm,

Re: [HACKERS] Question about STRICT

2009-06-03 Thread Gevik Babakhani
place function insert_test(int,varchar) 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

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: On

[HACKERS] Question about STRICT

2009-06-03 Thread Gevik Babakhani
s values if the function 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] usability of pg_get_function_arguments

2009-05-26 Thread Gevik Babakhani
Tom Lane wrote: Gevik Babakhani 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 you have to do

Re: [HACKERS] usability of pg_get_function_arguments

2009-05-25 Thread Gevik Babakhani
it looks like PgAdmin does the trick by hand parsing the string. 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

[HACKERS] usability of pg_get_function_arguments

2009-05-25 Thread Gevik Babakhani
in turn is a challenge on its own. Perhaps it would be much better 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 li

Re: [HACKERS] pg_class and enum types

2009-05-24 Thread Gevik Babakhani
Tom Lane wrote: Andrew Dunstan 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 pg_cl

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
Robert Haas wrote: On Sun, May 24, 2009 at 4:37 PM, Gevik Babakhani 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 not true

[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] 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) To

[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@post

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

[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 sub

[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

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 wrote: Hi, As I was working on my code generator app, I noticed that one is able to create a function with multiple parameters with the

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

2009-04-26 Thread Gevik Babakhani
7;,id; end; $$ 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] PostgreSQL network discovery

2008-10-29 Thread Gevik Babakhani
ctober 29, 2008 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

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' > Subje

[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

[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
ult the code being more C++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

[HACKERS] Preserve identifier case

2008-09-24 Thread Gevik Babakhani
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

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'

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 abo

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
+ is a natural choice when porting (upgrading) ANSI C application. 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. Re

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

[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

[HACKERS] Buildfarm: cardinal down for maintenance.

2008-05-15 Thread Gevik Babakhani
The "cardinal" in pgbuildfarm has been taken down for server/hardware maintenance. 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] 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 ti

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

2008-02-27 Thread Gevik Babakhani
oubt any non 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?

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] 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] 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 encounte

[HACKERS] TO_DATE behavior!

2008-02-21 Thread Gevik Babakhani
); to_date 2008-02-21 (1 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

Re: [HACKERS] Which MemoryContext?

2008-02-21 Thread Gevik Babakhani
oking for a way 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 :)

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 :) Regar

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

[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

[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)---

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

Re: [HACKERS] NLS on MSVC strikes back!

2008-02-12 Thread Gevik Babakhani
t; or "es_ES.utf8" or anything else...; select to_char(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 ---

Re: [HACKERS] NLS on MSVC strikes back!

2008-02-12 Thread Gevik Babakhani
es are returned. A possible solutions: - Keep to_char/LC_MESSAGES 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\G

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

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

[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 TO

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)

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

2008-02-07 Thread Gevik Babakhani
forth by internally executing SET LC_* to the given locale. 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.postgres

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 > ---(e

[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

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 ch

[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] path with spaces in config.pl

2008-02-05 Thread Gevik Babakhani
e darn msbuild which accepts 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 TrueSo

[HACKERS] path with spaces in config.pl

2008-02-05 Thread Gevik Babakhani
s='C:\prog\pgsql\depend\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] 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

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

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

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

2008-02-04 Thread Gevik Babakhani
es for a list of some kind. 3. 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

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

2008-01-29 Thread Gevik Babakhani
p?s=42957f48bac95dd18ca8bffcf7578dcc&a ttachmentid=49287&d=1152543402> &attachmentid=49287&d=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 Cholt

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 Babak

[HACKERS] system catalog constraints question

2008-01-28 Thread Gevik Babakhani
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] MSVC Build error

2008-01-27 Thread Gevik Babakhani
/UNWINDINFO I:\pgdev> Regards, Gevik Babakhani PostgreSQL NL http://www.postgresql.nl TrueSoftware BV http://www.truesoftware.nl --

[HACKERS] MSVC Build error

2008-01-27 Thread Gevik Babakhani
"ValidateSolutionConfiguration" skipped. Previously built successfully. Target misc\libpgport: Task "VCBuild" Regards, Gevik Babakhani PostgreSQL NL http://www.postgresql.nl TrueSoftware BV http://www.truesoftwar

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

[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 of

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

2007-11-30 Thread Gevik Babakhani
us". This is actually my plan B, hence it is less 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

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:

[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 of

Re: [HACKERS] quotas once again

2007-11-29 Thread Gevik Babakhani
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 Mess

Re: [HACKERS] quotas once again

2007-11-28 Thread Gevik Babakhani
y different story than quotas per-tablespace. ---- Gevik Babakhani PostgreSQL NL http://www.postgresql.nl TrueSoftware BV http://www.truesoftware.nl > > > > > > Regards >

[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] 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 tr

[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] Throw error and ErrorContext question.

2007-11-09 Thread Gevik Babakhani
ql; I am working on all 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:/

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-nomai

Re: [HACKERS] Throw error and ErrorContext question.

2007-11-07 Thread Gevik Babakhani
unct1" == , 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 Babak

[HACKERS] Throw error and ErrorContext question.

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

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

2007-11-06 Thread Gevik Babakhani
y thoughts? Regards, Gevik. ---- Gevik Babakhani PostgreSQL NL http://www.postgresql.nl TrueSoftware BV http://www.truesoftware.nl ---(end of broadcast)---

[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
parser API then I'd like 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. -

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: &quo

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

2007-10-30 Thread Gevik Babakhani
arse a function when 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.

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

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

[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: Yo

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

[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 inc

[HACKERS] unused_oids?

2007-01-25 Thread Gevik Babakhani
86 - 88 90 100 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

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

[HACKERS] Extending tablespaces

2006-10-19 Thread Gevik Babakhani
UM, pg_dump, indexing, sorting 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.pos

Re: [HACKERS] Row IS NULL question

2006-09-28 Thread Gevik Babakhani
regards, tom lane > > ---(end of broadcast)--- > TIP 5: don't forget to increase your free space map settings > Would it be correct to do the null test in ExecEvalNullTest (I would like to learn wha

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

Re: [HACKERS] Row IS NULL question

2006-09-28 Thread Gevik Babakhani
e 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://w

  1   2   3   >