AW: Dods: bug in dods 5.1

This is a multi-part message in MIME format.

------=_NextPart_000_0071_01C3A6DE.96E22760
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi !

Exactly this is why we have implemented the "SQL splitter" which
seperates CREATE TABLES from FOREIGN KEYS...give it a try ! It is an
option in the DODS Generator wizard...

Greetings.

Alfred

-----Urspr=FCngliche Nachricht-----
Von: Kip C. Lubliner [mailto:[email protected]]=20
Bereitgestellt: Samstag, 08. November 2003 00:22
Bereitgestellt in: DODS
Unterhaltung: Dods: bug in dods 5.1
Betreff: Dods: bug in dods 5.1


Hello,

I am a new user to DODS, and Enhydra.  I build a small doml file, and=20
generated the SQL for Postgres.  the SQLcreate.sql file didn't work.
Upon=20
further inspection, the problem is that dods re-ordered my list of
tables. =20
In my original DODS file, all tables only referred to tables earlier in=20
the file - but after the re-ordering, this is no longer the case.

This isn't that big of a deal - I simply re-ordered the order of table=20
creation, and then it worked.  However, it is possible to have two
tables=20
that refer to each other.  In such a case, no re-ordering will fix the=20
problem.  In this case, the only solution is to put the referential=20
integrity constraints in after the create table statements.

Thanks,
Kip

_______________________________________________
Dods mailing list
[email protected] http://www.enhydra.org/mailman/listinfo.cgi/dods

------=_NextPart_000_0071_01C3A6DE.96E22760
Content-Type: application/x-pkcs7-signature;
	name="smime.p7s"
Content-Transfer-Encoding: base64
Content-Disposition: attachment;
	filename="smime.p7s"

MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAAoIII2jCCAmIw
ggHLoAMCAQICAwsPZTANBgkqhkiG9w0BAQQFADBiMQswCQYDVQQGEwJaQTElMCMGA1UEChMcVGhh
d3RlIENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhhd3RlIFBlcnNvbmFsIEZyZWVt
YWlsIElzc3VpbmcgQ0EwHhcNMDMxMTAyMTcyODQyWhcNMDQxMTAxMTcyODQyWjBZMQ0wCwYDVQQE
EwRNYWRsMQ8wDQYDVQQqEwZBbGZyZWQxFDASBgNVBAMTC0FsZnJlZCBNYWRsMSEwHwYJKoZIhvcN
AQkBFhJBLk1hZGxAdG9nZXRoZXIuYXQwgZ8wDQYJKoZIhvcNAQEBBQADgY0AMIGJAoGBAMSUz0lI
gbjM8T5YPR5N2zkqHZCEQnP6hHG2LfUAVkssM+ArKJWrxPrfpNJrggv1SWBII3qeHOaZZbHeHLTc
Ji3xxEduLuM9dUcxEOgYc+4Q3mw4O2IVJN343rHuzEtFktOJWMpoSZihy8OHhsaukhOMFGDo/2Lp
D0nLRQS5v4OlAgMBAAGjLzAtMB0GA1UdEQQWMBSBEkEuTWFkbEB0b2dldGhlci5hdDAMBgNVHRMB
Af8EAjAAMA0GCSqGSIb3DQEBBAUAA4GBAKnq3350qe6y9F+qnEhU8wwmW7sFvYgbVJubU/lrdm/D
0SsUci6e7b3aOr0T60Ubl9J4BPAmfy0pBBBKfrKHvHzuUJCiNItLXe2xf3sFCakK9qUmH8897o9Q
fseb+Gll7EOkWyh6cvq5+7J9q9dwLOQ5omDQXicZvXTSmsORjUdiMIIDLTCCApagAwIBAgIBADAN
BgkqhkiG9w0BAQQFADCB0TELMAkGA1UEBhMCWkExFTATBgNVBAgTDFdlc3Rlcm4gQ2FwZTESMBAG
A1UEBxMJQ2FwZSBUb3duMRowGAYDVQQKExFUaGF3dGUgQ29uc3VsdGluZzEoMCYGA1UECxMfQ2Vy
dGlmaWNhdGlvbiBTZXJ2aWNlcyBEaXZpc2lvbjEkMCIGA1UEAxMbVGhhd3RlIFBlcnNvbmFsIEZy
ZWVtYWlsIENBMSswKQYJKoZIhvcNAQkBFhxwZXJzb25hbC1mcmVlbWFpbEB0aGF3dGUuY29tMB4X
DTk2MDEwMTAwMDAwMFoXDTIwMTIzMTIzNTk1OVowgdExCzAJBgNVBAYTAlpBMRUwEwYDVQQIEwxX
ZXN0ZXJuIENhcGUxEjAQBgNVBAcTCUNhcGUgVG93bjEaMBgGA1UEChMRVGhhd3RlIENvbnN1bHRp
bmcxKDAmBgNVBAsTH0NlcnRpZmljYXRpb24gU2VydmljZXMgRGl2aXNpb24xJDAiBgNVBAMTG1Ro
YXd0ZSBQZXJzb25hbCBGcmVlbWFpbCBDQTErMCkGCSqGSIb3DQEJARYccGVyc29uYWwtZnJlZW1h
aWxAdGhhd3RlLmNvbTCBnzANBgkqhkiG9w0BAQEFAAOBjQAwgYkCgYEA1GnX1LCUZFtx6UfYDFG2
6nKRsIRefS0Nj3sS34UldSh0OkIsYyeflXtL734Zhx2G6qPduc6WZBrCFG5ErHzmj+hND3EfQDim
AKOHePb5lIZererAXnbr2RSjXW56fAylS1V/Bhkpf56aJtVquzgkCGqYx7Hao5iR/Xnb5VrEHLkC
AwEAAaMTMBEwDwYDVR0TAQH/BAUwAwEB/zANBgkqhkiG9w0BAQQFAAOBgQDH7JJ+Tvj1lqVnYiqk
8E0RYNBvjWBYYawmu1I1XAjPMPuoSpaKH2JCI4wXD/S6ZJwXrEcp352YXtJsYHFcoqzceePnbgBH
H7UNKOgCneSa/RP0ptl8sfjcXyMmCZGAc9AUG95DqYMl8uacLxXK/qarigd1iwzdUYRr5PjRznei
gTCCAz8wggKooAMCAQICAQ0wDQYJKoZIhvcNAQEFBQAwgdExCzAJBgNVBAYTAlpBMRUwEwYDVQQI
EwxXZXN0ZXJuIENhcGUxEjAQBgNVBAcTCUNhcGUgVG93bjEaMBgGA1UEChMRVGhhd3RlIENvbnN1
bHRpbmcxKDAmBgNVBAsTH0NlcnRpZmljYXRpb24gU2VydmljZXMgRGl2aXNpb24xJDAiBgNVBAMT
G1RoYXd0ZSBQZXJzb25hbCBGcmVlbWFpbCBDQTErMCkGCSqGSIb3DQEJARYccGVyc29uYWwtZnJl
ZW1haWxAdGhhd3RlLmNvbTAeFw0wMzA3MTcwMDAwMDBaFw0xMzA3MTYyMzU5NTlaMGIxCzAJBgNV
BAYTAlpBMSUwIwYDVQQKExxUaGF3dGUgQ29uc3VsdGluZyAoUHR5KSBMdGQuMSwwKgYDVQQDEyNU
aGF3dGUgUGVyc29uYWwgRnJlZW1haWwgSXNzdWluZyBDQTCBnzANBgkqhkiG9w0BAQEFAAOBjQAw
gYkCgYEAxKY8VXNV+065yplaHmjAdQRwnd/p/6Me7L3N9VvyGna9fww6YfK/Uc4B1OVQCjDXAmNa
LIkVcI7dyfArhVqqP3FWy688Cwfn8R+RNiQqE88r1fOCdz0Dviv+uxg+B79AgAJk16emu59l0cUq
VIUPSAR/p7bRPGEEQB5kGXJgt/sCAwEAAaOBlDCBkTASBgNVHRMBAf8ECDAGAQH/AgEAMEMGA1Ud
HwQ8MDowOKA2oDSGMmh0dHA6Ly9jcmwudGhhd3RlLmNvbS9UaGF3dGVQZXJzb25hbEZyZWVtYWls
Q0EuY3JsMAsGA1UdDwQEAwIBBjApBgNVHREEIjAgpB4wHDEaMBgGA1UEAxMRUHJpdmF0ZUxhYmVs
Mi0xMzgwDQYJKoZIhvcNAQEFBQADgYEASIzRUIPqCy7MDaNmrGcPf6+svsIXoUOWlJ1/TCG4+DYf
qi2fNi/A9BxQIJNwPP2t4WFiw9k6GX6EsZkbAMUaC4J0niVQlGLH2ydxVyWN3amcOY6MIE9lX5Xa
9/eH1sYITq726jTlEBpbNU1341YheILcIRk13iSx0x1G/11fZU8xggMcMIIDGAIBATBpMGIxCzAJ
BgNVBAYTAlpBMSUwIwYDVQQKExxUaGF3dGUgQ29uc3VsdGluZyAoUHR5KSBMdGQuMSwwKgYDVQQD
EyNUaGF3dGUgUGVyc29uYWwgRnJlZW1haWwgSXNzdWluZyBDQQIDCw9lMAkGBSsOAwIaBQCgggIJ
MBgGCSqGSIb3DQEJAzELBgkqhkiG9w0BBwEwHAYJKoZIhvcNAQkFMQ8XDTAzMTEwOTE1MjkwNFow
IwYJKoZIhvcNAQkEMRYEFCWcQ1YLbicN0GCahYbEx45nb7T4MEsGCyqGSIb3DQEJEAIBMTwwOgQd
AAAAABAAAAAW7IIyBG8zSrvnW4GVYULpAQAAAACAAQAwFjAUgRJBLk1hZGxAdG9nZXRoZXIuYXQw
ZwYJKoZIhvcNAQkPMVowWDAKBggqhkiG9w0DBzAHBgUrDgMCGjAOBggqhkiG9w0DAgICAIAwDQYI
KoZIhvcNAwICAUAwBwYFKw4DAgcwDQYIKoZIhvcNAwICASgwCgYIKoZIhvcNAgUweAYJKwYBBAGC
NxAEMWswaTBiMQswCQYDVQQGEwJaQTElMCMGA1UEChMcVGhhd3RlIENvbnN1bHRpbmcgKFB0eSkg
THRkLjEsMCoGA1UEAxMjVGhhd3RlIFBlcnNvbmFsIEZyZWVtYWlsIElzc3VpbmcgQ0ECAwsPZTB6
BgsqhkiG9w0BCRACCzFroGkwYjELMAkGA1UEBhMCWkExJTAjBgNVBAoTHFRoYXd0ZSBDb25zdWx0
aW5nIChQdHkpIEx0ZC4xLDAqBgNVBAMTI1RoYXd0ZSBQZXJzb25hbCBGcmVlbWFpbCBJc3N1aW5n
IENBAgMLD2UwDQYJKoZIhvcNAQEBBQAEgYClTciRzusExDIqks0Im0HLLMaKM9am3clpctae1blF
E6SO+ZgaIVRScB8KoCB0D+FvxM+lyhspQcm0D94LHOuSlAinTyoPRcYEYdrD+zYwmszKL6wgaJGd
jeJiGOGmB4rYf4knO3yiw9wQ4kf9TqYZvqXSdWD+WkdncMcE0huVNAAAAAAAAA==

------=_NextPart_000_0071_01C3A6DE.96E22760--