Please unsubscribe me,
Thank you
x27;c');
fetch all in funcur;
COMMIT;
On 9/28/05, Tomas Zerolo <[EMAIL PROTECTED]> wrote:
On Wed, Sep 28, 2005 at 12:25:54PM -0700, vishal saberwal wrote:> hi,>> I am trying to create a stored procedure that takes a column name as> parameter and then uses it to sort the
hi,
I am trying to create a stored procedure that takes a column name as
parameter and then uses it to sort the table for result set.
create or replace function ptest_Sort_Select(varchar) returns setof ptest1 as $$
DECLARE
res ptest1%ROWTYPE;
BEGIN
for res in
select * from ptest
m the same CA. Do they both might need to authenticate, or in other
words is it true that:
(1) Machine A has to send its postgresql (.key,.crt) to Machine B and
(2) Machine B has to send its postgresql (.key,.crt) to Machine A.
thanks,
vish
On 8/25/05, vishal saberwal <[EMAIL PROTECTED]> wrot
hi,
I am not sure if this is a bug.
My PG_HBA.CONF
local all all trust
host all all 127.0.0.1 255.255.255.255 trust
host all all 192.168.0.0/16 trust
hostssl dbm all 192.168.200.201 255.255.255.255 md5
int ret=PQconnectdb("hostaddr=192.168.200.10 dbname=dbm user=postg
, what
keys they need to have in common?
thanks,
vish
On 8/24/05, Tom Lane <[EMAIL PROTECTED]> wrote:
> vishal saberwal <[EMAIL PROTECTED]> writes:
> > Guess i can stay on 8.0.1 until we get 8.0.4 ... (is it right for me
> > to ask what data-loss you are talking about)
talking about) ...
thanks again,
vish
On 8/24/05, Tom Lane <[EMAIL PROTECTED]> wrote:
> vishal saberwal <[EMAIL PROTECTED]> writes:
> > I agree with what you said ... They considered 8.0.1 as a stable
> > version they can rely on (but i believe i can propose a change no
...
thanks a lot TJ and Tom ...
you've been a great help ...
vish
On 8/24/05, Tom Lane <[EMAIL PROTECTED]> wrote:
> vishal saberwal <[EMAIL PROTECTED]> writes:
> > But, Management requires me to use 8.0.1 (on both servers and clients)
> > as our total infrastructure and co
Thanks a lot TJ,
You were right ...
I installed 8.0.3 and then placed the certificates as suggested by you
... It worked ...
But, Management requires me to use 8.0.1 (on both servers and clients)
as our total infrastructure and coding is based on it ... Is there a
patch I can apply to 8.0.1 so tha
directory on the
> client side.
>
> So that answers a).
>
> b) The client shouldn't be looking for root.crt
>
> c) That should do it. If you have any more questions feel free to email
> me off the list and I'll see what else ya need help with.
>
> T
er.
I have following Questions:
(a) How do i create the ~/.postgresql/postgresql.crt and
~/.postgresql/postgresql.key files (not sure about the commands)?
(b) Where do i get the ~/.postgresql/root.crt from?
(c) Is there anything else i am missing thats not in document or that
i need
11 matches
Mail list logo
