Tom Lane wrote:
"Justin R. Smith" <[EMAIL PROTECTED]> writes:
I've solved the problem.
I was accessing Postgres over an ssh connection and had enabled X
forwarding in the sshd server (not the default configuration). For
reasons that pass understanding, psql attempts to establish
Tom Lane wrote:
Jan Wieck <[EMAIL PROTECTED]> writes:
On 9/27/2005 12:20 AM, George Essig wrote:
We have a database with about 30 tables and some RI. The RI constraints,
however, were not named upon creation of the database 2-3 years ago and
now when we get an error it contains for the constra
On 9/27/2005 3:27 PM, Tom Lane wrote:
Jan Wieck <[EMAIL PROTECTED]> writes:
On 9/27/2005 12:20 AM, George Essig wrote:
We have a database with about 30 tables and some RI. The RI constraints,
however, were not named upon creation of the database 2-3 years ago and
now when we get an error it co
Jan Wieck <[EMAIL PROTECTED]> writes:
> On 9/27/2005 12:20 AM, George Essig wrote:
>>> We have a database with about 30 tables and some RI. The RI constraints,
>>> however, were not named upon creation of the database 2-3 years ago and
>>> now when we get an error it contains for the constraint.
On 9/27/2005 12:20 AM, George Essig wrote:
On 9/26/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wro
We have a database with about 30 tables and some RI. The RI constraints,
however, were not named upon creation of the database 2-3 years ago and
now when we get an error it contains for the constr
Tom Lane wrote on 27.09.2005 03:19:
Thomas Kellerer <[EMAIL PROTECTED]> writes:
I'm trying to change the server messages back to english (initdb created
'German_Germany.1251' because I'm running a German Windows) by setting
the lc_messages property to 'C'. But the messages from e.g. pgsql or
Damon Hart <[EMAIL PROTECTED]> writes:
> I came across this thread after intermittently observing very similar
> error messages last week from a PostgreSQL (8.0.2) server, e.g.:
> SQL error: = 'type "local_roll" already exists' in line 1984
> ...
> Sorry I haven't been able to diagnose this any mor
Hi all -
I came across this thread after intermittently observing very similar
error messages last week from a PostgreSQL (8.0.2) server, e.g.:
SQL error: = 'type "local_roll" already exists' in line 1984
(only the portion in quotes is generated by the server, the context is
from the client app
Hi everybody,
if someone get's confused by the subject, let me explain:
Oracle 10g on Linux with ODBC installation for DB-Link to Postgresql. That
works very fine!
But, now the problem:
In PL/SQL procedure I open a view on the PGSQL (8.0.3) DB into a cursor
which i want to loop through until E
Uroš Gruber <[EMAIL PROTECTED]> writes:
> Hi!
>
> I have an old pgsql dir backuped and I want to know if there's any way
> to restore some data from this files. Any tool I can use.
Re-install the version that created the files and use pg_dump to dump
it out to SQL. That's by far the easiest way.
Hi!
I have an old pgsql dir backuped and I want to know if there's any way
to restore some data from this files. Any tool I can use.
regards
Uros
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
> If it just needs to work over HTTP, there are frontends that can tunnel
> over a HTTP connection. EMS Postgres Manager is one of them and the lite
> versions are free.
>
> http://www.sqlmanager.net
Hannes,
How to edit the table data with free version ( addd, delete, filter rows)?
pgAdmin al
On Tue, Sep 27, 2005 at 09:38:46AM -0400, Tom Lane wrote:
> "Justin R. Smith" <[EMAIL PROTECTED]> writes:
> > Interestingly, it does NOT help to have X forwarding turned off only in
> > the client: sshd itself must not do any forwarding.
>
> [ scratches head... ] That makes no sense at all. psq
Doing the following query:
explain analyze SELECT * FROM my.tablename WHERE node = '1234567890'
AND date BETWEEN '2005-03-27' AND NOW() ORDER BY id DESC
ORDER BY node,id is forcing the planner to use the right index.
Thanks,
Poul
---(end of broadcast)---
"John D. Burger" <[EMAIL PROTECTED]> writes:
> I mistyped a table name in the following query:
>select * from gazContainers
> where gazPlaceID in (select gazPlaceID from tipsterAuxiliary);
> Turns out there's no gazPlaceID column in tipsterAuxiliary, so the
> inner gazPlaceID was refe
On 9/27/05, Dawid Kuroczko <[EMAIL PROTECTED]> wrote:
> > QUERY PLAN
> > -> GroupAggregate (cost=0.00..85168.65 rows=11
> width=22)
> > (actual time=3149.916..45578.292 rows=515 loops=1)
>
> Hmm, planner expected 11 rows, got 515
>
>
> > (cost=0.00..85167.23 rows=107 width=22) (actual
>
Richard Huxton writes:
> adccs wrote:
>> [EMAIL PROTECTED] ~]# /usr/bin/pg_restore -a /tmp/royapuram.backup
>> ERROR: pg_restore: [archiver] unsupported version (1.10) in file header
> Your user probably has a more recent version of PostgreSQL than you do,
> so pg_restore can't understand the fo
"Justin R. Smith" <[EMAIL PROTECTED]> writes:
> I've solved the problem.
> I was accessing Postgres over an ssh connection and had enabled X
> forwarding in the sshd server (not the default configuration). For
> reasons that pass understanding, psql attempts to establish an X
> connection with
Poul Møller Hansen wrote:
Doing the following query:
explain analyze SELECT * FROM my.tablename WHERE node = '1234567890' AND
date BETWEEN '2005-03-27' AND NOW() ORDER BY id DESC
takes 1,3 sec. with this result:
Sort (cost=52971.52..53033.26 rows=24693 width=93) (actual
time=1141.002..1252.9
Doing the following query:
explain analyze SELECT * FROM my.tablename WHERE node = '1234567890' AND
date BETWEEN '2005-03-27' AND NOW() ORDER BY id DESC
takes 1,3 sec. with this result:
Sort (cost=52971.52..53033.26 rows=24693 width=93) (actual
time=1141.002..1252.995 rows=25109 loops=1)
S
Hi -
I mistyped a table name in the following query:
select * from gazContainers
where gazPlaceID in (select gazPlaceID from tipsterAuxiliary);
Turns out there's no gazPlaceID column in tipsterAuxiliary, so the
inner gazPlaceID was referring to the outer gazContainers table. This
On 9/26/05, boinger <[EMAIL PROTECTED]> wrote:
Hello.I'm not sure if this is a question suited for here, the -sql list, orthe -performance list, so if I'm mis-posting, please direct me to theright list.I was unable to come up with anything relevant from the archives
(though...I am not too sure wher
On 9/27/05 7:45 AM, "Yonatan Ben-Nes" <[EMAIL PROTECTED]> wrote:
> Tom Lane wrote:
>> "Cristian Prieto" <[EMAIL PROTECTED]> writes:
>>
>>> mydb=# explain analyze select locid from geoip_block where
>>> '216.230.158.50'::inet between start_block and end_block;
>>
>>
>>> As you see it still using
adccs wrote:
Help needed to restore a backup database!
1. Postgres service was started. When I run a restore command for the
backup stored in /tmp (backed from another server working on this
database and sent to meby email by another user). I created a database
by the same name "royapuram" by us
Tom Lane wrote:
"Cristian Prieto" <[EMAIL PROTECTED]> writes:
mydb=# explain analyze select locid from geoip_block where
'216.230.158.50'::inet between start_block and end_block;
As you see it still using a sequential scan in the table and ignores the
index, any other suggestion?
That tw
Jim C. Nasby wrote:
On Mon, Sep 26, 2005 at 08:41:03PM +0200, Yonatan Ben-Nes wrote:
Anyway I saw the idea:
BEGIN;
CREATE new_table;
SELECT INTO new_table * FROM temp_table;
DROP TABLE table;
ALTER TABLE new_table RENAME TO table;
COMMIT;
Where if I understood correctly "table" is the final
Hello.
I'm not sure if this is a question suited for here, the -sql list, or
the -performance list, so if I'm mis-posting, please direct me to the
right list.
I was unable to come up with anything relevant from the archives
(though...I am not too sure where to start so I may just have been
lookin
Hi All,
I have the following simplified setup. A client has 2 products: 'vbp'
and 'year_balance', but a client has also workers who have a product,
named 'ib'. A client can have multiple workers.
-- clients
CREATE TABLE clients (
id serial NOT NULL PRIMARY KEY,
name text NOT NULL,
vb
Peter Eisentraut wrote:
Am Dienstag, 27. September 2005 10:15 schrieb Gábor Farkas:
for historical reasons ;) (are there any other reasons),
we have a postgres db,
where the data are in iso-8859-15 encoding,
but the "database encoding" is iso-8859-1.
2. if it remains like it is currently, whe
is it some logging information that is being written
into some file at the end of some transactions
(each intsall is one transaction for
me)
the data directory is containing these folders..
base/
pg_clog/ pg_ident.conf pg_subtrans/
PG_VERSION postgresql.conf postmaster.pidglobal
Am Dienstag, 27. September 2005 10:15 schrieb Gábor Farkas:
> for historical reasons ;) (are there any other reasons),
> we have a postgres db,
> where the data are in iso-8859-15 encoding,
> but the "database encoding" is iso-8859-1.
>
> question(s):
> 1. is it possible to change the db-encoding?
Am Dienstag, 27. September 2005 00:44 schrieb Thomas Kellerer:
> I'm trying to change the server messages back to english (initdb created
> 'German_Germany.1251' because I'm running a German Windows) by setting
> the lc_messages property to 'C'. But the messages from e.g. pgsql or
> pg_ctl still sh
it is the commit call to postgres that suddently
takes more time than normal(as observed for other inserts)
it seems as if postgres does some activity (on its
own) after some installs.
thats why i have observed this pattern i.e.
commit taking less time for some installs (eg 1000) ..then s
Hi all,
I've recently asked a similar question, which received no useful answer
yet, so I'll drop in too.
In my case, the table I was inserting to was a quite big one already to
start with (and analyzed so), so I was expecting that it will not slow
down due to indexes, as they were quite big to s
hi,
for historical reasons ;) (are there any other reasons),
we have a postgres db,
where the data are in iso-8859-15 encoding,
but the "database encoding" is iso-8859-1.
question(s):
1. is it possible to change the db-encoding?
2. if it remains like it is currently, when can there be problems?
Help needed to restore a backup database!
1. Postgres service was started. When I run a restore command for the backup stored in /tmp (backed from another server working on this database and sent to meby email by another user). I created a database by the same name "royapuram" by using created
[EMAIL PROTECTED] ("surabhi.ahuja") wrote in
news:[EMAIL PROTECTED]:
> Hello,
>
> Is it not possible to write such an sql statement:
>
> select ser into val1, count(*) into val2 from tab1 where id = $1;
>
> do i need to perform the 2 selects separately ..wont that impact the
performance?
37 matches
Mail list logo
