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
[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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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")
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
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
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
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.
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
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
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
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
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,
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
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
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
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
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
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".
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
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
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
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
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
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 (
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
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
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
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
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
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
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
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)
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
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
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
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
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
> > >
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
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
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
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');
> >
> >
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
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
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
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
> >
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
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
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
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
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
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
>
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
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
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.
> >
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
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 -
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
79 matches
Mail list logo