Greg,
all the registry-entries are for "convenience", that is: to make it
possible for the installer to check if PostgreSQL is installed.
So to use PostgreSQL on Win32, simple distribute the files found
within PostgreSQL/8.1/ from a normal installation. ["normal"
is quite a challenge nontheless,
After trying this, it is close, but not really what I want.
I would prefer to bundle the selected files in my Installshield installer,
and write the necessary registry entries.
Could somebody please tell me which files, and which registry entries I need
to have PostGreSQL installed?
-Origina
Tom Lane writes:
I don't have the patience to run this for 10^8 rows, but the test case
I got suspicious of my 'test' file so I took 1000 rows. That had problems
and pointed out problems with the file.
It seems I had mismatched single quotes.. my guess is that psql got confused
and went in
The reason the default is currently 10 is just conservatism: it was
already an order of magnitude better than what it replaced (a *single*
representative value) and I didn't feel I had the evidence to justify
higher values. It's become clear that the default ought to be higher,
but I've still g
Francisco Reyes <[EMAIL PROTECTED]> writes:
> I have a test ".sql" file of the form:
> insert into testtable values ('1');
> insert into testtable values ('2');
> insert into testtable values ('3');
>
> 100 Million
I don't have the patience to run this for 10^8 rows, but the test case
I did r
I have a test ".sql" file of the form:
insert into testtable values ('1');
insert into testtable values ('2');
insert into testtable values ('3');
100 Million
Right before I call the file with "\i" I do a begin transaction.
At some point during the load the process stops.
After some 5+ minu
- Original Message
>From: Jim C. Nasby <[EMAIL PROTECTED]>
>To: Shelby Cain <[EMAIL PROTECTED]>
>Cc: Csaba Nagy <[EMAIL PROTECTED]>; [EMAIL PROTECTED]; >Postgres general
>mailing list ; >[EMAIL PROTECTED]
>Sent: Monday, May 22, 2006 5:04:51 PM
>Subject: Re: [GENERAL] allow LIMIT in UPDATE
"Jim C. Nasby" <[EMAIL PROTECTED]> writes:
> On Wed, May 17, 2006 at 10:29:14PM -0400, Tom Lane wrote:
>> The reason the default is currently 10 is just conservatism: it was
>> already an order of magnitude better than what it replaced (a *single*
>> representative value) and I didn't feel I had th
On Mon, May 22, 2006 at 09:41:10AM +1200, Brent Wood wrote:
>
>
> On Sat, 20 May 2006, Bruno Wolff III wrote:
>
> > I am not sure that Postgres needs CPAN. CPAN is particularly useful for
> > handling dependencies. I doubt that there will be lots of dependencies in
> > Postgres add ons. So havin
Dawid Kuroczko wrote:
On 5/22/06, Florian G. Pflug <[EMAIL PROTECTED]> wrote:
elein wrote:
> This issue is a very old issue and people have not come up with
> the definitive solution to distributing "datablades" as Stonebraker
> called them.
True, but OTOH there is no "definitive solution" for O
On Sat, May 20, 2006 at 11:46:25AM +0200, Tomi NA wrote:
> On 5/20/06, Martijn van Oosterhout wrote:
>
> >Seems you can't use a variable there. Your choices are to build a
> >string and use EXECUTE, or just do:
> >
> >SELECT setval('sequence',value);
>
> The EXECUTE string solution did the job.
Try posting to -bugs since no one replied. You can also try searching
the archives; this sounds familiar, but I don't remember any of the
details.
On Fri, May 19, 2006 at 11:36:16AM -0400, Reid Thompson wrote:
> PG_VERSION 8.1 - windows XP - 1GB RAM -- Desktop workstation, PG used
> for test/dev.
On Fri, May 19, 2006 at 10:25:19AM -0700, Shelby Cain wrote:
> - Original Message
> >From: Csaba Nagy <[EMAIL PROTECTED]>
> >To: Shelby Cain <[EMAIL PROTECTED]>
> >Cc: [EMAIL PROTECTED]; Postgres general mailing list
> >>; [EMAIL PROTECTED]
> >Sent: Friday, May 19, 2006 11:46:42 AM
> >Sub
On Fri, May 19, 2006 at 05:19:37PM +0200, Csaba Nagy wrote:
> > Since Postgresql's MVCC system doesn't require rollback segments I guess
> > the performance question is the more important of the two. If there could
> > be a performance gain in Postgresql with "delete from X where Y limit Z" vs
On Thu, May 18, 2006 at 11:42:02PM -0700, Don Y wrote:
> We aren't populating tables. Most of our work is involved
> in the things *around* the database (the database is just a
> small piece of the puzzle). I, for example, drop all of
> my tables at the end of each work day -- along with most
> o
On Fri, May 19, 2006 at 02:08:01AM -0400, Tom Lane wrote:
> Don Y <[EMAIL PROTECTED]> writes:
> > Jim C. Nasby wrote:
> >> This is a very minor reason why you should be running the most recent
> >> 8.0.x release and not 8.0.3. A much bigger reason is that there are
> >> data-loss bugs that have bee
Moving to -hackers
Does this still obey stats_command_string? I think it'd be very handy to
either have autovac always report what it's doing (ignoring
stats_command_string), or to provide it with it's own option for it. I
doubt this should pose a performance issue, since unless you have a
whole l
On Fri, May 19, 2006 at 09:37:30AM +0200, Martijn van Oosterhout wrote:
> On Thu, May 18, 2006 at 10:54:02PM -0700, Don Y wrote:
> > I assumed that the contents of ./contrib have NOT been
> > thoroughly tested/reviewed by the Postgres team (though
> > that is just an impression I have... i.e. why h
Jim C. Nasby wrote:
On Thu, May 18, 2006 at 07:25:09AM +0200, Florian Weimer wrote:
* Joshua D. Drake:
Sounds great! But why GPL? Are you looking to sell licenses?
GPL is to spread it as far and wide as possible as fast as possible.
LGPL?
My concern would be, I can't use this toolkit for a
On Mon, 22 May 2006, Rich Shepard wrote:
I've been searching for sales/customer management software I can use in my
small business _and_ which can use postgres as the database back end. I don't
understand why this has been an essentially futile search; almost everyone
puts something out that is
On Thu, May 18, 2006 at 07:25:09AM +0200, Florian Weimer wrote:
> * Joshua D. Drake:
>
> >>> Sounds great! But why GPL? Are you looking to sell licenses?
> >> GPL is to spread it as far and wide as possible as fast as possible.
> >
> > LGPL?
> >
> > My concern would be, I can't use this toolkit fo
To refresh people's memory I have a simple Delphi interface (TEdit and
TNavigator) connected via ODBC to a Postgresql 8.0 table.
I've tried the earlier suggestions in various forms with no success.
I again was successful in updating the table with the table containing no
serial column. With th
On Wed, May 17, 2006 at 10:29:14PM -0400, Tom Lane wrote:
> The reason the default is currently 10 is just conservatism: it was
> already an order of magnitude better than what it replaced (a *single*
> representative value) and I didn't feel I had the evidence to justify
> higher values. It's bec
I suspect that Delphi is specifying the serial column in the insert
statement, but then not assigning it a value (if you turn on query
logging you'll be able to confirm that). If that's the case, you could
write an insert trigger that would set the serial column's value to
nextval for the appropria
Greetings, I am Michael Dean,
At the suggestion of some of the guys in the Postgresql-advocacy
community, I am starting to compile some important lists, which I hope
to make more exhaustive than currently available. From those lists, I
expect to generate some definite new outcomes for the Post
I've been searching for sales/customer management software I can use in my
small business _and_ which can use postgres as the database back end. I don't
understand why this has been an essentially futile search; almost everyone
puts something out that is hard wired for MySQL.
I've just discov
On Sat, 20 May 2006, dfx wrote:
I am trying to get recordset from PostgreSQL database (8.1.3) with java but
I am some problem.
Can somebody send me a short fragment of code that call a function that
returns a set of records?
http://jdbc.postgresql.org/documentation/81/callproc.html#callpro
On 5/22/06, Florian G. Pflug <[EMAIL PROTECTED]> wrote:
elein wrote:
> This issue is a very old issue and people have not come up with
> the definitive solution to distributing "datablades" as Stonebraker
> called them.
True, but OTOH there is no "definitive solution" for OS-level package
managem
On Mon, May 22, 2006 at 08:10:11PM +0200, Florian G. Pflug wrote:
> elein wrote:
> >This issue is a very old issue and people have not come up with
> >the definitive solution to distributing "datablades" as Stonebraker
> >called them.
> True, but OTOH there is no "definitive solution" for OS-level
elein wrote:
This issue is a very old issue and people have not come up with
the definitive solution to distributing "datablades" as Stonebraker
called them.
True, but OTOH there is no "definitive solution" for OS-level package
management too, but still "apt-get" or "rpm" do a pretty decent job.
Mr. Fuhr,
This appears to be a gremlin. I wasn't able to reproduce the
problem. In the interim, I had changed a unique index on the table (took
conditional code out of the SQL statement and substituted a function) and wonder
if this wasn't interacting with the function. Anyway, it seems t
On Mon, May 22, 2006 at 12:52:33PM -0400, Greg Stark wrote:
> "Rafael Martinez, Guerrero" <[EMAIL PROTECTED]> writes:
>
> > Why do you think 'intr' is a bad thing, from man pages:
> > " If an NFS file operation has a major timeout and it is
> > hard mounted, then allow signals to inte
On Mon, May 22, 2006 at 11:20:04AM -0600, Michael Schmidt wrote:
> I've been going through functions for my database, originally
> developed with version 8.0, and had some odd behavior. I'm in the habit
> of putting parentheses around the conditional clauses in IF statements.
> One of my trigger f
This issue is a very old issue and people have not come up with
the definitive solution to distributing "datablades" as Stonebraker
called them.
For now, the best way is to have small well managed projects on
PgFoundry and encourage people to review what is available
there. Maybe we can even mak
On 5/21/06, Brendan Jurd <[EMAIL PROTECTED]> wrote:
Ah!Maybe the reason for such thoughts lies in nature of postgres intervals.
SQL:2003 standard paper says:
'There are two classes of intervals. One class, called year-monthintervals, has an express or implied datetimeprecision that includes no fie
Hi Florian :
Oracle has packages.
Packages are collections of functions, procedures, variables, constants,
ect, put all together.
You has two commands
CREATE PACKAGES, CREATE PACKAGES BODY.
CREATE PACKAGES this creates the definations, list of components, and the
name.
CREATE PACKAGES BODY i
I've been going through functions for my database, originally developed
with version 8.0, and had some odd behavior. I'm in the habit of
putting parentheses around the conditional clauses in IF statements. One
of my trigger functions didn't work, but when the parentheses were deleted, it
d
"Rafael Martinez, Guerrero" <[EMAIL PROTECTED]> writes:
> Why do you think 'intr' is a bad thing, from man pages:
> " If an NFS file operation has a major timeout and it is
> hard mounted, then allow signals to interupt the file operation and
> cause it to return EINTR to the cal
On 5/22/06, karthick muthu <[EMAIL PROTECTED]> wrote:
hello hai,
I am second year computerscience student(engineering),
I am very impressed by you all in asking questions and sending answers,
I am also very proud to be in this group,
now I am willing to do some mini projects(or)softwares from bas
On Mon, 2006-05-22 at 04:12, Rafael Martinez, Guerrero wrote:
> On Mon, 2006-05-22 at 10:25, Greg Stark wrote:
> > Using TCP with NFS is only really helpful when you have a high latency high
> > bandwidth link which isn't going to be a terribly positive environment for
> > postgres.
> >
>
> Well,
Agent M wrote:
I think the implementation of postgresql installable packages (and
package-space) should precede this idea. Then, any package management
system can install the packages.
Having a standardizes package management for postgresql would be great.
I believe one could use schemas to en
Greg,
http://pginstaller.projects.postgresql.org/silent.html
read on there.
best wishes,
Harald
On 5/22/06, Greg <[EMAIL PROTECTED]> wrote:
Hi,
I am creating a Windows Application in .NET that will use PostGreSQL for the
database.
I will be using Installshield to install to my appli
SODA Noriyuki <[EMAIL PROTECTED]> writes:
> On 22 May 2006 03:00:55 -0400, Greg Stark <[EMAIL PROTECTED]> said:
> + gcircle_tbl | t
> + gpolygon_tbl| t
>> This seems pretty mystifying. Perhaps it's leftover stuff from the
>> tablespace that failed to get dropped?
> No.
> Because
Hi,
I am creating a Windows Application in .NET that will use
PostGreSQL for the database.
I will be using Installshield to install to my application, and would like PgSQL to be installed in
the background.
What files/registry entries do I need to
make to have this done?
Thanks
hello hai,
I am second year computerscience student(engineering),
I am very impressed by you all in asking questions and sending answers,
I am also very proud to be in this group,
now I am willing to do some mini projects(or)softwares from basics,so
I need help(ideas) from you all .please give me
Thomas Friedman (NYT editorial writer) mentions
PostgreSQL and EnterpriseDB in his column (published
today in syndication in the hinterlands) about how
outsourcing is helping the economies in many places.
---(end of broadcast)---
TIP 4: Have you se
On Sat, 20 May 2006, Bruno Wolff III wrote:
> I am not sure that Postgres needs CPAN. CPAN is particularly useful for
> handling dependencies. I doubt that there will be lots of dependencies in
> Postgres add ons. So having something like the current system where you
> download and build package
On 5/20/06, Bruno Wolff III <[EMAIL PROTECTED]> wrote:
I am not sure that Postgres needs CPAN. CPAN is particularly useful for
handling dependencies. I doubt that there will be lots of dependencies in
Postgres add ons. So having something like the current system where you
download and build packa
On fös, 2006-05-19 at 12:21 -0700, Siah wrote:
> Some pointers could help. & any arguments pro/against saving bin data
> in db?
pro: backups can be made with pg_dump only.
if binary data is stored in filesystem, your backup
procedure gets more complicated, specially if your
binary files can get
Am Montag, 22. Mai 2006 11:30 schrieb Rafael Martinez, Guerrero:
> Our experience with NFS on linux is that not always works as is suppose
> to do. Yes, it works ok in many cases and yes, it works ok for some type
> of applications but it does not work for the level of reliability and
> integrity w
On a related note, which objects need to be GRANTed specifically?
There is a saying that following objects can have permissions GRANTed:
1. TABLE
2. DATABASE
3. FUNCTION
4. LANGUAGE
5. SCHEMA
6. TABLESPACE
What about SEQUENCE, TRIGGER? PostgreSQL manual has no mention about this.
Thanks.
On 5/2
On Mon, May 22, 2006 at 04:34:34PM +0900, SODA Noriyuki wrote:
> These two "tablespace not empty" results both came from NFS mounts.
> (I should have said that explicitly, sorry.)
> So, this means the REMOVE RPC sometimes may overtake other RPCs?
> Hmm...
Maybe an explicit fsync() is needed on the
On Mon, 2006-05-22 at 11:00, Peter Eisentraut wrote:
> Am Montag, 22. Mai 2006 09:17 schrieb Rafael Martinez, Guerrero:
> > To have a database on a NFS filesystem is a disaster waiting to happen,
> > specially if the NFS server is running on Linux. Not to talk on the
> > performance penalty of runn
On Mon, 2006-05-22 at 10:25, Greg Stark wrote:
> Using TCP with NFS is only really helpful when you have a high latency high
> bandwidth link which isn't going to be a terribly positive environment for
> postgres.
>
Well, having a protocol that by definition says that datagrams may
arrive out of
Am Montag, 22. Mai 2006 09:17 schrieb Rafael Martinez, Guerrero:
> To have a database on a NFS filesystem is a disaster waiting to happen,
> specially if the NFS server is running on Linux. Not to talk on the
> performance penalty of running the database via NFS.
With all due respect, this is a bu
"Rafael Martinez, Guerrero" <[EMAIL PROTECTED]> writes:
> I would say that anything is better than NFS for running a database. But
> if you absolutely have to use NFS, run NFS via TCP not UDP, use hard and
> turn off all cache . In the server side we are talking about 'sync'
> and 'no_wdelay'
> On 22 May 2006 03:00:55 -0400, Greg Stark <[EMAIL PROTECTED]> said:
> That said I would have expected a good NFS server to still live up to
> everything important as long as the server doesn't actually crash or get shut
> down at any point.
> I certainly would have expected tmpfs to live up
On Mon, 2006-05-22 at 06:15, SODA Noriyuki wrote:
Hei
> We've encountered failures of "make check", when we put PostgreSQL
> data directory on a NFS filesystem or a tmpfs filesystem.
> It doesn't always fail, but fails occasionally.
>
To have a database on a NFS filesystem is a disaster waiting
SODA Noriyuki <[EMAIL PROTECTED]> writes:
> NFS server:
> OS version: Fedora Core 3 Linux
> "async" is specified in /etc/exports, thus the server violates
> the NFS protocol, and replys to requests before it stores
> changes to its disk.
The reason the protocol is speced the wa
59 matches
Mail list logo
