> On Tue, 26 Dec 2000 [EMAIL PROTECTED] wrote:
>
> > Is there a way set a primary key to Auto Increment like you can
> > with MySQL?
>
> See the documentation on CREATE SEQUENCE, and also on CREATE TABLE and the
> SERIAL type.
>
> [An aside: this is something definitely that qualifies as a
On Tue, 26 Dec 2000, Bruce Momjian wrote:
> > See the documentation on CREATE SEQUENCE, and also on CREATE TABLE and the
> > SERIAL type.
> >
> > [An aside: this is something definitely that qualifies as a frequently
> > asked question, as this is like the 4th time in a week this question has
>
> On Tue, 26 Dec 2000, Bruce Momjian wrote:
>
> > > See the documentation on CREATE SEQUENCE, and also on CREATE TABLE and the
> > > SERIAL type.
> > >
> > > [An aside: this is something definitely that qualifies as a frequently
> > > asked question, as this is like the 4th time in a week this q
On Wed, 27 Dec 2000, Bruce Momjian wrote:
> > Perhaps not -- this is what I am wondering. Is it sent to subscribers as
> > part of a welcome message? At any rate, this particular question I think
> > has now qualified for the FAQ, at the very least! Or maybe even a section
> > in the FAQ for p
>> Would posting a FAQ list on a regular basis to the list be
>> helpful for things like this, like is done on the Perl newsgroups?]
> I don't think so. Doesn't everyone know the location of the FAQ?
Undoubtedly not :-( ... but it's unlikely that a routine posting would
help to dispel cluelessn
> OK, now that my foot is out of my mouth... perhaps a gentle reminder to
> some of the newer folks that a lot of questions asked are answered in the
> FAQ already, and if you don't know where the FAQ is, go to
> http://www.postgresql.org/docs/faq-english.html (there are also FAQs in
> German, Jap
On Wed, 27 Dec 2000, Tom Lane wrote:
> At one time Marc was arranging for the list bot to append automatic
> tags to all postings. I'd be in favor of an automatic tag that read
> something like
>
> list administrivia: [EMAIL PROTECTED]
> Postgres FAQs: http://...
>
>
This site looked quite good for general database information:
http://www.palslib.com/
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be y
Ok... I think I found a bug... tell me if I'm smoking something on this:
I create a table with a mixed case name... everything works fine until I try
to use the sequence created with the SERIAL datatype.
test_db=# create table "mixed_Case" ("mix_id" SERIAL, "mix_var"
varchar(50));
NOTICE: CREAT
