Re: [GENERAL] system command in dblink?

/bin/main_wms 99 ' || new.iddocsalida || ''' )'; select dblink_exec('paso_lx',sql,TRUE) into ifres; cheers mike stanton - Original Message - From: AI Rumman To: pgsql-general

[GENERAL] Access postgresql data base from .net

a major rewrite of all the SQL ?. Obviously we may have problemas with differences between Sql-server and Postgresql syntax, but we don´t want to de a rewrite. Hope to hear soon, any help appreciated. Mike Stanton W. Santiago Chile __ Información de ESET NOD32 Antivirus, versión de la

Re: [GENERAL] Access postgresql data base from .net

Dann, perhaps the a better question would be.if we use, for example, npgsql, we'd have to adapt code and use the tools own calls. And that means rewriting. Is this true?. Cheers Mike - Original Message - From: Dann Corbit To: 'mike stanton' ; pgsql-general@postgresql.org

[GENERAL] PgCluster

Hello all, this is not a joke. Does anyione know if PgCluster as a project is suspended, or is alive and kicking. In the second case, has anyone got a medium sized system working well with this multi-master replication option.? Hope to hear soon. Mike Stanton Santiago, Chile

[GENERAL] ECPG: No multidimensional array support for simple data types

Hello all, I get the following error message when ecpg precompiles an EXEC SQL INCLUDE on this variable: short cst_vent[MAX_SUC][12]; (MAX_SUC is defined as 24) Mesage: No multidimensional array support for simple data types Is there a fix or am I stuck? Version: PostgreSQL

[GENERAL] Compiling .pgc programs gives error

I have a problem compiling pgc programs with ecpg. I always get the following error: /usr/local/pgsql/lib/libpgtypes.a(timestamp.o): In function `timestamp2tm': timestamp.c:(.text+0x2fc): undefined reference to `rint' Version: PostgreSQL 8.3.6 on i686-pc-linux-gnu, compiled by GCC gcc (GCC)

[GENERAL] Reading a table with composite type, into it equivalent c structure

Hello All, Has anyone got a working program that reads a tuple from a table (defined as a single Composite type with lower atributes also as composite types) and converts the data into the corresponding C structure variables ? I've been looking for a working example, but havn´t found that

[GENERAL] Order by with spaces and other characters

Hello everyone. We have a simple problem...that we have keys that include blanks and various other commonly used characters like ,, ; and -. For some reason, the select we have, nothing complicated, ignores these special characters and happily sorts by the A-z range. How do we sort by the, say

[GENERAL] refcursor

a refcursor variable? Hope you can help. Cheers Mike Stanton, Santiago Chile Michael Stanton W. Depto. Informática