Depends on your OS. Are you using Linux or Windows?
If you're using a linux terminal window you can usually highlight it and
ctrl-shift-c. Or use the menus.
On Mon, Nov 22, 2010 at 10:15 AM, Lukasz Brodziak wrote:
> Lame question - how to copy output from psql console?
>
I might be being optimistic but I should be able to make sense of the \d+
output if you can post that.
On Mon, Nov 22, 2010 at 10:04 AM, Lukasz Brodziak wrote:
> The output is in Polish :) is there anything particular to look for?
>
The output is in Polish :) is there anything particular to look for?
2010/11/22 Matthew Walden :
> You can describe an object with the psql command \d. \d+ gives you extended
> information. So at the psql command line if you type the following -
>
> \d+ users
>
> You should see a description of
You can describe an object with the psql command \d. \d+ gives you extended
information. So at the psql command line if you type the following -
\d+ users
You should see a description of the layout of the table along with
associated indexes.
On Mon, Nov 22, 2010 at 8:56 AM, Lukasz Brodziak
wro
\d+ what do You mean by that?
2010/11/22 Matthew Walden :
> And the \d+ on users? Also would you mind pasting the output exactly as it
> is appears on screen, assuming it is in English?
>
> I'm trying to build up a picture here of how many problems you have and
> whether they can be fixed convent
And the \d+ on users? Also would you mind pasting the output exactly as it
is appears on screen, assuming it is in English?
I'm trying to build up a picture here of how many problems you have and
whether they can be fixed conventionally with the database interface or
whether you need to start mes
And the version is 8.2.4
2010/11/22 Lukasz Brodziak :
> Hello,
>
> I got access to corrupted DB... The SELECT COUNT(*) FROM users where
> id_usr IS NULL returned error of invalid page header in one of the
> blocks...
>
> And the ANALYZE users got me an error that one of the pg_clog files is
> miss
Hello,
I got access to corrupted DB... The SELECT COUNT(*) FROM users where
id_usr IS NULL returned error of invalid page header in one of the
blocks...
And the ANALYZE users got me an error that one of the pg_clog files is
missing...
2010/11/21 Matthew Walden :
> Oh and could we please have the
Oh and could we please have the output from SELECT version(); too please.
On Sun, Nov 21, 2010 at 7:56 PM, Matthew Walden wrote:
> A few more information requests if you don't mind.
>
> Can you analyze the table ie "ANALYZE USERS" without error?
>
> Could you please paste the output from "\d+ use
Can you post the select and the exact error?
On Sun, Nov 21, 2010 at 6:43 PM, Lukasz Brodziak
wrote:
> 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 includi
Found the message but all I get is null value in column
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 :
> Hello,
>
> I have a problem with one of the tables in my database. Th
A few more information requests if you don't mind.
Can you analyze the table ie "ANALYZE USERS" without error?
Could you please paste the output from "\d+ users".
And try SELECT COUNT(*) FROM users WHERE id_usr IS NULL;
Is your database large? Can you shut down the instance cleanly and take a
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
13 matches
Mail list logo
