[HACKERS] TODO item "%Allow pg_hba.conf be controlled via SQL"

Just out of curiosity. Is there someone involved with ToDo item “%Allow pg_hba.conf settings to be controlled via SQL”? Regards, Gevik. ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [HACKERS] TODO item "%Allow pg_hba.conf be controlled via

I found this thread on google, http://groups.google.nl/group/pgsql.hackers/browse_thread/thread/1ccb7ade8d7e7475/8b10fb1ca5fdd3ef?lnk=st&q=pg_hba.conf+settings+to+be+controlled+via+SQL&rnum=3&hl=nl#8b10fb1ca5fdd3ef > Bruno Wolff III wrote: >> On Tue, Nov 22, 2005 at 10:57:19 +0100, >> [EMAIL

[HACKERS] Embedded postgresql

Dear Sirs, I would like to know if there are any discussions about creating an embedded version on postgresql. My thoughts go towards building/porting a sqlite equivalent of pg. Regards, GB. ---(end of broadcast)--- TIP 1: subscribe and unsubscr

[HACKERS] embedded postgresql

Dear Sirs, I would like to know if there are any discussions about creating an embedded version on postgresql. My thoughts go towards building/porting a sqlite equivalent of pg. Regards, GB. ---(end of broadcast)--- TIP 8: explain analyze is your

[HACKERS] Contribute to the development of PostgreSQL

nd whether anyone is interested in helping. Regards, Gevik. ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[HACKERS] debugging PostgreSQL

Dear Folks, Could someone be so kind to give me some pointers about how to debug pg. I would like to know which debugger you use under windows and linux Regards, Gevik ---(end of broadcast)--- TIP 7: don't forget to increase your free spac

[HACKERS] newbie compile question. please help

Dear Folks, Could someone please tell me what I am doing wrong here? I made some minor changes to main.c then make then make install when I want to start the postmaster I get ** The program "postmaster" was found by "/home/gevik/

[HACKERS] Code documentation

very interested considering the options and future plans. Regards, Gevik ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[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

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

lict with actual column names). 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

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.

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

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

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

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

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

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

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.

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

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

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

[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

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] 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] MSVC Build error

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

[HACKERS] system catalog constraints question

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

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

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

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

[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] TODO item:Allow to_date() and to_timestamp() accept localized month names

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

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

[HACKERS] path with spaces in config.pl

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

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 ch

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

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

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!

> 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

[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

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

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

[HACKERS] PostgreSQL future ideas

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

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

Re: [HACKERS] PostgreSQL future ideas

+ 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

> 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

> 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

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'

[HACKERS] Preserve identifier case

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

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

[HACKERS] PostgreSQL network discovery

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

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

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

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

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

[HACKERS] Which MemoryContext?

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

Re: [HACKERS] Which MemoryContext?

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?

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

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

[HACKERS] TO_DATE behavior!

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

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

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

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

[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

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

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

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

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

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

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

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

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

[HACKERS] usability of pg_get_function_arguments

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] usability of pg_get_function_arguments

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

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

[HACKERS] Question about STRICT

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

Re: [HACKERS] Question about STRICT

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

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

[HACKERS] Question about FUNCDETAIL_MULTIPLE

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

  1   2   3   >