> -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
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
"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
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
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
"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
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
"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),
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
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
[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
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
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
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
-
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
15 matches
Mail list logo