Re: [GENERAL] Am I using the SERIAL type properly?

2003-07-12 Thread Jeffrey Melloy
If you use a serial datatype, it simply says "the *default* behavior is to use the next value of sequence a". So you can insert 1, 2, 10,204,492 into the column just fine. However, by inserting data into something you want to auto-increment, you can run into non-uniqueness. (Like you were).

[GENERAL] DB_USER_NAMESPACE

2003-07-12 Thread Sean Mullen
What is the 'status' of DB_USER_NAMESPACE? Is it still a temporary measure and is it safe to rely on it? Sean. ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [GENERAL] What about a comp.databases.postgresql usenet newsgroup

2003-07-12 Thread Daniel Seichter
Hello, > see news.us.postgresql.org for now, while we deal with some issues locally > ... if anyone else wishes to open up a similar mirror, please let us know > and we'll help get it setup ... > > all the lists are gatewayed to a comp.databases.postgresql.* newsgroup ... Is it with or without auth

Re: [GENERAL] What about a comp.databases.postgresql usenet newsgroup

2003-07-12 Thread The Hermit Hacker
see news.us.postgresql.org for now, while we deal with some issues locally ... if anyone else wishes to open up a similar mirror, please let us know and we'll help get it setup ... all the lists are gatewayed to a comp.databases.postgresql.* newsgroup ... On Thu, 10 Jul 2003, Bruno BAGUETTE wr