Re: [HACKERS] [COMMITTERS] pgsql: Minor doc tweak: NOT NULL is

2005-12-28 Thread Neil Conway

Christopher Kings-Lynne wrote:

I hope you mean 'redundant with PRIMARY KEY in example'...


Why? SERIAL implies NOT NULL (although PRIMARY KEY does as well, of course).

-Neil


---(end of broadcast)---
TIP 4: Have you searched our list archives?

  http://archives.postgresql.org


Re: [HACKERS] [COMMITTERS] pgsql: Minor doc tweak: NOT NULL is

2005-12-28 Thread Christopher Kings-Lynne
Why? SERIAL implies NOT NULL (although PRIMARY KEY does as well, of 
course).


Ah yes you're right.  I mixed up with the fact that SERIAL no longer 
implies UNIQUE...


Chris


---(end of broadcast)---
TIP 6: explain analyze is your friend


Re: [HACKERS] [COMMITTERS] pgsql: Minor doc tweak: NOT NULL is redundant

2005-12-27 Thread Christopher Kings-Lynne

I hope you mean 'redundant with PRIMARY KEY in example'...

Works out the same way though.

Chris

Neil Conway wrote:

Log Message:
---
Minor doc tweak: NOT NULL is redundant with SERIAL in example.

Modified Files:
--
pgsql/doc/src/sgml/ref:
create_domain.sgml (r1.26 - r1.27)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/ref/create_domain.sgml.diff?r1=1.26r2=1.27)

---(end of broadcast)---
TIP 4: Have you searched our list archives?

   http://archives.postgresql.org



---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings