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>
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:21 Stephan Szabo <sszabo@megazone.bigpanda.com>
parent: Jaime Casanova <el_vigia_ec@hotmail.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