U++ forum: Welcome to the forum

Status & Roadmap

Authors & License

Funding Ultimate++

Search on this site

Search in forums

Home » U++ Library support » U++ SQL » PostgreSQL issues

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

Return to the default flat view

Create a new topic

Submit Reply

Re: PostgreSQL issues [message #9692 is a reply to message #9656]

Fri, 25 May 2007 09:08

unodgs is currently offline

unodgs
Messages: 1367
Registered: November 2005
Location: Poland

Ultimate Contributor

What is the problem with explicity defining column as PRIMARY_KEY?

SERIAL (ID) PRIMARY_KEY

I think primary_key attribute should be removed from sqlite schema to preserve consistency instead of adding it to postgresql.
Besides PostrgesSQL documentation says:
Note: Prior to PostgreSQL 7.3, serial implied UNIQUE. This is no longer automatic. If you wish a serial column to be in a unique constraint or a primary key, it must now be specified, same as with any other data type.

Report message to a moderator

Send a private message to this user

[Message index]

		PostgreSQL issues By: zsolt on Wed, 23 May 2007 22:34
		Re: PostgreSQL issues By: zsolt on Wed, 23 May 2007 22:47
		Re: PostgreSQL issues By: mirek on Thu, 24 May 2007 23:30
		Re: PostgreSQL issues By: unodgs on Fri, 25 May 2007 09:08
		Re: PostgreSQL issues By: zsolt on Fri, 25 May 2007 19:43
		Re: PostgreSQL issues By: mirek on Fri, 13 July 2007 13:49
		Re: PostgreSQL issues By: zsolt on Fri, 13 July 2007 22:30
		Re: PostgreSQL issues By: mirek on Sun, 15 July 2007 11:45

Previous Topic:	How to access a firebird database ?
Next Topic:	Returning a null from select

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

PDF

]

Current Time: Tue Jul 08 07:08:39 CEST 2025

Total time taken to generate the page: 0.06001 seconds