On Wed, Jun 06, 2012 at 12:55:42PM +0000, Molenaar, Gijs wrote:

I have an issue with getting all the Django tests working with MonetDB. Django assumes a database can have a column with a hyphen in it's name, as long as it is correctly escaped.

It is this specific test which should generate valid SQL when passed trough the MonetDB Django backend: https://github.com/django/django/blob/master/tests/modeltests/reserved_names...

Does MonetDB support a hyphen in it's column name, if so, how do I escape this correctly?

I guess, MonetDB does not allow hyphens in identifiers, even when quoted:

sql>create table t (a-b int); 42000!syntax error, unexpected '-' in: "create table t (a-" sql>create table t ("a-b" int); Invalid identifier 'a-b'

Stefan

-- Gijs Molenaar http://www.astro.uva.nl/people/gijs-molenaar/

---

Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/

---

MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users

On 06/06/2012 09:31 PM, Stefan de Konink wrote:

Hi Gijs,

I have got a lot of trouble using MonetDB with the standard Python code. MonetDB eats endsless amounts of memory, where I suspect it has to do with keeping the connection alive. Eventually getting a Out-Of-Memory.

I'm seeing similar problems with the Python API. I was not able to complete the full Django test suite on Djonet and MonetDB yet, since it will crash mserver5 or let CPU usage go to 100% at random points in the test suite. Maybe there is something weird happening in the Python API that will result in unstable behaviour of MonetDB. I'm trying to isolate the problem, but it takes time.

Since I guess Djonet is also keeping the database connect alive, do you nee any summing up of MonetDB's memory?

Sorry, I don't understand your question.

greetings,

- Gijs