Re: [GENERAL] my C pgm

2000-11-23 Thread bmccoy
You also declared num4 twice. It ran fine for me then. What C compiler are you using? Brett W. McCoy http://www.chapelperilous.net/~bmccoy/ --- CONGRATULATIONS! Now should I make thinly

Re: [GENERAL] True ACID under linux (no fsync)?

2000-10-31 Thread bmccoy
"Gary Howland (During daytime)" wrote: > Just a quickie - I heard that linux does not have a working fsync() > call (it has no concept of raw devices). In other words, fsync cannot > be used to ensure that data is on disk (try it with a floppy - it > returns IMMEDIATELY!!! - long before the writ

Re: [GENERAL] phpPgAdmin

2000-10-26 Thread bmccoy
On Thu, 26 Oct 2000, danyele wrote: > Brett and Ron said to me to rebuild php with the --with-pgsql option > in the configuration step. > > I've already did what you recommend but another warning is appearing! > > Warning: Unable to connect to PostgresSQL server: FATAL 1: SetUserId: > user

Re: [GENERAL] (redefinition) alter table, add foreign key constraint

2000-10-17 Thread bmccoy
On Tue, 17 Oct 2000, Matthew Kennedy wrote: > A little redefinition of my question is in order. If I try doing this: > > create table things (name varchar(20), state(2)); > create table states (abbreviation varchar(2)); > alter table things > add foreign key (state) > references st

Re: [GENERAL] Re: R: PostgreSQL book

2000-10-12 Thread bmccoy
On Thu, 12 Oct 2000, Travis Bauer wrote: > I'll second Bookpool for computer books. I've used them a couple of times > and they are good. I'm a big fan of readme.doc -- especially because they have a store only minutes from my house! Brett W. McCoy

Re: [GENERAL] Pg.pm question

2000-10-10 Thread bmccoy
On Tue, 10 Oct 2000, KMiller wrote: > Can anyone explain this in more detail and/or offer suggestions for a > fix? How about some code? It's hard to tell just by looking at error messages. Brett W. McCoy http://www.chapelperilous.net --

Re: [GENERAL] Re: VIEW problem

2000-10-09 Thread bmccoy
On Fri, 6 Oct 2000, Stephan Szabo wrote: > About view rules: > Of course, you shouldn't actually be > able to get into the situation with > a view rule, since dropping the table > the view points to should drop the view > (or refuse to drop the table) it appears > from looking at drop table in t

Re: [GENERAL] Question

2000-10-09 Thread bmccoy
On Thu, 5 Oct 2000, Amy Antle wrote: > I have 2 tables in Access. I want one of them to act as an archive table. > The first table collects records for a tempoary amount of time, and then > drops them into another table that will store them and keep growing and > growing each time it receive

Re: [GENERAL] Re: URL Type

2000-10-06 Thread bmccoy
On Fri, 6 Oct 2000, K Parker wrote: > But MS Access is _both_, remember? The question > came up when migrating from Access talking to > its own local Jet database to Access talking > to pgsql via odbc. I'm not sure there is a > way to tell Access to consider a particular > text field in a remo

Re: [GENERAL] Redhat 7 and PgSQL

2000-09-29 Thread bmccoy
On 29 Sep 2000, Trond Eivind Glomsrød wrote: > > But claiming that you can't upgrade is painting over what might rather be > > a deficiency in the RPM mechanism, ISTM. Why can't you have a spec file > > like this: > > > > %preupgrade > > pg_dumpall >somewhere > > > 1) You don't know that post

Re: [GENERAL] Redhat 7 and PgSQL

2000-09-29 Thread bmccoy
On Fri, 29 Sep 2000, Efrain Caro wrote: > So we can say that we can upgrade, at least in theory, but that's not the > official policy? Well, I don't know about 'policy', but yes, you can upgrade PostgreSQL, you just need to dump your data first (which you should do anyway to backup -- never upgr

Re: [GENERAL] Redhat 7 and PgSQL

2000-09-29 Thread bmccoy
On 29 Sep 2000, Trond Eivind Glomsrød wrote: > That you can't upgrade postgresql from e.g. 6.5 to 7.0 or from 7.0 to > 7.1 > > Incidentally, you can dump data from a database. You can also insert > data into a database. If you do this before and after upgrading, > you'll hopefully have the same

Re: [GENERAL] ORDERING alphabetically

2000-08-09 Thread bmccoy
Y surname; Brett W. McCoy http://www.chapelperilous.net/~bmccoy/ --- But soft you, the fair Ophelia: Ope not thy ponderous and marble jaws, But get thee to a nunnery -- go!

RE: [GENERAL] 4 billion record limit?

2000-07-26 Thread bmccoy
gend. Brett W. McCoy http://www.chapelperilous.net/~bmccoy/ --- A girl's conscience doesn't really keep her from doing anything wrong-- it merely keeps her from enjoying it.

Re: [GENERAL] Describe structure.

2000-07-25 Thread bmccoy
+--+ It's all in the online help. The command you want is \d . Brett W. McCoy http://www.chapelperilous.net/~bmccoy/ --- Yow! Is my fallout shelter termite proof?

Re: [GENERAL] Web front-end

2000-07-24 Thread bmccoy
modeled after the one that was made for MySQL. Brett W. McCoy http://www.chapelperilous.net/~bmccoy/ --- Darth Vader! Only you would be so bold! -- Princess Leia Organa