Hi,
How to pass connection object
across the functions.So that there is no need for me to connect to postgres
database in each and every function.
For Ex:If i have say 3 functions:
One function i use to connect to the
database.
In the other function, if i want to creat a table
...I
Hi,
i have similar problem - can't make dumps of any db with the same error message
(and all applications using this pg server works fine) . But in my case, i
think, only user 'postgres' is duplicated:
template1=> select * from pg_catalog.pg_shadow where usename = 'postgres';
usename | usesysi
On Thu, Sep 01, 2005 at 04:12:17PM +0530, sandhya wrote:
> How to pass connection object across the functions.So that there
> is no need for me to connect to postgres database in each and every
> function.
What functions? You didn't say what language you're using, nor
whether you're writing clien
"Bartek GRUbY" <[EMAIL PROTECTED]> writes:
> i have similar problem - can't make dumps of any db with the same error
> message (and all applications using this pg server works fine) . But in my
> case, i think, only user 'postgres' is duplicated:
> template1=> select * from pg_catalog.pg_shadow
Bartosz Nowak <[EMAIL PROTECTED]> writes:
> postgres=> select ctid,xmin,xmax,cmin,xmax,* from pg_shadow where
> usename = 'postgres';
> ctid |xmin| xmax | cmin | xmax | usename | usesysid |
> usecreatedb | usesuper | usecatupd | passwd
> | valuntil | us
Bartosz Nowak <[EMAIL PROTECTED]> writes:
> Tom Lane napisa³(a):
>> You could manually delete either row, probably better to zap the second
>> one:
>> delete from pg_shadow where ctid = '(1,25)';
> Heh... i wish it was that easy - i tried it already :] When i delete the
> 'second' postgres user (
Tom Lane napisał(a):
Bartosz Nowak <[EMAIL PROTECTED]> writes:
postgres=> select ctid,xmin,xmax,cmin,xmax,* from pg_shadow where
usename = 'postgres';
ctid |xmin| xmax | cmin | xmax | usename | usesysid |
usecreatedb | usesuper | usecatupd |
passwd
Tom Lane napisał(a):
"Bartek GRUbY" <[EMAIL PROTECTED]> writes:
i have similar problem - can't make dumps of any db with the same error message
(and all applications using this pg server works fine) . But in my case, i
think, only user 'postgres' is duplicated:
template1=> selec
Tom Lane napisał(a):
Bartosz Nowak <[EMAIL PROTECTED]> writes:
Tom Lane napisał(a):
You could manually delete either row, probably better to zap the second
one:
delete from pg_shadow where ctid = '(1,25)';
Heh... i wish it was that easy - i tried it already :] When i delete
I am using normal C-Functions,In one function i will make connection with
the database.This connection object i need to get in my all other functions
where i will do the other operations like creating a table ,altering a table
in their respective functions.So..There is no need for me to ask the use
On Fri, Sep 02, 2005 at 09:56:19AM +0530, sandhya wrote:
> I am using normal C-Functions,In one function i will make connection with
> the database.This connection object i need to get in my all other functions
> where i will do the other operations like creating a table ,altering a table
> in thei
In case of multiple users what will happen?
Each must have different connection objects right!
- Original Message -
From: "Michael Fuhr" <[EMAIL PROTECTED]>
To: "sandhya" <[EMAIL PROTECTED]>
Cc: "Askar Zaidi" <[EMAIL PROTECTED]>; "postgre"
Sent: Friday, September 02, 2005 10:46 AM
Subje
On Fri, Sep 02, 2005 at 11:19:53AM +0530, sandhya wrote:
> In case of multiple users what will happen?
> Each must have different connection objects right!
That's why global variables are bad. But what's wrong with passing
a PGconn * to various functions? If that's a problem in your
application
13 matches
Mail list logo
