U++ framework: U++ SQL » PostgreSQL fieldname case bug

Home » U++ Library support » U++ SQL » PostgreSQL fieldname case bug

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

[Message index]

		PostgreSQL fieldname case bug By: zsolt on Fri, 25 May 2007 00:16
		Re: PostgreSQL fieldname case bug By: mirek on Fri, 25 May 2007 09:23
		Re: PostgreSQL fieldname case bug By: unodgs on Fri, 25 May 2007 09:24
		Re: PostgreSQL fieldname case bug By: zsolt on Fri, 25 May 2007 19:50
		Re: PostgreSQL fieldname case bug By: mirek on Mon, 18 June 2007 20:18

Previous Topic:	SqlFormat() bug with Date and Time types
Next Topic:	How to access a firebird database ?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Wed May 06 21:49:46 GMT+2 2026

Total time taken to generate the page: 0.00571 seconds