solaris 8
gcc 3.3.2
postgresql : 8.0.3
thanks
-Message d'origine-
De : [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] la part de Michael Fuhr
Envoyé : mardi 21 juin 2005 15:21
À : FERREIRA, William (COFRAMI)
Cc : pgsql-general@postgresql.org
Objet : Re: [GENERAL] compilation postg
hi
i trying to compile PostgreSQL (with perl) on Solaris
and i get an error
my perl version is 5.8.5
end of the execution trace :
[...]
gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Wendif-labels
-fno-strict-aliasing -I../../../../src/include -c -o tupdesc.o tupdesc.c
In file included f
do you really need to use lo module ?
try this ...
CREATE TABLE test
(
description varchar(20),
picture oid
)
WITHOUT OIDS;
if you want to import a BLOB :
insert into test values ("toto", lo_import('mypicture'))
and if you want no value
insert into test values ("toto", 0)
-Message d'ori
hi
i writing a j2ee application working with postgresql and i meet a problem with
autocommit
from my j2ee application i call a perl function and i get an error :
in french : Les Large Objects ne devraient pas être utilisés en mode
auto-commit.
in english : Large Objects should not be used in mo
Title: stored procedures / C-Language
hi
at
present my j2ee application use an Oracle database with XA
transactions.
i'm
migrating Oracle to PostgreSQL, and i'm looking for a XA driver for
PostgreSQL.
does
it exist ?
(i
don't want to rewrite all my code)
regards
William
Ferreir
the search_path works well
thanks a lot
-Message d'origine-
De : Pavel Stehule [mailto:[EMAIL PROTECTED]
Envoyé : mardi 3 mai 2005 16:09
À : FERREIRA, William (COFRAMI)
Cc : pgsql-general@postgresql.org
Objet : Re: [GENERAL] some questions : psql
On Tue, 3 May 2005, FERREIRA, Wi
: Pavel Stehule [mailto:[EMAIL PROTECTED]
Envoyé : mardi 3 mai 2005 14:30
À : FERREIRA, William (COFRAMI)
Cc : pgsql-general@postgresql.org
Objet : Re: [GENERAL] some questions : psql
Hello
> 1- is it possible to set a default schema ?
> i tried : set DEFAULT SCHEMA base1; but it did
Title: iterate over refcursor
hi,
i have some questions about
psql.
i'm trying to write a script for
deploying my database and i have some questions
:
1- is it possible to set a default schema
?
i tried : set DEFAULT
SCHEMA base1; but it didn't worked
2- is it possible to have one f
in
which language ?
-Message d'origine-De :
[EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]Envoyé : mardi 12 avril 2005
15:25À : pgsql-general@postgresql.orgObjet :
[GENERAL] Get Number of milliseconds for an intervall
Hi,
I would like to
get the elapsed time in mi
Title: Convert Cursor to array
hi,
i'm
trying to port an oracle script to postgresql, but i don't find any alternative
for some problems
this
is an extract of the oracle script :
DEFINE MDNSImportBlobDirectory =
C:\Temp\_lm_\ExternalTablesSpace\mdns;@createFraweWorkTables_script.ddl;@creat
Title: stored procedures / C-Language
hi,
i'm trying to find some documentation about writing stored procedures with C-language.
i found description in postgresql's documentation but i don't understand everything.
Aat present, i have a pl/perl stored procedure but it isn't fast enough, so
Title: RE: [GENERAL] plperl doesn't release memory
i have a similar problem
i'm running PostgreSQL on a PIV with 1GO and Windows 2000 NT
i have a large database and a big traitment taking more than 4 hours.
during the first hour postgresql use as much memory as virtual memory and i find this s
Title: postgresql max memory (pl/Perl)
hi
in my application i select data from my database and i store it into a pl/perl variable $myClob.
the quantity of data is very big (around 250Mo, growing to 800Mo). and next i write this data into a file.
with Oracle, it works, but with Oracle i get
Title: RE: [GENERAL] pl/perl problem
yes, it works
exactly what i needed, thanks a lot
-Message d'origine-
De : Richard Huxton [mailto:dev@archonet.com]
Envoyé : mardi 22 mars 2005 12:41
À : FERREIRA William (COFRAMI)
Cc : 'Sean Davis'; pgsql-general@postgresql
Title: RE: [GENERAL] pl/perl problem
thanks a lot
with your example and the example of Richard it works fine
-Message d'origine-
De : Sean Davis [mailto:[EMAIL PROTECTED]]
Envoyé : mardi 22 mars 2005 12:51
À : FERREIRA William (COFRAMI)
Cc : pgsql-general@postgresql.org
Objet
essage d'origine-De : Sean Davis
[mailto:[EMAIL PROTECTED]Envoyé : lundi 21 mars 2005
16:46À : FERREIRA William (COFRAMI);
pgsql-general@postgresql.orgObjet : Re: [GENERAL] pl/perl
problem
- Original Message -
From:
FERREIRA William (COFRAMI)
To
Title: RE: [GENERAL] Convert Cursor to array
hi
i
wrote a store procedure using the pl/perlU language, and the comportment is
strange.
my
procedure do a select on my database and some traitments too and write the
result in a file;
when i
run the procedure a first time, it works fine, th
Title: RE: [GENERAL] Convert Cursor to array
hi
is it
possible to create subroutines with plPerl ?
i
tried this :
CREATE
OR REPLACE FUNCTION adoc.CREATE_XML_FILE(docId int4, eleId int4, evo
int4, fileName text, fileRelativeDir text) RETURNS int4
AS$BODY$ my $theClob=''; my $params = '
Title: RE: [GENERAL] Convert Cursor to array
hi
i need
to know the execution time of a part of my pl/pgsql code
so, i
tried to use CURRENT_TIME :
t_time_d TIME;t_time_f TIME;t_diff TIME;
select CURRENT_TIME into
t_time_d;
//the traitment
select
CURRENT_TIME into t_time_f;t_
Title: RE: [GENERAL] Convert Cursor to array
ok, i think that i will try to use pl/perl or pl/python
but i don't know which one is better for my problem
maybe you can help me.
thanks
-Message d'origine-
De : [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]De la part de Richard Huxton
E
e : Ragnar Hafstað [mailto:[EMAIL PROTECTED]]
Envoyé : lundi 14 mars 2005 12:11
À : FERREIRA William (COFRAMI)
Cc : 'Richard Huxton'; GIROIRE Nicolas (COFRAMI);
'pgsql-general@postgresql.org'
Objet : Re: [GENERAL] Convert Cursor to array
On Mon, 2005-03-14 at 10:44 +0100, FERREIRA W
Title: RE: [GENERAL] Convert Cursor to array
hi
i'm a friend of nicolas and i'm working with him on this project
so this is the problem :
we are working on an application allowing to manage documentation in xml format.
At the the first level, there is the root, and at the next level there
Title: iterate over refcursor
hi
does
the table partitionning exists under PostgreSQL ? or maybe an alternative exists
?
Oracle
implements this system : it allows to spread rows on differents partitions
depending on an attribute.
For
example, my application store xml documents in databa
Title: RE: [GENERAL] Move cursor
does i hope that CURSOR will be fully implemented soon ?
(or maybe you know an alternative for my problem ? :) )
-Message d'origine-
De : Michael Fuhr [mailto:[EMAIL PROTECTED]]
Envoyé : mardi 8 mars 2005 18:29
À : Tom Lane
Cc : FERREIRA Wi
Title: iterate over refcursor
hi
i need
to use the MOVE function on a cursor, for extracting special
rows.
the
function is written in pl/pgSQL
CREATE
OR REPLACE FUNCTION TEST() RETURNS void AS
$$DECLARE
childCursor CURSOR FOR select
* from ... childRecord
adoc.xdb_c
Title: iterate over refcursor
hi
I got 2 functions write in pl/pgsql.
In the first function, i create a cursor and i need to use it into an other function
so the parameter is a refcursor.
the code :
1st function :
DECLARE
childCursor CURSOR FOR select * from ...
BEGIN
Title: number of rows in a cursor
hi
is it possible to know the number of rows into a cursor ? does any function exists ?
thanks in advance
Will
hi
i need to select rows from a table and to store them into an array.
and next, i would like to sort my array depending on some criteria.
so, my questions are :
how to store rows into a array ?
and how reverse some lines ?
(example : row[i]=row[i+1])
thanks in advance
Will
n the server
-Message d'origine-
De : [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]De la part de Tom Lane
Envoyé : mardi 22 février 2005 16:29
À : Richard Huxton
Cc : FERREIRA William (COFRAMI); 'pgsql-general@postgresql.org'
Objet : Re: [GENERAL] rows and array
Richard Huxton
OWTYPE
and next when i declare my variable with this type :
children recordChild;
i can store rows and re-order them like this :
children(i-j) := children(i-j-1);
-Message d'origine-
De : Richard Huxton [mailto:dev@archonet.com]
Envoyé : mardi 22 février 2005 12:20
À : FERREIRA
Title: RE: [GENERAL] Problem with inserting data into a table.
maybe you can try to add the name of the schema like this :
insert into my_schema.COL_LED_TBL
(LED_STATE_COLOR,NEID,LED_STATE_MODE,PHY_INDEX,PORT_INDEX,MODE_DFGH)
values (1,1234,3,0,104,'test led numbetr 1');
-Message
Title: rows and array
hi
does postgresql allows to store rows into array ?
i select rows in a table and i would like to sort them depending on my criteria.
thanks
Will
32 matches
Mail list logo
