Here I found an installation issue:
- I was installing pg 8.1 on a Windows 2000 box.
- I chose a different folder than default (D:\PGSERVER did
not exist yet)
- When installing, the setup complained about not being able
to write into the directory
- I check the directory
I fixed path in pg_sphere (and done some more clean up).
BTW, I usially install contrib modules before restoring database (of course, it
need to dump db without content of modules)...
--
Teodor Sigaev E-mail: [EMAIL PROTECTED]
Christopher Kings-Lynne wrote:
Anyone know how I can turn off these emails to the pgsql committer's
list?
Well, each pgfoundry project can turn it off if they like - it's driven
from their CVSROOT - I think it's the loginfo or commitinfo file.
But if you don't want to see them, why not
This one is quite long, but I guess the quality of the answer depends on
the quality of the question :).
I use views to simplify the underlying database schema for the end
users. The end do however still like to know about relations. Here is a
very simple example:
CREATE TABLE t_orgs (
On 11/9/05, Tom Lane [EMAIL PROTECTED] wrote:
Alvaro Herrera [EMAIL PROTECTED] writes:
Jaime Casanova wrote:
ok, i execute 'make distclean' and then get the same error when making
after configuring with --with-perl
Is this a clean source tree? Try cvs update -C (beware it'll destroy
Are you talking about make install, initdb, or somethingi else?
Not just the windows setup MSI. Without permissions to everyone it won't
install
-Original Message-
From: Kevin Grittner [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 10, 2005 12:28 AM
To:
Fredrik Olsson wrote:
Have I misunderstood the concept of pg_depend? Can it even be used for
what I intend, and if not in what direction should I be searching next?
I'd take a few minutes to investigate the new-sys-views project and see
if they've got anything you can steal:
Gevik,
this list is the wrong place to discuss this - please ask on the
installer project site on the link I gave in an earlier reply.
cheers
andrew
Gevik Babakhani wrote:
Are you talking about make install, initdb, or somethingi else?
Not just the windows setup MSI. Without
contains the following:
/*
* initial contents of pg_proc
*
*/
/* keep the following ordered by OID so that later changes can be made
easier */
which has manifestly not been followed. Should we fix the file or remove
the second comment?
cheers
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Andrew Dunstan
Sent: 10 November 2005 14:30
To: PostgreSQL-development
Subject: [HACKERS] pg_proc.h
contains the following:
/*
* initial contents of pg_proc
*
My dev box was running 8.1rc1 and I thought it was time to put 8.1 on
it. I downloaded the 8.1 binaries-only dist off of postgresql.org (bt
version), did a binary swap on my server and nothing ran...it turns out
all the binaries like initdb.exe, postgres.exe have a dll dependency on
various
Tom Lane wrote:
http://candle.pha.pa.us/main/writings/pgsql/sgml/sql-set-transaction.html
http://candle.pha.pa.us/main/writings/pgsql/sgml/transaction-iso.html
It's a bit amusing that this person is dissing us for not having
REPEATABLE READ, when what he actually seems to want is
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Merlin Moncure
Sent: 10 November 2005 14:56
To: pgadmin-hackers@postgresql.org
Cc: pgsql-hackers@postgresql.org
Subject: [HACKERS] win32 8.1 pgadmin dll issues
My dev box was running 8.1rc1
My dev box was running 8.1rc1 and I thought it was time to put 8.1
on
it. I downloaded the 8.1 binaries-only dist off of postgresql.org
(bt
version), did a binary swap on my server and nothing ran...it
turns out
all the binaries like initdb.exe, postgres.exe have a dll
dependency on
On Thu, 10 Nov 2005, Tony Caduto wrote:
Serializable is stricter and somehwat unusable in a multi-user, loaded
database, because only one transaction can run at any time. Let's say you
would have one long running serializable transaction encapsulating a
reporting query, this will cause other
Fredrik Olsson [EMAIL PROTECTED] writes:
Have I misunderstood the concept of pg_depend? Can it even be used for
what I intend, and if not in what direction should I be searching next?
What you missed is that the per-column dependencies you are looking for
go from the view's rewrite rule to the
Andrew Dunstan [EMAIL PROTECTED] writes:
contains the following:
/* keep the following ordered by OID so that later changes can be made
easier */
which has manifestly not been followed. Should we fix the file or remove
the second comment?
Reordering the file into strict OID order is
Dave Page dpage@vale-housing.co.uk writes:
I vote for fixing the file (but then I'm not doing the work).
Unused_oids or whatevers it's called is fine, but it's still handy to be
able to read the file easily.
Our convention is that hand-assigned OIDs are *globally* unique,
not just within the
Tony Caduto [EMAIL PROTECTED] writes:
Tom,
This is what the firebird guy said:
Serializable is stricter and somehwat unusable in a multi-user, loaded
database, because only one transaction can run at any time.
He's already demonstrated that he has no clue what he's talking about,
so I think
My dev box was running 8.1rc1 and I thought it was time to
put 8.1 on it. I downloaded the 8.1 binaries-only dist off
of postgresql.org (bt version), did a binary swap on my
server and nothing ran...it turns out all the binaries like
initdb.exe, postgres.exe have a dll dependency on
On Thu, Nov 10, 2005 at 04:24:46PM +0100, Magnus Hagander wrote:
My dev box was running 8.1rc1 and I thought it was time to
put 8.1 on it. I downloaded the 8.1 binaries-only dist off
of postgresql.org (bt version), did a binary swap on my
server and nothing ran...it turns out all the
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Martijn van Oosterhout
Sent: 10 November 2005 15:42
To: Magnus Hagander
Cc: Merlin Moncure; pgadmin-hackers@postgresql.org;
pgsql-hackers@postgresql.org
Subject: Re: [HACKERS] win32 8.1 pgadmin
I am looking at creating a few generic functions builtin for the enum
stuff. These would be tied to each enum type as it is created. However,
they should not really appear in pg_proc initially, as there wouldn't be
any enum types to tie them to anyway. But I want them to have reserved
oids
On Thu, Nov 10, 2005 at 12:02:58PM -0500, Andrew Dunstan wrote:
I am looking at creating a few generic functions builtin for the enum
stuff. These would be tied to each enum type as it is created. However,
they should not really appear in pg_proc initially, as there wouldn't be
any enum
Martijn van Oosterhout wrote:
On Thu, Nov 10, 2005 at 12:02:58PM -0500, Andrew Dunstan wrote:
I am looking at creating a few generic functions builtin for the enum
stuff. These would be tied to each enum type as it is created. However,
they should not really appear in pg_proc initially,
On Wed, 2005-11-09 at 14:20 -0500, Tom Lane wrote:
Rod Taylor [EMAIL PROTECTED] writes:
As you can see, we have duplicates within the table (heap) of a primary
key value. The index itself only references one of these tuples.
Can you put together a test case to reproduce this? It doesn't
Andrew Dunstan [EMAIL PROTECTED] writes:
I am looking at creating a few generic functions builtin for the enum
stuff. These would be tied to each enum type as it is created. However,
they should not really appear in pg_proc initially, as there wouldn't be
any enum types to tie them to
Tom Lane wrote:
Andrew Dunstan [EMAIL PROTECTED] writes:
I am looking at creating a few generic functions builtin for the enum
stuff. These would be tied to each enum type as it is created. However,
they should not really appear in pg_proc initially, as there wouldn't be
any enum types
Andrew Dunstan [EMAIL PROTECTED] writes:
What I want to have is some builtin functions that can be used as the
input/output/cast/etc functions for each enum type.
The hard part of that is going to be figuring out how to get the
information to the functions about which enum type they're being
Hello,
how can i make a checkout from CVS server ? What is the address?
Thanks,
Gustavo
On Thu, 2005-10-11 at 15:22 -0300, Gustavo Tonini wrote:
how can i make a checkout from CVS server ? What is the address?
http://www.postgresql.org/developer/sourcecode/
-Neil
---(end of broadcast)---
TIP 4: Have you searched our list archives?
Hi Tony,
As the referenced documentation states, the PostgreSQL SERIALIZABLE
transaction isolation level complies with the ANSI/ISO requirements, but
not with a mathematically pure interpretation of the term. (The only
quibble I have with that documentation is that you have to be averting
your
I've also modified the Makefile. I removed the special .sql.in : .sql implicit
rule and re-organized the Makefile. I didn't commit as it was after 12:00pm
when I finished...
I'll send you what I did when I return home. If you just replaced the $libdir
with $$libdir, then a merge will be easy.
FYI, I am looking into all the reports of pgindent failures and will
have those fixed and a sample re-run diff posted in a few days.
---
Chuck McDevitt wrote:
Pgindent adds spaces after the stars if it doesn't recognize
On Thursday 10 November 2005 10:22, Gustavo Tonini wrote:
Hello,
how can i make a checkout from CVS server ? What is the address?
You can find all the information you need to know about how to check pgsql out
of cvs at: http://www.postgresql.org/developer/sourcecode/
Thanks,
Gustavo
--
Just a point of attention... Perhaps one is interested to fix this (if it is
a bug);
Um, so what actually is the problem?
//Magnus
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
If you mean that you have to grant permissions, that's already in the
FAQ.
//Magnus
Just a point of attention... Perhaps one is interested to fix
this (if it is a bug);
Um, so what actually is the problem?
//Magnus
---(end of
Greg Stark [EMAIL PROTECTED] writes:
Maybe my conception of enums is different from yours. My conception is
basically that of C enums. Where they're purely a creature of the syntax and
type system. At run-time they don't make any effort to prevent you from
treating them as integers.
Well, C
On Thu, Nov 10, 2005 at 01:15:07PM -0500, Tom Lane wrote:
Andrew Dunstan [EMAIL PROTECTED] writes:
What I want to have is some builtin functions that can be used as the
input/output/cast/etc functions for each enum type.
The hard part of that is going to be figuring out how to get the
On Thu, 2005-11-10 at 11:00 -0800, Darcy Buskermolen wrote:
On Thursday 10 November 2005 10:22, Gustavo Tonini wrote:
Hello,
how can i make a checkout from CVS server ? What is the address?
You can find all the information you need to know about how to check pgsql
out
of cvs at:
Tom Lane wrote:
Andrew Dunstan [EMAIL PROTECTED] writes:
What I want to have is some builtin functions that can be used as the
input/output/cast/etc functions for each enum type.
The hard part of that is going to be figuring out how to get the
information to the functions about
Andrew Dunstan [EMAIL PROTECTED] writes:
My idea was to have the functions that need access to the text values
look up fcinfo-flinfo-fn_oid and then use that to look up the type
info. But that would mean we would need pg_proc entries for these
functions for each enum, even if it's the same
I have an interesting situation...am staging a mock upgrade from 8.0 to
8.1 on a bzip compressed backup image from one of our production
servers. The dump image is big (270 mb compressed) and so is the file
in question ~ 440k rows.
Am piping the backup image to the server via
psql -cd
On Thu, Nov 10, 2005 at 03:28:55PM -0500, Andrew Dunstan wrote:
Eek! I would be prepared to go to quite a lot of trouble to avoid that.
My idea was to have the functions that need access to the text values
look up fcinfo-flinfo-fn_oid and then use that to look up the type
info. But that
Greg Stark wrote:
I know the tendency has been to want to discourage implicit casts, but I think
this is a good use for them. The whole point of enums is to have syntactic
sugar over integers that let you use nicer syntax but that imposes minimal
additional complexity over simply using
Andrew Dunstan [EMAIL PROTECTED] writes:
Well, for one thing, I have no plan to allow explicit setting of the internal
representational value, as one can do in C. And the fact that it's an int
underneath is in implementation detail, IMNSHO. After all, KL just advised
using a text domain with
Tom Lane wrote:
I'm not convinced that using bigint-equivalent space for an enum is a
mortal sin...
at least venial ...
cheers
andrew
---(end of broadcast)---
TIP 4: Have you searched our list archives?
On Thu, Nov 10, 2005 at 04:08:29PM -0500, Andrew Dunstan wrote:
Tom Lane wrote:
I'm not convinced that using bigint-equivalent space for an enum is
a mortal sin...
at least venial ...
Heh.
Would ORDER BY somehow know about enums' given ordering?
Cheers,
D
--
David Fetter [EMAIL
On Thu, 2005-11-10 at 15:23, Joshua D. Drake wrote:
On Thu, 2005-11-10 at 11:00 -0800, Darcy Buskermolen wrote:
On Thursday 10 November 2005 10:22, Gustavo Tonini wrote:
Hello,
how can i make a checkout from CVS server ? What is the address?
You can find all the information you need
David Fetter wrote:
On Thu, Nov 10, 2005 at 04:08:29PM -0500, Andrew Dunstan wrote:
Tom Lane wrote:
I'm not convinced that using bigint-equivalent space for an enum is
a mortal sin...
at least venial ...
Heh.
Would ORDER BY somehow know about enums' given ordering?
On Thu, Nov 10, 2005 at 05:26:45PM -0500, Andrew Dunstan wrote:
David Fetter wrote:
On Thu, Nov 10, 2005 at 04:08:29PM -0500, Andrew Dunstan wrote:
Tom Lane wrote:
I'm not convinced that using bigint-equivalent space for an enum is
a mortal sin...
at least venial ...
Heh.
Tom Lane said:
Andrew Dunstan [EMAIL PROTECTED] writes:
My idea was to have the functions that need access to the text values
look up fcinfo-flinfo-fn_oid and then use that to look up the type
info. But that would mean we would need pg_proc entries for these
functions for each enum, even if
Andrew Dunstan [EMAIL PROTECTED] writes:
What about having the calling code fill in the io type oid in an extra field
in the flinfo?
I don't think that's workable; for one thing there's the problem of
manual invocation of the I/O functions, which is not going to provide
any such special hack.
Merlin Moncure [EMAIL PROTECTED] writes:
When the dump gets to the point where the indexes/keys are built, the
primary key fails to build due to duplicate key constraint failure.
However, after dump is complete, I can create the p-key without any
modification to the table and everything is
I just make postgresql 8.1 rpm for mandriva and I was making basic test. I
made in pgfoundry the module pgrpm (rpm function in postgres).
However after installing postgresql 8.1 I have:
ERREUR: unable to load library
«/usr/lib64/pgsql/pgrpm.so»: /usr/lib64/pgsql/pgrpm.so: undefined symbol:
On Thu, Nov 10, 2005 at 12:00:12 -0600,
Kevin Grittner [EMAIL PROTECTED] wrote:
Hi Tony,
As the referenced documentation states, the PostgreSQL SERIALIZABLE
transaction isolation level complies with the ANSI/ISO requirements, but
not with a mathematically pure interpretation of the term.
On Thu, 10 Nov 2005, Tom Lane wrote:
When the dump gets to the point where the indexes/keys are built, the
primary key fails to build due to duplicate key constraint failure.
That's pretty bizarre. What's the datatype of the key column(s)?
There was one guy on IRC that had the same
Tom Lane wrote:
Fredrik Olsson [EMAIL PROTECTED] writes:
Have I misunderstood the concept of pg_depend? Can it even be used for
what I intend, and if not in what direction should I be searching next?
What you missed is that the per-column dependencies you are looking for
go from the
58 matches
Mail list logo
