--- operationsengineer1(at)yahoo(dot)com wrote:
> does anybody use this technique? it is supported by
> pgsql, however, setting it up isn't intuitive to
> When you create records, you need to generate unique
> id's for each record. There are two common
> (1) auto-incrementing columns and (2) sequences.
> Auto-incrementing columns are supported by MySQL,
> Sybase and Microsoft Access and SQL Server. However
> most other databases do not support this feature. So
> for portability, you have little choice but to use
> sequences. Sequences are special functions that
> a unique incrementing number every time you call it,
> suitable to be used as database keys. In ADOdb, we
> the GenID( ) function. It has takes a parameter, the
> sequence name. Different tables can have different
> $id = $connection->GenID('sequence_name');
> $connection->Execute("insert into table (id,
> firstname, lastname) values ($id, $firstname,
> For databases that do not support sequences
> ADOdb emulates sequences by creating a table for
> i'm left wondering if i need to create a sequence
> table with name 'sequence_name' before this
> will work. or, rather, is it just a name i need to
> plug in to uniquely identify a particular sequence
> controlled by the function?
> i'm sorry this is 50% off topic (adodb) and 50% on
> topic (pqsql).
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam
> protection around
> ---------------------------(end of
> TIP 1: subscribe and unsubscribe commands go to
i found out how to create a pgsql sequence in pgsql
i guess my question now becomes - what are the
relative merits of using a serial within each table or
using a sequence that supports all tables (or several
sequences to support tables of my choosing)?
Do you Yahoo!?
The all-new My Yahoo! - Get yours free!
In response to
pgsql-novice by date
|Next:||From: Mitch Pirtle||Date: 2005-02-02 20:41:51|
|Subject: Re: pgsql and adodb's genID() for unique id sequence...|
|Previous:||From: operationsengineer1||Date: 2005-02-02 20:21:51|
|Subject: pgsql and adodb's genID() for unique id sequence...|