[GENERAL] can function arguments have the type tablename.columnname%TYPE?

2010-05-11 Thread Dino Vliet
Hi people, I'm writing a plpgsql function in pgadminIII and want to know if the arguments can have the following type: tablename.columnname%TYPE If so, how do I accomplish this in pgadminIII as it doesn't allow me to change the arguments to this type. The function I'm writing looks like this:

[GENERAL] last and/or first in a by group

2010-05-16 Thread Dino Vliet
Dear postgresql experts, I want to know if postgresql has facilities for getting the first and or the last in a by group. Suppose I have the following table: resnr,dep,arr,cls,dbd meaning reservationsnumber, departure station, arrival station, the class of the reservation and the daysbeforedep

Re: [GENERAL] last and/or first in a by group

2010-05-21 Thread Dino Vliet
From: "Thomas Kellerer" To: "" Dino Vliet wrote on 16.05.2010 18:07: > Dear postgresql experts, > > I want to know if postgresql has facilities for getting the first and or > the last in a by group. > > Suppose I have the following table: > > resn

[GENERAL] How to improve: performance of query on postgresql 8.3 takes days

2010-07-29 Thread Dino Vliet
Dear postgresql list, I have some troubles generating data for a analysis task at hand. I have a table (table A) containing 5 million records and 28 number of attributes. This table is 461MB big if I copy it to a csv file. I want to create another table (table B) based o

[GENERAL] general questions postgresql performance config

2010-01-25 Thread Dino Vliet
Dear postgresql people,   Introduction Today I've been given the task to proceed with my plan to use postgresql and other open source techniques to demonstrate to the management of my department the usefullness and the "cost savings" potential that lies ahead. You can guess how excited I am r

[GENERAL] join two tables without a key

2010-04-03 Thread Dino Vliet
Hi postgresql list, If I have two tables with the same number of rows but different columns and I want to create one table out of them what would be the way to do that in postgresql? Table A has N number of rows and columns X,Y,Z and Table B has N number of rows and P,Q,R as columns. None of

Re: [GENERAL] join two tables without a key

2010-04-03 Thread Dino Vliet
--- On Sat, 4/3/10, Raymond O'Donnell wrote: From: Raymond O'Donnell Subject: Re: [GENERAL] join two tables without a key To: "Dino Vliet" Cc: pgsql-general@postgresql.org Date: Saturday, April 3, 2010, 1:01 PM On 03/04/2010 11:16, Dino Vliet wrote: > Hi postgresql lis

[GENERAL] managing kernel

2005-04-17 Thread Dino Vliet
My sysadmin has changed the values for shmall to 256MB (268435456) and shmmax to 1GB (1073741824) and I wonder if these values seem ok to you. We are working on a linux system (2.4 kernel) and have 2 GB RAM at our disposal. I have this large database running (15 million records). Are there any oth

Re: [GENERAL] managing kernel

2005-04-17 Thread Dino Vliet
sider changing in order to boost performance. I'm using postgresql 7.4. Brgds Dino --- Dino Vliet <[EMAIL PROTECTED]> wrote: > My sysadmin has changed the values for shmall to > 256MB > (268435456) and shmmax to 1GB (1073741824) and I > wonder if these values seem ok to you. W

[GENERAL] reporting solution for postgresql

2005-05-24 Thread Dino Vliet
Hi folks, Maybe a little bit off topic, but I want to convince my managers of the value of opensource products and decided that I will reverse engineer the datawarehouse at my company. We are a small player and our datawarehouse solution is based on an ETL tool from Informatica, Oracle and Busines

[GENERAL] /libexec/ld-elf.so.1: Shared object "libpq.so.4" not found

2007-02-28 Thread Dino Vliet
Hi folks, when I start pgadmin3 on my system I get the following error: /libexec/ld-elf.so.1: Shared object "libpq.so.4" not found, required by "pgadmin3" The only thing I have done lately is upgrade the database to 8.2 in the freebsd ports system. Pgadmin did work in the past, so what could

[GENERAL] why can't I increase shared buffers to higher value?

2007-02-28 Thread Dino Vliet
I have the following config but increasing the shared buffers to a value greater then 32 doesn't let the database server start (I want a value of 256MB there because I will have a giant table of 12 million rows which will be qeuried extremely). I have a 3GB RAM amd64 system running freebsd 6.1

[GENERAL] relations betwee subclasses in postgersql

2004-11-15 Thread Dino Vliet
and if so, when will this be fixed? Brgds Dino Vliet __ Do you Yahoo!? Check out the new Yahoo! Front Page. www.yahoo.com ---(end of broadcast)--- TIP 9: the planner will ignore your desire to

[GENERAL] frustrated by plpgsql procedure

2006-03-27 Thread Dino Vliet
Hi guys, I trying for days to get this simple plpgsql procedure to run but I keep getting this error: psql:pgsql_procedure.txt:15: ERROR: syntax error at or near at character 17 QUERY: copy cancel TO $1 with delimiter as ',' null as '.' CONTEXT: SQL statement in PL/PgSQL function doedit near

Re: [GENERAL] frustrated by plpgsql procedure

2006-03-27 Thread Dino Vliet
Nope:-( I added it just now and still the same error message!! --- Bricklen Anderson <[EMAIL PROTECTED]> wrote: > Dino Vliet wrote: > > Hi guys, > > > > I trying for days to get this simple plpgsql > procedure > > to run but I keep getting this error:

Re: [GENERAL] frustrated by plpgsql procedure

2006-03-27 Thread Dino Vliet
Ok thanks for now. I understood the problem and what I should do to fix it. Will try that later. Thanks for all the tips and the REALLY FAST answers!! --- John DeSoi <[EMAIL PROTECTED]> wrote: > > On Mar 27, 2006, at 2:10 PM, Dino Vliet wrote: > > > Can somebody te

[GENERAL] execute in pl/pgsql

2006-09-10 Thread Dino Vliet
Hi, In my pl/pgsql procedure I have the following line: execute 'copy cancella to ' || location || ' with delimiter as \',\''; Location is a string that gives the absolute pathname. It's obvious what I'm aiming for, but this still gives an error because of the two '' I'm missing around the loca

Re: [GENERAL] execute in pl/pgsql

2006-09-10 Thread Dino Vliet
Solved:-) Thanks for your aanswer, now I can go further with exploring pl/pgsql. Looks nice. Brgds --- Tom Lane <[EMAIL PROTECTED]> wrote: > Dino Vliet <[EMAIL PROTECTED]> writes: > > In my pl/pgsql procedure I have the following > line: > > > execute 'co

[GENERAL] can postgresql handle these large tables

2004-08-18 Thread Dino Vliet
Hi folks, I'm busy with analyzing some data and therefore will have to store 2 big tables containing 50 million obs & 25 million obs. Selecting some interesting obs can decrease these tables with maybe a factor 10 but eventually I will have to combine them using a join. These tables contain almost

[GENERAL] help with trigger

2004-08-25 Thread Dino Vliet
Hi folks, I'm new to PostgreSQL and am busy tring to work with it. Of pl/pgsql I know even less and that's the part I have a question on right now. I have this nice example to get me started with pl/pgsql... I have a table with the schedule of a service my sport team wants to offer: Table Sch

[GENERAL] job for sql, pl/pgsql,gawk,perl or ??

2004-08-27 Thread Dino Vliet
Dear all, I have this problem with getting information out of my database and I don't know if it is my knowledge of sql or that this is something that can't be done in sql. I have the following table: id fdateprod pricestat nr_items sdate x1 23-11-2003123 456 yes 7

Re: [GENERAL] help with trigger

2004-08-27 Thread Dino Vliet
Maybe I've missed it but can someone plese help me with this? Brgds and thanks in advance, --- Dino Vliet <[EMAIL PROTECTED]> wrote: > Hi folks, > I'm new to PostgreSQL and am busy tring to work with > it. Of pl/pgsql I know even less and that's the part > I

Re: [GENERAL] error: insert has more expressions than target column

2004-09-07 Thread Dino Vliet
alles() RETURNS trigger AS ' BEGIN FOR i in 0..7 LOOP INSERT INTO lessons (..) SELECT dayofweek,startdate + (i*7), enddate + (i*7),...; RETURN NEW; END LOOP; END; ' LANGUAGE plpgsql; --- Richard Huxton <[EMAIL PROTECTED]> wrote: > Dino Vliet wrote: > > I'm gett