ows can be accessed with one page
access (to the heap) why should it use an index?
--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
t i am getting only
> size 9213 MB.
>
> Dont know, what exactly happend?
Well, you could narrow the possibilities by restoring that dump to
an 8.4 database and see how big that is. Some major releases have
improved the storage formats for some data types, like numeric; but
you might just b
ing:
REINDEX DATABASE '"PremierIEX"'
--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
"pc...@contigo.com" wrote:
> Anyway to tell what went wrong from the memory dump?
I would start by looking for the biggest "total" allocation.
--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
--
Sent via pgsql-bugs mailing list (pg
ger column, it but can be coerced to
work with a properly normalized relational database with a little
effort. In my experience it's worth the effort.
--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
--
Sent via pgsql-bugs mailing list (pgsql-bug
Tom Lane wrote:
> Kevin Grittner writes:
>> It occurs to me that the behavior you are seeing would be
>> consistent with 945 being considered an uppercase letter, with
>> 60536 being considered its lowercase form. Normal PostgreSQL
>> case-folding of identifiers w
Kevin Grittner wrote:
> Whether it is a bug in Windows or in PostgreSQL character-
> handling under Windows I can say myself, since I haven't
> had any reason to use Windows for years.
Er, that should have been I *can't* say.
>> create or replace function α(β int, ξ in
ame) = 1;
ascii | proname
---+-
945 | α
(1 row)
test=# select ascii('α');
ascii
---
945
(1 row)
test=# select proname from pg_proc where proname = 'α';
proname
-
α
(1 row)
--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL
his is supposed to make things faster, but all the bugs might not
be out of it yet.
--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
9:16:38 WARNING: could not create listen socket for "127.0.0.1"
> 2013-07-24 19:16:38 FATAL: could not create any TCP/IP sockets
Is another postmaster running on port 5432?
You could run any or all of these statements to get insight into that:
lsof -i4TCP@127.0.0.1:5432
netstat -plnt |
"g.bakalar...@icm.edu.pl" wrote:
> Kevin Grittner wrote:
>> "g.bakalar...@icm.edu.pl" wrote:
>>
>>> When doing these kind of statements
>>
>>> execute : CREATE TEMPORARY TABLE [...]
>>
>>> After few days [...] my huge s
into action - it usually kills one of
> postgres processes - postmaster restart all databases) and after
> all linux has again some 100GB of not commited memory
What do you have as settings for temp_buffers and max_connections?
--
Kevin Grittner
EDB: http://www.enterprisedb.com
Th
3.2) and (3.2 / 2), respectively.
--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
ow.
> You should use a newer version.
Most definitely.
--
Kevin Grittner
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
art of a decimal fraction when you can't
draw a line over those digits?)
In the absence of such a type, you might want to arrange your
calculations such that any division or square root calculations
are done last. That way the effect of the truncation of the
repeating (or not) infinite decimal
> )
> WITH (OIDS=FALSE)
> ;
> CREATE INDEX IX_FullText_2 ON "User_Full_Text_Search_2"
> USING gin("tsv");
> I don't understand why a materialized column is more slow than a
> calculeted one...
Try materia
upgraded with pg_dump (or some
other logical population of the data, versus a pg_upgrade run) you
are probably getting bitten by the initial setting of hint bits.
http://wiki.postgresql.org/wiki/Hint_Bits
See if it is still slow after that
--
Kevin Grittner
EnterpriseDB: http://www.enterpr
David Johnston wrote:
> varchar(100)
> The other option to index words via the full-text search capabilities.
Or for columns this short, a similarity search on a trigram index.
http://www.postgresql.org/docs/current/interactive/pgtrgm.html
--
Kevin Grittner
EnterpriseDB
name SET STORAGE MAIN;
http://www.postgresql.org/docs/9.0/interactive/sql-altertable.html
http://www.postgresql.org/docs/9.0/interactive/storage-toast.html
--
Kevin Grittner
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
--
Sent via pgsql-bugs mailing list (pgsql-bug
pdate table_A set situation='Waiting' where id='23';
UPDATE 1
test=# select * from table_a;
id | situation
+---
23 | Waiting
(1 row)
test=# select * from table_b;
id | sitation | when
+--+--------
23
iple directory entries to point
to the same data location. Until you delete the last directory
entry the file remains.
--
Kevin Grittner
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your
idn't happen
...
The file is delete_old_cluster.sh on most platforms. The suffix is
.bat on Windows.
It can be run anytime after the upgrade *as long as you have not
moved the new cluster to the old location*.
Thanks to Bruce Momjian for telling me in chat when I asked just now.
--
Ke
consultation was very
> slow, taking almost the time of the query without LIMIT and
> OFFSET.
You should probably use a cursor instead of LIMIT and OFFSET.
--
Kevin Grittner
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
--
Sent via pgsql-bugs mailing list (p
modify
or truncate any of the hard-linked files, as they are quite likely
to still be just another name for the same file that is in use for
production under the newer version. You want to simply remove the
older directory entry pointing to the file.
http://www.linfo.org/hard_link.html
--
Kevi
uding all files
which start with a filename you derived from pg_class and has a dot
or underscore followed by more characters?
--
Kevin Grittner
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make chan
g depends more on the number
of database objects than their size.)
http://www.postgresql.org/docs/9.1/interactive/pgupgrade.html
--
Kevin Grittner
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To
James R Skaggs wrote:
> Agreed, we shouldn't have so many dead rows. Our autovacuum is
> set on but has default parameters. We are clustering today.
> This, of course, means downtime and inconvenience to the users.
Right, which is why it's important to figure out why the bloat
happened. Som
"jim...@seagate.com" wrote:
> INFO: analyzing "public.stream_file"
> INFO: "stream_file": scanned 3 of 2123642 pages, containing
> 184517 live rows and 2115512 dead rows; 3 rows in sample,
> 158702435 estimated total rows
184517 live rows in 3 randomly sampled pages out of 2123642
"m...@fontling.com" wrote:
> Documentation for the SQL UPDATE statement doesn't mention that
> it sets the FOUND variable. (Refer to sql-update.html,
> "Outputs".) That behavior *is* documented, but only in
> plpgsql-statements.html (Basic Statements, section 39.5.5).
>
> I understand the differe
Bruce Momjian wrote:
> On Thu, Jan 24, 2013 at 08:43:37PM -0300, Alvaro Herrera wrote:
>> Bruce Momjian escribió:
>>> On Tue, Sep 4, 2012 at 02:01:54PM -0400, Bruce Momjian wrote:
>>>> On Tue, Sep 4, 2012 at 12:49:40PM -0500, Kevin Grittner wrote:
>>>>&g
alessan...@nwsoftware.com.br wrote:
> I use PostgreSQL 9.0.6 and I´m with a problem using PostgreSQL with external
> network, by internet (cloud).
>
> If the user open the application and don´t use the application by minutes,
> the connection with database is lost, but if the user to use applicat
tsunez...@efficlabo.com wrote:
> Rotation of the log is not carried out.
>
> "log_rotation_size" is not effective.
We need more details.
http://wiki.postgresql.org/wiki/Guide_to_reporting_problems
-Kevin
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to yo
Andres Freund wrote:
> On 2013-01-12 14:29:38 -0500, Tom Lane wrote:
>> "Kevin Grittner" writes:
>>> To try to get your function code to work as you expect, the
>>> language would essentially need to identify which statements could
>>> be pre-planne
Rodrigo Rosenfeld Rosas wrote:
> I'm curious though. Why wouldn't this behavior be considered a
> bug? Is there any link to previous discussions about this subject
> that I could read?
A plpgsql function generates a plan on initial execution which
chooses which particular tables are used. On subs
Rodrigo Rosenfeld Rosas wrote:
> Tom Lane wrote:
>> There have been discussions about changing that
> if I understand it correctly, you do consider it a bug but you
> don't want to backport a fix because it might break existent
> behavior in some dbs, right?
No, there has been discussion about w
paul.wat...@zephyr-consulting.com wrote:
> [...] --pgdata="C:\Program Files\PostgreSQL\9.2\data2"
> The files belonging to this database system will be owned by user
> "pwatson".
> This user must also own the server process.
> fixing permissions on existing directory C:/Program
> Files/PostgreSQL
liebehenz wrote:
> a_name (char var 48) is sometimes empty in the select of the new 9.2.2
> Version,
>
> the a_name is in the table column set.
>
> Something is going wrong.
> here in screenshot same identical database on 9.2.1 Server and 9.2.2 Server
Character-based results are preferred on a
Sumit kumar sharma wrote:
> I have downloaded 9.2 version but I am unable to install postgres
> sql in windows 8 please fix it as soon as possible.
Please provide details.
http://wiki.postgresql.org/wiki/Guide_to_reporting_problems
-Kevin
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postg
Rogelio Monter wrote:
> In my company, we're using Postgresql 8.0.0 beta 5 since the
> company started to implement databases.
> Win 2000 Server
Version 8.0 is years out of support, support for it and 8.1 on
Windows was dropped years earlier than for other platforms because
there were problems w
p.ela...@gmail.com wrote:
> Description:
>
> subj
This is not a bug report. You might try posting on the
pgsql-general list. If you want any useful response, you need to
provide a little more detail.
-Kevin
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to y
Branka Stancic wrote:
> I using command pg_restore
> get an error: pg_restore: [archiver] input file appears to be a
> text format dump. Please use psql
pg_restore is not used for restoring text files; psql is. If you
want to use pg_restore you should use -Fc when you run pg_dump. At
this point,
This is not a bug report. Next time post to a more appropriate list.
http://www.postgresql.org/community/lists/
JEHAD GHAREEB wrote:
> I want to install "PG 7.3.4"
That version has been out of support for over five years.
http://www.postgresql.org/support/versioning/
Unless you're writing a h
This is not a bug report. Please post any future questions to a
more appropriate list:
http://www.postgresql.org/community/lists/
Duggirala, Manikanth (TCS) wrote:
> Can you please let us know if PostgreSQL v8.1.11 is compatible
> with OS 2008 R2 ?
No, it's not.
Problems with PostgreSQL versio
louis-claude.ca...@univ-fcomte.fr wrote:
> In the first paragraph of Section 13.2.1, it is first stated that
> "[with] this isolation level, a SELECT query [...] never sees [...]
> changes committed during query execution by concurrent
> transactions." It is my understanding that this is untrue (a
Tom Lane wrote:
> plus some not-very-large CPU-per-tuple charges
In my experience, cpu_tuple_cost should be higher. I've often had to
boost it to get good plans for a wide mix of queries in a load.
Doubling it to 0.02 is often not enough to get good plans. I've taken
it to 0.05 with production wo
ronnydobbelste...@yahoo.com wrote:
> I changed the font in pgAdmin III UI Maintenance to one that makes
> the program crash. I have re installed the total package and after
> that separately pgAdmin but it picks up the same font and thus
> crashes again. Can not change font; when I press options t
wrote:
> test=# explain select max(a.info)from sli_test a where a.id not
> in(select b.id from sli_test2 b where b.id<5);
> Aggregate (cost=9241443774.00..9241443774.01 rows=1 width=12)
A slower plan for NOT IN than NOT EXISTS is a fact, but definitely
not a bug. According to the stan
wrote:
> PostgreSQL version: 9.0.1
> Operating system: Windows Server 2012
> I have a folder "Data". PG versioned postgresql-9.0.1-1.1C (x64).
> Have installed the same version of Postgres. Substitute for the
> "Data" then Postgres server does not start.
I don't think anyone can give you much
[Adding the OP back to CC, in case he's not subscribed to the list]
Mark Kirkwood wrote:
> On 09/09/12 14:01, Kevin Grittner wrote:
>> "Pieter Viljoen Sr." wrote:
>>
>>> The TWO most important factors in hindering us to convert to
>>> Postgres
wrote:
> The TWO most important factors in hindering us to convert to
> Postgres are the following:
>
> Parallel execution of queries.
>
> No Table Partitioning
Not a bug, so off-topic for this list. If you need help figuring
out how best to use PostgreSQL, or whether it is a good fit for
yo
"Lokendra Dixit" wrote:
> RAM: 2 GB
You do realize how small that is for a database server, I hope.
Many people are walking around with cell phones in their pockets
that have a lot more. This could contribute to severe slowdown with
even minimal growth of the database, as cached access will
wrote:
> PostgreSQL version: 8.4.11
> 1.When I am taking bacup and restore two three times when databse
> size automatically incresed please descrive the solution.
>
> 2. I have created non cluster index on tables to increase query
> performance at same time performance incresed but after on
Bruce Momjian wrote:
> On Tue, Sep 4, 2012 at 12:11:53PM -0500, Kevin Grittner wrote:
>> What do you think would be the right thing to do with it at this
>> point?
>
> Well, there should probably be a tar files with a README. What
> about adding this to /contrib?
I
Bruce Momjian wrote:
> On Mon, Apr 9, 2012 at 02:07:43PM -0500, Kevin Grittner wrote:
>> Bruce Momjian wrote:
>>> On Mon, Apr 09, 2012 at 03:37:09PM -0300, Alvaro Herrera wrote:
>>>
>>>> (Another related tool is clearxlogtail which zeroes areas from
>
Denis Kolesnik wrote:
> My arguments are:
>
> is that even
> select id, str_last_name from tbl_owners_individual where id in
> (83,175,111,1) order by id;
>
> id |str_last_name
> -+--
>1 | Kolesnik
> 83 | GX
> 111 | Kolesnik
> 175 | GX
> (
"Kevin Grittner" wrote:
> Denis Kolesnik wrote:
>> and even sorting by id:
>> select id, str_last_name from tbl_owners_individual where id in
>> (83,175,111,1) order by str_last_name;
>>
>> id |str_last_name
>> -+---
Denis Kolesnik wrote:
> I have now VERY strong argument to consider it is as a bug:
No, you appear to have very strong feelings about it, but you are
not making an argument that holds water.
> if there a understandable for SQL language sequence which sorts
> in other fashion when adding "LIM
wrote:
> In my live environment i have a table with a boolean where the
> boolean is usually true. The boolean is false on new or changed
> entrys and if i select the false-rows order by primary key i get
> slow querys. The table has a lot of million rows and a very small
> amount of rows with f
"Kevin Grittner" wrote:
<> p...@elbrief.de> wrote:
>
>> insert into bla ( a , b )
>> select a , a
>> from generate_series( 1 , 100 ) as a ( a ) ;
>
>> explain analyze select * from bla
>> where b > 99 order by a limit 1
wrote:
> insert into bla ( a , b )
> select a , a
> from generate_series( 1 , 100 ) as a ( a ) ;
> explain analyze select * from bla
> where b > 99 order by a limit 10 ;
> [uses index on b and has a long run time]
The problem is that PostgreSQL doesn't have any sense of the
c
[moving to pgsql-novice]
wrote:
This doesn't look like a bug report. When you follow up, please
start a new thread on pgsql-general or pgsql-novice.
> PostgreSQL version: 9.0.0
Please update that to 9.0.8 or 9.1.4.
http://www.postgresql.org/support/versioning/
> I want to run query in
wrote:
> I created a Index in postgres.Now i want to fire select query in
> this Index and check data.
>
> Please tell me how to perform this???
This is not a bug. Please post any follow-ups or similar questions
to pgsql-general or pgsql-novice; or if it is a performance
question, try pgsql-
Tom Lane wrote:
> The reason I mentioned arrays is that it seems clear to me that
> nobody sane would consider ARRAY[NULL,NULL]::int[] to be
> equivalent to NULL::int[].
I will defer on that to anyone who has been in a position where the
former has any meaningful semantics in a SQL environment
Tom Lane wrote:
> "Kevin Grittner" writes:
>> So currently a NOT NULL constraint on a column with a composite
>> type is equivalent to:
>> CHECK (NOT c IS NULL)
>
> I don't believe this statement is accurate. What's really
> happening is
Rikard Pavelic wrote:
> The only inconsistent thing is check constraint, which behaves as
> NOT column IS NULL instead of column IS NOT NULL as docs says.
So currently a NOT NULL constraint on a column with a composite type
is equivalent to:
CHECK (NOT c IS NULL)
and the question is whethe
wrote:
> --This doesn't work as expected
> select * from bad where c is not null;
Are you seeing any behavior which does not match the documentation
and the standard?
http://www.postgresql.org/docs/current/interactive/functions-comparison.html
says:
| Note: If the expression is row-valu
wrote:
> CREATE OR REPLACE FUNCTION foo() RETURNS INTEGER AS $$
> DECLARE
> dummy INTEGER;
> BEGIN
> dummy=(SELECT MAX(id) FROM test); -- VALID
> dummy=(UPDATE test SET i=i+10 RETURNING i); -- NOT VALID.. WHY?
> dummy=(INSERT INTO test(i) VALUES (10) RETURNING i); -- NOT VALID..
> WHY?
> RETURN d
[moving to -jdbc list with bcc to -bugs]
wrote:
> PostgreSQL version: 9.1.4
> java version "1.7.0_04"
> Java(TM) SE Runtime Environment (build 1.7.0_04-b20)
> Java HotSpot(TM) Client VM (build 23.0-b21, mixed mode)
What PostgreSQL driver jar?
-Kevin
--
Sent via pgsql-bugs mailing list
Bruce Momjian wrote:
> I get your point about COUNT(*) really counting rows, not values,
> but why doesn't GROUP BY then skip nulls?
>
> WITH null_test (col1, col2) AS
> (
> SELECT 1, null
> UNION ALL
> SELECT null, null
> )
> SELECT COUNT(*), col2 FROM null_test group by
Bruce Momjian wrote:
> COUNT(*) can't skip nulls because there is no specified column,
> but why does COUNT(col) skip nulls --- again, inconsistent.
I disagree -- one is counting rows, the other is counting rows with
a value in that column. I guess one could criticize the syntax for
specifyin
jo wrote:
> Thanks for the explanation about standard sql.
> The goodness of it must be accepted by faith. :-)
Not if you have the stamina to fight your way through the standards
documents. ;-)
> I still have a doubt about the result of the GROUP BY clause.
> It seems to me that there's an
Pooja Khobragade wrote:
> I guess I get this error because there are two versions of
> postgreSQL installed on the same machine.
It sounds like that may be part of the problem, or an improper or
incomplete attempt at an update to a new major version.
On the other hand, there is definitely mo
Tom Lane wrote:
> pooja_khobrag...@persistent.co.in writes:
>> Error while connecting to server FATAL: shmemindex size is wrong
>> for datastructure xlog ctl : expected xxx actaul xxx
>
> That's an interesting one. The only theory that comes to mind is
> that you've got multiple versions of Post
Mitesh Shah wrote:
> *pg_dump: server version: 9.1.2; pg_dump version: 9.0.5*
> *pg_dump: aborting because of server version mismatch*
This is not a bug. Use a version of pg_dump which is at least as
new as the server. The older version of pg_dump is unlikely to be
able to recognize everythi
wrote:
> PostgreSQL version: 8.4.1
[sigh]
Please apply the security and bug fixes which have accumulated over
the last two-and-a-half years:
http://www.postgresql.org/support/versioning/
> we are getting below error please advise:
> org.postgresql.util.PSQLException: FATAL: terminating c
wrote:
> PostgreSQL version: 9.1.0
Please update to 9.1.3.
http://www.postgresql.org/support/versioning/
> Operating system: Solaris 10
> initdb -D /u01/app/postgres/postgres_data
> ld.so.1: initdb: fatal: libxslt.so.1: open failed: No such file or
> directory
> Killed
My first instinc
wrote:
> When tried setting FETCH FIRST parameter dynamically in RETURN
> QUERY EXECUTE some_query USING param1 it resulted with a syntax
> error on FETCH FIRST parameter.
>
> Apparently, it only accepts constants so it works with ($1)
That's not a bug. Use the parentheses as specified in t
snehal maniyar wrote:
> I have 2 databases for single user .
> Both these databases connect to 2 different applications.
>
> Configuration for one database is set to maximum 30 connections.
> Other database is not configured for maximum allowed connections
> explicitly.
>
> Now, I receive a brok
Greg Stark wrote:
> Only IMMUTABLE functions can be used in CHECK constraints.
> It's a feature that expressions including subqueries are
> automatically detected as not being immutable and automatically
> barred.
It doesn't look like that to me:
test=# create function xxx() returns text vol
* wrote:
> Kevin Grittner ***:
>> what you have written will scan the entire table and give each
>> row a 1 in 10 chance of being selected.
>>
> Hmm, is this because random() marked as volatile (and would be
> called for every row)? Ups, I
wrote:
> select * from testt where id = (random()* 10)::integer;
>
> And sometimes it comes out something like this:
> id | val
> ---+
> 11894 | 15051
> 29233 | 42198
> 80725 | 90213
> 85688 | 100992
> 88017 | 108075
> (5 rows)
> Here can be 2, 3 or other rows amount in result..
> Tom Lane wrote:
> eshkin...@gmail.com writes:
>> set timezone to 'W-SU'; select '2011-03-27 23:00:00'::timestamptz;
>> SET
>> timestamptz
>>
>> 2011-03-28 02:59:54+04
>
> Bizarre. On my Fedora 16 box, I see a different misbehavior:
>
> regression=# set timezone to 'Eur
wrote:
> PostgreSQL version: 9.0.0
http://www.postgresql.org/support/versioning/
There are fixes in newer bug-fix releases which would likely take
care of this. If you still see it under 9.0.7, please let us know.
-Kevin
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To
Bruce Momjian wrote:
> On Mon, Apr 09, 2012 at 03:37:09PM -0300, Alvaro Herrera wrote:
>> (Another related tool is clearxlogtail which zeroes areas from
>> WAL files when they are empty because of an early switch due to
>> archive timeout).
>
> Should we document that?
Our shop has been using
Bruce Momjian wrote:
> Robert Haas wrote:
>> wrote:
>>> In section 24.3.5.1 of the docs on setting up continuous
>>> archiving, there are a few paragraphs and examples for using
>>> pglesslog (pg_compresslog and pg_decompresslog). This tool did
>>> not get out of beta for 9.0 and the only repor
Alex Matzinger wrote:
> The connection that is executing the SELECT 1 are generally open
> for 1-5 hours before they are killed. The specific connection
> only executes SELECT 1. The transaction is simply BEGIN, and then
> SELECT 1's, no other query is executed.
Don't do that.
In particula
[Please keep the list copied. I won't respond to any more emails
directly to me without a copy to the list.]
Tatiana Ortiz wrote:
> Kevin Grittner >> Test if you have network connectivity from your client to the
>>> server host using ping or equivalent tools.
>>
"Eye Gee" wrote:
> Can you point to me which sites I can refer to for the 9.1
> installer for SUSE and Red Hat for IBM Power.
As Robert pointed out, there is a difference between an environment
being supported by the community (i.e., we expect it to work if
built and installed there, and will
[Please keep the list copied. Also, please quote selected portions
of a post to which you are replying, and put your reply below, like
you see here.]
Tatiana Ortiz wrote:
> I have the program PostgreSQL with PostGIS extension.
Obtained from where? Installed how?
> In postgre I have a data
wrote:
> looking at
> http://www.postgresql.org/docs/9.1/static/earthdistance.html
>
> it looks very scarce and missing, and conflicting, some things
> operate based on miles, others meters. it also doesnt specify the
> units used for earth_distance() which seems to be meters.
Any chance you
wrote:
> i'm trying to install PostgreSQL but always recibe the same error
> message."an non-fatal error "
That's not a lot to go on. Is there any more to the message, or a
log you can look at to get more detail?
> I'm on Windows XP 32b SP3
> I tried to install version 9.1.3, 9.4.5.1, and 9
wrote:
> x1 | x2 | x3
> ++
> | 1 | 1
To reduce the ambiguity about what value is coming from where, I
slightly modified the script before testing it against a recent HEAD
build:
create table t (c integer);
create function p(out x1 integer, out x2 integer, out x3 integer)
wrote:
> Create Table Test (x integer,y integer);
>
> Insert Into Test Values(1,100);
> Insert Into Test Values(2,200);
>
> First database session:
> ---
> start transaction;
> Lock table Test;
>
> Second database session
> ---
> start transaction;
prem tolani wrote:
> I running an applicatio in java with postgresql 8.1.
> I am using windows 7.
Version 8.1 has been unsupported on Windows for four years. That's
before Windows 7 even came out, so that combination has *never* been
supported. Upgrade to a supported environment and you sh
"Kevin Grittner" wrote:
> Aren Cambre wrote:
>
>> SELECT COUNT(*)
>> FROM consistent.master
>> WHERE citation_id IS NOT NULL
>> UNION
>> SELECT COUNT(*)
>> FROM consistent.master
>> UNION
>> SELECT COUNT(*)
>> FROM c
Aren Cambre wrote:
> SELECT COUNT(*)
> FROM consistent.master
> WHERE citation_id IS NOT NULL
> UNION
> SELECT COUNT(*)
> FROM consistent.master
> UNION
> SELECT COUNT(*)
> FROM consistent.master
> WHERE citation_id IS NULL
>
> I got this result:
>
> 2085344
> 2085343
> 0
>
> Not clear how ad
Christopher Browne wrote:
> Nie, Guocong wrote:
>> Could you please let me know how can I replicate database from
>> Linux to Windows ?
>
> The built-in replication requires that you are using the same
> version of PostgreSQL on the same OS platform. That doesn't seem
> to be documented as cl
wrote:
> My postgresql does not start and giving me this error:
>
> Could not connect to server: Connection refused (0x274D/10061)
> Is the server running on host *127.0.0.1* and accepting TCP/IP
> connections on port 5432?
That message looks like it is coming from some client software on
wrote:
> Problem with COPY COMMAND in java code.
> File path can't read with dbpool.It require base
> connection(PostgreSql).
It sounds like you need to investigate whether dbpool includes
support for database-specific extensions like COPY; and if so
whether and how the PostgreSQL COPY command
wrote:
> This bug was not in jdbc4 driver: 8.4-701
> But is introduced in jdbc4 driver: 8.4-702
> It is still present in 9.1-901
You might get this in front of a more appropriate group of people if
you post to the pgsql-jdbc list. I'm moving discussion to that list.
> Context:
> * Tomcat 7
1 - 100 of 533 matches
Mail list logo
