Why would the backend get a KILL signal like this? It was doing a
routine select ... into , or a copy ... to at the time.
2005-09-19 09:52:46 [1511] LOG: server process (PID 19446) was
terminated by signal 9
2005-09-19 09:52:46 [1511] LOG: terminating any other active server
processes
2005-09-1
___
> Do You Yahoo!?
> Información de Estados Unidos y América Latina, en Yahoo! Noticias.
> Visítanos en http://noticias.espanol.yahoo.com
>
> ---(end of broadcast)---
> TIP 4: Don't 'kill -9' the post
Try this:
1) Add a new column of type DECIMAL(5,2)
2) update the table setting the new column with the value in the old
column.
3) rename the old column to something not used
4) rename the new colum to the name of the old column
5) wait for a later version where you can drop column, or just leave
I think.. you needed: currval('"mytable_ABC_seq"')
I avoid non-lower case names personally. It is not very portable to rely
on that in your application and will be confusing if anyone else messes
with your code.
--
David Stanaway
signature.asc
Description: This is a digitally signed message part
an: CREATE TABLE "Foo" ( ... )
otherwise.. You will need to change your code to quote all references to
the name:
EG:
$q = 'SELECT * from "Foo"';
If you don't put ["]'s around the object identifier, it gets case folded
to lower case.
--
David Stanaway
signature.asc
Description: This is a digitally signed message part
mucha práctica en español.
--
David Stanaway
signature.asc
Description: This is a digitally signed message part
This might be helpful..
--- Begin Message ---
> Can someone clue me in as to proper syntax for adding a not null
> check constraint? I've fumbled around a bit without much luck
> and I don't see this covered in the alter table section of the
> interactive docs.
>
> My pseudo code is:
> ALTER T
; for
> table 'tabla2'
> CREATE
>
> proba=# alter table tabla1 drop constraint ID not null;
Here you refer to it as ID which is case folded to id and does not refer
to the column named ID.
I don't know if that is your problem, but it is one problem with your
code. and it will no doubt show up in many more places.
--
David Stanaway
signature.asc
Description: This is a digitally signed message part
reject
Anyway.. you probably want to restore the database as a super user (EG:
User Postgres) The dump script should have
\connect - "www-data"
statements in it. It also may have some
\connect - "postgresql"
statements too. which could cause problems as user www-data
--
David Stanaway
signature.asc
Description: This is a digitally signed message part
s pretty safe.
There is also pgmonitor (Which I think is in contrib) which shows the
stats on the current backend processes (Works on 7.1.3 for me) and is
much nicer for working out whats using CPU, and the query that is
causing the problem.
--
David Stanaway
signature.asc
Description: This is a digitally signed message part
know a way around this?
==
David Stanaway
Personal: [EMAIL PROTECTED]
Work: [EMAIL PROTECTED]
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL
know a way around this?
==
David Stanaway
Personal: [EMAIL PROTECTED]
Work: [EMAIL PROTECTED]
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL
r that postmaster runs as? (pgsql or postgres depending on distribution)
======
David Stanaway
Personal: [EMAIL PROTECTED]
Work: [EMAIL PROTECTED]
rds
David Stanaway
Technology Manager
Australia's Premier Internet Broadcasters
Phone: +612 9357 1699
Fax: +612 9357 1169
Web: http://www.netventures.com.au
Support: [EMAIL PROTECTED]
The Inspire Foundation is proudly supporte
ently off)
\z list table access permissions
\! [cmd] shell escape or command
======
David Stanaway
Personal: [EMAIL PROTECTED]
Work: [EMAIL PROTECTED]
On Tuesday, January 15, 2002, at 07:08 PM, Roman Gavrilov wrote:
David Stanaway wrote:
On Wednesday, January 9, 2002, at 10:31 PM, Roman Gavrilov wrote:
One more question is how can I see all tables in the template1 ?
Thanks allot.
in the psql client: psql template1
\dt
\h is
.
--
Best Regards
David Stanaway
Technology Manager
Australia's Premier Internet Broadcasters
Phone: +612 9357 1699
Fax: +612 9357 1169
Web: http://www.netventures.com.au
Support: [EMAIL PROTECTED]
The Inspire Foundation is pr
to the database.
Take a look here maybe:
http://gborg.postgresql.org/project/pgmonitor/projdisplay.php
One more question is how can I see all tables in the template1 ?
Thanks allot.
in the psql client: psql template1
\dt
\h is definately worth reading too.
==
David
an let you know what its status is.
- --
Best Regards
David Stanaway
Technology Manager
Australia's Premier Internet Broadcasters
Phone: +612 9357 1699
Fax: +612 9357 1169
Web: http://www.netventures.com.au
Support: [EMAIL PROTECTED]
===
e office on Windows workstations
querying the database.
==
David Stanaway
Personal: [EMAIL PROTECTED]
Work: [EMAIL PROTECTED]
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
var/ you may like to allocate more
space or clear some old files.
==
David Stanaway
Personal: [EMAIL PROTECTED]
Work: [EMAIL PROTECTED]
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
Here goes:
$ sudo su - postgres
$ pg_dump -x -Ft nvplayer > nvplayer-010920.tar
getDatabase(): SELECT failed. Explanation from backend: 'ERROR: More
than one tuple returned by a subselect used as an expression.
'.
Any suggestions?
--
Best Regards
D
SD, and of
course it is inspired by stuff that commercial unix systems have had for
a while.
======
David Stanaway
Personal: [EMAIL PROTECTED]
Work: [EMAIL PROTECTED]
---(end of broadcast)---
TIP 6: Have you searched our li
production
state
Now my Database is really not all that large:
59M /var/lib/postgres
==
David Stanaway
Personal: [EMAIL PROTECTED]
Work: [EMAIL PROTECTED]
---(end of broadcast)---
TIP 1: subscribe and unsubscribe
24 matches
Mail list logo
