Re: [teiid-dev] PostgreSQL Sequences
Hi Jimmy,
What type of sequence support are you looking for? Full language support?
For Oracle, in designer a sequence may be modeled as a table with a name in source of dual
and columns with the name in source set to <sequence name>.[nextval|currentval].
You can use a sequence as the default value for insert columns by setting the column to
autoincrement and the name in source to <element name>:SEQUENCE=<sequence
name>.<sequence value>. The latter is more of a workaround though, rather than a
good solution.
It seems like we would need to extend that support for PostgreSQL and other databases
supporting sequences. We should also think about getting sequence information as part of
dynamic vdb metadata so this isn't a manual exercise.
For documentation we're always looking for more wiki content, examples, etc. The
newer documents, like the admin guide, may be a little lite. So if you see anything
omitted, let us know.
Steve
----- Original Message -----
From: "James C Schappet" <james-schappet(a)uiowa.edu>
To: teiid-dev(a)lists.jboss.org
Sent: Monday, June 21, 2010 8:54:47 AM GMT -06:00 US/Canada Central
Subject: [teiid-dev] PostgreSQL Sequences
Quick question: Will teiid ever support sequences in postgres or oracle?
BTW, Theres lots of good work going on here -- CR2 looks good.
Is there some documentation I could help writing?
--Jimmy
--
James Schappet
james-schappet(a)uiowa.edu
_______________________________________________
teiid-dev mailing list
teiid-dev(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/teiid-dev