Skip site navigation (1) Skip section navigation (2)

Conversion from Sybase

From: "Didier Gasser-Morlay" <didiergm(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Conversion from Sybase
Date: 2007-10-26 18:44:38
Message-ID: 608b66ce0710261144j1e5fcb48n1a6205d429bd878e@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
Hello,

I am evaluating the possibility to port several applications from Sybase
ASE. Reading the PostgreSQL manual, (and getting a very good feeling about
PostGreSQL, I must say) it seems reasonably feasible but I have still some
doubts about the following:

-Case sensitivity : I have found a mention of case sensitivity/insensitivity
but have not found how to control this. For selects using or not an index
-Temporary tables: in Sybase I often use temp tables: tables created 'on the
fly' during the course of a stored procedure. This allows for some havey
processing to happen on the server side before returning results or
minimising the number of updates. Is it possible to create
-I often use the variable @@spid which , in Sybase, corresponds to the
current process id, this allows me to partition work tables when temporary
tables cannot be used in Sybase : one cannot create temp tables from within
a transaction. This is particularly useful to me when several "system" or
unattended task run. All my program connect using the same user , which
makes sense in a context of automatic interfacing between applications, run
via a cron job. In that case I cannot use a user id to achieve what I need.
-Multi-database queries or at least possibility to call a function in
another database. I often use this to build interfaces between systems. I
believe this is not possible in PostgreSQL.
-Multi-server (RPC) comminucation. clearly the answer to this one should be
no if the previous is not possible either.

Could you point me to a place where I could find the answers to these
questions (if you do not have the answer readily available :)

thanks in advance

Didier

pgsql-novice by date

Next:From: G. J. WalshDate: 2007-10-26 18:59:34
Subject: Re: readline library not found
Previous:From: Brian HurtDate: 2007-10-26 17:25:02
Subject: plpgsql question: inserting records

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group