> Hi Richard ,
> Very good Day. Great information that you given to me.
Great glad you think it's useful. Oh, don't forget to cc: the
mailing-list - that's the convention around here.
> I will try in your idea. Here I am using SQL server 2000(Even I can use SQL
> Sever 2005 too if needed.) We are dealing with lot of databases with lot of
> business logic. I think your information will great for me.
Ah - you're not using PostgreSQL? Well, the principle is the same but
you should be aware that this is a PostgreSQL list so the details will
> Let I try and I will back with you.
> Thanks and hands of too you.
> But i don't have any idea of getting Session from databases (I think you are
> meaning that user can be handle with session). If you have some more idea
> then it will be great full to me.
With MS-SQL you'll probably want to look at T-SQL variables, although I
don't know if they last longer than a single transaction. Failing that,
functions or temporary tables might be a help.
In response to
pgsql-performance by date
|Next:||From: Arnau||Date: 2006-04-25 13:28:45|
|Subject: Query on postgresql 7.4.2 not using index|
|Previous:||From: Richard Huxton||Date: 2006-04-25 09:40:08|
|Subject: Re: security for row level but not based on Database user's|