pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Doubt...
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>
  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>
  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-11 09:44 doubt sathish <sathish@ceedees.com>
@ 2004-06-14 07:25 ` Jouneau Luc <Luc.Jouneau@diamant.jouy.inra.fr>
  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-11 09:44 doubt sathish <sathish@ceedees.com>
@ 2004-06-14 15:22 ` Bruno Wolff III <bruno@wolff.to>
  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>
  2005-07-07 03:52 ` Re: doubt Joshua D. Drake <jd@commandprompt.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:40 doubt Mogin Mohandas <moginmo@gmail.com>
@ 2005-07-07 03:52 ` Joshua D. Drake <jd@commandprompt.com>
  2005-07-07 05:05   ` Re: doubt Dong B. Calmada <dongcalmada@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 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   ` Dong B. Calmada <dongcalmada@gmail.com>
  2005-07-07 06:07     ` Re: doubt 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 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     ` Joshua D. Drake <jd@commandprompt.com>
  2005-07-07 06:21       ` Re: doubt Dong B. Calmada <dongcalmada@gmail.com>
  2005-07-07 06:25       ` Re: doubt Jonathan Daugherty <cygnus@cprogrammer.org>
  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 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       ` Dong B. Calmada <dongcalmada@gmail.com>
  2005-07-07 06:29         ` Re: doubt 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 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         ` Joshua D. Drake <jd@commandprompt.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

* Re: doubt
  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:25       ` Jonathan Daugherty <cygnus@cprogrammer.org>
  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

* 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