Hi All,
Im testing my postgres 7.3.2 db on redhat 9.0 using osdb 0.16. I couldnot find any
docuementation for interpreting the results obtained. Im doing multiuser (10 users)
test. I've two different con figurations for postgresql.conf. In one it takes 44 mins
to finish while in other it takes
[EMAIL PROTECTED] wrote:
The query below will return all of the foreign keys in the current schema,
I get the ForeignKey name as FK_NAME and both the primary and foreign
table's name and schema, now I just need the columns involved in the
foreign key itself, there is a column called confkey in pg_c
H..,
There was a post running about using C_LOCALE is the only way to use
LIKE, and I put something similar to the below in comment to it. It
never showed up on the list. Oh well.
If I wanted a multinational database capable of many langauges,and
wanted the most functionality of sor
Jim Seymour wrote:
Like this:
my $data_source = "dbi:Pg:dbname=mydatabase";
^^^
thank you very much.
Now if I could just authenticate correctly...
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please
The query below will return all of the foreign keys in the current schema,
I get the ForeignKey name as FK_NAME and both the primary and foreign
table's name and schema, now I just need the columns involved in the
foreign key itself, there is a column called confkey in pg_constraint and
it's an arr
Hello,
I do not believe that to be the case. DBD::SPI is experimental but DBD:
Pg is quite stable
and I believe DBD is a requirement that works WITH DBI.
Sincerely,
Joshua D. Drake
Tom Allison wrote:
I'm used to using the DBI modules in perl.
The online docs mention DBD as expiremental.
I'm think
pg_hba.conf entry:
host all all 192.168.0/24md5
I get the error
2004-06-14 20:51:48 [21072] LOG: invalid entry in pg_hba.conf file at
line 89, token "md5"
When I connect as:
psql -U postfix -h 192.168.0.5 postfix
This user works locally with version 7.
Tom Allison <[EMAIL PROTECTED]> wrote:
>
> I'm stuck on something stupid.
>
> I'm trying to use perl to open up a database handle and I can't find the
> right database dsn string.
>
> my $data_source = "dbi:Pg:mydatabase";
> my $username = "mydatebasereader";
> my $auth = "secret";
>
> my $dbh
I'm stuck on something stupid.
I'm trying to use perl to open up a database handle and I can't find the
right database dsn string.
my $data_source = "dbi:Pg:mydatabase";
my $username = "mydatebasereader";
my $auth = "secret";
my $dbh = DBI->connect($data_source, $username, $auth);
DBI connect('p
I'm used to using the DBI modules in perl.
The online docs mention DBD as expiremental.
I'm thinking of sticking with DBI, unless there's some compelling reason
to do otherwise.
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, plea
Richard Huxton wrote:
sathish wrote:
dear groups,
i have a doubt in sql,
i have a table staff_skills in which i have set a table level
constraint to create a primary key of two fields .
so 'name' and 'skill' combinedly forms a primary key.
now the issue is in another table i have only
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Jim Seymour
> Sent: Saturday, June 12, 2004 12:27 PM
> To: [EMAIL PROTECTED]
> Subject: Re: [GENERAL] Opteron scaling with PostgreSQL
>
>
> Steve Atkins <[EMAIL PROTECTED]> wrote:
> >
> > On Sat, Jun
NMB Webmaster <[EMAIL PROTECTED]> writes:
> I have two database quite similar, one has more tables than the other.
Are both of them vacuumed/analyzed recently? The slow plan seems to be
estimating many more rows out of the e/m join than the other one.
> My Postgres version is 7.2.3. Please help
sathish wrote:
dear groups,
i have a doubt in sql,
i have a table staff_skills in which i have set a table level
constraint to create a primary key of two fields .
so 'name' and 'skill' combinedly forms a primary key.
now the issue is in another table i have only 'name' field and i wan
Title: RE: [GENERAL] Keep history of modifications
Write an audit trigger to insert the required data into a table. I'm doing that myself for a table holding budget ledger data and will be creating the same concept for other tables.
Duane
-Original Message-
From: Daniel Devico [mai
On Fri, Jun 11, 2004 at 15:12:36 +0530,
sathish <[EMAIL PROTECTED]> wrote:
> dear groups,
>i have a doubt in sql,
>i have a table staff_skills in which i have set a table level
> constraint to create a primary key of two fields .
>so 'name' and 'skill' combinedly forms a primary key.
agus liem wrote:
Hai..
I introduce myself, my name : Agus, from Indonesia.
Im develop application using POwerbuilder 7 and postgresql 7.3.
I have serveral error, and cannot solve yet. Anybody help me?
Hi Agus, I'll do my best.
This is the error :
1. When I connecct postgresql using powerbuilder , t
I succeeded in installing Postgresql 7.4.2 pretty much as I had planned
it below. I found that I had to edit the old startup script for the new
version and add the path to the man.conf file for the new man pages.
Previously I had used a utility called pgaccess for some things. I
pulled the lates
18 matches
Mail list logo
