On Thu, 23 Jul 1998, The Web Administrator wrote:
> Nope.. Oracle has a background process which re-allocates free space..It does get
> fragmented, and the only real way to unfrag is to export (dump) and import.No Vacuum,
> at least on 7.3.2
So, essentially, our VACUUM command provides f
> >> In fact, they are handled by SQL: CREATE DATABASE and DROP DATABASE. The
> >> createdb and destroydb tools just call these SQL statements
> >Let's remove the "I don't want to think" utilities like
> >{create,destroy}{db,user} and force DBA's to actually use the *proper*
> >functi
On Thu, 23 Jul 1998, Dan Delaney wrote:
> On Fri, 24 Jul 1998, The Hermit Hacker wrote:
> > We've never really been able to come up with an agreeable image of
> > "the mascot"...last I heard, we were looking at an alligator, with some
> > images having been made, but no final image decided on...
On Fri, 24 Jul 1998, The Hermit Hacker wrote:
> Hey, my preference is an elephant. Big, strong, reliable and
> never forgets...
Too many connotations with the GOP...
Brett W. McCoy
http://www.lan2wan.com/~bmccoy
On Fri, 24 Jul 1998, Brett W. McCoy wrote:
> On Fri, 24 Jul 1998, The Hermit Hacker wrote:
>
> > Hey, my preference is an elephant. Big, strong, reliable and
> > never forgets...
>
> Too many connotations with the GOP...
Enlighten me...what is "the GOP"?
On Fri, 24 Jul 1998, The Hermit Hacker wrote:
> > Too many connotations with the GOP...
>
> Enlighten me...what is "the GOP"?
Sorry. The US Republican Party, which uses an elephant for their mascot.
Brett W. McCoy
http://www.lan2wan.co
> > > Too many connotations with the GOP...
> >
> > Enlighten me...what is "the GOP"?
>
> Sorry. The US Republican Party, which uses an elephant for their mascot.
I wouldn't let that stop you from using an elephant. I think that's a
pretty far leap. And I don't expect anyone would associat
Bruce Tong wrote:
>
>
> Another window appeared and said "Error while executing the query. ERROR:
> The field being ordered by must appear in the target list (#1)."
>
> Since I hadn't specified any sorting, the "order by" part of the message
> had me confused. I decided to have MS Access show m
On Fri, 24 Jul 1998, Dan Delaney wrote:
>I'm working on a library catalog and trying to decide what to use
> for the primary key for the authors. Do you think that the first
> three letters of first and last name with the birth year would be
> sufficient (e.g., Alan Watts would be ALAWAT1915)
On Fri, 24 Jul 1998, Dan Delaney wrote:
> I don't like doing that because I don't want to store the entire
> name in every other table which needs to be linked with this one.
> So, for instance, in the table that keeps track of what authors go
> to what book, I want it to just have two fields, th
> Does PostgreSQL support Unicode text fields? If not, that would be
> AWEFULLY nice! Especially now that so many OSs (the MacOS for one)
> and standards (HTML for one) are beginning to use it.
Yeah, I'll probably eventually try to exchange data with a Magic Cap OS
based PDA which also uses Unico
> > >> In fact, they are handled by SQL: CREATE DATABASE and DROP DATABASE. The
> > >> createdb and destroydb tools just call these SQL statements
>
> > >Let's remove the "I don't want to think" utilities like
> > >{create,destroy}{db,user} and force DBA's to actually use the *proper*
On Fri, 24 Jul 1998, Bruce Tong wrote:
> > > > Too many connotations with the GOP...
> > >
> > > Enlighten me...what is "the GOP"?
> >
> > Sorry. The US Republican Party, which uses an elephant for their mascot.
>
> I wouldn't let that stop you from using an elephant. I think that's a
> pre
Bruce Tong wrote:
>
> > The working version of \windows\system\MSJET35.DLL is 3.51.0623.4
> > The broken version I tested was 3.50.3602.4
> > I'm not sure at what release they fixed this problem.
> >
> > I will dig around on MS web site.
> >
> > Does anyone know if its OK to redistribute the MS J
> They have to connect to template1 to do the work. Currently, they don't
> need to know template1 even exists, so it seems like an added burden. I
> will add a mention to the createdb, destroydb man pages. createuser
> does psql too.
And as a result, I didn't know what template1 was for until
On Fri, 24 Jul 1998, Bruce Tong wrote:
> > They have to connect to template1 to do the work. Currently, they don't
> > need to know template1 even exists, so it seems like an added burden. I
> > will add a mention to the createdb, destroydb man pages. createuser
> > does psql too.
>
> And as
Herve Lefebvre wrote:
> ---Marc Fournier <[EMAIL PROTECTED]> wrote:
> >
> > On Thu, 23 Jul 1998, The Web Administrator wrote:
> >
> > > Nope.. Oracle has a background process which re-allocates free
> space..It does get
> > > fragmented, and the only real way to unfrag is to export (dump)
> and i
On Fri, 24 Jul 1998, The Web Administrator wrote:
> The boys at Postgres have so far done a good job of creating an effecient
> Database, let's keep it that way, rather than created a Clone of some
> commercial software that might have years of compatibility issues that
> forced implementation of
On Fri, 24 Jul 1998, Richard Lynch wrote:
> At 8:28 AM 7/24/98, Marc Fournier wrote:
>
> >So, essentially, our VACUUM command provides functionality that
> >Oracle *doesn't* have, right?
>
> Yes, but yours doesn't run automatically.
>
>
> Ideally, when one created a database, one coul
At 8:28 AM 7/24/98, Marc Fournier wrote:
>So, essentially, our VACUUM command provides functionality that
>Oracle *doesn't* have, right?
Yes, but yours doesn't run automatically.
Ideally, when one created a database, one could specify vacuum frequency
and/or time slot, and PostgreSQL w
> I think only doing it the SQL way would be fine. Documentation would, of
> course, have to cover it
That last sentence says it all..."Documentations would, of course, have to cofver
it." The reason I used createdb to generate the my database, is that is what the
man page said to do. Unfortun
>
>
> I don't like doing that because I don't want to store the entire
> name in every other table which needs to be linked with this one.
> So, for instance, in the table that keeps track of what authors go
> to what book, I want it to just have two fields, the Book's primary
> key and the Autho
At 10:36 AM 7/24/98, Byron Nikolaidis wrote:
>Bruce Tong wrote:
>> Another window appeared and said "Error while executing the query. ERROR:
>> The field being ordered by must appear in the target list (#1)."
>>
>> Since I hadn't specified any sorting, the "order by" part of the message
>> had me
On Fri, 24 Jul 1998, Ferruccio Zamuner wrote:
> CREATE TABLE foo (
> x int2
> );
>
> CREATE TABLE bar (
> y foo,
> z int
> );
>
> I read on some Postgres mailing digest that I had to put the OID of instance
> of foo into y field of bar.
>
> So I tried.
>
> The problem is that when I sub
>On Fri, 24 Jul 1998, Richard Lynch wrote:
>
>> At 8:28 AM 7/24/98, Marc Fournier wrote:
>>
>> >So, essentially, our VACUUM command provides functionality that
>> >Oracle *doesn't* have, right?
>>
>> Yes, but yours doesn't run automatically.
>>
>>
>> Ideally, when one created a database,
Richard Lynch wrote:
>
>
> FWIW:
>
> I seldom do much more than add the tables in MS Access's stupid
> query design thingy. I immediately use the menu to view SQL and
> just type the SQL I want. Obviously, different folks think different ways,
> and maybe you actually understand and like th
> FWIW:
>
> I seldom do much more than add the tables in MS Access's stupid
> query design thingy. I immediately use the menu to view SQL and
> just type the SQL I want. Obviously, different folks think different ways,
> and maybe you actually understand and like that MS Access point and clic
>
> Since I'm learning SQL in my spare time, I tend to use these feature in MS
> Access and PgAccess to point me in the right direction or sometimes
> confirm, or deny my assertions.
>
> I like psql, but its not the kind of tool which suggests other
> alternatives. It just says "this part is bog
28 matches
Mail list logo
