Re: [GENERAL] help with plpgsql

On Apr 21, 2008, at 8:51 AM, Pau Marc Munoz Torres wrote: psql:/usr/local/Make2D-DB_II /pgsql/make2db_functions.pgsql:85: ERROR: language plpgsql does not exist HINT: Use CREATE LANGUAGE to load the language into the database. and then when I try to create the language, i get geldb=#

[GENERAL] Schema migration tools?

this exist? If not, I might have a new project... Thanks! -- Christophe -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Postgresql 7.4.3/8.2.4 out of memory

on client connection -- Dr Christophe COMBET Tel: (+33) (0)4 37 65 29 47 Fax: (+33) (0)4 72 72 26 04 Pôle BioInformatique Lyonnais - Lyon Gerland - http://pbil.ibcp.fr IBCP (UMR 5086 CNRS - Université Lyon 1) - http://www.ibcp.fr 7, passage du Vercors - 69367 Lyon - FRANCE

[GENERAL] Postgresql 7.4.3/8.2.4 out of memory

Dear all, With the below transaction we got an out of memory error. BEGIN; ANALYZE referenceAuthorLnkTemp; INSERT INTO referenceAuthor (author) SELECT DISTINCT ON (author) author FROM referenceAuthorLnkTemp; ANALYZE referenceAuthor; UPDATE referenceAuthorLnkTemp SET

Re: [GENERAL] Best way to store and retrieve photo from PostGreSQL

Hello Tomas, Tomas Vondra wrote: Store the pictures in the filesystem and only the path, description and other metadata in the database. My suggestion ;-) Andreas Anyway, I do recommend storing images in the database, using a 'bytea' column for the binary data (and load them only if

[GENERAL] skip duplicate key error during inserts

Hello,I have a table like this:create table dummy (value integer primary key);and I insert a row like thisinsert into dummy values(0);then I want to insert three rows:insert into dummy values(0);insert into dummy values(1);insert into dummy values(2);none of them will be inserted because the first

Re: [GENERAL] looping through query to update column

Thanks for the "ctid" trick. The code below worked fine for rec in select * from fromemail_trades loop update fromemail_trades set recordid = row where ctid = rec.ctid; row := row -1; end loop;The first line is a little different from your's: FOR row IN SELECT ctid, * FROM table FOR UPDATE

[GENERAL] looping through query to update column

Hello,I am trying to loop through a table to update one columncreate or replace function foo() returns integer as $$declare rec RECORD; row integer := 0;begin for rec in select * from table loop update rec set recordid = row; row++; end loop; return 0;end;$$ language plpgsqlIn pgadmin, I am

Re: [GENERAL] Storing images in PostgreSQL databases (again)

? I would certainly like! For instance, I would like to get the pictures whose main color is green (requirement from a real project), and a select * from images where main_color(image) = 'green' would be nice.JCR- Original Message From: Alexander Staubo [EMAIL PROTECTED]To: Jean-Christophe

Re: [GENERAL] Storing images in PostgreSQL databases (again)

Hi,If the database had built-in functions to manipulate images (make a thumbnail, add text ont it.., make a montage of two pictures) and I could write something like select thumbnail(image_field, 100, 100) from images_tablethat would be a good reason to go the db route versus the filesystem route.

[GENERAL] now() and time zone

Hello,I am a bit sorry to come back on that topic but I just cannot get it right. How comes that select now() at time zone 'EST'returns "2006-10-04 15:59:26.713623"when it is actually 16:59 on the east coast? Can it be that the server where the PostgreSQL database is located is not properly

Re: [GENERAL] now() and time zone

Yes you are right, that's what I have just realized; I should be using EDT instead of EST. Sorry for the botherJCR- Original Message From: Martijn van Oosterhout kleptog@svana.orgTo: Jean-Christophe Roux [EMAIL PROTECTED]Cc: pgsql-general@postgresql.orgSent: Wednesday, October 4, 2006 5:06

Re: [GENERAL] pg web hosting with tsearch2?

I don't know if A2webhosting.com specifically supports tsearch2, but they say they offer 8.1 with procedural language installed.JCR- Original Message From: Joshua D. Drake [EMAIL PROTECTED]To: Rick Schumeyer [EMAIL PROTECTED]Cc: pgsql-general@postgresql.orgSent: Friday, September 29, 2006

[GENERAL] Asynchronous trigger

not to block the client application during the recursive process ? Regards, -- Jean-Christophe Praud - http://shub-niggurath.com Conseil Développement Informatique http://www.praud.com Ph'nglui mglw'nafh Cthulhu n'gah Bill R'lyeh Wgah'nagl fhtagn

[GENERAL] ...unknown user name or bad password error during install

Hi,I am trying to install PostgreSQL 8.1.3 on windows xp. This computer had previous versions of postgresql installed but they have been uninstalled.When the installer reach the window Service Configuration, I keep the default values and add a password. I am getting the error:"Invalid username

Re: [GENERAL] Sequence skipping values

Micheal,Thanks a lot for you very clear explanation. To solve the problem, I have created another table so that the table does not use a rule to update itself. It works fine now.RegardsJCRMichael Fuhr [EMAIL PROTECTED] wrote: On Sat, Feb 11, 2006 at 06:06:21AM -0800, Jean-Christophe Roux wrote

Re: [GENERAL] Sequence skipping values

helpJCRMichael Fuhr [EMAIL PROTECTED] wrote: On Fri, Feb 10, 2006 at 08:10:36PM -0800, Jean-Christophe Roux wrote: here are the structures of the table involved:I co uldn't duplicate the problem in 8.1.2 or 8.0.6 with the codeyou posted. I created the given tables and rules (plus guesses forthe

[GENERAL]

Hello,I have a table with and id field (primary key) which default value is the result of a sequence (increment explicitly set to 1). To my surprise, the real increment on insert is the total number of rows of the table. For instance, with 41 rows and a sequence last_value of 1141, the next insert

[GENERAL] Sequence skipping values

Hello,I have a table with and id field (primary key) which default value is the result of a sequence (increment explicitly set to 1). To my surprise, the real increment on insert is the total number of rows of the table. For instance, with 41 rows and a sequence last_value of 1141, the next

Re: [GENERAL] Sequence skipping values

contain a column that refer to topics.id as a foreign key.Those three columns contain id automatically generated by sequences and I have not observed any problemThanksJCSteve Crawford [EMAIL PROTECTED] wrote: Jean-Christophe Roux wrote: Hello, I have a table with and id field (primary key) which

Re: [GENERAL] Sequence skipping values

0800, Jean-Christophe Roux wrote: The table with the id not incrementing by 1 as I expected is named topics. I have three other tables that contain rules that on insert into those tables, some fields of the table Topic should be updated. Each of those three tables contain a column that refer to

[GENERAL] Open Source Database Opportunity

Title: Open Source Database Opportunity Hello all I am looking for a survey which compares functionalities of the 3 following databases : Oracle, Mysql and PostreSQL Do somebody could send me some link or some documentation about this Thanks Regards Christophe TOUBLANC Architecture

[GENERAL] 7.4 performance issue

the query? Thanks a lot for your answers. Christophe Musielak Christine Bruzaud Akio Software PS : Concerning the seq_scan shown in the explain plan, as there is indexes on the tables as show below, we think Postgres is choosing seq_scan versus index_scan to improve performance. We tried

Re: [GENERAL] 7.2.3-7.4.2 migration

Thanks for your advices. Christophe Le jeu 01/04/2004 17:28, Tom Lane a crit : Richard Huxton [EMAIL PROTECTED] writes: On Thursday 01 April 2004 12:12, Christophe Musielak wrote: First, is it possible to upgrade directly from 7.2.3 -- 7.4.2 : ie dump the 7.2.3 datas, upgrade to 7.4.2

Fwd: [GENERAL] URGENT ! Nouveau virus

-Christophe Boggio [EMAIL PROTECTED] -o) Independant Consultant and Developer /\\ Delphi, Linux, Perl, PostgreSQL _\_V ---(end of broadcast)--- TIP 6: Have you searched our list archives

Re[2]: [GENERAL] Unexplained behaviour

information ! -- Jean-Christophe Boggio [EMAIL PROTECTED] Independant Consultant and Developer Delphi, Linux, Perl, PostgreSQL ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL

[GENERAL] Where's that doc on plans ?

A few days ago I read a very interesting doc about postgres' query planner, how to read an EXPLAIN plan, how is a cost calculated, etc. but I can't find it anymore. Anyone has an idea ? Thanks in advance. -- Jean-Christophe Boggio [EMAIL PROTECTED] Independant Consultant and Developer Delphi

[GENERAL] Request regarding logs

s is why I tried to say things differently. My apologies for the ~repost -- Jean-Christophe Boggio [EMAIL PROTECTED] Independant Consultant and Developer Delphi, Linux, Perl, PostgreSQL ---(end of broadcast)--- TIP 5: Have you checked our ext

Re: [GENERAL] INSERT ... RETURNING as Oracle

Just wanted to add that PHP has a GETLASTOID function that will work (after an insert) even if you don't use sequences/serials. -- Jean-Christophe Boggio [EMAIL PROTECTED] Independant Consultant and Developer Delphi, Linux, Perl, PostgreSQL ---(end of broadcast

Re: [GENERAL] Error creating tables.

). You can try : DROP SEQUENCE test_id_seq; Just guessing... -- Jean-Christophe Boggio [EMAIL PROTECTED] Independant Consultant and Developer Delphi, Linux, Oracle, Perl

[GENERAL] 2 phase commit abilities

, Regards, -- Christophe Doré Audientia - Core Engineering [EMAIL PROTECTED] tel : +33 1 46 22 40 00

[GENERAL] [Smalltalk]

Hello, I am looking for a tool which allows to use Postgres from a Smalltalk environment. Has everyone heard of it ? Thank you for your answers. Regards, Christophe Touzemail : [EMAIL PROTECTED]

[GENERAL] Expensive query

I have two tables, structured as: users: id varchar(70) not null unique events: userid varchar(70) not null, codechar(10) not null, whendatetime not null The query I need to perform answers the question, "Which

Re: [GENERAL] Expensive query

At 02:13 PM 10/30/98 , you wrote: That users table looks kinda useless. I'd recommend changing id to name and making id an int, then putting your events users in as ints. Currently, it doesn't do anything at all, and you might as well be doing this query [...] Actually, the real-life

Re: [GENERAL] Getting input from email...

I do something of that sort right now to support an email notification service. Rather than use Procmail, I use scripts written in Perl which accept a message, parse it up using the Mail::Internet and Mail::Address modules, and then insert it into the database. Works like a charm. At 08:09 AM

<    1   2   3