DBTools Software

Anonymous

Incorrect namespace in deleting rows (254 visualizações)
Incorrect namespace in deleting rows	Postado em 08/07/2003 08:44 por christiannancy
Trying to delete a record from a table which belongs to a namespace other than "public". The namespace is called "test", so the syntax would be: DELETE FROM "test"."testtable" WHERE "id" = "1" for example. When selecting the record and clicking on the 'Drop Record' button, it fails because it tries to do: DELETE FROM "public"."testtable" WHERE "id" = "1" I think the bug here is that it doesn't use the correct namespace (eventhough it knows which namespace the table belongs to). Thanks, -Christian PostgreSQL 7.3.3 Windows XP Pro - Cygwin Christian Nancy
Incorrect namespace in deleting rows (254 previews)