U++ forum: Welcome to the forum

Re: PostgreSQL fieldname case bug [message #9694 is a reply to message #9689]

Fri, 25 May 2007 09:24

unodgs
Messages: 1367
Registered: November 2005
Location: Poland

Ultimate Contributor

I'm sorry. I was experimenting with PostgreSql plugin and forgot to revert this change. It will be fixed.

PS:
As you can see in postgre plugin code I added GetInsertedId but I pass null in sequence variable:
Format("select currval('%s')", sequence);
As I discovered this is the only way to get the squence value. Unfortunatelly this way requires sequence name.

This leads me to 2 conclusions:
1. GetInsertedId() must be change to GetInsertedId(const char *sequence = NULL)

2. postgres sch interface should generate squences ids automaticaly if column's type is SERIAL (to be able to write SQL.GetInsertedID(T_ID_SEQ)) Now I would be force to do something like this:

TABLE(T)
  INT (id) PRIMARY_KEY
  SEQUENCE(id)
END_TABLE

instead of just

TABLE(T)
  SERIAL (id) PRIMARY_KEY
END_TABLE

[Updated on: Fri, 25 May 2007 09:28]

Report message to a moderator