Re: [ADMIN] Using oid with RServ w/ Postgresql 7.2

2002-10-17 Thread Will LaShell
On Thu, 2002-10-17 at 18:55, Tom Lane wrote: > Will LaShell <[EMAIL PROTECTED]> writes: > > My question would then be, are there any problems/reasons or hints with > > using the oid field as the field that the rserv trigger is set on? > > We will be using rserv in a production environment so I'm lo

Re: [ADMIN] Using oid with RServ w/ Postgresql 7.2

2002-10-17 Thread Tom Lane
Will LaShell <[EMAIL PROTECTED]> writes: > My question would then be, are there any problems/reasons or hints with > using the oid field as the field that the rserv trigger is set on? > We will be using rserv in a production environment so I'm looking at > this as not just an academic solution but

[ADMIN] Using oid with RServ w/ Postgresql 7.2

2002-10-17 Thread Will LaShell
Hey all, So I have rserv set up, the problem we had originally was that when you tell rserv what field to use to replicate you could only specify 1 field. This doesn't exactly work for most of our tables as we use multi field keys. However, we tried it out using the "oid" field, and it seems to

Re: [ADMIN] size estimates

2002-10-17 Thread Laurette Cisneros
Ok, color me silly. I've found pg_statistic and with a few joins and the FAQ, I have the information I'm looking for. Nix this last email. Thanks, L. On Thu, 17 Oct 2002, Laurette Cisneros wrote: > Yes, indeed. Somewhat helpful. But, doesn't tell me how to find out what > the maximum size of

Re: [ADMIN] size estimates

2002-10-17 Thread Laurette Cisneros
Yes, indeed. Somewhat helpful. But, doesn't tell me how to find out what the maximum size of rows are in each of my tables. Is there a way to do this? Also, it gives the overhead for each page and row in the table but not for system tables (indexes, etc.). Is this somewhere? Thank you for help

Re: [ADMIN] Fwd: [BUGS] Fwd: FATAL 1: Database dialup does not

2002-10-17 Thread Robert Treat
What is the output of psql -l ?? Robert Treat On Thu, 2002-10-17 at 10:27, roco wrote: > This is a forwarded message > From: roco <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Date: Friday, September 27, 2002, 2:52:53 PM > Subject: [BUGS] Fwd: FATAL 1: Database dialup does not exist in pg_databa

[ADMIN] Fwd: [BUGS] Fwd: FATAL 1: Database dialup does not exist in pg_database

2002-10-17 Thread roco
This is a forwarded message From: roco <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Date: Friday, September 27, 2002, 2:52:53 PM Subject: [BUGS] Fwd: FATAL 1: Database dialup does not exist in pg_database ===8<==Original message text=== This is a forwarded message From: roco