On Nov 4, 2011, at 0:37, Efrain Lopez wrote:
> I have this tables
>
>
> Table: Contact
> IdContact
> First Name
> Second Name
> … other columns
>
> Table: Employee
> IdEmployee
> IdContact, related to Contact table
> … other columns
>
> Table: Salesman
> IdSaleman
> IdEmployee, if salesman is
I have this tables
Table: Contact
IdContact
First Name
Second Name
… other columns
Table: Employee
IdEmployee
IdContact, related to Contact table
… other columns
Table: Salesman
IdSaleman
IdEmployee, if salesman is employee, related to Employee table
IdContact, if salesman is not an employee, r
I dumped from:
OS: OS X 10.5.8
pg version: PostgreSQL 9.0.4 on x86_64-apple-darwin, compiled by GCC
i686-apple-darwin10-gcc-4.2.1 (GCC) 4.2.1 (Apple Inc. build 5664), 64-bit
Installation Method: EDB installer
to:
OS: Ubuntu 10.04.3 64bit
pg version: PostgreSQL 9.1.1 on x86_64-pc-linux-gnu, compile
On Thu, Nov 3, 2011 at 16:15, Benjamin Smith wrote:
> On Thursday, November 03, 2011 10:59:37 AM you wrote:
>> There's a pretty varied mix of speed, durability, and price with any
>> SSD based architecture, but the two that have proven best in our
>> testing and production use (for ourselves and o
On Thu, Nov 3, 2011 at 12:25 AM, Samba wrote:
> The postgres manual explains the "replication_timeout" to be used to
>
> "Terminate replication connections that are inactive longer than the
> specified number of milliseconds. This is useful for the primary server to
> detect a standby crash or net
On Thursday, November 03, 2011 10:59:37 AM you wrote:
> There's a pretty varied mix of speed, durability, and price with any
> SSD based architecture, but the two that have proven best in our
> testing and production use (for ourselves and our clients) seem to be
> Intel (mostly 320 series iirc), a
Howdy,
We have a process that's deadlocking frequently. It's basically multiple
threads inserting data into a single table.
That table has FK constraints to 3 other tables.
I understand how an FK check will cause a sharelock to be acquired on the
reference table and in some instances that
lea
On Thu, Nov 3, 2011 at 4:15 AM, Allan Kamau wrote:
>
>
> How about SSDs on Raid 1+0 (I have no experience on SSD and RAID
> though) and have replication to another server having the same setup
> and still do frequent backups. The Crucial m4 SSDs seem to be
> reasonably priced and perform well.
>
On Thu, Nov 03, 2011 at 06:02:04PM -0400, Tom Lane wrote:
> select * from pg_attribute where attrelid = 'sss.xobjects'::regclass
> and attisdropped;
no dropped columns.
looking for some other info. will post as soon as i'll gather it, but
that will be in utc morning :(
Best regards,
depesz
hubert depesz lubaczewski writes:
> i tried:
> create table qqq as select cmax as o_cmax, xmax as o_xmax, cmin as
> o_cmin, xmin as o_xmin, ctid as o_ctid, * from sss.xobjects;
> but the resulting table didn't have -1 values:
Oh, that's pretty interesting ... suggests that the targetlist has
> I would like to know the ctid's of the -1 rows in the copied table,
> along with the ctid's of the rows they share magic_ids with, and
> the ctid's of the rows with those same magic_ids in the original.
> I'm wondering whether the affected rows are physically clustered ...
i tried:
create table
Adrian Klaver writes:
> On Thursday, November 03, 2011 1:03:12 pm hubert depesz lubaczewski wrote:
>> as you can see counts of rows in created table are more or less
>> sensible, but whatever method I used - create table as, insert into,
>> using sychronized_scans (initially) or not (later) - copy
On Thursday, November 03, 2011 1:03:12 pm hubert depesz lubaczewski wrote:
> On Thu, Nov 03, 2011 at 10:55:20AM -0400, Tom Lane wrote:
>
> So, did some tests:
>
> as you can see counts of rows in created table are more or less
> sensible, but whatever method I used - create table as, insert int
BINGO!
Thanks everyone. That did the trick!
On Thu, 2011-11-03 at 12:56 -0700, Ioana Danes wrote:
>
> >
> > pg_dump newdb > /DUMPDIR/newdb.dmp -n dev -T corgi -w -v -F c 2>
> > /DUMPDIR/newdb.log
> >
>
> Try: -T dev.corgi instead of -T corgi
>
>
--
Sent via pgsql-general mailing list
On Thursday, November 03, 2011 12:54:35 pm Tony Capobianco wrote:
> I'm using 9.0.3. I've tried several permutations of this script and
> still I get a dump of the entire schema. The corgi table is still
> included when I need it excluded.
You may be getting bit by search path issues:
http://ww
On Thu, Nov 03, 2011 at 10:55:20AM -0400, Tom Lane wrote:
> hubert depesz lubaczewski writes:
> > index on xobject_id might be corrupted, but it doesn't explain that I
> > don't see duplicates with group_by/having query on xobjects, which uses
> > seqscan:
>
> I was just going to ask you to check
>
> pg_dump newdb > /DUMPDIR/newdb.dmp -n dev -T corgi -w -v -F c 2>
> /DUMPDIR/newdb.log
>
Try: -T dev.corgi instead of -T corgi
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
I'm using 9.0.3. I've tried several permutations of this script and
still I get a dump of the entire schema. The corgi table is still
included when I need it excluded.
On Thu, 2011-11-03 at 12:02 -0700, Adrian Klaver wrote:
> On Thursday, November 03, 2011 8:16:42 am Tony Capobianco wrote:
> > W
On Thursday, November 03, 2011 8:16:42 am Tony Capobianco wrote:
> When I issue:
>
> pg_dump newdb > /DUMPDIR/newdb.dmp -n dev -T corgi -w -v -F c 2>
> /DUMPDIR/newdb.log
>
> I get a dump of the entire dev schema. My goal is to dump the dev
> schema minus the corgi table. How can I adjust my sc
Tony --
> When I issue:
>
> pg_dump newdb > /DUMPDIR/newdb.dmp -n dev -T corgi -w -v -F c 2>
> /DUMPDIR/newdb.log
>
> I get a dump of the entire dev schema. My goal is to dump the dev
> schema minus the corgi table. How can I adjust my script to perform
> this function?
>
> Thanks.
Maybe
On Thu, Nov 3, 2011 at 9:02 AM, Sabn Coanda wrote:
> Hi,
>
> I am using trust authentication since some years, but I need now to
> authenticate the user for a specific application when connect to postgresql
> database. I found "trust" ignores the password, so I changed it in
> pg_hba.conf to "pass
On Wed, Nov 2, 2011 at 11:02 PM, Benjamin Smith
wrote:
> On Wednesday, November 02, 2011 11:39:25 AM Thomas Strunz wrote:
>> I guess go Intel
>> route or some other crazy expensive enterprise stuff.
>
> It's advice about some of the "crazy expensive enterprise" stuff that I'm
> seeking...? I don't
Hi,
I am using trust authentication since some years, but I need now to
authenticate the user for a specific application when connect to
postgresql database. I found "trust" ignores the password, so I changed
it in pg_hba.conf to "password".
My application is working now, but I have problems
Hello.
I just uploaded a first version of our multicorn foreign data wrapper:
http://pgxn.org/dist/multicorn/0.0.3/
Homepage for the project is at http://multicorn.org.
It provides python bindings for foreign data wrapper through a minimalist
interface.
It is not safe (any python module could be
Siva Palanisamy wrote:
Hi All. I basically have 3 tables. One being the core table and the
other 2 depend on the 1st. I have the requirement to add upto 7
records in all the tables. I do have constraints (primary & foreign
keys, index, unique etc) set for the tables. I can't go for bulk
2011/11/3 Devrim GÜNDÜZ :
> On Wed, 2011-11-02 at 13:16 -0400, Robert Treat wrote:
>> >
>>
>> Hey Devrim, any chance you have published your rpm spec files you used
>> on the earlier 8.3 -id builds? I looked around and couldn't find one.
>
> They were in the previous repo -- anyway, I just update t
On Thursday, November 03, 2011 8:30:34 am hubert depesz lubaczewski wrote:
> On Thu, Nov 03, 2011 at 08:23:01AM -0700, Adrian Klaver wrote:
> > On Thursday, November 03, 2011 8:05:38 am hubert depesz lubaczewski wrote:
> > > On Thu, Nov 03, 2011 at 08:04:19AM -0700, Adrian Klaver wrote:
> > > > So
On ons, 2011-11-02 at 22:40 -0300, Martín Marqués wrote:
> 2011/11/2 John R Pierce :
> > On 11/02/11 11:21 AM, Martín Marqués wrote:
> >>
> >> Don't worry, they are both x86 arch, so I'll just install 32bit
> >> postgresql on the 64 bit server. That should make it work, right?
> >
> > yes, that sho
hi there,
I habe to upgrade a db from 8.4 to 91 that is using tsvector (that was converted
from an older version before).
now I am looking for pointer on how to proceed.
for insance in the dump from the old db I find declarations like added at the
end (and lots more):
I think these are thes
hubert depesz lubaczewski writes:
> other tests are running, but simple question - how to get number of rows
> affected from psql?
> create table xxx as select * from xobjects;
> returns just:
> SELECT
We fixed that in 9.0, but 8.4 won't provide the count (unless you care to
patch it). That's w
On Thu, Nov 03, 2011 at 08:23:01AM -0700, Adrian Klaver wrote:
> On Thursday, November 03, 2011 8:05:38 am hubert depesz lubaczewski wrote:
> > On Thu, Nov 03, 2011 at 08:04:19AM -0700, Adrian Klaver wrote:
> > > So just to be clear there is and never has been a -1 value for xobject_id
> > > in the
On Thu, Nov 03, 2011 at 04:21:37PM +0100, Alban Hertroys wrote:
> On 3 November 2011 09:25, hubert depesz lubaczewski wrote:
> > All looks good. pg_dump of the table also doesn't show any strange
> > problems, and is duplicate free. But:
> >
> > $ create table zzz as select * from sss.xobject
When I issue:
pg_dump newdb > /DUMPDIR/newdb.dmp -n dev -T corgi -w -v -F c 2>
/DUMPDIR/newdb.log
I get a dump of the entire dev schema. My goal is to dump the dev
schema minus the corgi table. How can I adjust my script to perform
this function?
Thanks.
--
Sent via pgsql-general mailing l
On Thursday, November 03, 2011 8:05:38 am hubert depesz lubaczewski wrote:
> On Thu, Nov 03, 2011 at 08:04:19AM -0700, Adrian Klaver wrote:
> > So just to be clear there is and never has been a -1 value for xobject_id
> > in the source table?
>
> yes. min value of xobject_id is 1000, and we had tr
On 3 November 2011 09:25, hubert depesz lubaczewski wrote:
> All looks good. pg_dump of the table also doesn't show any strange problems,
> and is duplicate free. But:
>
> $ create table zzz as select * from sss.xobjects;
> SELECT
>
> $ select xobject_id, count(*) from zzz group by 1 having c
On Thu, Nov 03, 2011 at 08:04:19AM -0700, Adrian Klaver wrote:
> So just to be clear there is and never has been a -1 value for xobject_id in
> the
> source table?
yes. min value of xobject_id is 1000, and we had trigger in place on the
table which logged all inserts/updates/deletes and the val
On Thursday, November 03, 2011 7:15:22 am hubert depesz lubaczewski wrote:
> On Thu, Nov 03, 2011 at 07:00:30AM -0700, Adrian Klaver wrote:
> > > I also verified that there are no concurrent updates that would set
> > > xobject_id to -1, so it's not a problem of isolation.
> > >
> > > During the n
On Thu, Nov 03, 2011 at 10:55:20AM -0400, Tom Lane wrote:
> > index on xobject_id might be corrupted, but it doesn't explain that I
> > don't see duplicates with group_by/having query on xobjects, which uses
> > seqscan:
> I was just going to ask you to check that. Weird as can be.
> Does plain ol
hubert depesz lubaczewski writes:
> index on xobject_id might be corrupted, but it doesn't explain that I
> don't see duplicates with group_by/having query on xobjects, which uses
> seqscan:
I was just going to ask you to check that. Weird as can be.
Does plain old "SELECT COUNT(*)" show a diff
- Original Message -
From: Scott Marlowe
To: Ioana Danes
Cc: PostgreSQL General
Sent: Thursday, November 3, 2011 10:30:27 AM
Subject: Re: [GENERAL] Memory Issue
On Thu, Nov 3, 2011 at 7:34 AM, Ioana Danes wrote:
> After another half an hour almost the entire swap is used and the sys
On Thu, Nov 3, 2011 at 7:34 AM, Ioana Danes wrote:
> Hello Everyone,
>
> I have a performance test running with 1200 clients performing this
> transaction every second:
>
>
> begin transaction
> select nextval('sequence1');
> select nextval('sequence2');
> insert into table1;
> insert into table2
On Thu, Nov 03, 2011 at 03:19:36PM +0100, Alban Hertroys wrote:
> On 3 November 2011 15:15, hubert depesz lubaczewski wrote:
> >> Do the xobject_id values have other negative numbers or is -1 just a
> >> special
> >> case? The only thing I can think of is a corrupted index on xobject_id.
> >
> >
On 3 November 2011 15:15, hubert depesz lubaczewski wrote:
>> Do the xobject_id values have other negative numbers or is -1 just a special
>> case? The only thing I can think of is a corrupted index on xobject_id.
>
> minimal xobject_id in source table is 1000.
>
> index on xobject_id might be cor
On Thu, Nov 03, 2011 at 07:00:30AM -0700, Adrian Klaver wrote:
> > I also verified that there are no concurrent updates that would set
> > xobject_id to -1, so it's not a problem of isolation.
> >
> > During the night I repeated the procedure and the rows that got duplicated
> > seem to be the sam
On Thursday, November 03, 2011 1:25:58 am hubert depesz lubaczewski wrote:
> Hi
> We have pretty weird situation, which seems to be impossible, but perhaps
> you'll notice something that will let me fix the problem.
>
> System: SunOS 5.11 snv_130
> Pg: PostgreSQL 8.4.7 on i386-pc-solaris2.11,
Hello Everyone,
I have a performance test running with 1200 clients performing this transaction
every second:
begin transaction
select nextval('sequence1');
select nextval('sequence2');
insert into table1;
insert into table2;
commit;
Table1 and table2 have no foreign keys and no triggers. Ther
El día 3 de noviembre de 2011 09:18, Rodrigo Gonzalez
escribió:
> El 02/11/11 22:40, Martín Marqués escribió:
>>
>> 2011/11/2 John R Pierce:
>>>
>>> On 11/02/11 11:21 AM, Martín Marqués wrote:
Don't worry, they are both x86 arch, so I'll just install 32bit
postgresql on the 64 bit s
El 02/11/11 22:40, Martín Marqués escribió:
2011/11/2 John R Pierce:
On 11/02/11 11:21 AM, Martín Marqués wrote:
Don't worry, they are both x86 arch, so I'll just install 32bit
postgresql on the 64 bit server. That should make it work, right?
yes, that should work fine.
Sad thing is that it's
This message has been digitally signed by the sender.
Re___GENERAL__dblink_not_returning_result.eml
Description: Binary data
-
Hi-Tech Gears Ltd, Gurgaon, India
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscr
On Thu, Nov 3, 2011 at 6:02 AM, Benjamin Smith wrote:
> On Wednesday, November 02, 2011 11:39:25 AM Thomas Strunz wrote:
>> I have no idea what you do but just the fact that you bought ssds to
>> improve performance means it's rather high load and hence important.
>
> Important enough that we back
Hi,
From reading your email and from the URL below, it seems that the error
is because it's returning the status of the first call (where you are
beginning the transaction and making the first query).
http://www.postgresql.org/docs/9.1/static/contrib-dblink-get-result.
Have you tried doing a
This message has been digitally signed by the sender.
Re___GENERAL__Why_is_there_no_8_3_16_rpm_with__id__.eml
Description: Binary data
-
Hi-Tech Gears Ltd, Gurgaon, India
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to y
On 2011-11-03 04:02, Benjamin Smith wrote:
Which is what we're trying next, X25E. 710's apparently have 1/5th the rated
write endurance, without much speed increase, so don't seem like such an
exciting product.
I've tested the 710 with diskchecker.pl and it doesn't lie about it's
cache status
On Wed, 2011-11-02 at 13:16 -0400, Robert Treat wrote:
> >
>
> Hey Devrim, any chance you have published your rpm spec files you used
> on the earlier 8.3 -id builds? I looked around and couldn't find one.
They were in the previous repo -- anyway, I just update the spec file to
8.3.16:
http://sv
Hi
We have pretty weird situation, which seems to be impossible, but perhaps
you'll notice something that will let me fix the problem.
System: SunOS 5.11 snv_130
Pg: PostgreSQL 8.4.7 on i386-pc-solaris2.11, compiled by cc: Sun C 5.10
SunOS_i386 2009/06/03, 64-bit
In there I have a table:
Sorry forgot to mention the thread I referred to -
http://archives.postgresql.org/pgsql-general/2010-12/msg01000.php
Thanks
VB
On Thu, Nov 3, 2011 at 3:48 PM, Venkat Balaji wrote:
> Hello Everyone,
>
> We had recently taken an online backup of our production database cluster
> (pg_start_backup(
Hi All. I basically have 3 tables. One being the core table and the other 2
depend on the 1st. I have the requirement to add upto 7 records in all the
tables. I do have constraints (primary & foreign keys, index, unique etc) set
for the tables. I can't go for bulk import (using COPY command)
On Thu, Nov 3, 2011 at 4:34 AM, Robert James wrote:
> When trying to INSERT on Postgres (9.1) to a bytea column, via E''
> escaped strings, I get the strings rejected because they're not UTF8.
> I'm confused, since bytea isn't for strings but for binary. What
> causes this? How do I fix this? (I
Hello Everyone,
We had recently taken an online backup of our production database cluster
(pg_start_backup() - rsync - pg_stop_backup()).
We had built the testing cluster with the backup.
When we try to vacuum the database or vacuum full the testing database, we
are getting the following error.
I am using Postgresql 9.1. I found that dblink is not returning result for
BEGIN transaction.
select new_conn('conn1');
select new_conn('conn2');
select dblink_send_query('conn1','begin; update t2 set i=10 where
nam=''a1'';');
select
60 matches
Mail list logo
