> 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 d
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 j
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
> 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: pgsql-hackers@post
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:
http://pgfoundr
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 per
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
andre
> -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_
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 pgAdmi
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 SERIALIZA
> -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
> > 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
> > depe
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 tra
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
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 i
"Dave Page" 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 particular catalog.
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
> 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 al
> -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
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 an
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 en
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, a
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 d
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 bein
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 ey
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 th
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 broadcast)--
Tom Lane <[EMAIL PROTECTED]> writes:
> 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
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
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
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 wh
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 th
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 backup.bz2
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 t
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 integer
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
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?
http://arc
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 [
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 informati
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...
> >>>
> >
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 enu
"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 ha
"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
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:
Me
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 t
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
59 matches
Mail list logo
