RE: [GENERAL] Error: cannot write block XX of XXXXX/XXXXX blind: resource tempo rarily unavailable

2001-06-21 Thread Stock, Stuart H.
> -Original Message- > From: Larry Rosenman [SMTP:[EMAIL PROTECTED]] > Sent: Thursday, June 21, 2001 12:19 PM > To: Tom Lane > Cc: Stock, Stuart H.; '[EMAIL PROTECTED]' > Subject: Re: [GENERAL] Error: cannot write block XX of X/X > blind: resource tempo rarily unavailable

Re: [GENERAL] newbie primary key problem

2001-06-21 Thread will trillich
On Tue, Jun 12, 2001 at 05:33:02PM +0100, Dan wrote: > Hello, > > I have a small php script to log web access that writes to a psql database. > The error I get everytime I do a refresh is: > Warning: PostgreSQL query failed: ERROR: Cannot insert a duplicate key into > unique index session_pkey in

Re: [GENERAL] WAL failure?

2001-06-21 Thread Tom Lane
"Jim Buttafuoco" <[EMAIL PROTECTED]> writes: > My system crashed today (don't know why yet.) After i started the > postmaster the log file this entry in it. > DEBUG: ReadRecord: invalid magic number in logfile 4 seg 34 off > 1592 > Is this a problem??? This looks like a fairly normal WA

Re: [GENERAL] Moving rows to another database

2001-06-21 Thread will trillich
On Fri, Jun 15, 2001 at 11:18:40AM +0100, Mark wrote: > How would I go about moving or copying data between databases on the same > server, without actually doing a dump ? Using an SQL statement, > something like: > > SELECT dbase_a.sometable.somefield > INTO dbase_b.sometable > FROM dbase_a

Re: [GENERAL] Re: Newbie question: How to check how many tables avaliable at that database?

2001-06-21 Thread will trillich
On Wed, Jun 13, 2001 at 07:25:46PM +0200, Nils Zonneveld wrote: > > > Carfield Yim wrote: > > > > I am a new user of PostgreSQL dbms, how can I check how many tables > > avaliable at that database? > > To get a list of tables through SQL: > > SELECT tablename FROM pg_tables WHERE tablename N

Re: [GENERAL] Error: cannot write block XX of XXXXX/XXXXX blind: resource tempo rarily unavailable

2001-06-21 Thread Tom Lane
"Stock, Stuart H." <[EMAIL PROTECTED]> writes: > I am running Postgresql 7.1.1 compiled with GCC 2.95.2 on a Sun 220 > Solaris 2.8 box and am experiencing the following error: > DEBUG: mdblindwrt: close() failed: Resource temporarily unavailable > ERROR: cannot write block 44 of 2139949/240576

[GENERAL] Error: cannot write block XX of XXXXX/XXXXX blind: resource temporarily unavailable

2001-06-21 Thread Stock, Stuart H.
All, After searching the mailing list archives, Deja's comp.databases.postgresql.* archives, the Postgres docs, and Google I cannot find an answer to a strange error I am seeing, so I seek your wisdom. I am running Postgresql 7.1.1 compiled with GCC 2.95.2 on a Sun 220 Solaris 2.8 box and

Re: [GENERAL] aggregate function for median calculation

2001-06-21 Thread Tom Lane
"Thalis A. Kalfigopoulos" <[EMAIL PROTECTED]> writes: > I worked on it so the struct state now has 3 fields: int length, int > elem_count, int *elements. Now the issue is that the transition > function, which I declare as strict, has a different input and state > type (int4 and text respectively),

Re: [GENERAL] aggregate function for median calculation

2001-06-21 Thread Thalis A. Kalfigopoulos
On Thu, 21 Jun 2001, Tom Lane wrote: > "Thalis A. Kalfigopoulos" <[EMAIL PROTECTED]> writes: > > I'm still a bit confused about how to declare the type of the transition state. > > I have a structure that will hold the current state: > > struct state { > > int elem_count; //how many numbers h

Re: [GENERAL] Foreign Keys to Non-primary keys?

2001-06-21 Thread Stephan Szabo
On Thu, 21 Jun 2001 [EMAIL PROTECTED] wrote: > > Is it possible to have a foreign key to a non-primary key (also > meaning non-unique and therefore non-indexed) column i a table? Generally no. It's not allowed by the spec, so as of 7.1, we prevent it. Admittedly, you could pull the rug out f

Re: [GENERAL] Authentification

2001-06-21 Thread Tom Lane
[EMAIL PROTECTED] writes: > I´m using PostgreSQL 7.1.2 (from Debian). My pg_hba.conf looks like > # default > localall peer sameuser There is no such authentication type as "peer". regards, tom lane

Re: [GENERAL] index on a box

2001-06-21 Thread Tom Lane
Dustin Sallings <[EMAIL PROTECTED]> writes: > I was wondering, however, if there's a way I can use an index to > avoid table scanning for this. If you say "SET enable_seqscan TO off", and repeat the EXPLAIN, do you get an indexscan plan? I don't recommend doing such a SET for production pu

Re: [GENERAL] Quick RServ Question

2001-06-21 Thread Thalis A. Kalfigopoulos
On Wed, 20 Jun 2001 [EMAIL PROTECTED] wrote: > Hello, > > I have a quick RServ question. We have got it all running and it seems to > work except, only manually. In other words, it works great as long as we > use the Replicate command. > > So my question is... Is the Replicate command supposed

[GENERAL] WAL and problems with loading a large table

2001-06-21 Thread Martin Weinberg
I'm trying to load a 200GB table. WAL seems to be using many GB of disk space and slowing down the load. I tried "-F" and fync=off in the postmaster.conf (these are supposed to be the same, right?) but these don't inhibit the WAL use. What is the right approach here? Thanks! --Martin -

[GENERAL] Authentification

2001-06-21 Thread tillea
Hello, I´m using PostgreSQL 7.1.2 (from Debian). My pg_hba.conf looks like # default localall peer sameuser host all 127.0.0.1 255.0.0.0 ident sameuser # added myself to cope with the problem host all