Re: [DOCS] Mysql -> Postgresql pitfalls

2003-08-01 Thread scott.marlowe
On Fri, 1 Aug 2003, Chad N. Tindel wrote: > Excellent! That is exactly what I'm talking about. > > BTW, the "my2pg.pl" link is a dead link. This is probably something that could be codified a bit here in the news group. I'd say the pitfalls I'm aware of are: autoincrement fields -> sequences

Re: [DOCS] Mysql -> Postgresql pitfalls

2003-08-04 Thread scott.marlowe
On Fri, 1 Aug 2003, Chad N. Tindel wrote: > > > Excellent! That is exactly what I'm talking about. > > > > > > BTW, the "my2pg.pl" link is a dead link. > > > > This is probably something that could be codified a bit here in the news > > group. > > > > I'd say the pitfalls I'm aware of are: >

Re: [DOCS] Mysql -> Postgresql pitfalls

2003-08-04 Thread scott.marlowe
On Sat, 2 Aug 2003, Chad N. Tindel wrote: > > > As a programmer, I personally would never write code that kept > > > people from running things as root. I mean, what is the point? > > > > If someone roots your box, it's not our fault. Simple as that. > > I didn't say "require them to run as a

Re: [DOCS] truth table missing values

2003-08-04 Thread scott.marlowe
On Mon, 4 Aug 2003, Dennis Björklund wrote: > The reason stated in > http://www.mysql.com/documentation/mysql/bychapter/manual_Introduction.html#Differences_from_ANSI > > is > > "NULL AND FALSE will evaluate to NULL and not to FALSE. This is because we > don't think it's good to have to evaluat

Re: [DOCS] Mysql -> Postgresql pitfalls

2003-08-04 Thread scott.marlowe
On Mon, 4 Aug 2003, Josh Berkus wrote: > Folks, > > Are we actually arguing about whether or not Postmaster should be allowed to > run as root? > > I thought this question was settled, like, 5 years ago. > > If migrating MySQL users have trouble with it, maybe we should focus on > supplyin

Re: [DOCS] Mysql -> Postgresql pitfalls

2003-08-04 Thread scott.marlowe
On Mon, 4 Aug 2003, Chad N. Tindel wrote: > > > > Yes. The documentation very clearly states using sequences instead of > > > > auto-increment, but it doesn't make it clear that inserting the id's into > > > > data by hand doesn't cause the sequence to be auto-matically incremented. > > > > It'd

Re: [DOCS] Mysql -> Postgresql pitfalls

2003-08-04 Thread scott.marlowe
On Mon, 4 Aug 2003, Chad N. Tindel wrote: > > > > FWIW, in 7.5 we're likely to implement SQL3 IDENTITY columns ... basically > > > > just a SERIAL column where you don't have the option of inserting your own > > > > value, you have to take what it gives you. > > > > > > Interesting... how do yo

Re: [DOCS] buffring in pgsql

2003-09-18 Thread scott.marlowe
On Thu, 18 Sep 2003, Josh Berkus wrote: > Monu, > > > I have developed a new page buffring algo for DBMS packages I want to > > implement it in postgresql but I haven't any knowlegde of postgresql code > > can any1 tell me from where I should start & which docs I will have to > > study for that.