pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedDoubt...
13+ messages / 9 participants
[nested] [flat]
* Doubt...
@ 2001-07-14 00:11 LA <acuario6@servidor.unam.mx>
0 siblings, 0 replies; 13+ messages in thread
From: LA @ 2001-07-14 00:11 UTC (permalink / raw)
To: pgsql-admin
Hi..
I have a few doubts, please help me..
1. how I change from a database to other?
2.- The command "copy" just root-postgres can do it o another users?
3.- If "copy" can do another users what priviligies must have them?
Thanks
______
^ permalink raw reply [nested|flat] 13+ messages in thread
* doubt
@ 2004-06-11 09:44 sathish <sathish@ceedees.com>
0 siblings, 2 replies; 13+ messages in thread
From: sathish @ 2004-06-11 09:44 UTC (permalink / raw)
To: pgsql-jdbc@postgresql.org
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 want
to create a foreign key constraint which refers the staff_skills table's
'name' field only.
staff_skills (table) - name,skill,ability (columns) --- primary
key(name,skill)
staff_xxxx (table) - name,x,y,z (columns) --- foreign
key(name) references staff_skills(name).
how to do the above?
your immediate reply will be helpful
yours sincerely
SathishKumar.S
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: [ADMIN] doubt
@ 2004-06-14 07:25 Jouneau Luc <Luc.Jouneau@diamant.jouy.inra.fr>
parent: sathish <sathish@ceedees.com>
1 sibling, 0 replies; 13+ messages in thread
From: Jouneau Luc @ 2004-06-14 07:25 UTC (permalink / raw)
To: pgsql-jdbc@postgresql.org
Hi,
It seems there's something wrong in the design of your db : Don't you have
another table containing name attribute as primary key which you could refer
as foreign key in staf_xxxx ?
I don't know how to implement what you want to do, except perhaps
implementing your own referential control in procedural sql functions fired
by triggers.
Anyhow, it is better design pattern to use sequential number without any
business meaning as primary key.
Luc Jouneau
----- Original Message -----
From: "sathish" <sathish@ceedees.com>
To: <pgsql-jdbc@postgresql.org>
Sent: Friday, June 11, 2004 11:44 AM
Subject: [ADMIN] doubt
> 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 want
> to create a foreign key constraint which refers the staff_skills table's
> 'name' field only.
> staff_skills (table) - name,skill,ability (columns) --- primary
> key(name,skill)
> staff_xxxx (table) - name,x,y,z (columns) --- foreign
> key(name) references staff_skills(name).
> how to do the above?
> your immediate reply will be helpful
> yours sincerely
> SathishKumar.S
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: [ADMIN] doubt
@ 2004-06-14 15:22 Bruno Wolff III <bruno@wolff.to>
parent: sathish <sathish@ceedees.com>
1 sibling, 0 replies; 13+ messages in thread
From: Bruno Wolff III @ 2004-06-14 15:22 UTC (permalink / raw)
To: sathish <sathish@ceedees.com>; +Cc: pgsql-jdbc@postgresql.org
On Fri, Jun 11, 2004 at 15:14:07 +0530,
sathish <sathish@ceedees.com> 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 want
> to create a foreign key constraint which refers the staff_skills table's
> 'name' field only.
No. References need to be to keys (columns with a unique index on just
the columns being referenced).
In this case you almost certainly what to have the name table separate
from the skill table and have both the skill table and the other table
refer to the name table.
> staff_skills (table) - name,skill,ability (columns) --- primary
> key(name,skill)
> staff_xxxx (table) - name,x,y,z (columns) --- foreign
> key(name) references staff_skills(name).
> how to do the above?
> your immediate reply will be helpful
> yours sincerely
> SathishKumar.S
^ permalink raw reply [nested|flat] 13+ messages in thread
* doubt
@ 2005-07-07 03:40 Mogin Mohandas <moginmo@gmail.com>
0 siblings, 1 reply; 13+ messages in thread
From: Mogin Mohandas @ 2005-07-07 03:40 UTC (permalink / raw)
To: pgsql-admin
Hi again
I just wanted to know for extending the database, is it
better to install postgres from a pre-installed package or source. I
have installed ubuntu and was trying to install from source. Please
give me some opinions.
Thank you
Mogin
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: doubt
@ 2005-07-07 03:52 Joshua D. Drake <jd@commandprompt.com>
parent: Mogin Mohandas <moginmo@gmail.com>
0 siblings, 1 reply; 13+ messages in thread
From: Joshua D. Drake @ 2005-07-07 03:52 UTC (permalink / raw)
To: Mogin Mohandas <moginmo@gmail.com>; +Cc: pgsql-admin
Mogin Mohandas wrote:
> Hi again
> I just wanted to know for extending the database, is it
> better to install postgres from a pre-installed package or source. I
> have installed ubuntu and was trying to install from source. Please
> give me some opinions.
It depends on what you mean by Extend. If you mean adding contrib
modules, custom functions etc... then just make sure that you have all
of postgresql installed...
libecpg-dev - development files for ECPG (Embedded PostgreSQL for C)
libecpg4 - run-time library for ECPG programs
libpq3 - PostgreSQL C client library
postgresql - object-relational SQL database management system
postgresql-client - front-end programs for PostgreSQL
postgresql-dev - development files for libpq (PostgreSQL library)
postgresql-doc - documentation for the PostgreSQL database management
> Thank you
> Mogin
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
--
Your PostgreSQL solutions provider, Command Prompt, Inc.
24x7 support - 1.800.492.2240, programming, and consulting
Home of PostgreSQL Replicator, plPHP, plPerlNG and pgPHPToolkit
http://www.commandprompt.com / http://www.postgresql.org
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: doubt
@ 2005-07-07 05:05 Dong B. Calmada <dongcalmada@gmail.com>
parent: Joshua D. Drake <jd@commandprompt.com>
0 siblings, 1 reply; 13+ messages in thread
From: Dong B. Calmada @ 2005-07-07 05:05 UTC (permalink / raw)
To: Joshua D. Drake <jd@commandprompt.com>; +Cc: Mogin Mohandas <moginmo@gmail.com>; pgsql-admin
According to Joshua D. Drake:
> Date: Wed, 06 Jul 2005 20:52:22 -0700
>
> It depends on what you mean by Extend. If you mean adding contrib
> modules, custom functions etc... then just make sure that you have all
> of postgresql installed...
>
> libecpg-dev - development files for ECPG (Embedded PostgreSQL for C)
> libecpg4 - run-time library for ECPG programs
> libpq3 - PostgreSQL C client library
> postgresql - object-relational SQL database management system
> postgresql-client - front-end programs for PostgreSQL
> postgresql-dev - development files for libpq (PostgreSQL library)
> postgresql-doc - documentation for the PostgreSQL database management
>
I also advise 'postgresql-autodoc'. With it you can generate htmlized
documentation as well as Dia-based E-R diagram.
Dong
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: doubt
@ 2005-07-07 06:07 Joshua D. Drake <jd@commandprompt.com>
parent: Dong B. Calmada <dongcalmada@gmail.com>
0 siblings, 2 replies; 13+ messages in thread
From: Joshua D. Drake @ 2005-07-07 06:07 UTC (permalink / raw)
To: Dong B. Calmada <dongcalmada@gmail.com>; +Cc: Mogin Mohandas <moginmo@gmail.com>; pgsql-admin
Dong B. Calmada wrote:
> According to Joshua D. Drake:
>
>>Date: Wed, 06 Jul 2005 20:52:22 -0700
>>
>>It depends on what you mean by Extend. If you mean adding contrib
>>modules, custom functions etc... then just make sure that you have all
>>of postgresql installed...
>>
>>libecpg-dev - development files for ECPG (Embedded PostgreSQL for C)
>>libecpg4 - run-time library for ECPG programs
>>libpq3 - PostgreSQL C client library
>>postgresql - object-relational SQL database management system
>>postgresql-client - front-end programs for PostgreSQL
>>postgresql-dev - development files for libpq (PostgreSQL library)
>>postgresql-doc - documentation for the PostgreSQL database management
>>
>
>
> I also advise 'postgresql-autodoc'. With it you can generate htmlized
> documentation as well as Dia-based E-R diagram.
I don't show that as a package in my apt-cache?
>
> Dong
--
Your PostgreSQL solutions provider, Command Prompt, Inc.
24x7 support - 1.800.492.2240, programming, and consulting
Home of PostgreSQL Replicator, plPHP, plPerlNG and pgPHPToolkit
http://www.commandprompt.com / http://www.postgresql.org
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: doubt
@ 2005-07-07 06:21 Dong B. Calmada <dongcalmada@gmail.com>
parent: Joshua D. Drake <jd@commandprompt.com>
1 sibling, 1 reply; 13+ messages in thread
From: Dong B. Calmada @ 2005-07-07 06:21 UTC (permalink / raw)
To: Joshua D. Drake <jd@commandprompt.com>; +Cc: Mogin Mohandas <moginmo@gmail.com>; pgsql-admin
According to Joshua D. Drake:
>
> I don't show that as a package in my apt-cache?
postgresql-autodoc is under the 'multiverse' category. Have you added the
keyword to the sources.list's archive entry?
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: doubt
@ 2005-07-07 06:25 Jonathan Daugherty <cygnus@cprogrammer.org>
parent: Joshua D. Drake <jd@commandprompt.com>
1 sibling, 0 replies; 13+ messages in thread
From: Jonathan Daugherty @ 2005-07-07 06:25 UTC (permalink / raw)
To: pgsql-admin
# I don't show that as a package in my apt-cache?
It's in mine on debian testing. Redhat's package cache isn't nearly
as extensive; I've found numerous widely-available packages missing
from it, even ones you can get on redhat CDs.
--
Jonathan Daugherty
Lead Programmer
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Replication & Support Services, (503) 667-4564
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: doubt
@ 2005-07-07 06:29 Joshua D. Drake <jd@commandprompt.com>
parent: Dong B. Calmada <dongcalmada@gmail.com>
0 siblings, 0 replies; 13+ messages in thread
From: Joshua D. Drake @ 2005-07-07 06:29 UTC (permalink / raw)
To: Dong B. Calmada <dongcalmada@gmail.com>; +Cc: Mogin Mohandas <moginmo@gmail.com>; pgsql-admin
Dong B. Calmada wrote:
> According to Joshua D. Drake:
>
>>I don't show that as a package in my apt-cache?
>
>
> postgresql-autodoc is under the 'multiverse' category. Have you added the
> keyword to the sources.list's archive entry?
Aha! I had universe not multiverse. Thanks for the tip.
J
--
Your PostgreSQL solutions provider, Command Prompt, Inc.
24x7 support - 1.800.492.2240, programming, and consulting
Home of PostgreSQL Replicator, plPHP, plPerlNG and pgPHPToolkit
http://www.commandprompt.com / http://www.postgresql.org
^ permalink raw reply [nested|flat] 13+ messages in thread
* doubt
@ 2005-07-08 08:18 Mogin Mohandas <moginmo@gmail.com>
0 siblings, 0 replies; 13+ messages in thread
From: Mogin Mohandas @ 2005-07-08 08:18 UTC (permalink / raw)
To: pgsql-admin
Hi
When I try to run 'make install' it gives me an "error 2". Any
idea about error 2. I guess it has something to do with initdb. Here
is portions of the error:
make[2]: *** [installdirs] Error 2
make[2]: Leaving directory `/home/mmohanda/postgres/postgresql-7.4.8/doc'
make[1]: *** [install] Error 2
make[1]: Leaving directory `/home/mmohanda/postgres/postgresql-7.4.8'
*** Error code 2
make: Fatal error: Command failed for target `install'
I got the same error during regression test also.
Please give me some hints
Thank you
Mogin
^ permalink raw reply [nested|flat] 13+ messages in thread
* Doubt
@ 2006-03-18 06:16 Babu <babu@adaptime.net>
0 siblings, 0 replies; 13+ messages in thread
From: Babu @ 2006-03-18 06:16 UTC (permalink / raw)
To: pgsql-admin-owner@postgresql.org
Hi
i have create one table and view., but i have not able to insert,update and delete view., how to solve this. Pls send me on example.
Table :
Create Table Test (eno int,ename varchar(10));
View :
Create or Replace view TestView as Select * from Test;
Regards
Babu.B
^ permalink raw reply [nested|flat] 13+ messages in thread
end of thread, other threads:[~2006-03-18 06:16 UTC | newest]
Thread overview: 13+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-07-14 00:11 Doubt... LA <acuario6@servidor.unam.mx>
2004-06-11 09:44 doubt sathish <sathish@ceedees.com>
2004-06-14 07:25 ` Re: [ADMIN] doubt Jouneau Luc <Luc.Jouneau@diamant.jouy.inra.fr>
2004-06-14 15:22 ` Re: [ADMIN] doubt Bruno Wolff III <bruno@wolff.to>
2005-07-07 03:40 doubt Mogin Mohandas <moginmo@gmail.com>
2005-07-07 03:52 ` Re: doubt Joshua D. Drake <jd@commandprompt.com>
2005-07-07 05:05 ` Re: doubt Dong B. Calmada <dongcalmada@gmail.com>
2005-07-07 06:07 ` Re: doubt Joshua D. Drake <jd@commandprompt.com>
2005-07-07 06:21 ` Re: doubt Dong B. Calmada <dongcalmada@gmail.com>
2005-07-07 06:29 ` Re: doubt Joshua D. Drake <jd@commandprompt.com>
2005-07-07 06:25 ` Re: doubt Jonathan Daugherty <cygnus@cprogrammer.org>
2005-07-08 08:18 doubt Mogin Mohandas <moginmo@gmail.com>
2006-03-18 06:16 Doubt Babu <babu@adaptime.net>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox