Re: [GENERAL] Completely new and discovering PostGresSql

1999-11-25 Thread Bruce Momjian
> There is also a work-in-progress for a book to be published in early 2000, > although I don't know the specifics at this point. Since I will have to > check thru my > archives for that. Go to our web site at www.postgresql.org, and look at the FAQ & Documentation page. That is were you should

Re: [GENERAL] Completely new and discovering PostGresSql

1999-11-25 Thread Bruce Momjian
> B. I have seen a fair amount of projects listed on the Web site, but it > does not say much so my question is are there any heavy users of PG so > far (by heavy I mean db with 150+ tables, 150 users, 3000 insert/update > transactions a day + three times as much Selects) and really > busines

Re: [GENERAL] Table names case sensitive?

1999-11-25 Thread Bruce Momjian
> We have recently had a few problems with Interbase on Linux so the > pressure is on them (and they are defiantely not moving ahead as fast as > postgresql is, all the recent versions have been very late and some big > bugs have been left in the field for a long time). Yes, we seem to move at li

Re: [GENERAL] Table names case sensitive?

1999-11-25 Thread Bruce Momjian
> That explains it. In fact, the creates do not use double quotes, > but the queries do. I'll have to find a way to fix that. I have seen that before. Quotations either preserve case, or they don't, but it seems some db's don't honor that. -- Bruce Momjian| http://w

[GENERAL] problems on INSERTS via ODBC?

1999-11-25 Thread Moray McConnachie
6.5.3 running on RedHat Linux 6.0. Front-end running on MS Access 2000 over ODBC on WinNT I have recently been experiencing some worrying problems whereby an "INSERT INTO..." query executed in Access succeeds to all appearances. Opening the linked table or querying it from Access shows that the r

[GENERAL] rule's and trigger's

1999-11-25 Thread J. Roeleveld
Hi,   I was wondering if anyone knows what's being executed first, a Rule on a view, or a trigger set to 'before ' on a view?   Eg. what's executed first? The RULE, or the TRIGGER?   Joost Roeleveld   ps. I hope I'm making sense.

Re: [GENERAL] Completely new and discovering PostGresSql

1999-11-25 Thread Peter Eisentraut
On Thu, 25 Nov 1999, Didier Gasser-Morlay wrote: > I've been using MS Sql Server for the last 4 years on NT and I am quite > fed-up with it. > So I am now seriously considering a move towards LINUX and I investigate > the serious DB offering and PostgreSql Seems to come as a really strong > cand

[GENERAL] about speed

1999-11-25 Thread Vovk G. Grigoriy
Can any tell my, what will fastly - "SELECT ..." statement or function doing "SELECT..."? I do query whith storage procedure in MS SQL, and what about postgresql? Vovk G. Grigoriy.

Re: [GENERAL] Postgres ODBC driver and BLOBs

1999-11-25 Thread Patrick Welche
Vegeta wrote: > > Hi list, > > Is it posible to read and write BLOBs to a PostgreSQL table using > the PostgreSQL ODBC driver? > > Thanks in advance, > Guido Urdaneta I think this is the bit you may need? The type used in the driver is simply called "lo" and here is the command used

Re: [GENERAL] Completely new and discovering PostGresSql

1999-11-25 Thread J. Roeleveld
> Hi everyone, > > I've been using MS Sql Server for the last 4 years on NT and I am quite > fed-up with it. > So I am now seriously considering a move towards LINUX and I investigate > the serious DB offering and PostgreSql Seems to come as a really strong > candidate. > > however I have some que

Re: [GENERAL] Table names case sensitive?

1999-11-25 Thread David Warnock
Stephen, Interesting that you are converting from Interbase. We have now reached the point where we only use 2 commercial pieces of software. Interbase and Visual SlickEdit. I would like to drop Interbase but currently we ship quite a few single user systems running on Win 9x. We have very good

[GENERAL] Re: Cleaning up vacuums

1999-11-25 Thread Mark Jewiss
Hello, On Wed, 24 Nov 1999, Janos Farkas wrote: > I think you see the output from the *backend* itself (on the console/tty > it has been started), which is a child of the postmaster; try > redirecting postmaster when starting it... Spot on, thanks for that! ;-) Regards, Mark. -- Mark Jewiss

[GENERAL] Completely new and discovering PostGresSql

1999-11-25 Thread Didier Gasser-Morlay
Hi everyone, I've been using MS Sql Server for the last 4 years on NT and I am quite fed-up with it. So I am now seriously considering a move towards LINUX and I investigate the serious DB offering and PostgreSql Seems to come as a really strong candidate. however I have some question, which

[GENERAL] can I do this.

1999-11-25 Thread Jason C. Leach
hi, I'm wondering if I can set a trigger or stored procedure that will run a perl script? Thanks, Jason. -- . . Jason C. Leach .. University College of the Cariboo ... [EMAIL PROTECTED] .. http://www.ocis.net/~jcl . The Search for Extraterrestrial Intelligence from Hom

[GENERAL] pg_shadow

1999-11-25 Thread datab
Hi all! I create a new user: XXX, and give him superuser rights. When the user execute:"SELECT * FROM pg_shadow" on local machine, works ok. If try to execute this select in a JAVA aplication on another machine, doesn't works. Other selects works ok in JAVA application: "SELECT *