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
>
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