cross-database references are not implemented?

burning snow · Post by **burning snow** » Fri 14 Dec 2007 14:05

Hi folks,

What does this error means?

cross-database references are not implemented: "zds.public.contacts"

CoreLab.PostgreSql.PgSqlException was unhandled
Message="cross-database references are not implemented: \"zds.public.contacts\""
Source="CoreLab.PostgreSql"
ErrorCode=-2147467259
CallStack=""
DetailMessage=""
FileName="namespace.c"
Hint=""
LineNumber=195
Position=0
ProcedureName="RangeVarGetRelid"
StackTrace:
bei CoreLab.PostgreSql.a.d(Boolean A_0)
bei CoreLab.PostgreSql.a.ae()
bei CoreLab.PostgreSql.a.b(String A_0)
bei CoreLab.PostgreSql.a.l()
bei CoreLab.PostgreSql.PgSqlCommand.a(Boolean A_0, Int32 A_1, Int32 A_2)
bei CoreLab.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior)
bei System.Data.Common.DbCommand.ExecuteReader()
bei CoreLab.Common.DbCommandBase.ExecuteNonQuery()
bei Clockworkz.Zds.Ral.Contact.PgSql.ContactRal.Create(ZdoContact objContact)
bei Clockworkz.Zds.Bll.Contact.ContactBll.Save(ZdoContact objContact)
bei Clockworkz.Zds.Gui.Test.Program.Main(String[] args) in C:\Dokumente und Einstellungen\ZA\Eigene Dateien\Visual Studio 2005\Projects\Clockworkz\Clockworkz.Zds.Gui.Test\Program.cs:Zeile 34.
bei System.AppDomain.nExecuteAssembly(Assembly assembly, String[] args)
bei System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence assemblySecurity, String[] args)
bei Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly()
bei System.Threading.ThreadHelper.ThreadStart_Context(Object state)
bei System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
bei System.Threading.ThreadHelper.ThreadStart()

I've got one table with several fields and no relation to other tables.

SecureGen · Post by **SecureGen** » Fri 14 Dec 2007 14:27

Please send me a small test project to reproduce the problem.
Include the definition of your own database objects.
Use e-mail address provided in the Readme.html file.
Do not use third party components.
If it is impossible for you to create the test project, send us a piece of
your code where the error occurs.

burning snow · Post by **burning snow** » Fri 14 Dec 2007 15:47

The problem is now solved, after I recreated the complete database with lower case database name. I don't know why this was the problem.

SecureGen · Post by **SecureGen** » Fri 14 Dec 2007 16:22

As far as I can see, it was an internal server error. I cannot determine its reason. I suppose it was a server configuration problem.