We've got a table that has a definition as follows:
CREATE TABLE linking_table (
    fk        int8 REFERENCES source_table( pk1 ),
    value    int8,

I tried to truncate a table and received the following error:
"expected both swapped tables to have TOAST tables".
Googling provided no insight. What does it mean?
Version 7.4.1.

So sorry for the OT :-)
I'm experiencing some weird behaviour by majordomo-owner (not answering
my posts, even older than a week) and also with pgsql-novice and cygwin,
I addressed a few posts to them which are nowhere to be seen (a search

Is that site working for you?
I'm unable to reach it since a couple of days, my messages are not
getting through, pgsql-?????-owner@postgresql.org do not answer my
'requests for clarification', majordomo is not responding to my

I have got a table which is supposed to contain only one row. It does
not have any primary keys defined.
So, essentially, when a new insert happens in that table, I would like
it (the insert) to fail if there is already a row existing in that

I have a question about substring(), when I run the following query:
prepaid=# select substring('15148300', 0, 5);
substring
-----------

I have an existing installation of 7.3.4 that appears to have been made with
"--without-readline and --without-zlib" parameters used at build time.  How
do I change those  parms without reinstalling the whole thing.  I would
normally go through the archives, but they appear to be ...

Does anyone have experiences using PostgreSQL for storing Microsoft
Project data?  MS Access, SQL Server and Oracle are supported
according to the manual.  A simple test with PostgreSQL results in an
error something like 'Unknown data type "lo"'.  

I met a  problem about cannot start postmaster.
The situation I met is that I was running postmaster, but because of the
server closed all my konsole. As a result, I did not shutdown postmaster
successfully. Next time, when I tried to run

Can anyone suggest if there's a way to force a plpgsql stored procedure
to be recompiled every time that it's called, based on the values of the
parameters that it's given?  I assumed it would be possible, but
unfortunately haven't been able to find any documentation on how to

I'm new to PostgreSQL (and C) and what I'm trying to do is to store a
query plan on disc (in a binary file).
My approach is to use SPI functions to get the query plan and then
transform it into a 'storable' format (Replacing the pointers with

We have a list of customers, some of whom have purchased feature X and some of
whom have not. If a customer has paid for featurex, they can use it, and a
strict relationship between cust_items.items_id and items.id, but only if
they are signed up to use featurex, otherwise I want ...

Dear debuggers,
Sorry again if it was already reported or it is a work in progress, but I
cannot have access to the list archives right now.
On my linux box with a cvs-head updated  this morning:

PostgreSQL: 7.4.1
Last week, I had a corrupt index on one table with 2 million rows.  On a
specific search, the database would SEGV.  I dropped and recreated the index
involved in the search, and did a REINDEX on the primary key.  That problem

The docs says that numeric type supports numbers upto
any precision
<docs>
8.1.2. Arbitrary Precision Numbers