hello all
i've did pg_dump --data-only for quit a while and didn't have any
problem with restoring the resulting backup.
but since the schema changed slightly the restore fails:
ERROR: insert or update in table "angebotsmuster" violates
foreignkey-constraints
it seems to me like the order of th
On 8/28/2006 9:36 PM, Joshua D. Drake wrote:
Hello,
O.k. so how about a phased approach?
1. Contact maintainers to create their new projects on pgfoundry and
begin moving tickets
2. Migrate CVS
3. Migrate mailing lists
Apparently something cut the throat first. GBorg is down since Sunday
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Jan Wieck
> Sent: 31 August 2006 13:59
> To: Joshua D. Drake
> Cc: Dave Cramer; Greg Sabino Mullane; pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Cutting the Gborg throat
>
> On 8/28/2006 9
On 8/30/06, Randall Lucas <[EMAIL PROTECTED]> wrote:
I'm storing facts about an entity (e.g., "company") in a normalized
form with various repeating groups, link tables, etc. My workflow
requires that after (or as part of) collecting these facts, I be able
to "sign off" as having verified all of
> > > Hello,
> > >
> > > O.k. so how about a phased approach?
> > >
> > > 1. Contact maintainers to create their new projects on
> > pgfoundry and
> > > begin moving tickets
> > >
> > > 2. Migrate CVS
> > >
> > > 3. Migrate mailing lists
> >
> > Apparently something cut the throat first. GBorg is d
On Tue, 2006-08-29 at 11:56, David Fetter wrote:
> On Tue, Aug 29, 2006 at 11:02:12AM -0500, Ron Johnson wrote:
> > -BEGIN PGP SIGNED MESSAGE-
> > Hash: SHA1
> >
> > Hi,
> >
> > Does PostgreSQL support them?
>
> Not yet.
Note, however, that by using the dblink package you can get someth
Dave Page wrote:
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Jan Wieck
Sent: 31 August 2006 13:59
To: Joshua D. Drake
Cc: Dave Cramer; Greg Sabino Mullane; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Cutting the Gborg throat
On 8/28/2006
On 8/31/2006 9:10 AM, Dave Page wrote:
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Jan Wieck
Sent: 31 August 2006 13:59
To: Joshua D. Drake
Cc: Dave Cramer; Greg Sabino Mullane; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Cutting the Gbor
> -Original Message-
> From: Jan Wieck [mailto:[EMAIL PROTECTED]
> Sent: 31 August 2006 14:51
> To: Dave Page
> Cc: Joshua D. Drake; Dave Cramer; Greg Sabino Mullane;
> pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Cutting the Gborg throat
>
> > Neptune lost 2 disks at once...
> >> Apparently something cut the throat first. GBorg is down since
> Sunday.
> >
> > Neptune lost 2 disks at once... Buts whats more interesting is
> that
> > yours is the first complaint I've seen.
>
> Meaning what?
>
> A) Will be restored from backup
> B) Data is lost finally and must be recov
I seem to get this error "user postgres could not be created, user
account already exists" when trying to install postgres. Anyone knows
how to fix this?
Erik Jones wrote:
Erik Jones wrote:
Ok, consider the following table definition:
CREATE TABLE stats (
id SERIAL PRIMARY KEY,
hits bigint d
"Michael Nolan" <[EMAIL PROTECTED]> writes:
> Situation in a nutshell:
> Production and test databases are on two separate systems inside the
> firewall. The web server is at an ISP, outside the firewall.
> The firewall sends all data coming from the ISP, port 5432 to a specific IP
> address in
On Thu, Aug 31, 2006 at 03:27:13PM +0200, Magnus Hagander wrote:
> > > > Hello,
> > > >
> > > > O.k. so how about a phased approach?
> > > >
> > > > 1. Contact maintainers to create their new projects on
> > > pgfoundry and
> > > > begin moving tickets
> > > >
> > > > 2. Migrate CVS
> > > >
> > > >
> > You don't look carefully enough. There's been a couple of
> complaints
> > earlier. But no, not many.
>
> Perhaps it's because you responded with a message to the effect
> "we're on it" when I asked, and people took that to mean that
> prompt action was in the works :)
Probably. Heck, that's
Can you give a link to the PostgreSQL binding? I haven't been able to
find it there. All I see is C, Perl and PHP bindings for the generation
of UUIDs, and nothing about storage.
(For my application, as it happens, I don't need to generate UUIDs in
the database, but I recognize that would be use
Jan Wieck wrote:
On 8/28/2006 9:36 PM, Joshua D. Drake wrote:
Hello,
O.k. so how about a phased approach?
1. Contact maintainers to create their new projects on pgfoundry and
begin moving tickets
2. Migrate CVS
3. Migrate mailing lists
Apparently something cut the throat first. GBorg is
grate mailing lists
Apparently something cut the throat first. GBorg is down since Sunday.
Neptune lost 2 disks at once... Buts whats more interesting is that
yours is the first complaint I've seen.
Fetter also brought it up, but it was on IRC :)
Regards, Dave.
--
=== The PostgreSQ
> -Original Message-
> From: Joshua D. Drake [mailto:[EMAIL PROTECTED]
> Sent: 31 August 2006 15:47
> To: Dave Page
> Cc: Jan Wieck; Dave Cramer; Greg Sabino Mullane;
> pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Cutting the Gborg throat
>
> grate mailing lists
> >> Apparent
Postgres version: 8.1.3
I have a code similar to this pseudo-code:
try {
create temp table temp_report ...;
... do some processing using this table...
drop table temp_report;
commit;
} catch all errors {
rollback;
}
This code occasionally triggered the following error (couldn't reliabl
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
>> Apparently something cut the throat first. GBorg is down since Sunday.
>
> Neptune lost 2 disks at once... Buts whats more interesting is that
> yours is the first complaint I've seen.
The squeaky wheel gets the grease? I'm certainly unhappy abou
Hello everyone! i am checking a database due to some inconsintencies and
i was wandering if its possible to find out the creation date of a
record (using the oid, whatever...). Maybe i am saying something stupid
(since i am no DB expert) so if this is the case, please point it out
gently.
Tha
>From this array how could I get back the fact that this array consists
of a two dimensional array with X elements?
Select array_dims('{{1,4,10,11},{1,5,4,5}}'::text [])
I would like to get back the number 4 here?
Thanks for the help.
Balázs
---(end of broadcast)---
Gibson wrote:
I seem to get this error "user postgres could not be created, user
account already exists" when trying to install postgres. Anyone knows
how to fix this?
Sounds to me like the user postgres on the OS already exists.
Joshua D. Drake
Erik Jones wrote:
Erik Jones wrote:
Ok, c
How do i remove this user?I am running on Win XP here.
Joshua D. Drake wrote:
Gibson wrote:
I seem to get this error "user postgres could not be created, user
account already exists" when trying to install postgres. Anyone knows
how to fix this?
Sounds to me like the user postgres on the OS
Csaba Nagy wrote:
The code is possible to be executed in parallel by multiple threads, on
different connections, or in sequence on the same connection. I would
expect it in both cases to work correctly... in manual tests I was able
to create in parallel temporary tables named identically in diffe
Obviously the test section has separate configurations to the live section -
simply have 2 databases defined in the same server 'ourlivedatabase' and
'ourtestdatabase'. This still gives one small login/config setting that
changes between live and dev.
On 31/8/2006 12:20, "Kelly Burkhart" <[EMAIL
On Thu, 2006-08-31 at 17:25, Alban Hertroys wrote:
> Csaba Nagy wrote:
> > The code is possible to be executed in parallel by multiple threads, on
> > different connections, or in sequence on the same connection. I would
> > expect it in both cases to work correctly... in manual tests I was able
>
Csaba Nagy wrote:
In any case, the error message is strange in itself, as if I try to
create the temporary table when it exists, the error I get in manual
trial is:
ERROR: relation "test_temp_table" already exists
compared to the error from the OP which I cite here for referen
I prefer to have my live and test databases on separate systems, if only because each one takes up well over 100 GB of disk space. Our hardware firewall doesn't support port changes, but I was able to get the rinetd port redirector working to redirect 5431 to 5432 on the test system.. (And it wor
Go to Start/ Control Panel / Administrative tools / Computer Management /
and you see Local Users and groups
Delete the user from there
- Original Message -
From: "Gibson" <[EMAIL PROTECTED]>
Cc: "pgsql general"
Sent: Friday, September 01, 2006 2:31 AM
Subject: Re: [GENERAL] Fatal erro
I thought some people in this group may find this letter from one of
NetBSD's founders very interesting.
http://mail-index.netbsd.org/netbsd-users/2006/08/30/0016.html
It is current, to the point and has some direct correlations with our
project that we may want to be aware of.
Sincerely,
Jo
Csaba Nagy <[EMAIL PROTECTED]> writes:
> In any case, the error message is strange in itself, as if I try to
> create the temporary table when it exists, the error I get in manual
> trial is:
> ERROR: relation "test_temp_table" already exists
>
> compared to the error from the OP
I have been having performance problems with my DB so this morning I
added some config to log queries that take more than 250ms. The result
is surprising because some queries will take as long as 10 seconds, but
then you do a explain analyze on them they show that indexes are being
used and they r
# [EMAIL PROTECTED] / 2006-08-31 07:35:30 -0700:
> > Ralf Engelschall's OSSP uuid looks very good. Written in C with
> > interfaces into PostgreSQL, PHP and C++ (classes wrapping the C
> > structures and functions).
> >
> > http://www.ossp.org/pkg/lib/uuid/
>
> Can you give a link
Matthew Schumacher <[EMAIL PROTECTED]> writes:
> I have been having performance problems with my DB so this morning I
> added some config to log queries that take more than 250ms. The result
> is surprising because some queries will take as long as 10 seconds, but
> then you do a explain analyze o
On Thu, Aug 31, 2006 at 09:11:52AM -0700, Joshua D. Drake wrote:
> I thought some people in this group may find this letter from one of
> NetBSD's founders very interesting.
>
> http://mail-index.netbsd.org/netbsd-users/2006/08/30/0016.html
>
> It is current, to the point and has some direct corr
Hi!I am unable to install postgres 7.1.2 on my Ubuntu Linux Box. I am installing postgres 7.1.2 from source. I stopped at the process of invoking the "make" command. I have a 7.1.2 database with me and plan to replicate it to another box. Pg_dump reports and error while I was dumping.
My Linux Box
On 8/31/06, Jonathan Chocolate <[EMAIL PROTECTED]> wrote:
Hi!
I am unable to install postgres 7.1.2 on my Ubuntu Linux Box. I am
installing postgres 7.1.2 from source. I stopped at the process of invoking
the "make" command.
I have a 7.1.2 database with me and plan to replicate it to another bo
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Jonathan Chocolate wrote:
> Hi!
>
> I am unable to install postgres 7.1.2 on my Ubuntu Linux Box. I am
> installing postgres 7.1.2 from source. I stopped at the process of
> invoking the "make" command.
What error(s)?
> I have a 7.1.2 database with
Josh,
> It is current, to the point and has some direct correlations with our
> project that we may want to be aware of.
Well, we're not in any danger of the board of a foundation taking over
Postgres. ;-)
The only part of this that I see as relevant to us is setting of
development goals. An
The only part of this that I see as relevant to us is setting of
development goals. And we've already discussed this ad nauseum on the
Hackers list and AFAIK have an initial plan (the enhanced TODO), lacking
only the resources to implement it this month.
Almost the whole thing is relevant :
On Fri, Sep 01, 2006 at 01:57:03AM +0800, Jonathan Chocolate wrote:
> Hi!
>
> I am unable to install postgres 7.1.2 on my Ubuntu Linux Box. I am
> installing postgres 7.1.2 from source. I stopped at the process of invoking
> the "make" command.
Dear gods, that's an ancient version. You're not goi
Martijn van Oosterhout wrote:
-- Start of PGP signed section.
> On Thu, Aug 31, 2006 at 09:11:52AM -0700, Joshua D. Drake wrote:
> > I thought some people in this group may find this letter from one of
> > NetBSD's founders very interesting.
> >
> > http://mail-index.netbsd.org/netbsd-users/2006/0
Hello -
I am attempting to find a way to make use of arrays of text, as
demonstraited by the following:
CREATE TABLE messages (
id SERIAL,
format TEXT NOT NULL,
arguments TEXT[]
);
Into that table will be values that you would associate with some form of
printf. For example:
INSERT I
Josh,
> On the other hand, we do suffer from the locked project problem (the
> recent recursive query debacle is a perfect example).
Yep, and that was immediately recognized as a problem in need of a
solution. In fact, some of the arguments againts the issue/feature
tracker were that it would
In general, I think that people who harp on PostgreSQL's lack of a
benevolent dictator as an inhibitor to progress are people who are not
comfortable with democracy and are looking for excuses why company X needs
to "take over the project for its own good."
Well I definitely don't think we nee
Joshua D. Drake wrote:
> >
> > The only part of this that I see as relevant to us is setting of
> > development goals. And we've already discussed this ad nauseum on the
> > Hackers list and AFAIK have an initial plan (the enhanced TODO), lacking
> > only the resources to implement it this mon
Tom Lane wrote:
> Matthew Schumacher <[EMAIL PROTECTED]> writes:
>> I have been having performance problems with my DB so this morning I
>> added some config to log queries that take more than 250ms. The result
>> is surprising because some queries will take as long as 10 seconds, but
>> then you
On Thu, Aug 31, 2006 at 11:18:27AM -0700, Joshua D. Drake wrote:
> On the other hand, we do suffer from the locked project problem (the
> recent recursive query debacle is a perfect example).
Maybe, but we don't have the extreme form. Patches have been submitted
by people other than the ones sayi
On the other hand, we do suffer from the locked project problem (the
recent recursive query debacle is a perfect example).
Yep, but fortunately this problem doesn't happen to us often.
I think this might happen more then you think. I ran into it with Alvaro
just a couple of days ago. I brou
Martijn van Oosterhout writes:
> On Fri, Sep 01, 2006 at 01:57:03AM +0800, Jonathan Chocolate wrote:
>> I am unable to install postgres 7.1.2 on my Ubuntu Linux Box.
> Dear gods, that's an ancient version. You're not going to get a lot of
> help fixing something that old, nearly 6 major releases
[EMAIL PROTECTED] wrote:
> Hello -
>
> I am attempting to find a way to make use of arrays of text, as
> demonstraited by the following:
Interesting problem. Apparently plperl is not cool about parsing arrays
in the arguments to Perl arrays -- at least I couldn't make it work, and
I don't find
In response to "Joshua D. Drake" <[EMAIL PROTECTED]>:
> >>
> >> On the other hand, we do suffer from the locked project problem (the
> >> recent recursive query debacle is a perfect example).
> >
> > Yep, but fortunately this problem doesn't happen to us often.
>
> I think this might happen mor
[EMAIL PROTECTED] writes:
> * If I could figure a way to pass a variable number of arguments to a
> plperl function, or an array reference, I could use something like this
> function:
Doesn't plperl already contain a feature to convert a Postgres array
into a Perl array? It may be docum
On Thu, 2006-08-31 at 11:04 -0800, Matthew Schumacher wrote:
> Tom Lane wrote:
> > Matthew Schumacher <[EMAIL PROTECTED]> writes:
> >> I have been having performance problems with my DB so this morning I
> >> added some config to log queries that take more than 250ms. The result
> >> is surprising
Josh Berkus writes:
> In general, I think that people who harp on PostgreSQL's lack of a
> benevolent dictator as an inhibitor to progress are people who are not
> comfortable with democracy and are looking for excuses why company X needs
> to "take over the project for its own good."
I don't
Jeff Davis wrote:
> http://www.postgresql.org/docs/8.1/static/mvcc.html
>
> In the "Explicit Locking" section it details the locks acquired by
> UPDATE, etc.
>
>>From what you described, I would not expect many locking problems. Are
> there any other types of queries you run that may cause a lock
Jeff Davis <[EMAIL PROTECTED]> writes:
> From what you described, I would not expect many locking problems. Are
> there any other types of queries you run that may cause a lock?
Row locks (SELECT FOR UPDATE/SHARE) are a possible problem, particularly
if this is a pre-8.1 Postgres where exclusive r
Alvaro Herrera wrote:
[EMAIL PROTECTED] wrote:
Hello -
I am attempting to find a way to make use of arrays of text, as
demonstraited by the following:
Interesting problem. Apparently plperl is not cool about parsing arrays
in the arguments to Perl arrays -- at least I couldn't make it work,
[EMAIL PROTECTED] ("Jonathan Chocolate") writes:
> I am unable to install postgres 7.1.2 on my Ubuntu Linux Box. I am installing
> postgres 7.1.2 from source. I stopped at the
> process of invoking the "make" command.
> I have a 7.1.2 database with me and plan to replicate it to another box.
> Pg
Matthew Schumacher <[EMAIL PROTECTED]> writes:
> I have "autovacuum = on" in the config file with a pretty frequent
> autovacuum_naptime, but I'm unsure if that does a vacuum or vacuum full.
autovacuum *never* does a vacuum full, because that would lead to
unexpected blockages of foreground querie
Csaba Nagy <[EMAIL PROTECTED]> writes:
> create temp table temp_report ...;
> ... do some processing using this table...
> drop table temp_report;
> commit;
> This code occasionally triggered the following error (couldn't reliably
> reproduce):
> ERROR: type "temp_report" already exists
B
Tom Lane wrote:
> Josh Berkus writes:
> > In general, I think that people who harp on PostgreSQL's lack of a
> > benevolent dictator as an inhibitor to progress are people who are not
> > comfortable with democracy and are looking for excuses why company X needs
> > to "take over the project fo
On Thu, Aug 31, 2006 at 09:17:54AM -0400, Merlin Moncure wrote:
> On 8/30/06, Randall Lucas <[EMAIL PROTECTED]> wrote:
>
> >An inverted way of thinking about the problem is the notion of getting a
> >source document (say, a "company registration form") and parsing and
> >storing it in a normalized
Bruce Momjian wrote:
> Tom Lane wrote:
> > It's pointless to suppose that individual developers would really be
> > answerable to any project-wide management, since that's not who they're
> > paid by. So I tend to think that a project roadmap would be more of an
> > exercise in wishful thinking t
Hi,While using SPI_execute for a select statement, how do we store the result returned by select statement (say a C variable)?SPI_execute returns different values for success or failure only as per the postgres manual.
Thanks,Jas
On Fri, Sep 01, 2006 at 02:24:32AM -0400, Jasbinder Bali wrote:
> Hi,
>
> While using SPI_execute for a select statement, how do we store the result
> returned by select statement (say a C variable)?
> SPI_execute returns different values for success or failure only as per the
> postgres manual.
Hi,I've written a trigger after insert on a table (parser) and the trigger calls a function that dynamically loads a shared object written in C.This shared object intends to use the newly inserted row in the table on which trigger is written and insert values in another table, something like this,
68 matches
Mail list logo
