Re: [SQL] AutoCommit and DDL

2005-02-27 Thread Don Drake
I did some traces and it all looks OK. The problem has to do with multiple concurrent connections to the server causing problems. I've removed the concurrent connections and now this works. Strange. -Don On Sun, 27 Feb 2005 12:54:34 -0700, Michael Fuhr <[EMAIL PROTECTED]> wrote: > On Sun, Feb

Re: [SQL] Serial and Index

2005-02-27 Thread Tom Lane
"Sam Adams" <[EMAIL PROTECTED]> writes: > I read at http://jamesthornton.com/postgres/FAQ/faq-english.html#4.15.1 > that when a serial is created then an index is created on the column. > However I can't seem to find this anywhere in the PoistgreSQL manual. Is > this true? Thanks. It was once true

Re: [SQL] Serial and Index

2005-02-27 Thread Ragnar Hafstað
On Sun, 2005-02-27 at 12:54 +, Sam Adams wrote: > I read at http://jamesthornton.com/postgres/FAQ/faq-english.html#4.15.1 > that when a serial is created then an index is created on the column. > However I can't seem to find this anywhere in the PoistgreSQL manual. Is > this true? Thanks. no,

Re: [SQL] Serial and Index

2005-02-27 Thread Miroslav Šulc
Documentation at http://www.postgresql.org/docs/8.0/interactive/datatype.html#DATATYPE-SERIAL says: "In most cases you would also want to attach a UNIQUE or PRIMARY KEY constraint to prevent duplicate values from being inserted by accident, but this is not automatic." and "*Note: * Prior to P

Re: [SQL] Serial and Index

2005-02-27 Thread Mike Rylander
On Sun, 27 Feb 2005 12:54:52 +, Sam Adams <[EMAIL PROTECTED]> wrote: > I read at http://jamesthornton.com/postgres/FAQ/faq-english.html#4.15.1 > that when a serial is created then an index is created on the column. > However I can't seem to find this anywhere in the PoistgreSQL manual. Is > thi

Re: [SQL] AutoCommit and DDL

2005-02-27 Thread Don Drake
I know it's not failing, I have the server logging the commands and there are no errors. The only change made was turning AutoCommit on. -Don On Sat, 26 Feb 2005 21:20:43 -0700, Michael Fuhr <[EMAIL PROTECTED]> wrote: > On Sat, Feb 26, 2005 at 02:56:52PM -0600, Don Drake wrote: > > > I turned

Re: [SQL] Serial and Index

2005-02-27 Thread Michael Fuhr
On Sun, Feb 27, 2005 at 12:54:52PM +, Sam Adams wrote: > I read at http://jamesthornton.com/postgres/FAQ/faq-english.html#4.15.1 That copy of the FAQ is over two years old according to the "Last updated" text at the top of the page. You can find the current FAQ here: http://www.postgresql.o

Re: [SQL] Serial and Index

2005-02-27 Thread Bruno Wolff III
On Sun, Feb 27, 2005 at 12:54:52 +, Sam Adams <[EMAIL PROTECTED]> wrote: > I read at http://jamesthornton.com/postgres/FAQ/faq-english.html#4.15.1 > that when a serial is created then an index is created on the column. > However I can't seem to find this anywhere in the PoistgreSQL manual. Is

[SQL] Serial and Index

2005-02-27 Thread Sam Adams
I read at http://jamesthornton.com/postgres/FAQ/faq-english.html#4.15.1 that when a serial is created then an index is created on the column. However I can't seem to find this anywhere in the PoistgreSQL manual. Is this true? Thanks. -Sam ---(end of broadcast)-

Re: [SQL] diference in dates in minutes

2005-02-27 Thread Bruno Wolff III
Discussions along this line should stay on the list so that other people can learn from and add comments to the discussion. On Sat, Feb 26, 2005 at 16:57:15 -0500, Joel Fradkin <[EMAIL PROTECTED]> wrote: > You sure? > I thought date1::date - date2::date returns an integer of day's diff, but > da