[snip] I believe this is fixed as of 8.2 --- can you duplicate it
there? (No, backpatching the fix is not practical.)
No, I was not able to duplicate it on 8.2, so I think it's fixed (given
that on 8.1 the errors are triggered almost 100% of the runs).
How sure are you about that
On Thu, Jan 25, 2007 at 04:29:58PM -0500, Tom Lane wrote:
Alvaro Herrera [EMAIL PROTECTED] writes:
Jeremy Haile wrote:
If anyone else is experiencing similar problems, please post your
situation.
All the Windows buildfarm machines are, apparently.
Can't anyone with a debugger
On Thu, Jan 25, 2007 at 04:29:58PM -0500, Tom Lane wrote:
Alvaro Herrera [EMAIL PROTECTED] writes:
Jeremy Haile wrote:
If anyone else is experiencing similar problems, please post your
situation.
All the Windows buildfarm machines are, apparently.
Can't anyone with a debugger
On Thu, Jan 25, 2007 at 04:29:58PM -0500, Tom Lane wrote:
Alvaro Herrera [EMAIL PROTECTED] writes:
Jeremy Haile wrote:
If anyone else is experiencing similar problems, please post your
situation.
All the Windows buildfarm machines are, apparently.
Can't anyone with a debugger
Apparantly there is a bug lurking somewhere in pgwin32_select(). Because
if I put a #undef select right before the select in pgstat.c, the
regression tests pass.
May be, problem is related to fixed bug in pgwin32_waitforsinglesocket() ?
WaitForMultipleObjectsEx might sleep indefinitely while
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Brian Wipf
Sent: donderdag 25 januari 2007 22:42
To: pgsql-general@postgresql.org
Subject: [GENERAL] Duplicate key violation
I got a duplicate key violation when the following query was performed:
INSERT
I believe you should design it in a slightly different way:
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
gustavo halperin
Sent: donderdag 25 januari 2007 21:34
To: pgsql-general@postgresql.org
Subject: [GENERAL] triggers vs b-tree
Hello I have a
Hello,
For a select array(...) as col1, col2, col3 from table I'd like the DBI
driver to output col1 as a perl array instead of a scalar
{res1,res2,etc.} representation of it.
Is that somehow possible? I looked at the docs without finding anything.
Thanks,
---(end of
On Fri, Jan 26, 2007 at 01:11:00PM +0300, Teodor Sigaev wrote:
Apparantly there is a bug lurking somewhere in pgwin32_select(). Because
if I put a #undef select right before the select in pgstat.c, the
regression tests pass.
May be, problem is related to fixed bug in
On Fri, Jan 26, 2007 at 12:26:58PM +0100, Magnus Hagander wrote:
On Fri, Jan 26, 2007 at 01:11:00PM +0300, Teodor Sigaev wrote:
Apparantly there is a bug lurking somewhere in pgwin32_select(). Because
if I put a #undef select right before the select in pgstat.c, the
regression tests pass.
Hi all!
First of all I'm new to this list, please be gentle :-) Next I'd like to
mention that I've already searched the documentation and the archives,
but couldn't find the answer to my question.
I'm running a production/development database using PostgreSQL 8.1 on a
Debian server. Due to some
2007/1/23, Paul Lambert [EMAIL PROTECTED]:
G'day,
Is there an equivalent in Postgres to the DTS Packages available in M$
SQL server.
I use these in SQL server to pre-load data from CSV files prior to
enabling replication from my primary application. Any pointers on where
best to go for this
Apparantly there is a bug lurking somewhere in pgwin32_select(). Because
if I put a #undef select right before the select in pgstat.c, the
regression tests pass.
May be, problem is related to fixed bug in pgwin32_waitforsinglesocket() ?
WaitForMultipleObjectsEx might sleep
Hello, maybe I have found a better solution.
In PostgreSQL 8.2 this current solution is not working properly, because I
got
too many triggers on table tablename error. This is the first thing. The
second problem
that if something go wrong between the disable and re-enable the trigger,
the trigger
I have the same problem yesterday. I got this error when I try to disable
the trigger in pg_catalog:
UPDATE pg_catalog.pg_class SET reltriggers = 0 WHERE oid =
'foobar'::pg_catalog.regclass';
But if I disabling the trigger using this syntax:
ALTER TABLE tablename DISABLE TRIGGER triggername
Jeremy Haile wrote:
Magnus - thanks for your investigation and work! Any chance I could get
a patched exe for win32 and test on my servers?
In the meantime, could you please confirm that turning row_level_stats
off makes the regression test pass? And whatever tests you were doing?
(Note that
Tom,
I've also got a customer getting this error message.
the OS is OSX 10.3 they are using plpgsql, and shared buffers is set
very low
shared_buffers = 16
Dave
On 3-Jan-07, at 10:19 AM, Tom Lane wrote:
hubert depesz lubaczewski [EMAIL PROTECTED] writes:
and - after some time of
Hello,
I am receiving a large (300k+_ document from an external agent and
need to reduce a few interesting bits of data out of the document on
an insert trigger into separate fields.
regex seems one way to handle this but is there any way to avoid
rescanning the document for each regex. One
On 1/26/07, Tomi N/A [EMAIL PROTECTED] wrote:
2007/1/23, Paul Lambert [EMAIL PROTECTED]:
Is there an equivalent in Postgres to the DTS Packages available in M$
SQL server.
what you're looking for exists in a number of variations.
You can use a good text editor with the postgres' COPY
On 1/26/07, M.A. Oude Kotte [EMAIL PROTECTED] wrote:
Now I've found the WAL files in the pg_xlog directory, and started
browsing around for documentation on what I can do with those. But all I
can find is that you can use them to restore your database after a crash
or a custom backup. But I
Magnus Hagander [EMAIL PROTECTED] writes:
Apparantly there is a bug lurking somewhere in pgwin32_select(). Because
if I put a #undef select right before the select in pgstat.c, the
regression tests pass.
I guess the bug is shown because with row level stats we simply have
more data to
On Fri, Jan 26, 2007 at 09:55:39AM -0500, Tom Lane wrote:
Magnus Hagander [EMAIL PROTECTED] writes:
Apparantly there is a bug lurking somewhere in pgwin32_select(). Because
if I put a #undef select right before the select in pgstat.c, the
regression tests pass.
I guess the bug is shown
We have had lots of reports of issues with the stats collector on
Windows. Some were definitly fixed by the patch by OT, but I don't
think all.
Here were a couple of other reports I found:
http://archives.postgresql.org/pgsql-hackers/2006-09/msg00415.php
Dave Cramer [EMAIL PROTECTED] writes:
I've also got a customer getting this error message.
the OS is OSX 10.3 they are using plpgsql, and shared buffers is set
very low
shared_buffers = 16
Well, the answer to that is if it hurts, don't do that. You couldn't
expect to process more than a
Besides being easy to schedule and very flexible, manipulating data
with queries is extremely powerful and fairly easy to maintain
assuming you know a little SQL -- thanks to postgresql's huge array of
built in string manipulation functions. Your skills learned here will
pay off using the
I've also used Pentaho Data Integration (previously known as Kettle)
quite extensively, and can recommend it. It supports many different
databases and has fairly good documentation (although thin in some
areas). It has a GUI drag-and-drop tool that can be used to configure
transformations and is
Hello I have a design question:
I have a table representing Families, and a table representing Persons.
The table Family have a row family_id as primary key.
The table Person have a row person_id as primary key and contain also a
row family_id.
As you can understand, the row family_id in
Csaba Nagy [EMAIL PROTECTED] writes:
And BTW, I have seen something similar while creating temporary tables
which should not conflict even with the same table name I think...
I've heard reports of that, but never been able to duplicate it ...
regards, tom lane
* M. A. Oude Kotte:
I'm running a production/development database using PostgreSQL 8.1 on a
Debian server. Due to some bad code in one of our applications who use
this database, some of the data was modified incorrectly the last few
days. The idea is that I would like to restore the entire
Hi,
I've got plperl code that works just fine when the database is encoded using
LATIN1, but fails as soon as I switch to UTF8.
I've been testing PG 8.1.4 under Linux, and PG 8.1.6 under FreeBSD, both behave
exactly the save.
I'm sorry I'm not able to strip down the code, and show you a small
Windows doesn't support symlinks. Is it possible instead for there to
be a config file that lets one set where the pg_xlog directory will sit?
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
# [EMAIL PROTECTED] / 2007-01-26 09:21:27 -0800:
Windows doesn't support symlinks. Is it possible instead for there to
be a config file that lets one set where the pg_xlog directory will sit?
Windows has junction points.
--
How many Vietnam vets does it take to screw in a light bulb?
You
In theory -- yes. In practicality -- no -- And yes... yopu are corerct --
postgreSQL needs to be installed PHP. YOu will find this to be the case with
ANY dependencies in PHP, including things like jpeg supprt, curl, etc. So
this is NOT a postgreSQL problem, not really anyway.
This is realy
Karen Hill wrote:
Windows doesn't support symlinks. Is it possible instead for there to
be a config file that lets one set where the pg_xlog directory will sit?
You can use a junction point for this instead of a symlink. Google for
utilities to create them.
Regards, Dave.
Karen Hill [EMAIL PROTECTED] writes:
Windows doesn't support symlinks.
Yes it does, at least in reasonably modern versions. They're called
junctions or something like that.
regards, tom lane
---(end of broadcast)---
TIP
Florian Weimer [EMAIL PROTECTED] writes:
In theory, this should be possible (especially if you haven't switched
off full page writes).
Not really --- the WAL records are not designed to carry full
information about the preceding state of the page, so you can't use them
to undo. (Example: a
Hi Ted,
Am Donnerstag, 25. Januar 2007 19:53 schrieb Ted Byers:
The question I'd ask before offering a solution is, Does the order of the
id data matter, or is it a question of having all the results for a given
id together before proceeding to the next id? The answer to this will
determine
I spend some time googling this and searching the Postgresql.org site, but
I'm either not good enough with the search strings, or it's not to be found.
I'm trying to plan upgrades so that we don't upgrade needlessly, but also
don't get caught using stuff that nobody's supporting any more.
The
On Jan 26, 9:45 am, [EMAIL PROTECTED] (Tom Lane) wrote:
Florian Weimer [EMAIL PROTECTED] writes:
In theory, this should be possible (especially if you haven't switched
off full page writes).Not really --- the WAL records are not designed to
carry full
information about the preceding
Is there some (easy !) way to install just the minimum parts of
PostgreSQL I need on the web server?
In a sane distribution, you would just do something like yum install
php php-pgsql, and that would pull in whatever bits of PostgreSQL are
required (shared libraries).
--
It's not a war on
This utility is useful for creating junctions in Windows:
http://www.microsoft.com/technet/sysinternals/FileAndDisk/Junction.mspx
I am using this to symlink my pg_xlog directory to another disk and it
works great.
Jeremy Haile
On Fri, 26 Jan 2007 18:27:04 +, Roman Neuhauser
[EMAIL
Hi Ted,
Hi Thorsten,
Am Donnerstag, 25. Januar 2007 19:53 schrieb Ted Byers:
The question I'd ask before offering a solution is, Does the order of
the
id data matter, or is it a question of having all the results for a given
id together before proceeding to the next id? The answer to
Alan Hodgson wrote:
Is there some (easy !) way to install just the minimum parts of
PostgreSQL I need on the web server?
In a sane distribution, you would just do something like yum install
php php-pgsql, and that would pull in whatever bits of PostgreSQL are
required (shared libraries).
You can also mount a partition as a directory under an existing drive letter,
using the disk management utility built-in to windows. It's not as granular
as the junction method, but there's a built-in gui for it, and its more widely
known and used.
-Original Message-
From: Jeremy
On Thu, Jan 25, 2007 at 10:47:50 -0700,
Isaac Ben [EMAIL PROTECTED] wrote:
The data is gene expression data with 20,000 dimensions. Part of the
project I'm working on is to discover what dimensions are truly
independent. But to start with I need to have
all of the data available in a
On 1/26/07, Bruno Wolff III [EMAIL PROTECTED] wrote:
On Thu, Jan 25, 2007 at 10:47:50 -0700,
Isaac Ben [EMAIL PROTECTED] wrote:
The data is gene expression data with 20,000 dimensions. Part of the
project I'm working on is to discover what dimensions are truly
independent. But to start
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 01/26/07 13:37, Isaac Ben wrote:
On 1/26/07, Bruno Wolff III [EMAIL PROTECTED] wrote:
On Thu, Jan 25, 2007 at 10:47:50 -0700, Isaac Ben
[EMAIL PROTECTED] wrote:
[snip]
I plan on accessing the data with postgres via python and R. The
main
Magnus Hagander [EMAIL PROTECTED] writes:
Attached patch seems to solve the problem on my machine at least. Uses
pgwin32_waitforsinglesocket() instead of pgwin32_select(). Changes
pgwin32_waitforsinglesocket() to accept the timeout as a parameter (this
is why it touches files outside of the
2007/1/25, Thorsten Körner [EMAIL PROTECTED]:
Hi,
when I fire the following query:
select m_id, m_u_id, m_title, m_rating from tablename where m_id in (26250,
11042, 16279, 42197, 672089);
I will get the same results in the same order, as in in the next query:
select m_id, m_u_id, m_title,
Hi,
I'm trying to create a table with 20,000 columns of type int2, but I
keep getting the error message that the limit is 1600. According to
this message http://archives.postgresql.org/pgsql-admin/2001-01/msg00199.php
it can be increased, but only up to about 6400. Can anyone tell me
how to get
Hello!
What is the best way to find out the relationship of two columns in a
table?
I want to know if it is 1:1, 1:N, or M:N. Is there an easy way to do
this with a SQL statement?
Best regards,
Kai
---(end of broadcast)---
TIP 1: if
On Wednesday 24 January 2007 20:57, bala [EMAIL PROTECTED]
wrote:
'script.sh' contains
PGUSER=postgres pg_dumpall /path/to/backup_date.sql
Running the script using crond creates the 0 byte files.
But , If i run the script in console , it creates the file with
content.
Any suggestion
Hello,
How can I loop a PL/PgSQL recorset variable? The example:
DECLARE
v_tmp_regi RECORD;
v_tmp RECORD;
BEGIN
SELECT * INTO v_tmp_regi FROM sulyozas_futamido sf WHERE
sf.termekfajta_id=
a_termekfajta_id AND sf.marka_id=a_marka_id;
DELETE FROM
On Fri, Jan 26, 2007 at 02:33:05PM +0100, Furesz Peter wrote:
I have the same problem yesterday. I got this error when I try to disable
the trigger in pg_catalog:
UPDATE pg_catalog.pg_class SET reltriggers = 0 WHERE oid =
'foobar'::pg_catalog.regclass';
Well duh. The error is precisely
Hello frends!
i am using postgresql database. I am using crond for daily backup.
Following is the crontab entry,
29 17 * * 1-6 postgres /path/to/script.sh
'script.sh' contains
PGUSER=postgres pg_dumpall /path/to/backup_date.sql
Running the script using crond creates the 0 byte files.
Applied to HEAD and 8.2 --- assuming the Windows buildfarm machines go
green, we should probably consider back-porting this to 8.1 and 8.0.
Not trying to be a nuisance, but I'd really like to try this out in my
environment and see if my problems disappear. Is there anyone out there
who could
Jeremy Haile wrote:
Applied to HEAD and 8.2 --- assuming the Windows buildfarm machines go
green, we should probably consider back-porting this to 8.1 and 8.0.
Not trying to be a nuisance, but I'd really like to try this out in my
environment and see if my problems disappear. Is there
On Fri, Jan 26, 2007 at 12:00:42PM +0100, Louis-David Mitterrand wrote:
Hello,
For a select array(...) as col1, col2, col3 from table I'd like the DBI
driver to output col1 as a perl array instead of a scalar
{res1,res2,etc.} representation of it.
Is that somehow possible? I looked at
Does anyone know what the default fillfactor is for index types other
than btree?
I found in the docs that the default for btree is 90, but can't seem to
find what it is for the other index types.
Thanks in advance,
Tony
---(end of
Using standard build (none of the things you mentioned) on 8.2.1
currently.
I really appreciate it!
On Fri, 26 Jan 2007 21:24:09 +0100, Magnus Hagander
[EMAIL PROTECTED] said:
Jeremy Haile wrote:
Applied to HEAD and 8.2 --- assuming the Windows buildfarm machines go
green, we should
Buen Dia.
Por favor si saben como, me gustaria saber como puedo eliminar un indice
PERO SOLO si este existe. Como valido si existe o no el indice para luego
eliminarlo ??
Gracias.
---
Please, i need drop index but ONLY and ONLY this exist index. Thanks.
I'm wanting to install PHP on a Apache/Linux server with support for
PostgreSQL.
It seems that I need to install PostgreSQL on the machine first,
before the PHP installation will work.
The way I've done this previously is simply to install PostgreSQL.
However, the database server is in fact
I have the following table definition in postgres 8.0:
CREATE TABLE userInfo
(
userID character varying(32) NOT NULL,
password character varying(32) NOT NULL,
salt character varying(16) NOT NULL,
CONSTRAINT userInfo_PK PRIMARY KEY (userID)
) ;
Administrators are able to add new users to
I am looking for some sample code using the libpqxx (C++) API for
Postgresql. I have found some tutorials
(http://thaiopensource.org/devprojects/libpqxx/doc/2.6.8/html/Tutorial/
http://www.cs.wisc.edu/~ajkunen/libpqxx-2.4.2/Tutorial/)
and some references
Hi everyone,
I have a problem with one of my costomers.
I made a program that uses a PostgreSQL (win32) database to save its data.
My customer claims that he lost lots of data reguarding his own clients
and that those data had surely been saved on the database.
My first guess is that he is the
Thanks for the advise folks.
I've just installed postgresql in its entirety, but won't run it.
Regards,
Richard
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your
The Windows Server 2003 Resource Kit and WinXP Resource Kit (both free
to download) both also provide the LINKD utility -- we use LINKD to
create junctions on most of our Windows servers (to mimic the equivalent
hard links we use on our Linux servers).
- Bill
-Original Message-
From:
In response to BluDes [EMAIL PROTECTED]:
Hi everyone,
I have a problem with one of my costomers.
I made a program that uses a PostgreSQL (win32) database to save its data.
My customer claims that he lost lots of data reguarding his own clients
and that those data had surely been saved on
On Fri, 2007-01-26 at 12:16 -0800, [EMAIL PROTECTED] wrote:
I am looking for some sample code using the libpqxx (C++) API for
Postgresql. I have found some tutorials
(http://thaiopensource.org/devprojects/libpqxx/doc/2.6.8/html/Tutorial/
Nik [EMAIL PROTECTED] writes:
I have the following table definition in postgres 8.0:
PG 8.0.what, exactly?
Why is it that the record is visible when bulk selected, but not when
selected as a part of the WHERE clause, and why is it that the index
rebuild and vacuum fixes the problem?
Sounds
On Fri, 2007-01-26 at 15:06, Bill Moran wrote:
In response to BluDes [EMAIL PROTECTED]:
Any suggestion?
In any event, refuse to ever do any business with him again. In my
experience, these kinds of customers aren't worth the pennies they pay
you. Also, refuse to give in. If you
Scott Marlowe wrote:
On Fri, 2007-01-26 at 15:06, Bill Moran wrote:
In response to BluDes [EMAIL PROTECTED]:
Any suggestion?
In any event, refuse to ever do any business with him again. In my
experience, these kinds of customers aren't worth the pennies they pay
you. Also, refuse to
Thanks all for your tips and pointers.
Looking at copy I think it may do just what I need. The tables I load
the data into have the same columns in the same order as those in the
CSV file. Loading data in this manner is going to be a rare occurance -
just when we install a new customer site
Bill Moran wrote:
I spend some time googling this and searching the Postgresql.org site, but
I'm either not good enough with the search strings, or it's not to be found.
I'm trying to plan upgrades so that we don't upgrade needlessly, but also
don't get caught using stuff that nobody's
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 01/26/07 17:28, Shane Ambler wrote:
Bill Moran wrote:
I spend some time googling this and searching the Postgresql.org site,
but
I'm either not good enough with the search strings, or it's not to be
found.
I'm trying to plan upgrades so that
On Thursday, January 25 Furesz Peter wrote:
How can I loop a PL/PgSQL recorset variable? The example:
DECLARE
v_tmp_regi RECORD;
v_tmp RECORD;
BEGIN
SELECT * INTO v_tmp_regi FROM sulyozas_futamido sf WHERE
sf.termekfajta_id=
a_termekfajta_id AND
Si quieres escribir en español, por favor, escribe a
[EMAIL PROTECTED]
esta es una lista en ingles. Tu respuesta abajo...
On 1/25/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Buen Dia.
Por favor si saben como, me gustaria saber como puedo eliminar un indice
PERO SOLO si este existe. Como
Ron Johnson [EMAIL PROTECTED] writes:
How much does the on-disk structure of *existing* tables and indexes
change between x.y versions?
Between, for example, 8.0 and 8.2?
Enough to require a dump/reload in order to upgrade. :)
Within major versions (8.2.0, 8.2.1, etc) the files are
Ron Johnson wrote:
There is no set time frame planned that I know of.
It is more a matter of users that keep the old versions alive. Some with
large datasets on busy servers that can't allocate enough downtime to
upgrade tend to be keeping the older versions running.
How much does
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 01/26/07 20:12, Bruce Momjian wrote:
Ron Johnson wrote:
There is no set time frame planned that I know of.
It is more a matter of users that keep the old versions alive. Some with
large datasets on busy servers that can't allocate enough
Ron Johnson wrote:
Yes:
http://www.postgresql.org/docs/8.2/static/migration.html
I was thinking of something like the release notes, but a bit more
targeted. (I know. diff the source.)
http://www.postgresql.org/docs/8.2/interactive/release-8-2.html
For example, I've read
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 01/26/07 21:48, Bruce Momjian wrote:
Ron Johnson wrote:
Yes:
http://www.postgresql.org/docs/8.2/static/migration.html
I was thinking of something like the release notes, but a bit more
targeted. (I know. diff the source.)
1. Cleanly shutdown pg.
2. Install v8.2.
3. Start pg.
4. psql -c 'REINDEX DATABASE' some_db
The changes are usually very subtle, like changes in the storage format
for certain data types, or bit changes in the row headers --- it isn't
something really of interest except to developers.
On Fri, Jan 26, 2007 at 10:16:39PM -0600, Ron Johnson wrote:
What are your plans for reducing the number of resources needed to
upgrade databases?
As noted, the table structure changes only slightly between versions,
if at all. What does change significantly is the catalog. Even now
there have
Shane Ambler [EMAIL PROTECTED] writes:
Bill Moran wrote:
Does the PostgreSQL project have any similar policy about EoLs?
There is no set time frame planned that I know of.
No, there's no agreed-on policy. So far there's really only been one
release that we've actively decided to
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 01/27/07 00:19, Martijn van Oosterhout wrote:
On Fri, Jan 26, 2007 at 10:16:39PM -0600, Ron Johnson wrote:
What are your plans for reducing the number of resources needed to
upgrade databases?
As noted, the table structure changes only
86 matches
Mail list logo