pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Robert J. Sanford, Jr. <rsanford@nolimitsystems.com>
To: pgsql-sql@postgresql.org
Subject: RE: how do i...
Date: Sun, 12 Aug 2001 00:11:10 -0500
Message-ID: <HOEFIONAHHKFEFENBMNOKENBCAAA.rsanford@nolimitsystems.com> (raw)
In-Reply-To: <HOEFIONAHHKFEFENBMNOOENACAAA.rsanford@nolimitsystems.com>

doh!

i have now discovered that every row in every table is
automatically given a globally unique OID. that's pretty
cool. that means that i don't have to personally create
an OID column for every table. excellent.

i also enjoy that i can use the OID as an index on tables.
nice, very nice. thank you for making my life easier.

rjsjr

> -----Original Message-----
> From: pgsql-sql-owner@postgresql.org
> [mailto:pgsql-sql-owner@postgresql.org]On Behalf Of Robert 
> J. Sanford, Jr.
> Sent: Saturday, August 11, 2001 10:49 PM
> To: pgsql-sql@postgresql.org
> Subject: [SQL] how do i...
> 
> 
> first - i'm new at this postgres thing...
> 
> i'm coming from a MSAccess and MSSQLServer environment where
> i can set up and "AUTOINCREMENT" primary key so that when i
> insert a row into a table i don't have to worry about trying
> to figure out what the primary key should be.
> 
> i know that i can set up a sequence in postgres but i then
> have to make sure that all of my inserts use the sequence to
> create the primary key and i would like to avoid that.
> 
> is there any way that i can set up a sequence so that the
> primary key is automatically generated whenever a row is
> inserted?
> 
> if not, then my plan is to create a stored procedure that
> performs the insert with the sequence call. however, i would
> like to make sure that ONLY the stored procedure has the
> ability to perform the insert and that my developers cannot
> insert directly into the table. is this possible? i'm worried
> that when i set up a stored procedure it only has the rights
> given to it by the caller so if i turn off insert rights for
> my applications then the store procedure won't be able to do
> the inserts either.
> 
> many thanks!
> 
> rjsjr
> 
> 
> http://www.postgresql.org/users-lounge/docs/faq.html
> 



view thread (9+ messages)  latest in thread

Message-ID: <HOEFIONAHHKFEFENBMNOKENBCAAA.rsanford@nolimitsystems.com>
Permalink:  ../HOEFIONAHHKFEFENBMNOKENBCAAA.rsanford@nolimitsystems.com/
Also on:    postgresql.org/message-id/HOEFIONAHHKFEFENBMNOKENBCAAA.rsanford@nolimitsystems.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: rsanford@nolimitsystems.com
  Subject: RE: how do i...
  In-Reply-To: <HOEFIONAHHKFEFENBMNOKENBCAAA.rsanford@nolimitsystems.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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