Hi!
I think an USING clause would be a great addition:
GENERATED BY DEFAULT AS IDENTITY [USING SEQUENCE name]
What do you think?
Adriano
Original Message
Subject:[Firebird-devel] [FB-Tracker] Created: (CORE-4191) Define
sequence name for Identity Column Type
Date:
I think an USING clause would be a great addition:
GENERATED BY DEFAULT AS IDENTITY [USING SEQUENCE name]
What do you think?
What Sequence (name) would be used if the USING was omitted?
Sean
--
Learn the
On 27/08/2013 13:30, Leyne, Sean wrote:
I think an USING clause would be a great addition:
GENERATED BY DEFAULT AS IDENTITY [USING SEQUENCE name]
What do you think?
What Sequence (name) would be used if the USING was omitted?
A generated one, like now and like happens with constraints and
27.08.2013 20:03, Adriano dos Santos Fernandes wrote:
I think an USING clause would be a great addition:
GENERATED BY DEFAULT AS IDENTITY [USING SEQUENCE name]
What do you think?
Basically, I don't mind, but the behavior will be different from
constraints in regard to the already existing
On 27/08/2013 14:11, Dmitry Yemanov wrote:
27.08.2013 20:03, Adriano dos Santos Fernandes wrote:
I think an USING clause would be a great addition:
GENERATED BY DEFAULT AS IDENTITY [USING SEQUENCE name]
What do you think?
Basically, I don't mind, but the behavior will be different from
I think an USING clause would be a great addition:
GENERATED BY DEFAULT AS IDENTITY [USING SEQUENCE name]
What do you think?
What Sequence (name) would be used if the USING was omitted?
A generated one, like now and like happens with constraints and indexes.
Aren't IDENTITY
On 27/08/2013 14:11, Dmitry Yemanov wrote:
27.08.2013 20:03, Adriano dos Santos Fernandes wrote:
I think an USING clause would be a great addition:
GENERATED BY DEFAULT AS IDENTITY [USING SEQUENCE name]
What do you think?
Basically, I don't mind, but the behavior will be different
On 27/08/2013 15:06, Leyne, Sean wrote:
I think an USING clause would be a great addition:
GENERATED BY DEFAULT AS IDENTITY [USING SEQUENCE name]
What do you think?
What Sequence (name) would be used if the USING was omitted?
A generated one, like now and like happens with constraints
if firebird supported namespaces/schema AND longer identifiers, this would
be alot simpler...
On 27 August 2013 14:11, Leyne, Sean s...@broadviewsoftware.com wrote:
On 27/08/2013 14:11, Dmitry Yemanov wrote:
27.08.2013 20:03, Adriano dos Santos Fernandes wrote:
I think an USING
I think an USING clause would be a great addition:
GENERATED BY DEFAULT AS IDENTITY [USING SEQUENCE name]
What do you think?
What Sequence (name) would be used if the USING was omitted?
A generated one, like now and like happens with constraints and indexes.
Aren't IDENTITY
The user issue is about managing the internal generator.
You can do it now, but you need to discover its internal name.
Why complicate things?
Identity columns allows the use to put manually generated values. So the
ability to manage a sequence is a must-have.
And if a object can be managed,
On 27/08/2013 15:19, Leyne, Sean wrote:
I think an USING clause would be a great addition:
GENERATED BY DEFAULT AS IDENTITY [USING SEQUENCE name]
What do you think?
What Sequence (name) would be used if the USING was omitted?
A generated one, like now and like happens with constraints
27.08.2013 20:22, Adriano dos Santos Fernandes wrote:
The user issue is about managing the internal generator.
You can do it now, but you need to discover its internal name.
Why complicate things?
Complication is managing identity columns via generator. Every operation
should be
Hi,
This is only theory about guids. I remember my real situation 10 servers from
the same part no. System with 1000 new rec per sec and every day we got e.g 20
records with the same guid on different mashines. We change design to prefix
keys in all servers unique.
Regards,
Karol
14 matches
Mail list logo