On 3/27/07, Tom Lane [EMAIL PROTECTED] wrote:
Matthijs Melissen [EMAIL PROTECTED] writes:
I am executing the following queries (id has a unique key):
1) begin;
1) delete from forum where id = 20;
1) insert into forum (id, name) values (20, 'test');
2) delete from forum where id = 20;
1)
Thanks!
*pg_indexes.indexdef* is exactly what I was looking for!
On 3/27/07, Erik Jones [EMAIL PROTECTED] wrote:
On Mar 26, 2007, at 5:24 PM, Dmitry Koterov wrote:
Hello.
I need to perform a mass operation (UPDATE) on each table row. E.g. -
modify one table column:
UPDATE tbl SET tbl_text
Pavan Deolasee wrote:
On 3/27/07, Tom Lane [EMAIL PROTECTED] wrote:
Matthijs Melissen [EMAIL PROTECTED] writes:
I am executing the following queries (id has a unique key):
1) begin;
1) delete from forum where id = 20;
1) insert into forum (id, name) values (20, 'test');
2) delete from
Alban Hertroys wrote:
Pavan Deolasee wrote:
On 3/27/07, Tom Lane [EMAIL PROTECTED] wrote:
Matthijs Melissen [EMAIL PROTECTED] writes:
I am executing the following queries (id has a unique key):
1) begin;
1) delete from forum where id = 20;
1) insert into forum (id, name) values (20, 'test');
I have a query that performs a multiple join between four tables and
that doesn't use the defined indexes.
If I set enable_seqscan to off, the query obviously uses the indexes and
it is considerable faster than normal planned execution with
enable_seqscan=true.
Can you give me a reason why
On Tue, Mar 27, 2007 at 12:41:53PM +0200, Matthijs Melissen wrote:
I get DELETE 0 even if a record with id=20 already exists before both
transactions.
Transaction 2 (T2) is deleting the version of the row with id = 20
that was visible to T2 when it executed its DELETE. Since T1 deleted
that
On 22 Mar 2007 14:58:15 -0700, Kev [EMAIL PROTECTED] wrote:
Hi everyone,
I'm still in the design phase of a project. I was just wondering if
anyone has any thoughts or experience on the idea of cutting the P out
of the LAMP (or in my case, WAMP for now) stack. What I mean is
having
everything
On 3/26/07, Tom Lane [EMAIL PROTECTED] wrote:
Sorin N. Ciolofan [EMAIL PROTECTED] writes:
I have to manage an application written in java which call another module
written in java which uses Postgre DBMS in a Linux environment. I'm new to
Postgres. The problem is that for large amounts of
On 27/03/07, Merlin Moncure [EMAIL PROTECTED] wrote:
On 22 Mar 2007 14:58:15 -0700, Kev [EMAIL PROTECTED] wrote:
Hi everyone,
I'm still in the design phase of a project. I was just wondering if
anyone has any thoughts or experience on the idea of cutting the P out
of the LAMP (or in my
Tom Lane wrote:
Jesse Cleary [EMAIL PROTECTED] writes:
This script has been running successfully for several months (70-90 min each
night). Out of the blue I'm now getting the following error message after each
psql command, except the last vacuum full analyze command:
ERROR:
Hi,
This could well be a recurrence of this issue:
http://archives.postgresql.org/pgsql-general/2007-01/msg01801.php
for which there doesn't seem to have been a resolution.
I am running:
PostgreSQL 8.1.5 on x86_64-pc-linux-gnu, compiled by GCC
x86_64-pc-linux-gnu-gcc (GCC) 4.1.1 (Gentoo
Kev, we have a GPL'd product targeting Postgres that has significant
overlap with what you want, though in other areas we went in another
direction. The site is www.andromeda-project.org, and I've put some
comments below:
Kev wrote:
Hi everyone,
I'm still in the design phase of a project.
On 3/27/07, Peter Childs [EMAIL PROTECTED] wrote:
Strangely the in-house application is often still the better way to
go. The web can make everything 3 times more complicated than it needs
to be. Toolkits like GWT help this but you still need to write
middleware even when you can trust the trust
Sorin N. Ciolofan [EMAIL PROTECTED] writes:
It seems that the legacy application creates tables dynamically and the
number of the created tables depends on the size of the input of the
application. For the specific input which generated that error I've
estimated a number of created tables of
I agree with everything you said except the point about the GWT.
Using a framework like this you can have your query in the javascript,
and pass it through directly the database and pass the data back using
extremely simple (think 10 line) php or perl rpc that renders query
result back in
Kenneth == Kenneth Downs [EMAIL PROTECTED] writes:
Kenneth This in effect makes the web server a proxy to the database, which
Kenneth sounds like what you are after. The P portion for us is PHP, not
Kenneth Perl, and it is small though non-zero. It has only two jobs really.
Kenneth In the one
Just bringing back to life a message I sent last July.
The problem I was having was that when importing very large data sets,
COPY seemed to drop some data. I built a script to use INSERTs, and same
problem. My server runs 8.1.3 on Linux. Several people investigated,
Reece Hart was unable to
22 Mar 2007 17:01:20 -0700, Jaro [EMAIL PROTECTED]:
Hello
How create something like this:
UserName: user1 (he's root db_user1)
DatabaseName db_user1
UserName: user2 (he's root db_user2)
DatabaseName db_user2
I'd like create several users and several databases, ever user should
be root only
Correction: my sever is running 8.1.3
Jaime Silvela wrote:
Just bringing back to life a message I sent last July.
The problem I was having was that when importing very large data sets,
COPY seemed to drop some data. I built a script to use INSERTs, and
same problem. My server runs 8.1.3 on
Hello -
Over the past couple of years I have made use of postgresql as my database
of choice when developing new software. During that time, my clients have
in multiple cases eventually come back to me and requested a re-targeting
to Any database that we (my client) can find skilled ops staff
On 3/27/07, Randal L. Schwartz merlyn@stonehenge.com wrote:
Kenneth == Kenneth Downs [EMAIL PROTECTED] writes:
Kenneth This in effect makes the web server a proxy to the database, which
Kenneth sounds like what you are after. The P portion for us is PHP, not
Kenneth Perl, and it is small
On 3/27/07, Csaba Nagy [EMAIL PROTECTED] wrote:
I agree with everything you said except the point about the GWT.
Using a framework like this you can have your query in the javascript,
and pass it through directly the database and pass the data back using
extremely simple (think 10 line) php
On 3/27/07, Marc Evans [EMAIL PROTECTED] wrote:
Hello -
Over the past couple of years I have made use of postgresql as my database
of choice when developing new software. During that time, my clients have
in multiple cases eventually come back to me and requested a re-targeting
to Any database
Randal L. Schwartz wrote:
Kenneth == Kenneth Downs [EMAIL PROTECTED] writes:
Kenneth This in effect makes the web server a proxy to the database, which
Kenneth sounds like what you are after. The P portion for us is PHP, not
Kenneth Perl, and it is small though non-zero. It has
David Brain [EMAIL PROTECTED] writes:
This could well be a recurrence of this issue:
http://archives.postgresql.org/pgsql-general/2007-01/msg01801.php
for which there doesn't seem to have been a resolution.
I never got a reproduceable case out of the other reporter ... can you
provide one?
Merlin Moncure wrote:
On 3/27/07, Randal L. Schwartz merlyn@stonehenge.com wrote:
Kenneth == Kenneth Downs [EMAIL PROTECTED] writes:
Kenneth This in effect makes the web server a proxy to the database,
which
Kenneth sounds like what you are after. The P portion for us is
PHP, not
Kenneth
On 22 Mar 2007 14:58:15 -0700, Kev [EMAIL PROTECTED] wrote:
Hi everyone,
I'm still in the design phase of a project. I was just wondering if
anyone has any thoughts or experience on the idea of cutting the P out
of the LAMP (or in my case, WAMP for now) stack. What I mean is
having
On Mar 27, 2007, at 9:37 AM, Merlin Moncure wrote:
On 3/27/07, Marc Evans [EMAIL PROTECTED] wrote:
Hello -
Over the past couple of years I have made use of postgresql as my
database
of choice when developing new software. During that time, my
clients have
in multiple cases eventually
Hi Kenneth,
This is wonderful news. I will definitely be checking into it as soon as I
have a moment. Thanks!
Kev
Kev, we have a GPL'd product targeting Postgres that has significant
overlap with what you want, though in other areas we went in another
direction. The site is
Not sure I can provide one either I'm afraid, I don't think I did
anything unusual. But I can provide you with some background as to how
this DB was created so if you can see any steps that may have been
problematic.
This db was created as part of an upgrade to new hardware, using Slony
to
Marc,
I forwarded your message to pgsql-advocacy list.
The same situation in Russia ! I think, that the major problem here is
lack of official training courses on PostgreSQL and certificates.
Official mean something that was accepted by the PostgreSQL community.
This is a real pity, since we
David Brain [EMAIL PROTECTED] writes:
The db is now semi production, but I'll happily provide whatever info I
can short of needing a restart (and even a restart could be scheduled if
necessary).
Let me know if I can provide any more info.
Can you send me the output of pg_dump -s (ie, no
'Lo all,
I've created a calendar table based on an article I found on the web,
but I can't figure out what's wrong with the query I've written to
populate it. Here's the table -
CREATE TABLE aux_dates
(
the_date date NOT NULL,
the_year smallint NOT NULL,
the_month smallint NOT NULL,
Added to TODO:
* Allow configuration of backend priorities via the operating system
Though backend priorities make priority inversion during lock
waits possible, research shows that this is not a huge problem.
http://archives.postgresql.org/pgsql-general/2007-02/msg00493.php
On 3/27/07, Oleg Bartunov oleg@sai.msu.su wrote:
Marc,
I forwarded your message to pgsql-advocacy list.
The same situation in Russia ! I think, that the major problem here is
lack of official training courses on PostgreSQL and certificates.
Official mean something that was accepted by the
Oleg Bartunov wrote:
Probably, it's time to sponsor our book-writers and other enthusiasts
to write PostgreSQL Administration handbook, which we (community)
will accept, support and translate to different languages.
http://www.postgresql.org/docs/current/static/admin.html
--
Peter Eisentraut
Peter Eisentraut wrote:
Oleg Bartunov wrote:
Probably, it's time to sponsor our book-writers and other enthusiasts
to write PostgreSQL Administration handbook, which we (community)
will accept, support and translate to different languages.
Raymond O'Donnell wrote:
to_char(extract (month from d.dates), 'FMmonth') as month_name,
to_char(extract (day from d.dates), 'FMday') as day_name
These formatting patterns are invalid. Check the documentation for the
real ones.
--
Peter Eisentraut
Joshua D. Drake wrote:
Peter Eisentraut wrote:
Oleg Bartunov wrote:
Probably, it's time to sponsor our book-writers and other enthusiasts
to write PostgreSQL Administration handbook, which we (community)
will accept, support and translate to different languages.
Raymond O'Donnell escreveu:
'Lo all,
I've created a calendar table based on an article I found on the web,
but I can't figure out what's wrong with the query I've written to
populate it. Here's the table -
CREATE TABLE aux_dates
(
the_date date NOT NULL,
the_year smallint NOT NULL,
On Tue, 27 Mar 2007, Peter Eisentraut wrote:
Oleg Bartunov wrote:
Probably, it's time to sponsor our book-writers and other enthusiasts
to write PostgreSQL Administration handbook, which we (community)
will accept, support and translate to different languages.
Jesse Cleary [EMAIL PROTECTED] writes:
One exception is notable - $PGDATA/base/835021/4294967264 - this file
has a size of 0 and a timestamp that coincides with the date and time
range of the nightly run when these errors first appeared. This seems
like a good clue, but not sure what I
Matthijs Melissen wrote:
I want two users to execute the following queries:
1) delete from forum where id = 'A';
1) insert into forum (id, name) values ('A', 'testa');
2) delete from forum where id = 'A';
2) insert into forum (id, name) values ('A', 'testb');
id is a unique key. The numbers
a (possibly slightly more user-friendly) alternative to the catalog
table is pg_dump, e.g.:
pg_dump -d your_db_name -t your_table -s | grep 'CREATE INDEX'
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Dmitry Koterov
Sent: Tuesday, March 27,
On Tue, 27 Mar 2007, Bruce Momjian wrote:
Joshua D. Drake wrote:
Peter Eisentraut wrote:
Oleg Bartunov wrote:
Probably, it's time to sponsor our book-writers and other enthusiasts
to write PostgreSQL Administration handbook, which we (community)
will accept, support and translate to
Kev wrote:
Hi everyone,
I'm still in the design phase of a project. I was just wondering if
anyone has any thoughts or experience on the idea of cutting the P out
of the LAMP (or in my case, WAMP for now) stack. What I mean is
having
everything encapsulated into sql (or plpgsql or
Hello.
I have found that sometimes heavy loaded PostgreSQL begins to run all the
queries slower than usual, sometimes - 5 and more times slower. I cannot
reprocude that, but symptoms are the following: queries work very fast for
5-10 minutes, and after that - significant slowdown (every query,
Jesse Cleary [EMAIL PROTECTED] writes:
This script has been running successfully for several months (70-90 min each
night). Out of the blue I'm now getting the following error message after
each psql command, except the last vacuum full analyze command:
ERROR: could not create relation
On Tue, 2007-03-27 at 08:54, Marc Evans wrote:
Hello -
Over the past couple of years I have made use of postgresql as my database
of choice when developing new software. During that time, my clients have
in multiple cases eventually come back to me and requested a re-targeting
to Any
On Mar 27, 2007, at 7:34 AM, Aidan Van Dyk wrote:
Kev wrote:
Hi everyone,
I'm still in the design phase of a project. I was just wondering if
anyone has any thoughts or experience on the idea of cutting the P
out
of the LAMP (or in my case, WAMP for now) stack. What I mean is
having
hmm,
looks like checkpoint ?
Check checkpoint settings in postgresql.conf.
Oleg
On Tue, 27 Mar 2007, Dmitry Koterov wrote:
Hello.
I have found that sometimes heavy loaded PostgreSQL begins to run all the
queries slower than usual, sometimes - 5 and more times slower. I cannot
reprocude
Oleg Bartunov wrote:
On Tue, 27 Mar 2007, Bruce Momjian wrote:
Joshua D. Drake wrote:
Peter Eisentraut wrote:
Oleg Bartunov wrote:
Probably, it's time to sponsor our book-writers and other enthusiasts
to write PostgreSQL Administration handbook, which we (community)
will accept,
David Brain [EMAIL PROTECTED] writes:
Tom Lane wrote:
Hm, I don't see fk_cdrsummary_cdrimportsession in there anywhere?
That is _very_ odd - I can see it in pgadmin, and also in pg_constraint,
but it's not showing up in pg_dump or on a '\d' in psql.
Oh really? (looks at code...) Hah, I
On 27/03/2007 17:00, Tom Lane wrote:
I think you want just to_char(d.dates, 'FMmonth') and so on.
What you're invoking above is to_char(numeric) which has entirely
different format codes...
Duh! Of course.I didn't spot that.
Thanks to all who replied.
Ray.
On 3/27/07, Erik Jones [EMAIL PROTECTED] wrote:
Not having looked myself, this is as much a question as a suggestion, but
are there not postgres dba training seminars/courses you could recommend
they send their dba's to?
There are some classes out there but in my opinion your best bet (from
On 3/27/07, Steve Atkins [EMAIL PROTECTED] wrote:
Or SQL-on-rails
http://www.sqlonrails.org/
LOL!
merlin
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
Tom Lane wrote:
Jesse Cleary [EMAIL PROTECTED] writes:
This script has been running successfully for several months (70-90 min each
night). Out of the blue I'm now getting the following error message after each
psql command, except the last vacuum full analyze command:
ERROR: could not
Fedora/Redhat has debuginfo packages that drop files with debug symbols
in /usr/src/debug/, and gdb can use them. Does anyone know how this
works and how I can get those files from the pg tarball?
---(end of broadcast)---
TIP 3: Have you checked
The sad reality from what I have observed is that unless more people gain
those skills and want to work in ops, it's becoming very hard for me to
justify recommending postgresql for enterprise (or larger) scale projects.
What do others do and/or experience?
I think there are
On Fri, 2007-02-23 at 12:07 -0800, Ron Mayer wrote:
Jim Nasby wrote:
The problem with using simple OS priority settings is you leave yourself
wide open to priority inversion.
Which is why you either
(a) note that papers studying priority inversion on RDBMS's
find that it's a non
On Tue, 2007-03-27 at 15:09, Tony Caduto wrote:
The sad reality from what I have observed is that unless more people gain
those skills and want to work in ops, it's becoming very hard for me to
justify recommending postgresql for enterprise (or larger) scale projects.
What do others
On Tue, Mar 27, 2007 at 03:57:49PM -0400, Joseph S wrote:
Does anyone know how this works and how I can get those files
from the pg tarball?
My guess: strip -o
Peter
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore
Merlin Moncure [EMAIL PROTECTED] writes:
On 3/27/07, Erik Jones [EMAIL PROTECTED] wrote:
Not having looked myself, this is as much a question as a suggestion, but
are there not postgres dba training seminars/courses you could recommend
they send their dba's to?
There are some classes out
Joseph S wrote:
Fedora/Redhat has debuginfo packages that drop files with debug symbols
in /usr/src/debug/, and gdb can use them. Does anyone know how this
works and how I can get those files from the pg tarball?
Where have you found these packages? Is this an rpm you have located?
--
On Tue, 2007-03-27 at 15:58, Jorge Godoy wrote:
I have the same opinion. Just look around and see how many certified
something are there and how many of them *really* know the product, its
details, how to work with it.
Certifications don't even certify the minimum knowledge. They are like
Hello, I currently store html color codes in that database with the
following DOMAIN:
CREATE DOMAIN html_color AS char(7) CHECK (VALUE ~ '^#[A-Fa-f0-9]{6}$');
Has anyone created a custom type that has additional functionality (eg
format the input or output to other formats, retrieve red, green
[EMAIL PROTECTED] (Tony Caduto) writes:
Another thing is this, how hard could it possibly be for a MS SQL DBA
or Oracle DBA to pick up using PostgreSQL?
I don't think it would take a decent admin of any database to come up
to speed in a very short time as long as they were interested in doing
Joseph S jks@selectacast.net writes:
Fedora/Redhat has debuginfo packages that drop files with debug symbols
in /usr/src/debug/, and gdb can use them. Does anyone know how this
works and how I can get those files from the pg tarball?
You download and install the postgresql-debuginfo RPM
Tom Lane wrote:
Joseph S jks@selectacast.net writes:
Fedora/Redhat has debuginfo packages that drop files with debug symbols
in /usr/src/debug/, and gdb can use them. Does anyone know how this
works and how I can get those files from the pg tarball?
You download and install the
On Mar 27, 2007, at 3:58 PM, Jorge Godoy wrote:
Merlin Moncure [EMAIL PROTECTED] writes:
On 3/27/07, Erik Jones [EMAIL PROTECTED] wrote:
Not having looked myself, this is as much a question as a
suggestion, but
are there not postgres dba training seminars/courses you could
recommend
Joseph S jks@selectacast.net writes:
Tom Lane wrote:
You download and install the postgresql-debuginfo RPM that exactly
matches your other postgresql RPM(s).
I don't use rpms, I build from the tarballs, hence my question.
You'd have to dig into the RPM code enough to figure out how it
Tom Lane wrote:
Joseph S jks@selectacast.net writes:
Fedora/Redhat has debuginfo packages that drop files with debug symbols
in /usr/src/debug/, and gdb can use them. Does anyone know how this
works and how I can get those files from the pg tarball?
You download and install the
Geoffrey [EMAIL PROTECTED] writes:
Tom Lane wrote:
You download and install the postgresql-debuginfo RPM that exactly
matches your other postgresql RPM(s).
I just downloaded 8.2.3 for RHWS 5 but did not see a debuginfo rpm.
Also looked for them same for 7.4.16 but didn't find a debuginfo
Hi,
On Tue, 2007-03-27 at 22:04 -0400, Tom Lane wrote:
Red Hat makes their debuginfo RPMs available in the normal course
of things (they're usually in a debug/ subdirectory of wherever you
find the RPMs)
Fedora and Red Hat 5 users can download debuginfo packages via yum.
Fedora users need to
Geoffrey wrote:
Joseph S wrote:
Fedora/Redhat has debuginfo packages that drop files with debug
symbols in /usr/src/debug/, and gdb can use them. Does anyone know
how this works and how I can get those files from the pg tarball?
Where have you found these packages? Is this an rpm you have
On 27 Mar 2007 05:10p -0400, Justin Dearing wrote:
Hello, I currently store html color codes in that database with the
following DOMAIN:
CREATE DOMAIN html_color AS char(7) CHECK (VALUE ~ '^#[A-Fa-f0-9]{6}$');
Has anyone created a custom type that has additional functionality (eg
format
76 matches
Mail list logo