Re: [GENERAL] maximum size

2005-02-24 Thread Sven Willenberger
On Wed, 2005-02-23 at 15:34 +0100, Molinet Sylviane wrote: > Hello, > > could you be so kind to help me with following requests ? > > I need the maximum size of the following types : > varchar(n) > numeric(n,p) > text > bytea > > Could you please give me the name of articles or publications and

Re: [GENERAL] basic trigger using OLD not working?

2005-02-26 Thread Sven Willenberger
[EMAIL PROTECTED] presumably uttered the following on 02/25/05 19:14: Yes, thank you, I corrected my function from statement level to row level. This did get rid of the error message. However, I still get no output from an OLD variable that should contain data: see the test variable in the simple

Re: [GENERAL] Referencing created tables fails with message that

2005-02-28 Thread Sven Willenberger
Tommy Svensson presumably uttered the following on 02/27/05 18:50: I have just installed Postgresql and tried it for the first time. One very serious problem I ran into was when actually trying to use created tables. Creating a simple table without any foreign keys works OK, but after creating t

Re: [GENERAL] PostgreSQL training

2005-03-14 Thread Sven Willenberger
Alex Adriaanse presumably uttered the following on 03/13/05 15:23: Hi, I'm working on an application for a client that uses PostgreSQL as its database backend. The client wants to train their team on PostgreSQL so that they can maintain the application and the database themselves after it goes

[GENERAL] plperl doesn't release memory

2005-03-23 Thread Sven Willenberger
the plperl function a dozen or so times, the run time for the COPY exceeds 3 minutes. Restarting the PostgreSQL backend (restart) brings the COPY time back down to sub-minute range. Is it normal for plperl to *not* release any memory? Or perhaps plperl is not pfreeing or SPI_FINISHing cleanly

Re: [GENERAL] plperl doesn't release memory

2005-03-24 Thread Sven Willenberger
On Wed, 2005-03-23 at 18:25 -0500, Tom Lane wrote: > Sven Willenberger <[EMAIL PROTECTED]> writes: > > I have been experiencing an issue with plperl and PostgreSQL 8.0.1 in > > that after calling a plperl function memory does not get released. > > AFAICT the result of s

Re: [GENERAL] plperl doesn't release memory

2005-03-24 Thread Sven Willenberger
On Thu, 2005-03-24 at 11:34 -0500, Tom Lane wrote: > Sven Willenberger <[EMAIL PROTECTED]> writes: > > Any suggestions on how to trace what is going on? Debug output methods? > > The first thing to figure out is whether the leak is inside Perl or in > Postgres proper. If

Re: [GENERAL] plperl doesn't release memory

2005-03-24 Thread Sven Willenberger
On Thu, 2005-03-24 at 13:51 -0500, Tom Lane wrote: > Sven Willenberger <[EMAIL PROTECTED]> writes: > > On Thu, 2005-03-24 at 11:34 -0500, Tom Lane wrote: > >> The first thing to figure out is whether the leak is inside Perl or in > >> Postgres proper. If I w

Re: [GENERAL] plperl doesn't release memory

2005-03-24 Thread Sven Willenberger
On Thu, 2005-03-24 at 15:52 -0500, Tom Lane wrote: > Sven Willenberger <[EMAIL PROTECTED]> writes: > > Yes, on these systems, perl was build with -Dusemymalloc (and > > concurrently -Ui_malloc) so there could very well be an issue with > > malloc pools going awry. Doi

Re: [GENERAL] pg_restore

2005-04-05 Thread Sven Willenberger
On Tue, 2005-04-05 at 12:10 +0530, Nageshwar Rao wrote: > Hi, > > I took a dump using the following command > > Pg_dump -f bk.dmp > > > When I tried to restore a table from the dump it just hangs there > > Pg_restore -f bk.dump -t table_name > > > Also tried by giving username also > > A

Re: [GENERAL] sequence advances on failed insert

2005-04-07 Thread Sven Willenberger
David Fetter presumably uttered the following on 04/07/05 20:16: On Thu, Apr 07, 2005 at 07:59:52PM -0400, Matthew Terenzio wrote: I'm noticing that a sequence is advancing even if the insertion fails. Is this weird or expected? It's expected. Sequences are guaranteed to generate unique IDs. Th

Re: [GENERAL] plperl function fails to "fire" Slony trigger

2005-04-22 Thread Sven Willenberger
On Fri, 2005-04-22 at 14:43 -0400, Alvaro Herrera wrote: > On Fri, Apr 22, 2005 at 02:24:57PM -0400, Jan Wieck wrote: > > On 4/22/2005 2:08 PM, Tom Lane wrote: > > > > >Sven Willenberger <[EMAIL PROTECTED]> writes: > > >>We have a replication set

[GENERAL] plperl function fails to "fire" Slony trigger

2005-04-22 Thread Sven Willenberger
We have a replication set up between 2 servers using Slony; both are runnind PostgreSQL 8.0.1. The issue is that when updates/inserts are made to a replicated table, the replication does not occur; apparently this is due to spi_exec somehow not allowing/causing the slony trigger function to fire. T

Re: [GENERAL] Error when try installing pgbench ?

2005-05-15 Thread Sven Willenberger
Andre Nas presumably uttered the following on 05/15/05 05:48: Hello … Im using source postgresql 8.0.3 under FreeBSD and already install, the database is running well. I want to install a pgbench, but I can’t install it, coz an error occur. I try to “make all” in directory ~/src/interfaces/l

Re: [GENERAL] CSV delim quoting differences PgCOPY, Excel etc...

2005-05-17 Thread Sven Willenberger
On Tue, 2005-05-17 at 15:58 -0400, Jerry Sievers wrote: > Hello. > > I confess knowing nothing about MS Excel, don't run Windows, never use > it. > > Anyway, I am often enough having to load Pg databases using SQL COPY > from CSV output written by Excel, that I've had to write a script to > cha

Re: [GENERAL] adding columns with defaults is not implemented

2005-06-02 Thread Sven Willenberger
On Thu, 2005-06-02 at 17:47 -0400, Marcelo wrote: > Hi, > Thanks for your reply, but I have some doubts. > > Are yoy sugesting I create the column as an Integer then change it to > Serial? in Pgsql 7 you cant change a column type. > > If I create the column as an int then add a default value, how

[GENERAL] Postfix/Maildrop and too many connections issues

2005-06-21 Thread Sven Willenberger
We have a system set up whereby postfix and maildrop gather user info from a pg database (7.4.2 on FreeBSD 5.2.1) to do local mail acceptance and delivery. I have configured max connections at 512 but I find that this is not enough and I get "connection limit exceeded for non-superusers" errors. I

Re: [GENERAL] Postfix/Maildrop and too many connections issues

2005-06-21 Thread Sven Willenberger
On Tue, 2005-06-21 at 13:49 -0700, Steve Crawford wrote: > On Tuesday 21 June 2005 12:00 pm, Sven Willenberger wrote: > > We have a system set up whereby postfix and maildrop gather user > > info from a pg database (7.4.2 on FreeBSD 5.2.1) to do local mail > > acceptance

Re: [GENERAL] Postfix/Maildrop and too many connections issues

2005-06-22 Thread Sven Willenberger
On Wed, 2005-06-22 at 01:30 +0200, Roman Neuhauser wrote: > # [EMAIL PROTECTED] / 2005-06-21 15:00:12 -0400: > > We have a system set up whereby postfix and maildrop gather user info > > from a pg database (7.4.2 on FreeBSD 5.2.1) to do local mail acceptance > > and delivery. I have configured max

Re: [GENERAL] Postfix/Maildrop and too many connections issues

2005-06-23 Thread Sven Willenberger
On Thu, 2005-06-23 at 03:39 +, Karl O. Pinc wrote: > On 06/22/2005 08:23:43 AM, Sven Willenberger wrote: > > On Wed, 2005-06-22 at 01:30 +0200, Roman Neuhauser wrote: > > > # [EMAIL PROTECTED] / 2005-06-21 15:00:12 -0400: > > > > We have a system set up whereby po

Re: [GENERAL] PL/pgSQL function to validate UPC and EAN barcodes

2005-06-25 Thread Sven Willenberger
Miles Keaton presumably uttered the following on 06/25/05 01:44: I've made a PL/pgSQL function to validate UPC and EAN barcodes. It works correctly, but is a little ugly. Wondering if any PL/pgSQL experts can offer some suggestions. (I'm new to PL/pgSQL.) Main questions: #1 - I wanted to ad

[GENERAL] PostgreSQL's vacuumdb fails to allocate memory for non-root users

2005-06-29 Thread Sven Willenberger
FreeBSD 5.4-Release PostgreSQL 8.0.3 I noticed that the nightly cron consisting of a vacuumdb was failing due to "unable to allocate memory". I do have maintenance_mem set at 512MB, and the /boot/loader.conf file sets the max datasize to 1GB (verified by limit). The odd thing is that if I run the

Re: [GENERAL] PostgreSQL's vacuumdb fails to allocate memory for

2005-06-29 Thread Sven Willenberger
On Wed, 2005-06-29 at 09:43 -0400, Douglas McNaught wrote: > Sven Willenberger <[EMAIL PROTECTED]> writes: > > > FreeBSD 5.4-Release > > PostgreSQL 8.0.3 > > > > I noticed that the nightly cron consisting of a vacuumdb was failing due > > to "unable

Re: [GENERAL] PostgreSQL's vacuumdb fails to allocate memory for

2005-06-29 Thread Sven Willenberger
On Wed, 2005-06-29 at 11:21 -0400, Tom Lane wrote: > Sven Willenberger <[EMAIL PROTECTED]> writes: > > ERROR: out of memory > > DETAIL: Failed on request of size 536870910. > > That's a server-side failure ... > > > Again, if I log in as myself and try

Re: [GENERAL] PostgreSQL's vacuumdb fails to allocate memory for

2005-06-29 Thread Sven Willenberger
On Wed, 2005-06-29 at 14:59 -0400, Vivek Khera wrote: > On Jun 29, 2005, at 9:01 AM, Sven Willenberger wrote: > > > Unix user root (and any psql superuser) the vacuum runs fine. It is > > when > > the unix user is non-root (e.g. su -l pgsql -c "vacuumdb -a -z")

Re: [GENERAL] PostgreSQL's vacuumdb fails to allocate memory for

2005-06-29 Thread Sven Willenberger
On Wed, 2005-06-29 at 16:40 -0400, Charles Swiger wrote: > On Jun 29, 2005, at 4:12 PM, Sven Willenberger wrote: > [ ... ] > > Something I have noticed, > > when the memory error occurs during the psql session (after a failed > > vacuumdb attempt) the memory stays at 6

Re: [GENERAL] PostgreSQL's vacuumdb fails to allocate memory for

2005-06-29 Thread Sven Willenberger
On Wed, 2005-06-29 at 16:58 -0400, Sven Willenberger wrote: > On Wed, 2005-06-29 at 16:40 -0400, Charles Swiger wrote: > > On Jun 29, 2005, at 4:12 PM, Sven Willenberger wrote: > > [ ... ] > > > Something I have noticed, > > > when the memory error occurs during

Re: [GENERAL] PostgreSQL's vacuumdb fails to allocate memory for

2005-06-29 Thread Sven Willenberger
Tom Lane presumably uttered the following on 06/29/05 19:12: Sven Willenberger <[EMAIL PROTECTED]> writes: I have found the answer/problem. On a hunch I increased maxdsiz to 1.5G in the loader.conf file and rebooted. I ran vacuumdb and watched top as the process proceeded. What I s

Re: [GENERAL] COnsidering a move away from Postgres

2005-06-30 Thread Sven Willenberger
On Thu, 2005-06-30 at 10:18 -0500, Jason Tesser wrote: > HI > > On Thursday 30 June 2005 9:20 am, Tom Lane wrote: > > Jason Tesser <[EMAIL PROTECTED]> writes: > > > 1. Our dev plan involves alot of stored procedures to be used and we have > > > found the way this is done in PG to be painful. (ie.

Re: [GENERAL] weirdness with the a sql update

2005-08-04 Thread Sven Willenberger
On Thu, 2005-08-04 at 09:19 -0500, Tony Caduto wrote: > Hi, > > I just noticed this, if I do a update like this: > > update new_requests set name = 'tony' where request_id = 2 > > If I do a select * from new_requests that record I just updated is now > at the bottom , before the update it was a

Re: [GENERAL] Index not being used unless enable_seqscan=false

2005-08-10 Thread Sven Willenberger
On Wed, 2005-08-10 at 12:01 -0700, Shane wrote: > Hello all, > > I am working with a simple table and query abut cannot seem > to get it to use the index I have created. However, if I > set enable_seqscan=false, the index is used and the query > is much faster. I have tried a vacuum analyze but

Re: [GENERAL] Index not being used unless enable_seqscan=false

2005-08-10 Thread Sven Willenberger
On Wed, 2005-08-10 at 12:58 -0700, Shane wrote: > On Wed, Aug 10, 2005 at 03:31:27PM -0400, Sven Willenberger wrote: > > Right off the bat (if I am interpreting the results of your explain > > analyze correctly) it looks like the planner is basing its decision to > > seqscan

Re: [GENERAL] Index not being used unless enable_seqscan=false

2005-08-10 Thread Sven Willenberger
On Wed, 2005-08-10 at 13:31 -0700, Shane wrote: > On Wed, Aug 10, 2005 at 04:24:51PM -0400, Sven Willenberger wrote: > > On Wed, 2005-08-10 at 12:58 -0700, Shane wrote: > > > On Wed, Aug 10, 2005 at 03:31:27PM -0400, Sven Willenberger wrote: > > > > Right off the

Re: [GENERAL] Serial Unique question

2005-08-15 Thread Sven Willenberger
On Mon, 2005-08-15 at 11:48 -0400, Madison Kelly wrote: > Douglas McNaught wrote: > > Madison Kelly <[EMAIL PROTECTED]> writes: > > > > > >> I want to use a 'serial uniue' column in a table but there is > >> likely to be many, many inserts and deletes from this column. I was > >> wondering,

Re: [GENERAL] PostgreSQL 8.0.3 limiting max_connections to 64 ?

2005-08-17 Thread Sven Willenberger
On Wed, 2005-08-17 at 13:05 -0300, eu wrote: > Hello, i need help... > > i have a postgresql 8.0.3 database running on the backend of a postfix > setup ( i didn't trust Mysql for the job ) on Linux kernel 2.6.8.1, > serving email to a dozen different virtual domains ( including this one > i'm u

Re: [GENERAL] strip zeros from fractional part

2005-10-04 Thread Sven Willenberger
On Mon, 2005-10-03 at 16:36 -0300, Giovanni M. wrote: > Yes! That did it, thanks for the help > > On 10/3/05, Tony Wasson <[EMAIL PROTECTED]> wrote: > > On 10/3/05, Giovanni M. <[EMAIL PROTECTED]> wrote: > > > Round and trunc dont provide the functionality I need. > > > > > > Say for example I hav

Re: [GENERAL] Restoring Database created on windows on FreeBSD

2005-10-19 Thread Sven Willenberger
On Wed, 2005-10-19 at 08:23 +0200, [EMAIL PROTECTED] wrote: > Hi > > I am very new to FreeBSD (Windows Background), but am busy trying to > implement a PostgreSQL database that I have running in the Windows > environemtn on FreeBSD. Naturally, most of my problems so far have been > geeting to grip

Re: [GENERAL] Restoring Database created on windows on FreeBSD

2005-10-19 Thread Sven Willenberger
On Wed, 2005-10-19 at 15:55 +0200, [EMAIL PROTECTED] wrote: > Hi Sven > > Thanks for the help. This looks like the kind of info I needed. > One question: > You suggest that I use : pkg_add -r postgresql80-server. If this requires > postgresql80-client, will it automatically download it and install

[GENERAL] NEW in Rule makes another nextval call?

2005-10-20 Thread Sven Willenberger
On a table ("customer") I have a rule set up that is designed to update a "contacts" table with a customer id once the customer is added to the customer table. (Yes, this does seem backwards but it has to do with the way this system of web-based signups gets translated into a customer record). CR

Re: [GENERAL] NEW in Rule makes another nextval call?

2005-10-20 Thread Sven Willenberger
On Thu, 2005-10-20 at 15:01 +0100, Richard Huxton wrote: > Sven Willenberger wrote: > > Is this intended behavior? or is the NEW > > acting as a macro that is replace by "nextval()" ? > > Well, it's understood behaviour even if not quite "intended".

Re: [GENERAL] PostgreSQL on 64-bit operating systems

2005-11-01 Thread Sven Willenberger
On Tue, 2005-11-01 at 22:00 +0200, Craig wrote: > Hi > > I am going to be hosting a PostgreSQL database on a new server. We > will be purchasing a server with the AMD Athlon 64 3200+ processor. > We are now posed with a choice of "FreeBSD 5.4" or "FreeBSD 5.4 > x86_64Bit". My question is: Will P

[GENERAL] Function to insert entire row%ROWTYPE into other table

2005-11-02 Thread Sven Willenberger
Postgresql 8.0.4 using plpgsql The basic function is set up as: CREATE FUNCTION add_data(t_row mytable) RETURNS VOID AS $func$ DECLARE newtable text; thesql text; BEGIN INSERT INTO newtable thename from mytable where lookup.id = t_row.id; thesql := 'INSERT INTO ' || newtable || VAL

Re: [GENERAL] About not to see insertion result "INSERT 0 1"

2005-11-21 Thread Sven Willenberger
Emi Lu presumably uttered the following on 11/21/05 15:40: Greetings, I tried to run insert command from a .sql file. For example, in a.sql file there are 100,000 lines like insert into t1 values(... ...); insert into t1 values(... ...); insert into t1 values(... ...); ... ... I do not want

Re: [GENERAL] Anyone know a good opensource CRM that actually installs with Posgtres?

2007-03-09 Thread Sven Willenberger
On Fri, 2007-03-09 at 01:22 +, Bradley Kieser wrote: > I hope that someone has cracked this one because I have run into a brick > wall the entire week and after 3 all-nighters with bad installations, I > would appreciate hearing from others! > > I am looking for a decent OpenSource CRM syste

Re: [GENERAL] postgresql 8.1.4 to 8.2.3

2007-04-17 Thread Sven Willenberger
On Sat, 2007-04-14 at 22:01 +0200, Anton Melser wrote: > On 14/04/07, Alain Roger <[EMAIL PROTECTED]> wrote: > > After clicking on your link i got "invalid project" page :-( > > and the whole page is empty... > > Ouch Alain... > Try > http://pgfoundry.org/projects/pg-migrator/ > :-) > But ask a si

[GENERAL] Overhead of dynamic query in trigger

2004-12-03 Thread Sven Willenberger
I am curious as to how much overhead building a dynamic query in a trigger adds to the process. The example: Have a list of subcontractors, each of which gets unique pricing. There is a total of roughly 100,000 items available and some 100 subcontractors. The 2 design choices would be 100 tables (

Re: [GENERAL] handing created and updated fields

2005-01-10 Thread Sven Willenberger
On Mon, 2005-01-10 at 15:45 +0100, Daniel Martini wrote: > Hi, > > Citing "Jim C. Nasby" <[EMAIL PROTECTED]>: > > ON INSERT: force created and updated to be current_timestamp > > ON UPDATE: deny updated created. force updated to be set to > > current_timestamp > [snip] > > Does anyone have an exam

Re: [GENERAL] querying two connections in one query

2005-01-24 Thread Sven Willenberger
On Mon, 2005-01-24 at 14:48 +, Abdul-Wahid Paterson wrote: > Hi, > > Is it possible, perhaps through some extension, to query two database > through one SQL select statement where the two databases have > different connections? Something similar to how you can link databases > in Oracle. > I

[GENERAL] Moving within a cursor declared in plpgsql function

2005-01-28 Thread Sven Willenberger
I have searched the web/archives for a solution to this and have found a few entries to my question but nothing definitive. In essence I have a function that opens a cursor (refcursor). It would appear though that one can only traverse the cursor forward-only and only one record at a time; is there

Re: [GENERAL] Moving from Sybase to Postgres - Stored Procedures

2005-01-29 Thread Sven Willenberger
Andre Schnoor wrote: "Joshua D. Drake" wrote: Andre Schnoor wrote: Hi, I am moving from Sybase to pgsql but have problems with stored procedures. The typical procedure uses a) named parameters, b) local variable declarations and assignments c) transactions d) cursors, views, etc. I can't seem to f

Re: [GENERAL] PL/pgSQL functions and RETURN NEXT

2005-01-30 Thread Sven Willenberger
Craig Bryden wrote: Hi Firstly, let me say that I am a newbie to PostgreSQL. I have written a PL/pgSQL function that will return a set of results. I have included the code below *** CREATE TYPE

Re: [GENERAL] FreeBSD 5.2.1, postgresql 7.4.5 and shared memory settings

2005-01-30 Thread Sven Willenberger
Rick Apichairuk wrote: I tried the settings you gave and they worked (with some caveats). After I recompiled the FreeBSD kernel with the options: options SYSVSHM options SYSVMSG options SYSVSEM options SHMMAXPGS=131072 options SEMMNI=128 options SEMM

Re: [GENERAL] FreeBSD 5.2.1, postgresql 7.4.5 and shared memory settings

2005-01-31 Thread Sven Willenberger
Rick Apichairuk wrote: On Sun, 30 Jan 2005 21:12:08 -0500, Sven Willenberger <[EMAIL PROTECTED]> wrote: I assume you added these variables to either the GENERIC or a custom kernel in /usr/src/sys/i386/conf. If you created a custom kernel called CUSTOM, then you would: That's what I

Re: [GENERAL] Howto determin the number of elemnts of an array

2005-01-31 Thread Sven Willenberger
Együd Csaba wrote: Hi, how can I determin the number of elements of an array? I saw function array_dims() which returns a string value representing the dimensions of the array. Is there a function which returns only the number of elements as an integer. -- Csaba array_upper(arrayname,dimension)

[GENERAL] Dereferencing a 2-dimensional array in plpgsql

2005-01-31 Thread Sven Willenberger
I am having an issue with trying to dereference a 2-dimensional array in plpgsql. The idea is to have an setup like: DECLARE myarray varchar[][]; myvar char; BEGIN --stuff myarray[1] := ''{value1,value2,value3}''; myarray[2] := ''{valuea,valueb,valuec}''; --If I then: myvar := array[1][1]; --I

Re: [GENERAL] Dereferencing a 2-dimensional array in plpgsql

2005-01-31 Thread Sven Willenberger
Tom Lane wrote: Sven Willenberger <[EMAIL PROTECTED]> writes: I am having an issue with trying to dereference a 2-dimensional array in plpgsql. The idea is to have an setup like: DECLARE myarray varchar[][]; myvar char; BEGIN --stuff myarray[1] := ''{value1,value2,valu

Re: [GENERAL] Dereferencing a 2-dimensional array in plpgsql

2005-01-31 Thread Sven Willenberger
Tom Lane wrote: Sven Willenberger <[EMAIL PROTECTED]> writes: The problem stems from being unable to assign values to an array without first initializing the array in plpgsql. I think we changed this in 8.0. Before 8.0, trying to assign to an element of a NULL array yielded a NULL result

Re: [GENERAL] Error in trigger after upgrading to 8.0.1?

2005-02-05 Thread Sven Willenberger
would appear as though the function in question was not created as a VOLATILE function (i.e. it was created with the STABLE or IMMUTABLE attribute). Can you try and: CREATE OR REPLACE FUNCTION function_name .. AS $$ $$ LANGUAGE plpgsql VOLATILE; Sven Willenberger ---(e

Re: [GENERAL] databases/p5-postgresql-plperl links to wrong libperl.so

2005-02-11 Thread Sven Willenberger
On Fri, 2005-02-11 at 21:35 +0100, Anton Berezin wrote: > On Fri, Feb 11, 2005 at 11:10:15AM -0500, Sven Willenberger wrote: > > On Fri, 2005-02-11 at 16:46 +0100, Palle Girgensohn wrote: > > > --On fredag, februari 11, 2005 10.24.22 -0500 Sven Willenberger > > >

Re: [GENERAL] databases/p5-postgresql-plperl links to wrong libperl.so

2005-02-11 Thread Sven Willenberger
On Fri, 2005-02-11 at 23:20 +0100, Anton Berezin wrote: > On Fri, Feb 11, 2005 at 11:09:35PM +0100, Anton Berezin wrote: > > On Fri, Feb 11, 2005 at 04:41:55PM -0500, Sven Willenberger wrote: > > > On Fri, 2005-02-11 at 21:35 +0100, Anton Berezin wrote: > > > > On F

Re: [GENERAL] databases/p5-postgresql-plperl links to wrong

2005-02-11 Thread Sven Willenberger
On Fri, 2005-02-11 at 18:35 -0500, Tom Lane wrote: > Sven Willenberger <[EMAIL PROTECTED]> writes: > > it looks like the sed line is stripping out pgac_tmp2 from the pgac_tmp1 > > leaving the system to use the default perl libperl.so. > > when I modified perl_embed_l

Re: [GENERAL] databases/p5-postgresql-plperl links to wrong

2005-02-11 Thread Sven Willenberger
On Fri, 2005-02-11 at 19:54 -0500, Tom Lane wrote: > Sven Willenberger <[EMAIL PROTECTED]> writes: > > The rpath solution you provided to patch GNUmakefile did not > > work however, bailing with: > > > gcc -O2 -fno-strict-aliasing -Wmissing-declarations, -Wl, &g

Re: [GENERAL] find last day of month

2005-12-09 Thread Sven Willenberger
On Fri, 2005-12-09 at 15:27 -0500, Chris Browne wrote: > "Andrus Moor" <[EMAIL PROTECTED]> writes: > > > I have a table containing month column in format mm. > > > > create table months ( tmkuu c(7)); > > insert into months values ('01.2005'); > > insert into months values ('02.2005'); > > > >

Re: [GENERAL] insert serial numbers

2006-01-04 Thread Sven Willenberger
Albert Vernon Smith presumably uttered the following on 01/03/06 13:36: I figured it out myself. Not TOO difficult. I was just having a hard time wading through the documentation before. Giving the answer out here, just in case any one else wants to see the solution (not using reserved

Re: [GENERAL] Best way to handle table trigger on update

2006-02-01 Thread Sven Willenberger
On Tue, 2006-01-31 at 13:45 -0600, Justin Pasher wrote: > Postgres 7.4.7 (I know, a little old, but we haven't had a chance to > upgrade) > > I have a table that stores menu items for a side navigation menu for a web > site. Each menu item has a "position" column set that determines where to > put

Re: [GENERAL] Best way to handle table trigger on update

2006-02-02 Thread Sven Willenberger
On Thu, 2006-02-02 at 08:58 -0600, Justin Pasher wrote: > > -Original Message- > > From: Sven Willenberger [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, February 01, 2006 2:13 PM > > To: Justin Pasher > > Cc: pgsql-general@postgresql.org > > Subje

Re: [GENERAL] Best way to handle table trigger on update

2006-02-02 Thread Sven Willenberger
On Thu, 2006-02-02 at 10:16 -0500, Sven Willenberger wrote: > On Thu, 2006-02-02 at 08:58 -0600, Justin Pasher wrote: > > > -Original Message- > > > From: Sven Willenberger [mailto:[EMAIL PROTECTED] > > > Sent: Wednesday, February 01, 2006 2:13 PM > >

Re: [GENERAL] out of memory for query result

2006-05-03 Thread Sven Willenberger
On Sat, 2006-04-22 at 15:08 -0400, Tom Lane wrote: > Francisco Reyes <[EMAIL PROTECTED]> writes: > > What resource do I need to increase to avoid the error above? > > Process memory allowed to the client; this is not a server-side error. > I am experiencing an "out of memory" situation as well o

Re: [GENERAL] out of memory for query result

2006-05-03 Thread Sven Willenberger
On Wed, 2006-05-03 at 13:16 -0400, Douglas McNaught wrote: > Sven Willenberger <[EMAIL PROTECTED]> writes: > > > On Sat, 2006-04-22 at 15:08 -0400, Tom Lane wrote: > >> Francisco Reyes <[EMAIL PROTECTED]> writes: > >> > What resource d

[GENERAL] VACUUM FULL versus CLUSTER ON

2006-07-07 Thread Sven Willenberger
Postgresql 8.0.4 on FreeBSD 5.4 I have a table consisting of some 300million rows that, every couple of months, has 100 million rows deleted from it (an immediately vacuumed afterward). Even though it gets routinely vacuumed (the only deletions/updates are just the quarterly ones), the freespace m

Re: [GENERAL] VACUUM FULL versus CLUSTER ON

2006-07-07 Thread Sven Willenberger
On Fri, 2006-07-07 at 09:55 -0700, Joshua D. Drake wrote: > On Friday 07 July 2006 08:19, Sven Willenberger wrote: > > Postgresql 8.0.4 on FreeBSD 5.4 > > > > I have a table consisting of some 300million rows that, every couple of > > months, has 100 million rows dele

Re: [GENERAL] VACUUM FULL versus CLUSTER ON

2006-07-07 Thread Sven Willenberger
On Fri, 2006-07-07 at 10:41 -0700, Joshua D. Drake wrote: > > > Sincerely, > > > > > > Joshua D. Drake > > > > Doing a quick check reveals that the relation in question currently > > consumes 186GB of space (which I highly suspect is largely bloat). > > Good lord.. .186 gig for a 300 million row t

Re: [GENERAL] VACUUM FULL versus CLUSTER ON

2006-07-07 Thread Sven Willenberger
Sven Willenberger presumably uttered the following on 07/07/06 13:52: > On Fri, 2006-07-07 at 10:41 -0700, Joshua D. Drake wrote: >>>> Sincerely, >>>> >>>> Joshua D. Drake >>> Doing a quick check reveals that the relation in question currently >

Re: [GENERAL] VACUUM FULL versus CLUSTER ON

2006-07-10 Thread Sven Willenberger
On Mon, 2006-07-10 at 10:50 -0500, Scott Marlowe wrote: > On Sat, 2006-07-08 at 10:20, Joshua D. Drake wrote: > > > > > > Unfortunately it would appear that I cannot vacuum full either as I get an > > > out of memory error: > > > > > > > > > # - Memory - > > > > > > shared_buffers = 5000

Re: [GENERAL] psql seems to hang during delete query

2006-07-20 Thread Sven Willenberger
On Thu, 2006-07-20 at 12:48 +0530, surabhi.ahuja wrote: > so how much space should be free so that i am able to delete > > i have a hard disk of size 130 G. > > > thanks, > regards > Surabhi > > > __ If you are trying to de

Re: [GENERAL] timestamp and calculations.

2006-07-20 Thread Sven Willenberger
On Thu, 2006-07-20 at 11:57 +0200, Andreas Kretschmer wrote: > Thor Tall <[EMAIL PROTECTED]> schrieb: > > > Hi, > > > > I am new to postgres sql and have a problem with an > > sql statement which I hope you can help me with. > > > > I want to do some calculation on the result of a > > query. > >

[GENERAL] pg_restore with Fc fails with [archiver] out of memory error

2004-08-10 Thread Sven Willenberger
Created a pg_dump with Fc (custom format compression) that resulted in a 300+MB file. Now trying to pg_restore this thing fails with either an out of memory error (as in the subject line) on FreeBSD 4.10-STABLE or a: pg_restore in malloc(): error: allocation failed Abort (core dumped) error on Fre

Re: [GENERAL] pg_restore with Fc fails with [archiver] out of memory

2004-08-10 Thread Sven Willenberger
Tom Lane wrote: Sven Willenberger <[EMAIL PROTECTED]> writes: pg_restore in malloc(): error: allocation failed Abort (core dumped) A stack trace from that core file would be useful in figuring out what the problem is... also, what PG version is this? regards, tom lane psql -

Re: [GENERAL] pg_restore with Fc fails with [archiver] out of

2004-08-12 Thread Sven Willenberger
On Tue, 2004-08-10 at 19:28 -0400, Sven Willenberger wrote: > > Tom Lane wrote: > > Sven Willenberger <[EMAIL PROTECTED]> writes: > > > >>pg_restore in malloc(): error: allocation failed > >>Abort (core dumped) > > > > > > A stack tr