Hi all
Thanks for all your responses. I have not yet been able to try your
suggestions as I have access to the system only on tuesday and wednesday. I
will come back and report how it goes.
/Anders
--
View this message in context:
Hi list,
I have the following query:
SELECT *
FROM base
INNER JOIN pt USING (x) WHERE pt.y IN ('1121', '11411', '11421',
'1161', '1162');
explain analyze yields the following result:
QUERY PLAN
Hi all!
I have an UTF8 encoded shapefile, and an UTF8 encoded postgis-enabled
database. I want my shapefile to be encoded in WIN1252, and a particular
field to be in uppercase.
Since I am on windows, I don't have an iconv executable. Therefore, I am
trying to :
- dump the shapefile with
On 16/10/2009 10:36, Arnaud Lesauvage wrote:
I have an UTF8 encoded shapefile, and an UTF8 encoded postgis-enabled
database. I want my shapefile to be encoded in WIN1252, and a particular
field to be in uppercase.
Since I am on windows, I don't have an iconv executable. Therefore, I am
Does that last query (invoking the upper() function) actually run well when
executed in pgsql console?
Rob
2009/10/16 Arnaud Lesauvage arnaud.lis...@codata.eu
Hi all!
I have an UTF8 encoded shapefile, and an UTF8 encoded postgis-enabled
database. I want my shapefile to be encoded in
Raymond O'Donnell a écrit :
If it's any help to you, you can get iconv (and a bunch of other helpful
stuff) from GnuWin32:
http://gnuwin32.sourceforge.net/
Thanks for your help Raymond.
I tried iconv but I have other problems now.
I still have to load the file into postgresql because the
Is there any reason, why I can't put quotes around name of savepoint, but I
have/can do this for prepare transaction ?
Ie:
SAVEPOINT 'foo'; --- doesn't work
SAVEPOINT foo; --- all grand
PREPARE TRANSACTION 'foo'; --- grand
PREPARE TRANSACTION foo; refuses to work.
It is quite confusing, I feel
On 16 Oct 2009, at 10:59, Christian Schröder wrote:
Hi list,
I have the following query:
SELECT *
FROM base
INNER JOIN pt USING (x) WHERE pt.y IN ('1121', '11411', '11421',
'1161', '1162');
explain analyze yields the following result:
Arnaud Lesauvage a écrit :
But then, if I dump it through a query to have my field in uppercase, I
get an error 'character 0xc29f of encoding UTF8 has no equivalent in
WIN1252' (translated by myself, the message is in French)
The command is simply :
pgsql2shp -f myouput.shp -u postgres -g
=?UTF-8?Q?Grzegorz_Ja=C5=9Bkiewicz?= gryz...@gmail.com writes:
Is there any reason, why I can't put quotes around name of savepoint, but I
have/can do this for prepare transaction ?
Savepoint names are identifiers; the SQL spec says so. Prepared
transaction GIDs are string literals. The
Alban Hertroys dal...@solfertje.student.utwente.nl writes:
I'm also somewhat surprised to see an array of what appear to be
integers be cast to bpchar[]. Did you define those coordinates(?) as
character types? Numerical comparisons tend to be faster than string
comparisons, which should
2009/10/16 Tom Lane t...@sss.pgh.pa.us
=?UTF-8?Q?Grzegorz_Ja=C5=9Bkiewicz?= gryz...@gmail.com writes:
Is there any reason, why I can't put quotes around name of savepoint, but
I
have/can do this for prepare transaction ?
Savepoint names are identifiers; the SQL spec says so. Prepared
I would do this last query searching for the 0xC29F character WITHOUT the
upper() function on the source table, in the native (to table) UTF8 client
encoding. No result either?
Rob
2009/10/16 Arnaud Lesauvage arnaud.lis...@codata.eu
Arnaud Lesauvage a écrit :
But then, if I dump it through a
Hi,
We are running with postgres sql 7.3.2. We were trying to create an
index on a big table. The create index command ran for nearly 5 hours at
which point we decided to interrupt it. Since this was interrupted, any
operations attempted on the table on which the index was being created
gives
Tom Lane wrote:
Viktor Rosenfeld listuse...@googlemail.com writes:
I can't find the documentation of the ~=~ operator anywhere on the
PostgreSQL homepage.
Which version's documentation are you reading? It's gone as of 8.4.
I realize that, but I have to use 8.3 right now and can't find
On Fri, Oct 16, 2009 at 11:26 AM, Neha Patel npa...@nevi-soft.com wrote:
Hi,
We are running with postgres sql 7.3.2. We were trying to create an index
on a big table. The create index command ran for nearly 5 hours at which
point we decided to interrupt it. Since this was interrupted, any
On Fri, Oct 16, 2009 at 11:26:40AM +0100, Neha Patel wrote:
Hi,
We are running with postgres sql 7.3.2.
Whatever you thought your most urgent priority was, it's actually
getting your database off of a major version of PostgreSQL, 7.3, whose
end-of-life was well over a year ago.
Your second
Hi David,
Many thanks for your reply. After good 10 hours of work we managed to
restore from a backup.
Regards
Neha
-Original Message-
From: David Fetter [mailto:da...@fetter.org]
Sent: 16 October 2009 17:28
To: Neha Patel
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL]
Neha Patel wrote:
Hi,
We are running with postgres sql 7.3.2. We were trying to...
well, right off the bat, thats a -really- old version. Release notes
say February 2003. 7.3 was updated to 7.3.21, and we're currently on
8.4 (while still supporting 8.3, 8.2, 8.1, and 7.4).There
I am trying to move databases to another macine (and update from 8.2
to 8.4 along the way). I first tried pg_dumpall, but I found that one
of the data bases did not restore and data, just an empty db with no
tables. Since then I have tried pg_dump with the following:
bash-3.2$
2009/10/16 Kirk Wythers kwyth...@umn.edu:
I am trying to move databases to another macine (and update from 8.2 to 8.4
along the way). I first tried pg_dumpall, but I found that one of the data
bases did not restore and data, just an empty db with no tables. Since then
I have tried pg_dump with
Hey everyone,
I apologize in advance for going slightly off topic, but I have never
setup a centralized authentication scheme under Linux. My question is,
what do most people do for centralized command line, X, and PG
authentication? From what I've read the main choices are NIS or LDAP.
LDAP
On Fri, Oct 16, 2009 at 2:38 PM, Scot Kreienkamp skre...@la-z-boy.comwrote:
Hey everyone,
I apologize in advance for going slightly off topic, but I have never setup
a centralized authentication scheme under Linux. My question is, what do
most people do for centralized command line, X,
These are all RH4 and 5, so they do all have PAM. I thought PAM had to
interface with something else, which is where NIS and LDAP enter the
picture, to authenticate to another server though. Otherwise I'm not
sure how it works?
Thanks,
Scot Kreienkamp
skre...@la-z-boy.com
From:
I just realized that my replies to my previous question on sparse
arrays went off list due to the way this list server is set up
(sigh). It has occurred to me that for my problem, one possible
solution is columnar indexes and that, in a way, partitioned tables in
Postgres might give me somewhat
On 16/10/2009 19:38, Scot Kreienkamp wrote:
Hey everyone,
I apologize in advance for going slightly off topic, but I have never
setup a centralized authentication scheme under Linux. My question
is,
what do most people do for centralized command line, X, and PG
authentication? From
On Oct 6, 2009, at 2:57 PM, Oleg Bartunov wrote:
this is an announcement of our new contribution module for
PostgreSQL - Plantuner - enable planner hints
(http://www.sai.msu.su/~megera/wiki/plantuner).
=# set enable_seqscan=off;
=# set plantuner.forbid_index='id_idx2';
Out of curiosity,
On Oct 12, 2009, at 1:21 PM, Erik Jones wrote:
On Oct 9, 2009, at 9:57 AM, Takeichi Kanzaki Cabrera wrote:
Hi everybody, I need your help. I have a hierarchy of tables, and
other table that has a foreign key with the top table of the
hierarchy, can I insert a value into the other table where
On Oct 16, 2009, at 10:04 AM, decibel wrote:
Out of curiosity, did you look at doing hints as comments in a query?
I don't think that a contrib module could change the grammar.
--
-- Christophe Pettus
x...@thebuild.com
--
Sent via pgsql-general mailing list
On Fri, Oct 16, 2009 at 9:19 PM, Peter Hunsberger
peter.hunsber...@gmail.com wrote:
The basic problem I have is that I have some tables that are
potentially very long (100,000's to millions of rows) and very skinny,
and I end up with maybe a total of 12 bits of data in each row.
Are You
On Fri, 2009-10-16 at 12:04 -0500, decibel wrote:
I'm guessing you couldn't actually do that in just a contrib module,
but it's how Oracle handles hints, and it seems to be *much* more
convenient, because a hint only applies for a specific query.
If that's the only reason, that seems easy
On 16/10/2009 19:38, Scot Kreienkamp wrote:
Hey everyone,
I apologize in advance for going slightly off topic, but I have never
setup a centralized authentication scheme under Linux. My question is,
what do most people do for centralized command line, X, and PG
authentication? From
On Fri, 2009-10-16 at 11:26 +0100, Neha Patel wrote:
We are running with postgres sql 7.3.2. We were trying to create an
index on a big table. The create index command ran for nearly 5 hours
at which point we decided to interrupt it. Since this was interrupted,
any operations attempted on the
On Fri, Oct 16, 2009 at 3:31 PM, marcin mank marcin.m...@gmail.com wrote:
On Fri, Oct 16, 2009 at 9:19 PM, Peter Hunsberger
peter.hunsber...@gmail.com wrote:
The basic problem I have is that I have some tables that are
potentially very long (100,000's to millions of rows) and very skinny,
On Fri, Oct 16, 2009 at 11:25 AM, Kirk Wythers kwyth...@umn.edu wrote:
Any ideas what the problem could be here?
Use the pg_dump from the target (i.e. newer) pgsql. I.e. if going
from 8.3.8 to 8.4.1, use the pg_dump that comes with 8.4.1 to dump the
8.3.8 database.
I usually just do it like
Scot Kreienkamp skre...@la-z-boy.com writes:
On 16/10/2009 19:38, Scot Kreienkamp wrote:
... We are a largely Windows shop with many app and
database servers running Linux. The Linux environment is growing too
large not to do centralized authentication of some kind.
So I guess what I see
2009/10/17 Tom Lane t...@sss.pgh.pa.us:
If you decide to go with this approach and use PAM as intermediary,
you'll need the patch I just committed in response to bug #5121 --- it
turns out nobody had ever tried that with Postgres before :-(. But
I think it's also possible to just use PG's
Is this the right place to post this?
I set up the same characteristics on the console, and it runs fine, (COPY
commands will import back, right? That's what it output.)
On the console, it was:
pg_dump -vaF p -f dbase.sql -U user-name dbase-name
More details:
about 11 tables, practically
On Oct 16, 2009, at 4:51 PM, Scott Marlowe scott.marl...@gmail.com
wrote:
On Fri, Oct 16, 2009 at 11:25 AM, Kirk Wythers kwyth...@umn.edu
wrote:
Any ideas what the problem could be here?
Use the pg_dump from the target (i.e. newer) pgsql. I.e. if going
from 8.3.8 to 8.4.1, use the
On Fri, Oct 16, 2009 at 10:04 AM, decibel deci...@decibel.org wrote:
Out of curiosity, did you look at doing hints as comments in a query? I'm
guessing you couldn't actually do that in just a contrib module, but it's
how Oracle handles hints, and it seems to be *much* more convenient, because
On Oct 12, 2009, at 1:21 PM, Erik Jones wrote:
On Oct 9, 2009, at 9:57 AM, Takeichi Kanzaki Cabrera wrote:
Hi everybody, I need your help. I have a hierarchy of tables, and
other table that has a foreign key with the top table of the
hierarchy, can I insert a value into the other table where
Hmm would this be a bad time to ask for PostGres 1.0 support?
On Fri, Oct 16, 2009 at 1:55 PM, Jeff Davis pg...@j-davis.com wrote:
On Fri, 2009-10-16 at 11:26 +0100, Neha Patel wrote:
We are running with postgres sql 7.3.2. We were trying to create an
index on a big table. The create index
42 matches
Mail list logo