Re: [GENERAL] Data Versioning

2001-08-01 Thread Yasuo Ohgaki
> Does any body know if pgsql supports any kind of versioning of binary > objects or data. e.g. If I'm storing a binary file in a row of a table, I > would want to see different versions of the same biary file. Everytime I do > a write, the version number should be bumped up !! With PostgreSQL, yo

RE: [GENERAL] Finding number of current connections

2001-08-01 Thread Tauren Mills
Hi Nils, Thanks for this information! I should be able to use this to create a script that will solve my needs. Does anyone know (Tom?) if this will still work when 7.2 is out? Or are there changes to the basic server structure and what 'ps' reports? Tauren > -Original Message- > Fro

RE: [GENERAL] Finding number of current connections

2001-08-01 Thread Nils O. Selåsdal
On Wednesday 01 August 2001 07:53 am, Tauren Mills wrote: > Thanks, Tom! > > I assume the fact you only mention 7.2 means the current versions have no > way to determine this. Well, postgresql starts one process per connection so you could see how many postmasters that are running(minus one for t

[GENERAL] Data Versioning

2001-08-01 Thread Sunit Bhatia
Does any body know if pgsql supports any kind of versioning of binary objects or data. e.g. If I'm storing a binary file in a row of a table, I would want to see different versions of the same biary file. Everytime I do a write, the version number should be bumped up !! Is it possible to do i

[GENERAL] Data Versioning

2001-08-01 Thread Sunit Bhatia
Does any body know if pgsql supports any kind of versioning of  binary objects or data. e.g. If I'm storing a binary file in a row of a table, I would want to see different versions of the same biary file. Everytime I do a write, the version number should be bumped up !!   Is it possible to do it i

Re: [GENERAL] Finding number of current connections

2001-08-01 Thread Martijn van Oosterhout
On Wed, Aug 01, 2001 at 10:11:22AM -0400, Tom Lane wrote: > "Tauren Mills" <[EMAIL PROTECTED]> writes: > > Will 7.2 also be able to let you control how many connections each user is > > using? > > No, there's no present plans for that. So you can't just do CREATE CONSTRAINT on that table and hav

[GENERAL] Re: Coursor keys don't work in "psql"

2001-08-01 Thread Tony Reina
Stuart Grimshaw <[EMAIL PROTECTED]> wrote in message news:<81x97.56$O34.7220@wards>... > Can anyone explain why my cursor keys don't work in psql? > > When I press one I get Up = ^[[A down = ^[[B etc. > > The last company I used to work for had the cursor keys working OK to > scroll back throu

Re: [GENERAL] Corrupted tables?

2001-08-01 Thread Mihai Gheorghiu
I tried to connect from another computer: the same tables cannot be opened. What would be in PG that ODBC uses and psql does not? Mihai -Original Message- From: Tom Lane <[EMAIL PROTECTED]> To: Mihai Gheorghiu <[EMAIL PROTECTED]> Cc: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date: Wednesday,

[GENERAL] [INTERFACES] libpgtcl.dll (fwd)

2001-08-01 Thread Fernando Schapachnik
Hi, I'm reposting it here because haven't found an answer on -interfaces. Hope to have more luck :) I wonder if somebody has a clue on this, because I'm lost. I was having problems with TCL 8.3 and encoding. Tatsuo Ishii was kind enough to provide me with the necessary

Re: [GENERAL] Re: Better backtrace (wasRe: pqReadData() -- backend closed the ch

2001-08-01 Thread Tom Lane
Well, the bottom line seems to be that there's something broken about the floating-point support on that box. Look in /usr/local/pgsql/data/tmp --- I made a trivial test program that just tries to convert a short integer to a double. I get: > cat tryit.c #include #include int main() {

Re: [GENERAL] Corrupted tables?

2001-08-01 Thread Mihai Gheorghiu
I'll try. Thanks a lot. Mihai -Original Message- From: Tom Lane <[EMAIL PROTECTED]> To: Mihai Gheorghiu <[EMAIL PROTECTED]> Cc: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date: Wednesday, August 01, 2001 11:14 AM Subject: Re: [GENERAL] Corrupted tables? >"Mihai Gheorghiu" <[EMAIL PROTECTED

Re: [GENERAL] Corrupted tables?

2001-08-01 Thread Tom Lane
"Mihai Gheorghiu" <[EMAIL PROTECTED]> writes: > I double-checked: > - It is the tables that were included in the MSAccess querry that can no > longer be accessed by MSAccess. > - The tables in question can be viewed with psql and PGAccess. Well, if you can read the tables with psql then they're n

Re: [GENERAL] Fwd: getInherits(): SELECT failed.

2001-08-01 Thread Tom Lane
Nigel Gilbert <[EMAIL PROTECTED]> writes: >> I have inherited a database apparently set up using postgres7.0.2. >> I now want to dump the database in preparation for tidying up and >> upgrading to the current version of postgresql. However, pg_dumpall >> gives: >> >> pg_dumpall >db.out >> get

[GENERAL] Fwd: getInherits(): SELECT failed.

2001-08-01 Thread Nigel Gilbert
I sent the message below to the list last Thursday and received not one single reply! Is there no one who could give me any help? Even 'this is the wrong list, send your query to XXX' would be useful. Yours in hope, Nigel Gilbert > >From [EMAIL PROTECTED] Thu Jul 26 23:49:27 2001 >Date: T

Re: [GENERAL] Finding number of current connections

2001-08-01 Thread Jan Wieck
Tauren Mills wrote: > I posted this message to the admin list, but just realized maybe it belongs > in the general list. Sorry for double posting! > > I need to find a way to determine how many concurrent connections are being > made to the database server at any given time. I'm coming from > ad