pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
[admin] index in pk
3+ messages / 2 participants
[nested] [flat]

* [admin] index in pk
@ 2004-04-07 21:11 Jaime Casanova <el_vigia_ec@hotmail.com>
  2004-04-07 21:21 ` Re: [admin] index in pk Stephan Szabo <sszabo@megazone.bigpanda.com>
  0 siblings, 1 reply; 3+ messages in thread

From: Jaime Casanova @ 2004-04-07 21:11 UTC (permalink / raw)
  To: pgsql-admin

hi all, there is a way to use my own index with pk constraint instead of the 
implicitly created one?
why? just because i don't like the name, maybe can i change the generated 
name?

thanx in advance,
Jaime Casanova

_________________________________________________________________
Help STOP SPAM with the new MSN 8 and get 2 months FREE*  
http://join.msn.com/?page=features/junkmail




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: [admin] index in pk
  2004-04-07 21:11 [admin] index in pk Jaime Casanova <el_vigia_ec@hotmail.com>
@ 2004-04-07 21:21 ` Stephan Szabo <sszabo@megazone.bigpanda.com>
  0 siblings, 0 replies; 3+ messages in thread

From: Stephan Szabo @ 2004-04-07 21:21 UTC (permalink / raw)
  To: Jaime Casanova <el_vigia_ec@hotmail.com>; +Cc: pgsql-admin

On Wed, 7 Apr 2004, Jaime Casanova wrote:

> hi all, there is a way to use my own index with pk constraint instead of the
> implicitly created one?
> why? just because i don't like the name, maybe can i change the generated
> name?

You should be able use the full version with the constraint naming clause:
 CONSTRAINT <name> PRIMARY KEY
to make <name> the name of the index.




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: [admin] index in pk
@ 2004-04-07 23:43 Jaime Casanova <el_vigia_ec@hotmail.com>
  0 siblings, 0 replies; 3+ messages in thread

From: Jaime Casanova @ 2004-04-07 23:43 UTC (permalink / raw)
  To: scott@QNET.COM; pgsql-admin

sorry if my questions are so primitive or show all my poor knowledge but ask 
is the way to find the right path. the dumber the question the smarter i 
will become.

_________________________________________________________________
Add photos to your e-mail with MSN 8. Get 2 months FREE*. 
http://join.msn.com/?page=features/featuredemail




^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2004-04-07 23:43 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-04-07 21:11 [admin] index in pk Jaime Casanova <el_vigia_ec@hotmail.com>
2004-04-07 21:21 ` Stephan Szabo <sszabo@megazone.bigpanda.com>
2004-04-07 23:43 Re: [admin] index in pk Jaime Casanova <el_vigia_ec@hotmail.com>

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