Hi RPK
My suggestion would be to create a view which presents the columns as
you wish.
eg
CREATE OR REPLACE VIEW tableView AS
SELECT a, b, c
FROM table
Then when you add add a new column, just adjust the view as required.
Cheers
Noel
RPK wrote:
Andreas,
I am talking about inserting a f
Hi,
Have you added the ability to store reservations, if a book is out. Maybe
having a table for this,
requests/reservations
id pk
user_id fk
item_id fk
date_requested (so that the first person on the list for this book is
notified)
Also, I'll assume there is more than one book per title, thu
Hi
all,
I posted this on the novice mailing list and as yet had no response,
hopefully someone here can help.
While we where trying to do a vacuum / pg_dump we encountered the
following error:
[EMAIL PROTECTED]:~$ pg_dumpall -d > dump.pg
pg_dump: dumpClasses(): SQL command failed
pg_dump:
activestate perl works a treat and crimson editor
(http://www.crimsoneditor.com/) as an editor. If you want a gui
database manager with sql scripting try aqua data :
http://www.aquafold.com/
Cheers
Noel
Roy Souther wrote:
I love Linux, any tool you need it has it. Just try to find the
Thanks for the pointers Michael!
Which config file will tell us how big the bock sizes are?
Cheers
Noel
Michael Fuhr wrote:
On Wed, Mar 01, 2006 at 04:12:53PM +1100, Noel Faux wrote:
Now after doing some searches I managed to work out that the data
corruption starts at
Is your table really over 100G?
Yeap 600+ million rows.
Anyway, if the block size is 8192
then 902292 sould be in the .6 file. If you can spare the time
then you might run the dd and od commands that Tom Lane mentions
in the above message and post the output.
Here's the output:
000 0
Noel
Michael Fuhr wrote:
On Tue, Mar 07, 2006 at 01:41:44PM +1100, Noel Faux wrote:
Here is the output from the pg_filedump; is there anything which looks
suss and where would we re-zero the data, if that's the next step
Thanks for all your help Michael, we wish to do a vacuum and dump
before the upgrade to 8.02. Do you believe this data corruption is a
postgres issue of an OS / hardware issue?
Cheers
Noel
Michael Fuhr wrote:
On Thu, Mar 09, 2006 at 11:13:40AM +1100, Noel Faux wrote:
Ok it
n Thu, Mar 09, 2006 at 11:13:40AM +1100, Noel Faux wrote:
Ok it worked but we ran into another bad block :(
/vacuumdb: vacuuming of database "monashprotein" failed: ERROR: invalid
page header in block 9022937 of relation "gap"
/
So the command we used was:
dd bs=8k seek=
hives.postgresql.org/pgsql-general/2006-03/msg2.php
Your thoughts / comments...
Cheers
Noel
Michael Fuhr wrote:
On Thu, Mar 09, 2006 at 12:37:52PM +1100, Noel Faux wrote:
I've been watching the post: Re: [GENERAL] Fixing up a corrupted toast table
In there they mention deleti
To clarify, when set on, every time it hits this error, postgres will
rezero that block?
Michael Fuhr wrote:
On Thu, Mar 09, 2006 at 03:57:46PM +1100, Noel Faux wrote:
Given that this seems problem has occurred a number of times for a
number I've written a small step by
Hi all,
Has anyone had this problem?
while in psql:
monashprotein=> \d alignment
ERROR: column c2.reltablespace does not exist
monashprotein=> \d region
ERROR: column c2.reltablespace does not exist
monashprotein=>
monashprotein=> \d
ERROR: relation "pg_catalog.pg_roles" does not exist
Any
Klint Gore wrote:
On Thu, 16 Mar 2006 12:33:26 +1100, Noel Faux <[EMAIL PROTECTED]> wrote:
Has anyone had this problem?
while in psql:
monashprotein=> \d alignment
ERROR: column c2.reltablespace does not exist
monashprotein=> \d region
ERROR: column c2.reltablesp
a64-unknown-linux-gnu, compiled by GCC gcc (GCC)
3.3.5 (Debian 1:3.3.5-13)
(1 row)
Please reply to all, ensuring that the post is placed on the
pqsql-general mailing list.
Klint Gore wrote:
On Thu, 16 Mar 2006 12:51:03 +1100, Noel Faux <[EMAIL PROTECTED]> wrote:
This is a multi-part m
Chris wrote:
Noel Faux wrote:
On the client machine:
$ psql --version
psql (PostgreSQL) 8.1.3
At the host:
monashprotein=> select version();
vers
Hi Chris,
I think the best bet would be to use a nested select:
Delete from A WHERE A.bk = (SELECT bk FROM B) where A.ak = x;
Cheers
Noel
Chris Velevitch wrote:
I'm using pg 7.4.5 on Win XP SP1.
I want to delete rows from a table B, but need to join it to another
table A in order to select t
16 matches
Mail list logo