Re: [GENERAL] GTK or TCL/TK ... what do you prefer ? (beginner)

2000-04-28 Thread Jurgen Defurne
Marcel Sierra wrote: > Hello, Forum > > In my 1st message. I'm developping in MSVB 6.0 & Access. Have you ever developed anything with VB and Access ? If your answer is yes, then you have already a basic understanding. If your answer is no, you should do that first. Is it imperative that you u

Re: [GENERAL] problem with nested views

2000-04-28 Thread Travis Bauer
What do you mean by "properly qualifying?" The query would look something like this: select keyword.token, keyword.value as kvalue, globalkw.value from keyword, globalkw where keyword.token=globalkw.token; A single record in globalkw should match multiple records in keyword. The single record

Re: [GENERAL] 7.0RC1: possible query and backend problem

2000-04-28 Thread Tom Lane
Michael Blakeley <[EMAIL PROTECTED]> writes: > I've just upgraded to 7.0RC1 on a Solaris 2.6+patches system (U5 with > 256MB). I'm having some trouble with a brand-new query, so I don't > know if this is a new bug or an old one. It has two parts: query > execution and backend robustness. >

[GENERAL] Re: Read Only from ODBC

2000-04-28 Thread James R. R. Service
SUDDN wrote: > > I downloaded the ODBC driver for postgres and installed it on my Win98 > Client. I'm writing a Visual Basic program that accesses the PostgreSQL > server on my Linux box. It can read the data fine but It won't write data. > I get a read only error when I try. > > I have unchec

[GENERAL] Data Warehousing and PostgreSQL

2000-04-28 Thread Julio Dominguez, BNC
Title: Data Warehousing and PostgreSQL Hello! I am evaluating PostgreSQL as a database server (with Linux) for a Data Warehousing Project and wondered if you have any experience in a similar task. Some of questions would be if it's capable of supporting A LOT of heavy queries and big amount

Re: [GENERAL] Restoring old database with OIDs that are now in use by another database after initdb = problems?

2000-04-28 Thread leonbloy
> > I'm wondering what would happen if I were to backup/archive an old > database with OIDs, then later someday, restore it after I've since done an > initdb and there is someother database using the same OIDs as the old database. > If I restore with OIDs, that would cause the OIDs to not be

Re: [GENERAL] Restoring old database with OIDs that are now in use byanother database after initdb = problems?

2000-04-28 Thread Bruce Momjian
> > I'm wondering what would happen if I were to backup/archive an old > database with OIDs, then later someday, restore it after I've since done an > initdb and there is someother database using the same OIDs as the old database. > If I restore with OIDs, that would cause the OIDs to not be uniq

[GENERAL] Restoring old database with OIDs that are now in use by another database after initdb = problems?

2000-04-28 Thread Robert B. Easter
I'm wondering what would happen if I were to backup/archive an old database with OIDs, then later someday, restore it after I've since done an initdb and there is someother database using the same OIDs as the old database. If I restore with OIDs, that would cause the OIDs to not be unique within

[GENERAL] GTK or TCL/TK ... what do you prefer ? (beginner)

2000-04-28 Thread Marcel Sierra
Hello, Forum In my 1st message. I'm developping in MSVB 6.0 & Access. I am beginner in Linux. I want to develop some easy program. I'd like to program with a dev.lang. to Linux and to know your opinions to interact with Posgres. No programs made at the moment. Nothing. I'm studing intensively

Re: [GENERAL] refint.sql

2000-04-28 Thread Marc Tardif
Those are all the files you need. First, run gmake in contrib/spi and you'll notice two more files are created: refint.so refint.sql Also, take note that referential integrity on postgresql 6.5.3 works by using triggers. So you must first CREATE FUNCTION which is detailed in refint.sql which, in

[GENERAL] problem with nested views

2000-04-28 Thread Travis Bauer
Can I create views based on a combination of an existing view and the table on which it was originally based? When I try this, I am getting no error, but the numbers in some columns of the resulting view are not correct. Thanks, T

Re: [GENERAL] advice on indexing email

2000-04-28 Thread Marc Tardif
Regarding your first suggestion, I cannot use a trigger since the actual email contents will not be inserted in the database because of the 8K limit on text fields. Instead, I will be keeping the messages as a seperate file and only keep the pathname in the database. As for your second suggestion

[GENERAL] How tu put/read a composite type in a table?

2000-04-28 Thread Loïc TREGOUËT
Thanks to those who will have the force read my mail until the end ... I 've search for a long time (one week) how to work with composite type. create table compositeDef ( i int4 , t text ) ; create table myTable ( j int4 , c composite); I'm right (isn't it?) because when i create a naw tabl

Re: [GENERAL] Revisited: Transactions, insert unique.

2000-04-28 Thread Bruce Momjian
[Charset iso-8859-1 unsupported, filtering to ASCII...] > On Thu, 27 Apr 2000, Bruce Momjian wrote: > > > Are you asking for sub-second timeout values? If so, we could add that. > > I already have a millisecond resolution for deadlock timeouts implemented. > Is that okay? Sure, that should wor