On Tue, 2005-05-24 at 19:48 +0200, Tino Wildenhain wrote:
> Am Dienstag, den 24.05.2005, 13:49 -0300 schrieb [EMAIL PROTECTED]:
> > It will be a very pleasant idea. Although I am
> > an application developer I don't know if I have
> > enough knowledge to do that. Do you know how could
> > I help t
Am Dienstag, den 24.05.2005, 13:49 -0300 schrieb [EMAIL PROTECTED]:
> It will be a very pleasant idea. Although I am
> an application developer I don't know if I have
> enough knowledge to do that. Do you know how could
> I help the PostgreSQL development ?
>
> Another feature I missed is the "re
On Tue, May 24, 2005 at 13:49:40 -0300,
[EMAIL PROTECTED] wrote:
>
> Another feature I missed is the "returning" clause
> of the Oracle "INSERT" SQL command, which allow the
> user to retrieve the "serial" value after an insert
> command, which works even in a concurrent network
> environment.
It will be a very pleasant idea. Although I am an application developer I don't know if I haveenough knowledge to do that. Do you know how couldI help the PostgreSQL development ?Another feature I missed is the "returning" clause of the Oracle "INSERT" SQL command, which allow the user to retrieve
Am Dienstag, den 24.05.2005, 10:37 -0500 schrieb Mike Nolan:
> > > I hope anybody can help me on this subject. The problem is not to find
> > > a substitute for the Oracle synonyms, but a way to write queries
> > > which, reliably, can be used no matter the schema which owns the
> > > tables.
> >
> > I hope anybody can help me on this subject. The problem is not to find
> > a substitute for the Oracle synonyms, but a way to write queries
> > which, reliably, can be used no matter the schema which owns the
> > tables.
>
> Maybe you use views?
Unless it changed in 8, you can't insert into o
Am Montag, den 23.05.2005, 23:21 -0300 schrieb [EMAIL PROTECTED]:
> So the search_path can not substitute the Oracle synonyms function
> which in a single way allow us to write generic queries for an
> application no matter the schema which is being used.
>
> I can not find a solution on this matt
So the search_path can not substitute the Oracle synonyms function which in a single way allow us to write generic queries for an application no matter the schema which is being used.I can not find a solution on this matter in PostgreSQL.I hope anybody can help me on this subject. The problem is no
On Mon, May 23, 2005 at 09:07:08AM -0300, [EMAIL PROTECTED] wrote:
> Thank you very much for your answer.
>
> What happens if there are more than one table with the same name in the
> "search_path" ?
It takes the first one.
There is no explicit relationship between users and schemas, however
man
Of course! Maybe I am mixing users and schemas, because in Oracle they are the same, the schema has the name of the user which is the owner of the database tables and objects.So the problem can be described as follows :1. Let be Ent01 an enterprise, and Ent02 a different one.2. At Ent01 the databas
Thank you very much for your answer.What happens if there are more than one table with the same name in the "search_path" ?Jayme Jeffman FilhoGSEE-PUCRS+55 51 91123422
On Sun, May 22, 2005 at 03:28:22PM -0300, [EMAIL PROTECTED] wrote:
> Of course! Maybe I am mixing users and schemas, because in Oracle they
> are the same, the schema has the name of the user which is the owner of
> the database tables and objects.
>
> So the problem can be described as follows :
Jeffman Filho
> Sent: 20-May-2005 13:31:49 -0300
> CC: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] table synonyms
> I don't remember off the top of my head exactly how synonyms worked, but
> I'm pretty sure PostgreSQL doesn't directly support them. You might
I have searched for the word synonym through the wholePostrgeSQL 7.42 pdf documentation and all the ocurrencesare from functions redefinitions, and another PostreSQLuser has answered me that it does not support tablessynonyms, so I am with a big problem : How can I writequeries to suport different
I don't remember off the top of my head exactly how synonyms worked, but
I'm pretty sure PostgreSQL doesn't directly support them. You might be
able to emulate them with rules, though.
On Mon, May 16, 2005 at 08:35:34AM -0300, Jayme Jeffman Filho wrote:
> Hi,
>
> I would like to know if PostgreSQ
15 matches
Mail list logo
