On Monday 20 October 2003 20:03, Martijn Tonies wrote:

> Hi Yves,
>
> > > > is firebird support auto increment data type?
> > > > (
> > > > like 'serial8' data type in postgresql.
> > > > like 'bigint auto_increment' in mysql.
> > > > )
> > >
> > > Yes, but its done through generators. Lookup generators in the
> > > docs.
> >
> > Has it never been considered to provide an "autoincrement" property
> > for integer columns, as in other dbs?
> >
> > There seems to be popular demand for autoincrement, and it would
> > surely help (non-dba)users (read "Access", etc...) to migrate to
> > FB.

Hi,

> Actually, I think auto-inc fields are an abomination when it comes to
> multi user etc access. Generators are much more powerful, and don't
> _have_ to be used in triggers. I usually use them to get a number
> first, then INSERT the new data. Very easy for any parent-child
> relationships you need to establish as well.

I fully agree. Still I think addition of the autoincrement property
would lower the entry barrier. :-)

best regards,
Yves

> With regards,
>
> Martijn Tonies
> Database Workbench - developer tool for InterBase, Firebird & MS SQL
> Server. Upscene Productions
> http://www.upscene.com
>
>
> ------------------------ Yahoo! Groups Sponsor
> ---------------------~--> Buy Ink Cartridges or Refill Kits for your
> HP, Epson, Canon or Lexmark Printer at MyInks.com. Free s/h on orders
> $50 or more to the US & Canada.
> http://www.c1tracking.com/l.asp?cid=5511
> http://us.click.yahoo.com/mOAaAA/3exGAA/qnsNAA/67folB/TM
> ---------------------------------------------------------------------
>~->
>
> To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/

--
Linux 2.4.22-1-k7 #1 Sat Sep 6 02:13:04 EST 2003 i686
20:34:11 up 1:20, 1 user, load average: 0.32, 0.27, 0.27