[SQL] SQL92 and Traditional

2000-06-19 Thread Toshihide Nakamura
Hello, I have a question. I am seeing lots of SQL92-compared-to-Traditional-SQL. What is a definition of "Traditional"? Is it SQL89? 86? Or anything before 92? It seems like postgresql supports both, but which is it better to write? Thanks, Tony

Re: [SQL] the day after...

2000-06-19 Thread Tom Lane
Tulassay Zsolt <[EMAIL PROTECTED]> writes: > FATAL 1: cannot create init file pg_internal.init Hmm, disk full? Wrong ownership or permissions on database directory (data/base/tek)? Looks like that error report needs to include the kernel error message... regards, tom l

[SQL] the day after...

2000-06-19 Thread Tulassay Zsolt
hi, our linux box crashed yesterday, and postgresql seems to have some trouble with one of the databases. It says: zsolt@tek:/var/lib/pgsql$ psql tek Connection to database 'tek' failed. FATAL 1: cannot create init file pg_internal.init All other databases are working just fine. Any idea? Th

Re: [SQL] Database Transfer

2000-06-19 Thread Kate Collins
I have an interest in this topic ... I am looking to do "real time" updates of a data base on two different servers, with one acting as a master and the other acting as a slave. In the realm of Oracle, I believe it is called "replication". >From what I have read, there is no such feature in pgs