[EMAIL PROTECTED] writes:
> Explain reports unexpected results with inheritance
I see no unexpected behavior here, nor anything that has anything to do
with inheritance. The CREATE INDEX updates (some of) the planner's
statistics about the table, so that it now knows tab2 contains only one
page
> When a table is created with a serial column and another column that
> has a foreign key constraint, if the foreign key check fails, the
> sequence will still be updated. This results in potential gaps in the
> serial column.
This is not a bug. If you cannot have gaps in your number sequence
David Lynn ([EMAIL PROTECTED]) reports a bug with a severity of 3
The lower the number the more severe it is.
Short Description
Explain reports unexpected results with inheritance
Long Description
When tab2 inherits tab1, explain in psql will always report a "Seq Scan" on tab2 even
if there are
David Lynn ([EMAIL PROTECTED]) reports a bug with a severity of 3
The lower the number the more severe it is.
Short Description
Sequence increased before constraint check
Long Description
When a table is created with a serial column and another column that has a foreign key
constraint, if the f
Tom,
Thanks for the quick response.
> Try it with the beta version's ODBC driver ...
How do I get it? I looked through the Development
version FTP filetree, and can't find the ODBC driver
anywhere. Link ... pretty please?
Second, I've also discovered that Pos
