[EMAIL PROTECTED] wrote:
Erwin Brandstetter <[EMAIL PROTECTED]> writes:
Wait .. not that great! The system locale is more or less ignored, but
my sort order will approach randomness?
Peter's point is that a given locale setting will expect a particular
encoding, and if you try to use a
Dear Michale..
I am unable to get answer from the link you sent...Just tell me whether
it is possible or not.
In the document they mentioned that . is used as a seperator for a
table/column name...So Is it any way to use dot while creating a
table/database
- Original Message -
From:
> In the document they mentioned that . is used as a seperator for a
> table/column name
I would say for this very reason the answer would be No, but I might be
wrong...
Andy
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner wil
Sandhya,
Hope this will explain, why it is so ...
http://www.postgresql.org/docs/7.4/static/ddl-schemas.html
Kannan
Andy Shellam wrote:
In the document they mentioned that . is used as a seperator for a
table/column name
I would say for this very reason the answer would be No, but I m
On Sat, Mar 25, 2006 at 05:51:13PM -, Andy Shellam wrote:
> As PostgreSQL numbers WALs sequentially, as long as your ls command by
> default orders listings by filename, then Yes. Or you could list by the
> last modified date/time should give the same effect.
But note that the order it create
On Mon, Mar 27, 2006 at 03:03:38PM +0530, sandhya wrote:
> Dear Michale..
> I am unable to get answer from the link you sent...Just tell me whether
> it is possible or not.
> In the document they mentioned that . is used as a seperator for a
> table/column name...So Is it any way to use dot whi
oh.ok
Now, just because you can do this doesn't mean it's a very good idea...
Why?
- Original Message -
From: "Jim C. Nasby" <[EMAIL PROTECTED]>
To: "sandhya" <[EMAIL PROTECTED]>
Cc: "Michael Fuhr" <[EMAIL PROTECTED]>; "Postgres"
Sent: Monday, March 27, 2006 4:08 PM
Subject: Re: [AD
You can throw your computer out of a 10-story window - but just because you
can do it doesn't mean it's a good idea. It's just wrong.
In your particular case it depends on whichever library/ interface/
application you're using to communicate with PG (e.g. PGSQL manager, the
dump and restore tools
On Mon, Mar 27, 2006 at 04:57:29PM +0530, sandhya wrote:
> > > In the document they mentioned that . is used as a seperator for a
> > > table/column name...So Is it any way to use dot while creating a
> > > table/database
> >
> > decibel=# create database "dot.test";
> > CREATE DATABASE
> > decibel
Am Montag, 27. März 2006 10:56 schrieb Erwin Brandstetter:
> Would the system locale of the _server_ OS mess with the sort order? (Or
> with anything at all?)
No.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)--
Peter Eisentraut wrote:
Milen Dzhumerov wrote:
Unfortunately if I try to submit it, it gives me some
error.
You need to post your exact input and the exact output. Otherwise we're
just guessing.
My other
question is who has access to the pg_catalog.* tables?
Everybody.
I was referring to the logs in the archive folder specified when WAL
archiving is turned on...not the pg_xlog folder.
I assume postgres will not use the logs in the archive folder
-Original Message-
From: Jim C. Nasby [mailto:[EMAIL PROTECTED]
Sent: Monday, March 27, 2006 2:35 AM
To: And
On Sat, 2006-03-25 at 23:26 +0200, Devrim GUNDUZ wrote:
> Hi,
>
> On Sat, 2006-03-25 at 20:46 +, Rick Ellis wrote:
> > I forgot to dump before I upgraded to Fedora Core 5 (Postgresql
> > 8.0.x to 8.1.x). Is there an easy way to bring up an 8.0.x server
> > long enough to dump the data?
>
> Do
Amadeus Zilfinski <[EMAIL PROTECTED]> writes:
> I have a similar problem. Had FC4 and PostgresQL installed. Upgraded to
> FC5, and want to use PostgresQL for a bugzilla backend. My problem is
> the same as the parent poster, but rather then save my old data I want
> to delete it. All of it. How wou
On Mon, 2006-03-27 at 20:22 -0500, Tom Lane wrote:
> Amadeus Zilfinski <[EMAIL PROTECTED]> writes:
> > I have a similar problem. Had FC4 and PostgresQL installed. Upgraded to
> > FC5, and want to use PostgresQL for a bugzilla backend. My problem is
> > the same as the parent poster, but rather then
Title: RE: [ADMIN] Feedback on auto-pruning approach
So, I have finally complete this auto-pruning solution. It has proven effective in keeping the size of the db under whichever threshold I set in an unattended fashion.
I have one final question. If my goal is to maximize the amount of h
Dear All, I am totally new to the PostgreSQL. I just installed the PostgreSQL and pgAdmin3 on my Debian system, using the apt-get install command. Apparently, the initial database and the user "postgres" have also been automatically created during the installation. It seems good. But I got b
17 matches
Mail list logo
