Choose a convention. At the moment, the first source table provides more characteristics to the target than do the other sources, and that could be true for OIDs also. I would be inclined to have the logic be that if *any* source table has OIDs, then the target gets them. Unless it was explicitly specified using the WITH/WITHOUT syntax of course.How would we make use of 'hasoids' in the case of multiple source tables, or a source table defined by an SRF?
Right. There is no problem coming up with consistant semantics, though there may be a problem getting a consensus on what those should be.Unless we can define some consistent semantics for when we use the hasoids of the source table(s), I'd say we should just add the WITH/WITHOUT OIDS syntax.
In the meantime we have broken compatibility with the previous release (since targets are created without OIDs) and should think about fixing that.
- Thomas
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
