[GENERAL] Triggers question

s type for SOME_TYPE (see above example).How can I write such trigger? I mean, what is the correct prototype of this trigger function?Thanks in advance/ycrux

[GENERAL] PL/pgSQL question

Hi All! I'm trying to get working the below PL/pgSQL function without sucess. The function is correctly created, but when I tested it i got: # SELECT grantAccess('sara', 'sarapass'); ERROR: set-valued function called in context that cannot accept a set CONTEXT: PL/pgSQL function "grantaccess" l

Re: [GENERAL] PL/pgSQL question

_type IN SELECT column1_table1, column17_table2 FROM table1, table2 WHERE some_conditions LOOP RETURN NEXT some_type; END LOOP; RETURN; $$ LANGUAGE 'plpgsql' STABLE; Thanks in advance Younes Message d'origi

Re: [GENERAL] getting failed while creating user accounts

Hi! Try : http://yhafri.club.fr/crux/postgresql/Pkgfile http://yhafri.club.fr/crux/postgresql/README Let me know if you still have install problems cheers Younes venu gopal a écrit : Hi all, I m trying to install postgres8.1 on my system.I tried with account name postgres.I was getting an

Re: [GENERAL] Turn OFF Stats of Postgresql

Ho Marcos! You can also try to adpat this parameters to your config: TUNING: * First, see: http://www.lyris.com/lm_help/6.0/tuning_postgresql.html * Adjust this params in your "/etc/sysctl.conf" to obtain the best performances: kernel.shmmax=7000 kernel.s

[GENERAL] PostgreSQL Free Visual Manager

Hi Folks! I'm looking for a free or open source PostgreSQL visual manager (Linux or Windows). My aim is to quickly create and manage databases. The ability to export DB schema to file will be really useful for me. Thanks in advance /youn ---(end of broadcast)-

Re: [GENERAL] PostgreSQL Free Visual Manager

Thanks guys, I'll give it a try cheers /youn Moises Alberto Lindo Gutarra a écrit : http://www.pgadmin.org/ 2006/3/15, Ycrux <[EMAIL PROTECTED]>: Hi Folks! I'm looking for a free or open source PostgreSQL visual manager (Linux or Windows). My aim is to quickly c

[GENERAL] Postgresql string parsing

Hi Folks, I'm looking for the fatest way to parse string in a postgresql function and insert each parsed chunk in a table. Something like that: CREATE FUNCTION parse_and_insert(text) RETURNS integer AS ' DECLARE my_string ALIAS FOR $1; -- empty string, do nothing IF my_stri

[GENERAL] functions behaviours

Hi All! I'm wondering if there is an elegant way to add simple behaviours to stored Postgres functions. 1. First, what I want to get here is a function which orders their results columns in ASC at one time and in DESC next time it is called. Something like that: CREATE FUNCTION sort_swap(inte