pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Adaptation of instnwnd.sql to Pgsql
3+ messages / 3 participants
[nested] [flat]

* Adaptation of instnwnd.sql to Pgsql
@ 2004-10-06 14:41 David.Jacques@CCRS.NRCan.gc.ca
  2004-10-06 23:01 ` Re: Adaptation of instnwnd.sql to Pgsql Gaetano Mendola <mendola@bigfoot.com>
  0 siblings, 1 reply; 3+ messages in thread

From: David.Jacques@CCRS.NRCan.gc.ca @ 2004-10-06 14:41 UTC (permalink / raw)
  To: pgsql-admin

Listers...

I am new to PostGreSQL and I am trying to adapt the
instnwnd.sql stored procedure from SQL Server to create the
ubiquitous NorthWind database structure on my server. However
the ability to name your indexes seems to be non existent. As is the
ability to create indexes of the same name on different tables.

Does anyone out there have an adapted Pgsql version of this script ?
It would be invaluable to me to get quickly up to speed on this version
of the SQL standard by comparing what I know from TSQL to what the
equivalent command syntax is in pgsql.

regards

David 

David A. Jacques
Spatial Database Developer
Natural Resources and Hazards Section 
Applications Division
Canada Centre for Remote Sensing
588 Booth Street, Room 317 
Ottawa ,Ontario K1A 0Y7 
Tel: (613) 947-1306
Fax: (613) 947-1408 
E-Mail: David.Jacques@CCRS.NRCan.gc.ca

The views and ideas expressed in this communication are hereby deemed to be
my own and in no way can be construed as endorsed by the CCRS or the
Government of Canada.




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

* Re: Adaptation of instnwnd.sql to Pgsql
  2004-10-06 14:41 Adaptation of instnwnd.sql to Pgsql David.Jacques@CCRS.NRCan.gc.ca
@ 2004-10-06 23:01 ` Gaetano Mendola <mendola@bigfoot.com>
  2004-10-06 23:50   ` Re: Adaptation of instnwnd.sql to Pgsql Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 1 reply; 3+ messages in thread

From: Gaetano Mendola @ 2004-10-06 23:01 UTC (permalink / raw)
  To: pgsql-admin

David.Jacques@CCRS.NRCan.gc.ca wrote:
> Listers...
> 
> I am new to PostGreSQL and I am trying to adapt the
> instnwnd.sql stored procedure from SQL Server to create the
> ubiquitous NorthWind database structure on my server. However
> the ability to name your indexes seems to be non existent. 

This is not true. During the index creation you can specify
the name, take a look at the documentation.

> As is the ability to create indexes of the same name on different tables.

About this you're right, index name are DB wide...


Regards
Gaetano Mendola




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

* Re: Adaptation of instnwnd.sql to Pgsql
  2004-10-06 14:41 Adaptation of instnwnd.sql to Pgsql David.Jacques@CCRS.NRCan.gc.ca
  2004-10-06 23:01 ` Re: Adaptation of instnwnd.sql to Pgsql Gaetano Mendola <mendola@bigfoot.com>
@ 2004-10-06 23:50   ` Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 3+ messages in thread

From: Tom Lane @ 2004-10-06 23:50 UTC (permalink / raw)
  To: Gaetano Mendola <mendola@bigfoot.com>; +Cc: pgsql-admin

Gaetano Mendola <mendola@bigfoot.com> writes:
> David.Jacques@CCRS.NRCan.gc.ca wrote:
>> As is the ability to create indexes of the same name on different tables.

> About this you're right, index name are DB wide...

Only schema-wide, but that probably doesn't help David any...

			regards, tom lane



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


end of thread, other threads:[~2004-10-06 23:50 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-10-06 14:41 Adaptation of instnwnd.sql to Pgsql David.Jacques@CCRS.NRCan.gc.ca
2004-10-06 23:01 ` Gaetano Mendola <mendola@bigfoot.com>
2004-10-06 23:50   ` Tom Lane <tgl@sss.pgh.pa.us>

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