Re: Zeroing single tuple in data file.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Found the message but all I get is null value in column <name>
violates non-null constraint. As I said before the tuple is in the
physical file and it contains all the data which is also in other
tuples.

2010/11/21 Lukasz Brodziak <lukasz.brodziak@xxxxxxxxx>:
> Hello,
>
> I have a problem with one of the tables in my database. The thing is
> that one of the rows is present in corresponding data file yet I'm
> unable to perform any actions on it including simple SELECT statement.
> Is there a way of deleting the tuple from the file by zeroing it and
> then reindexing the table. I tried other ways of dealing with the
> problem like vacuming and clustering the table but it pops out the
> error and terminates when processing the given row. I have several
> data folders so when I find the exact error message I will post it.
>
> --
> Åukasz Brodziak
> "What if everyting around You isn't quite as it seems,
> What if all the world You think You know is an inelaborate dream
> When You look at Your reflection is that all you want it to be
> What if You could look right through the cracks
> Would You find Yourself...... Find Yourself afraid to see"
>



-- 
Åukasz Brodziak
"What if everyting around You isn't quite as it seems,
What if all the world You think You know is an inelaborate dream
When You look at Your reflection is that all you want it to be
What if You could look right through the cracks
Would You find Yourself...... Find Yourself afraid to see"

-- 
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin



[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux