Well, we are entirely ready to accept patches from any Windows
Vista
beta testers who are able to find and fix portability issues.
It's the folks who think that non-Windows-using developers should
care
about Vista that bug me. This is open-source code, people.
Scratch
your own
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Tom Lane
Sent: 19 September 2006 05:43
To: Ron Johnson
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] vista
Ron Johnson [EMAIL PROTECTED] writes:
On 09/18/06 22:32, Joshua D. Drake
Ron Johnson wrote:
# select * from projects;
project_id | username | project_name
- +--+--
1 | foo |
2 | bar |
(2 rows)
dupe_filenames=# insert into projects (project_name, username )
dupe_filenames-# values ('foo', 'bar');
ERROR:
Hi,
At a customer site, we've made a migration from Oracle 8.1.5 to PGSQL
8.1.1. The migration happened without any problem and now the performances
are better with PG than with Ora, but the customer noticed that the size
of PG on disk where much greater than the size on disk of Oracle. And I'm
Hi Benoit,
Are you talking specifically the database?
You can run up 100's of gigs of log files in pg_log if you're not careful (he
says after doing the very same).
Cheers
Chris
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 19 September 2006 10:01
To:
[EMAIL PROTECTED] writes:
At a customer site, we've made a migration from Oracle 8.1.5 to PGSQL
8.1.1. The migration happened without any problem and now the performances
are better with PG than with Ora, but the customer noticed that the size
of PG on disk where much greater than the size
It's the folks who think that non-Windows-using developers should care
about Vista that bug me. This is open-source code, people. Scratch
your own itch.
The scratch your own itch line can only be pushed so far, if it is
being said by a developer who works on a project that desires to be
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Naz Gassiep
Sent: 19 September 2006 12:26
To: Tom Lane
Cc: Ron Johnson; pgsql-general@postgresql.org
Subject: Re: [GENERAL] vista
The scratch your own itch line can only be pushed so far, if
So what do you suggest? -core vote and order someone to do the work?
Postgresql.org isn't a business and doesn't employ any developer - we
only have the option of accepting patches from people/companies with
itches.
I don't suggest any chance to any structures in place, it's a purely PR
# [EMAIL PROTECTED] / 2006-09-19 21:26:16 +1000:
if you want to be taken seriously by anyone who uses Windows (hands up
anyone who knows a Windows user)
1. what do those two things have in common?
2. what makes you think that anyone who uses Windows runs
PostgreSQL on it?
3.
-Original Message-
From: Naz Gassiep [mailto:[EMAIL PROTECTED]
Sent: 19 September 2006 14:06
To: Dave Page
Cc: Tom Lane; Ron Johnson; pgsql-general@postgresql.org
Subject: Re: [GENERAL] vista
That's important and we acknowledge the need.
Even in the absence of any progress on
On 9/19/06, Roman Neuhauser [EMAIL PROTECTED] wrote:
# [EMAIL PROTECTED] / 2006-09-19 21:26:16 +1000:
if you want to be taken seriously by anyone who uses Windows (hands up
anyone who knows a Windows user)
1. what do those two things have in common?
2. what makes you think that anyone
Hi,
I have an application using Postgresql with a large (100+) number of
tables. Are there any free/open source tools that can ease the process
of updating the schema.
Specifically I would like to compare a source and a target, determine
the differences and the best way to update the target to
Hello,
I would like to install a PostgreSQL. I know how to manage the database
itself, creae databases, user, groups and so on. But I don't know how
to allow other users, who are outside LAN to connect to database
through Internet.
For example, my external IP is xxx.xxx.xxx.xxx, and my IP in the
HI
I have a table with a unique key constraint on col1,col2. The dattabase
allowed an multiple inserts. here is how
col1 col2
'abc' empty space
'abc' empty space
I am not sure how this can happen
---(end of
The solution you need all depends on the problem you are having. If you
explain how your application is written PHP, Java, etc and where your
performance problems are coming from, then someone could give you a better
answer!
Regards,
Ben
Najib Abi Fadel [EMAIL PROTECTED] wrote in message
The free, open-source SchemaCrawler tool will compare the schema and
data. SchemaCrawler outputs details of your schema (tables, views,
procedures, and more) in a diff-able plain-text format (text, CSV, or
XHTML). SchemaCrawler can also output data (including CLOBs and BLOBs)
in the same
Dave Page wrote:
because someone couldn't find the feature they wanted and were
encouraged to work on it themselves. pgAdmin got started in almost
^^
That's the key word here, encouraged, not discouraged. IMHO telling
a Windows user to go do it himself is discouraging. Quite impolite
Tomi NA wrote:
On 9/19/06, Roman Neuhauser [EMAIL PROTECTED] wrote:
# [EMAIL PROTECTED] / 2006-09-19 21:26:16 +1000:
if you want to be taken seriously by anyone who uses Windows (hands up
anyone who knows a Windows user)
1. what do those two things have in common?
2. what makes you
Junkone wrote:
HI
I have a table with a unique key constraint on col1,col2. The dattabase
allowed an multiple inserts. here is how
col1 col2
'abc' empty space
'abc' empty space
I suppose the values in col2 are NULL values?
You cannot compare NULL values. NULL ==
I found a rather strange but working method to compare the contents of two tables in different databases:
select 'otformularfeld' as which, md5(array_to_string(array(
select md5(id_pkff||id_formular||id_formfeld||id_bf) from otformularfeld where quarant=0 order by id_pkff
),''))
So:
- basically
In response to Tomi NA [EMAIL PROTECTED]:
On 9/19/06, Roman Neuhauser [EMAIL PROTECTED] wrote:
# [EMAIL PROTECTED] / 2006-09-19 21:26:16 +1000:
if you want to be taken seriously by anyone who uses Windows (hands up
anyone who knows a Windows user)
1. what do those two things have
On Mon, Sep 18, 2006 at 03:54:05PM -0700, Junkone wrote:
HI
I have a table with a unique key constraint on col1,col2. The dattabase
allowed an multiple inserts. here is how
col1 col2
'abc' empty space
'abc' empty space
Depends on what you mean by empty space. If
Hello Lukasz!
You need some port forwarding onto your router/firewall. You have to forward
incoming connections on port 5432 (or the port postmaster is listening on)
from IP xxx.xxx.xxx.xxx to IP yyy.yyy.yyy.yyy with the according port. If
your router is a Linux machine, take a look into the
I think the itch and scratch line is entirely appropriate.
This is open source software, not prepackaged code guaranteed to work on the
newest platforms.
People who are trying it out on Vista are developers, not non-technical
end-users.
A developer who wants an open source product to work on a
You have to either configure your router to redirect the public port to the private port. (By
default 5432). Or put your database server in the DMZ (not recommended).
Lukasz wrote:
Hello,
I would like to install a PostgreSQL. I know how to manage the database
itself, creae databases, user,
On Tue, Sep 19, 2006 at 03:34:47PM +0200, Alban Hertroys wrote:
It is not much harder to say We currently don't have the resources to
look into that, if you could be so kind to experiment a bit and see if
you can get it to work
Except that would be a lie. Perhaps:
Postgresql developers
John Meyer wrote:
has anybody gotten postgresql to install successfully under Windows
Vista?
---(end of broadcast)---
TIP 6: explain analyze is your friend
BTW, here's the issue at the pgFoundary
Although Tom's response may have seemed to be negative towards windows,
the original posting had a bit of an attitude to start with.
Actually the original poster asked has anybody gotten postgresql to install successfully under
Windows Vista? To which the answer should have been, no. Send us
On 19/9/2006 22:41, Lukasz [EMAIL PROTECTED] wrote:
Hello,
I would like to install a PostgreSQL. I know how to manage the database
itself, creae databases, user, groups and so on. But I don't know how
to allow other users, who are outside LAN to connect to database
through Internet.
For
-Original Message-
From: Martijn van Oosterhout [mailto:[EMAIL PROTECTED]
Sent: 19 September 2006 15:10
To: Alban Hertroys
Cc: Dave Page; Naz Gassiep; Tom Lane; Ron Johnson;
pgsql-general@postgresql.org
Subject: Re: [GENERAL] vista
If Vista is so important, why aren't seeing
am Tue, dem 19.09.2006, um 6:11:12 -0700 mailte Lukasz folgendes:
Hello,
I would like to install a PostgreSQL. I know how to manage the database
itself, creae databases, user, groups and so on. But I don't know how
to allow other users, who are outside LAN to connect to database
through
Naz Gassiep [EMAIL PROTECTED] writes:
For something like Vista
compatibility, if you want to be taken seriously by anyone who uses
Windows (hands up anyone who knows a Windows user), scratch your own
itch is not really going to cut it, IMHO.
I was responding to someone who is obviously a
Hi Martijn,
Am 2006-09-17 12:22:42, schrieb Martijn van Oosterhout:
Do you really want this? Compiling static is not straightforward, if
all the libraries actually exist in static form anyway.
Would it not be easier to install the system in a chroot, then you can
use all the normal system
taken seriously by professionals in industry. For minor features, yes,
perhaps it could be argued that the core team could ignore certain
issues, and just wait for a patch. For something like Vista
compatibility, if you want to be taken seriously by anyone who uses
Windows (hands up anyone who
Roman Neuhauser wrote:
# [EMAIL PROTECTED] / 2006-09-19 21:26:16 +1000:
if you want to be taken seriously by anyone who uses Windows (hands up
anyone who knows a Windows user)
1. what do those two things have in common?
2. what makes you think that anyone who uses Windows runs
Perhaps many of the core developers don't care if windows users take
the project seriously?
On Sep 19, 2006, at 4:26 AM, Naz Gassiep wrote:
It's the folks who think that non-Windows-using developers should
care
about Vista that bug me. This is open-source code, people. Scratch
your own
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Ben
Sent: 19 September 2006 17:03
To: Naz Gassiep
Cc: Tom Lane; Ron Johnson; pgsql-general@postgresql.org
Subject: Re: [GENERAL] vista
Perhaps many of the core developers don't care if windows
On Tue, Sep 19, 2006 at 05:11:54PM +0100, Dave Page wrote:
Perhaps many of the core developers don't care if windows users take
the project seriously?
Somehow I doubt that given that I was invited to join core precisely
because of my work on the Windows distro. I would think that implies
Ben wrote:
Perhaps many of the core developers don't care if windows users take the
project seriously?
Well that may or may not be true, but isn't really relevant. What is
relevant is that *any* community user would have been told the *exact*
same thing. Regardless of OS.
Joshua D. Drake
Hello -
I am observing odd behavior that I am wondering if anyone here may have an
idea of how better to debug. I am suspecting a bug in the pgsql code, but
would be happy to find it is my error.
My specific situation is that I am using version 8.1.4 on a FreeBSD 6.1
AMD-64 system. I have a
[EMAIL PROTECTED] (Naz Gassiep) writes:
It's the folks who think that non-Windows-using developers should care
about Vista that bug me. This is open-source code, people. Scratch
your own itch.
The scratch your own itch line can only be pushed so far, if it is
being said by a developer who
Marc Evans [EMAIL PROTECTED] writes:
... I have a table with about 15000 records in it, which I
would like to add a new column to. The alter command shows success.
However, testing inserts reveals that the data for the new column is never
stored.
What do you mean by that exactly? The
On Tue, 19 Sep 2006, Tom Lane wrote:
Marc Evans [EMAIL PROTECTED] writes:
... I have a table with about 15000 records in it, which I
would like to add a new column to. The alter command shows success.
However, testing inserts reveals that the data for the new column is never
stored.
What do
Marc Evans [EMAIL PROTECTED] writes:
On Tue, 19 Sep 2006, Tom Lane wrote:
What do you mean by that exactly? The example you showed seems to be
doing just what it's supposed to.
In the failure mode, the source_record column always has the value NULL,
regardless of any value specified in an
On Tue, 19 Sep 2006, Tom Lane wrote:
Marc Evans [EMAIL PROTECTED] writes:
On Tue, 19 Sep 2006, Tom Lane wrote:
What do you mean by that exactly? The example you showed seems to be
doing just what it's supposed to.
In the failure mode, the source_record column always has the value NULL,
Marc Evans [EMAIL PROTECTED] writes:
On Tue, 19 Sep 2006, Tom Lane wrote:
What insert command is being issued exactly, and from what source? I'm
speculating about issues like stale plans or metadata caches, but you're
not providing any information about where to look.
Sorry for being terse
On 9/18/06, Jack Orenstein [EMAIL PROTECTED] wrote:
-- Forwarded message --
From: Andrew - Supernews [EMAIL PROTECTED]
...
Jack I have an int8 that I need as a Datum for use with
Jack SPI_execute_plan.
Int64GetDatum(your_variable)
which then has to be pfree'd, correct?
On Tue, 19 Sep 2006, Tom Lane wrote:
Marc Evans [EMAIL PROTECTED] writes:
On Tue, 19 Sep 2006, Tom Lane wrote:
What insert command is being issued exactly, and from what source? I'm
speculating about issues like stale plans or metadata caches, but you're
not providing any information about
So...
If you're not a PostgreSQL Win32 port dev, and *don't know* what they're
up to as far as Vista, why respond to the Q? Or why respond fix it
yourself instead of ask this guy or nobody here will know yet or
post your query on -ports or -hackers.
Otherwise it's as useful as saying
Marc Evans [EMAIL PROTECTED] writes:
On Tue, 19 Sep 2006, Tom Lane wrote:
Hmph. You got any ON INSERT triggers or rules on that table? I can't
think of anything else that would interfere with data getting stored.
No INSERT triggers. I do have a BEFORE DELETE trigger, and a pile of
FOREIGN
On Tue, 19 Sep 2006, Tom Lane wrote:
Marc Evans [EMAIL PROTECTED] writes:
On Tue, 19 Sep 2006, Tom Lane wrote:
Hmph. You got any ON INSERT triggers or rules on that table? I can't
think of anything else that would interfere with data getting stored.
No INSERT triggers. I do have a BEFORE
Marc Evans [EMAIL PROTECTED] writes:
Any suggested tricks for seeing additional debug information or even
roaming through gdb, to try to figure this out?
Is the problem reproducible enough that you can watch it under gdb?
In that case it shouldn't be that hard to narrow it down. I gathered
On Tue, 19 Sep 2006, Tom Lane wrote:
Marc Evans [EMAIL PROTECTED] writes:
Any suggested tricks for seeing additional debug information or even
roaming through gdb, to try to figure this out?
Is the problem reproducible enough that you can watch it under gdb?
In that case it shouldn't be
Greetings,
*Except* copy command, are there other quick ways to load data from a
csv file into a pgsql table please?
Thanks a lot!
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
Define 'quick'.
You could write a script that would transform a .csv file into an INSERT
statement and save it to an .sql file.
Or I suppose you could do silly ODBC stuff with MS Access.
--
Brandon Aiken
CS/IT Systems Engineer
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL
On Sep 19, 2006, at 11:15 AM, Emi Lu wrote:
Greetings,
*Except* copy command, are there other quick ways to load data from
a csv file into a pgsql table please?
There are several bulk loaders, but I believe they all use COPY
behind the scenes.
If copy isn't an option then your best
On Tue, 2006-09-19 at 13:27, Brandon Aiken wrote:
Define 'quick'.
You could write a script that would transform a .csv file into an INSERT
statement and save it to an .sql file.
Or I suppose you could do silly ODBC stuff with MS Access.
--
Brandon Aiken
CS/IT Systems Engineer
Thank you for all the inputs.
Actually, I am reluctant to do the update line by line.
I plan to use a shell script to
. replace all characters such as ' to \'
. update each line to insert into
. call -c query load the file into db
In java, call this shell script, after data populated into
Emi Lu wrote:
Greetings,
*Except* copy command, are there other quick ways to load data from a
csv file into a pgsql table please?
Quick? No.
Joshua D. Drake
Thanks a lot!
---(end of broadcast)---
TIP 5: don't forget to increase your
On Tue, Sep 19, 2006 at 01:27:56PM -0400, Jack Orenstein wrote:
On 9/18/06, Jack Orenstein [EMAIL PROTECTED] wrote:
-- Forwarded message --
From: Andrew - Supernews [EMAIL PROTECTED]
...
Jack I have an int8 that I need as a Datum for use with
Jack SPI_execute_plan.
On 9/19/06, Martijn van Oosterhout kleptog@svana.org wrote:
On Tue, Sep 19, 2006 at 01:27:56PM -0400, Jack Orenstein wrote:
On 9/18/06, Jack Orenstein [EMAIL PROTECTED] wrote:
-- Forwarded message --
From: Andrew - Supernews [EMAIL PROTECTED]
...
Jack I have an int8 that I
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 09/19/06 13:26, Steve Atkins wrote:
On Sep 19, 2006, at 11:15 AM, Emi Lu wrote:
Greetings,
*Except* copy command, are there other quick ways to load data from a
csv file into a pgsql table please?
There are several bulk loaders, but I
Jack Orenstein [EMAIL PROTECTED] writes:
The C extension I'm writing, which uses the SPI, will be called
thousands or millions of times as part of a data conversion -- I do
have to worry about memory leaks.
Not if it's called in a short-lived context, which should ordinarily be
the case.
Hey, I've just find out what's happening.
The problem is the serial datatype creates a sequence in the background
(project_id_seq). If the sequence current numeber is 1, and I manually insert
a new entry whit ID=2, the sequence doesn't know it. So when I try the
INSERT statement, the next value in
We have a 4x 2.4ghz Opteron box w/ 8 gigs of ram running a very busy pg
8.1.4 server. Upon startup we see around 15-20 statistics buffer is
full messages and they repeat at random times throughout the day.
During peak times the box sometimes seems to grind to a halt. Any thoughts?
- E
Do you have
stats_command_string=onin postgresql.conf as that might cause this error.If it is truned on please turn it off and then try starting your server.Thanks,-- Shoaib MirEnterpriseDB (
www.enterprisedb.com)On 9/20/06, Eci Souji [EMAIL PROTECTED] wrote:
We have a 4x 2.4ghz Opteron box w/ 8
Eci Souji wrote:
We have a 4x 2.4ghz Opteron box w/ 8 gigs of ram running a very busy pg
8.1.4 server. Upon startup we see around 15-20 statistics buffer is
full messages and they repeat at random times throughout the day.
During peak times the box sometimes seems to grind to a halt. Any
[EMAIL PROTECTED] writes:
... My biggest concern is the existing FileMakerPro clients. How much
work would it be to connect the existing FMP clients to the postgreSQL
database using ODBC? Is this a viable temporary step or could it be
permanent?
And Tom Lane replies:
If they can
Oops, knew I forgot something. Here are the settings from our
postgresql.conf I beilive it's set to allow autovac to work and nothing
else.
# - Query/Index Statistics Collector -
stats_start_collector = on
stats_command_string = off
stats_block_level = off
stats_row_level = on
So...
If you're not a PostgreSQL Win32 port dev, and *don't know* what they're
up to as far as Vista, why respond to the Q? Or why respond fix it
yourself instead of ask this guy or nobody here will know yet or
post your query on -ports or -hackers.
Precisely. My point is not that people
I have seen a steady progressive rise in the number of postgresql
related jobs and the quality of those jobs. Major companies are
apparently rolling out critical infrastructure on postgresql...Vonage
is one example:
In article [EMAIL PROTECTED],
[EMAIL PROTECTED] (Robert Treat) wrote:
On Thursday 14 September 2006 12:19, Joshua D. Drake wrote:
Arturo Perez wrote:
Hi all,
Any response to this:
http://www.internetnews.com/dev-news/article.php/3631831
Well first, your subject line is very
Hi
Can somebody point me to some articles/how-to's on postgres clustering
and maybe comparisons to MySQL. (Recently saw an article on scaling
MySQL - up to 16 nodes)
Alex
---(end of broadcast)---
TIP 6: explain analyze is your friend
I wrote:
... I think maybe
something is applying an UPDATE to the row and losing the new value
at that point. Are any of the FKs non-default actions (ON ... SET NULL
or some such that would try to alter data instead of just erroring)?
I've been able to reproduce a problem that may or may not
75 matches
Mail list logo