Re: [HACKERS] where to write small reusable functions ?

2007-04-17 Thread Jim C. Nasby
On Fri, Apr 13, 2007 at 03:02:28PM +0200, Dany DeBontridder wrote:
 On 4/13/07, Heikki Linnakangas [EMAIL PROTECTED] wrote:
 
 Dany DeBontridder wrote:
  I'm working to implement a new feature to pg_dump: the ability to dump
  objects like function, indexes...
 
 pg_dump already dumps functions and indexes.
 
 Right but you can't dump only one or two functions or only the functions and
 nothing else. (the same for index, triggers...)

You should make sure and read past discussion about this, as well as
propose a design to the community before getting too far into a patch.
-- 
Jim Nasby[EMAIL PROTECTED]
EnterpriseDB  http://enterprisedb.com  512.569.9461 (cell)

---(end of broadcast)---
TIP 4: Have you searched our list archives?

   http://archives.postgresql.org


Re: [HACKERS] where to write small reusable functions ?

2007-04-13 Thread Heikki Linnakangas

Dany DeBontridder wrote:

I'm working to implement a new feature to pg_dump: the ability to dump
objects like function, indexes... 


pg_dump already dumps functions and indexes.

--
  Heikki Linnakangas
  EnterpriseDB   http://www.enterprisedb.com

---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster


Re: [HACKERS] where to write small reusable functions ?

2007-04-13 Thread NikhilS

Hi,

char *

pg_strcat (char *dest,char *src)
{
/* pg_realloc is a safer function than realloc */
 dest=pg_realloc(dest,strlen(dest)+strlen(src)+1);

strcat(dest,src);
return dest;
}



Postgres already has something for the above functionality.

See makeStringInfo, appendStringInfo.

Regards,
Nikhils
--
EnterpriseDB   http://www.enterprisedb.com


Re: [HACKERS] where to write small reusable functions ?

2007-04-13 Thread Peter Eisentraut
Am Freitag, 13. April 2007 14:28 schrieb Dany DeBontridder:
 But, in that case, those functions are only usable for pg_dump, what about
 the rest of code ? We don't have a central location for those small
 reusable snippets of code ?

The main point of these functions is to catch errors and exit the program.  
But that behavior is very program-dependent, so I don't think it'd be useful 
to put them in a central location.

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/

---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster


Re: [HACKERS] where to write small reusable functions ?

2007-04-13 Thread Dany DeBontridder

On 4/13/07, Heikki Linnakangas [EMAIL PROTECTED] wrote:


Dany DeBontridder wrote:
 I'm working to implement a new feature to pg_dump: the ability to dump
 objects like function, indexes...

pg_dump already dumps functions and indexes.




Right but you can't dump only one or two functions or only the functions and
nothing else. (the same for index, triggers...)

D.