[HACKERS] clang and LLVM

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

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

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? Could someone clarify this please? Consider the following example: ( FYI: parse_func.c->ParseFuncOrColumn->164 p

Re: [HACKERS] Question about STRICT

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

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

Shouldn't we raise an error when calling a function with NULL arguments values if the function is created as STRICT? No, what they do is return NULL automatically. The function doesn't have to check for NULL arguments itself. The "RETURNS NULL ON NULL INPUT" is logical and does the above acco

Re: [HACKERS] A humble request

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

Could someone please clarify the difference between "RETURNS NULL ON NULL INPUT" or "STRICT" when creating a function. Do both options exist because of historical reasons/SQL standard compliance? Shouldn't we raise an error when calling a function with NULL arguments values if the function is

Re: [HACKERS] usability of pg_get_function_arguments

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

That would be more work, not less, for the known existing users of the function (namely pg_dump and psql). It's a bit late to be redesigning the function's API anyway. I agree. The recommended way to do that is to use pg_get_expr --- it'd certainly be a bad idea to try to parse that string f

[HACKERS] usability of pg_get_function_arguments

I am trying to extract function argument information using the pg_get_function_arguments() and it strikes me that despite of this function generating very useful information, it is actually not so user friendly. Consider the following: - create o

Re: [HACKERS] pg_class and enum types

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

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

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

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

Josh Berkus wrote: On 5/23/09 7:37 PM, Konstantin Izmailov wrote: Number 4 is actually numeric_precision (I typed incorrectly). My recollection is that numeric_precision sometimes expressed in radix 2 and it caused issues for Windows apps. I agree on other issues. I was curious if database can

[HACKERS] question about pg_proc

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 you

Re: [HACKERS] A humble request

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

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://www.postgre

[HACKERS] view columns and pg_depend

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

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

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.

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 same name. For example: create or replace function func_test(id integer,id varchar, id timestamp) returns void as $$ begin raise notice '%',id; end; $$ language

Re: [HACKERS] PostgreSQL network discovery

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

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

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 possible with PG. Pinging every IP:PGPORT within the current subnet is one of the options but I guess that would be just a bad solution. Any tho

[HACKERS] Buildfarm Cardinal going down.

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

> Advantage of C++ is that it reduce lot of OO code written in > C in PostgreSQL, but it is so big effort to do that without > small gain. It will increase number of bugs. Do not forget > also that C++ compiler is not so common (so good) on > different platforms. If somebody interesting in that

[HACKERS] Preserve identifier case

PostgreSQL makes all identifiers to be lower-case except when putting an identifier between double-quotes. I have an special case where I would like to preserve the case-sensitivity without putting every column/table name inside double-quotes (The application is too big to change). Is this functi

Re: [HACKERS] PostgreSQL future ideas

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

> 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

> 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

> From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Jonah H. Harris > Sent: Friday, September 19, 2008 10:39 PM > To: Gevik Babakhani > Cc: Dave Page; PGSQL Hackers; > [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: Re: [HACKERS] PostgreSQL future ideas

Re: [HACKERS] PostgreSQL future ideas

Dave Page > Sent: Friday, September 19, 2008 9:58 PM > To: Gevik Babakhani > Cc: PGSQL Hackers > Subject: Re: [HACKERS] PostgreSQL future ideas > > On Fri, Sep 19, 2008 at 8:54 PM, Gevik Babakhani > <[EMAIL PROTECTED]> wrote: > > > > Dear PG hackers, > > &

[HACKERS] PostgreSQL future ideas

Dear PG hackers, Has there been any idea to port PG to a more modern programming language like C++? Of course there are some minor obstacles like a new OO design, this being a gigantic task to perform and rewriting almost everything etc... I am very interested to hear your opinion. (You can take

[HACKERS] Buildfarm: cardinal down for maintenance.

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

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

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

> > I am working on a patch to support this format (yes, it is a simple > > modification). There was a proposal and a discussion regarding how this datatype would be before I started developing it. We decided to go with the format proposed in RFC. Unless there is strong case, I doubt any non sta

Re: [HACKERS] about date/time parser

> 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

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!

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

I would like to have your opinion about the following behavior of TO_DATE. Is this correct or a hidden feature? case: 'mon 21-feb-2008' is obviously a bad date. It should be 'thu 21-feb-2008' test: testdb=# select to_date('mon 21-feb-2008','dy dd-mon-'); to_date 2008-02-21 (1

Re: [HACKERS] Which MemoryContext?

> All local memory is safe to handle that way. In my case I am reallocating memory for a global variable between transactions. I wanted to make sure I don't leave allocated memory behind. > The problem only arises when you have memory to release _earlier_ than that. First I was looking for a way

Re: [HACKERS] Which MemoryContext?

> 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] Which MemoryContext?

> TopMemoryContext sounds right. Be careful not to leak there. Thank you :) I have allocated memory using: MemoryContextAlloc(TopMemoryContext,n * sizeof(char*)); In pgsql/src/backend/utils/mmgr/README:142 is stated that memory allocated using above should be freed manually, Is this correct? Or d

[HACKERS] Which MemoryContext?

Hi, I want to keep an array of localized strings in memory. This array is dynamically allocated and is going to be used between transactions (that are not necessarily nested). It must be cleaned/freed when postmaster exists. In which context should this array be initialized? TopMemoryContext pe

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

I have started to develop this item. I would like to see whether I am on the right track. 1. For this item we need an array of localized month/day names. I was thinking of (re)initializing the array item using palloc, repalloc pfree etc.. when SET LC_MESSAGES is called. Would this be correct? 2.

Re: [HACKERS] Getting available options

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

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!

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!

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

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

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

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

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

> 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

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

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?

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

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

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

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

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

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

Hi, I would like report an observations regarding compilation with msvc++ I was trying to compile with nls=>'C:\Program Files\GnuWin32\' (of course with GetText installed and everything) The build process breaks on link with missing "Program.obj" error. When I changed nls='C:\prog\pgsql\depend\get

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

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

> Surely it should be the inverse of the solution for output, > eg TMMon selects localized input. Of cource. But how would TM enforce a localized formatting. (perhaps I am off 2:10 am...) Lets say I have en_US database but the dates I am trying to format is nl_NL. If I am not mistaking SET L

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

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?

I guess the fastest way is to: - create a column of type text. ex. create table foo( myimage text ); - read the contents of your image from file and encode it in base64 using: http://www.vbforums.com/attachment.php?s=42957f48bac95dd18ca8bffcf7578dcc

Re: [HACKERS] system catalog constraints question

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

Hi, Is there a way to query the column constraints between the tables of system catalog. For example pg_attribute.atttypid>pg_type.oid. This is described in the docs of course , but does the system use something like pg_constaint or the system catalog constraints are enforced only in the cod

Re: [HACKERS] MSVC Build error

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

[HACKERS] MSVC Build error

"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

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

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 broadca

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

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

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

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

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

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

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

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

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.

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

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

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.

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

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

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.

Hello, > You seem not to have understood my recommendation to use a > callback function. This patch might work nicely for SQL > functions but there will be no good way to use it for > plpgsql, or probably any other PL function language. If > we're going to change the parser API then I'd like

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

t;Tom Lane" <[EMAIL PROTECTED]> To: "Gevik Babakhani" <[EMAIL PROTECTED]> Cc: Sent: Wednesday, October 31, 2007 4:36 AM Subject: Re: [HACKERS] Proposal TODO Item: SQL-language reference parameters by name "Gevik Babakhani" <[EMAIL PROTECTED]> write

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

Thank you Tom. I think the most likely implementation would involve adding hooks in the parser at places where "unknown column" errors are about to be thrown, so that a function language could check for a match to one of its variable names only after the query-exposed names are checked. Would t

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

Hi all, I am working a lot with custom procedures/functions which are implemented in "language sql". At the moment function parameter refs cannot work with parameter names. I would like to try to implement this. The actual TODO item is: Allow SQL-language functions to reference parameters

[HACKERS] buildfarm fail "cardinal"

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 suppo

Re: [HACKERS] VC2005 build and pthreads

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

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 your

[HACKERS] unused_oids?

Folks, At this moment the following is the list of the unused OIDs. For the uuid datatype I use a script for generating catalog entries. I can close some gaps there if the "masters" are okay with this. Are any OIDs reserved for later or any range can be used in this case? 2 - 9 32 86 - 88 90 100

[HACKERS] Protocol specs

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://arch

[HACKERS] MVCC question

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

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

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

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

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

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   >