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
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 be dealing with dead space from deletes and updates.
--
Kevin
:
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 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 (pgsql-bugs
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-bugs@postgresql.org)
To make changes to your
---
945
(1 row)
test=# select proname from pg_proc where proname = 'α';
proname
-
α
(1 row)
--
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
Kevin Grittner kgri...@ymail.com 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, ξ int, μ float
Tom Lane t...@sss.pgh.pa.us wrote:
Kevin Grittner kgri...@ymail.com 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 would
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
postgres
--
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
g.bakalar...@icm.edu.pl g.bakalar...@icm.edu.pl wrote:
Kevin Grittner kgri...@ymail.com wrote:
g.bakalar...@icm.edu.pl g.bakalar...@icm.edu.pl wrote:
When doing these kind of statements
execute unnamed: CREATE TEMPORARY TABLE [...]
After few days [...] my huge server (192GB of RAM), gets
) 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
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
The Enterprise
now.
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
.
--
Kevin Grittner
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
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 materializing it as a tsvector instead of a varchar.
--
Kevin Grittner
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
David Johnston pol...@yahoo.com 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: http
. If you 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
COLUMN colname 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
| Waiting
(1 row)
test=# select * from table_b;
id | sitation | when
+--+
23 | Started | 08/03/2013 13:01:08.169213 CST
23 | Waiting | 08/03/2013 13:01:08.179754 CST
(2 rows)
How about showing us yours?
--
Kevin Grittner
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 subscription:
http
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 (pgsql-bugs
, 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
--
Kevin Grittner
EnterpriseDB: http://www.enterprisedb.com
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 changes to your subscription:
http://www.postgresql.org
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 make changes to your
jim...@seagate.com 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
m...@fontling.com 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
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:
Bruce Momjian br...@momjian.us wrote:
On Tue, Sep 4, 2012
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 application
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 your
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
Andres Freund wrote:
On 2013-01-12 14:29:38 -0500, Tom Lane wrote:
Kevin Grittner kgri...@mail.com 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-planned, and which would needed to be treated as raw
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
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
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 list
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
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
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,
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
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
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
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
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 the
l...@tom.com 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.id5);
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
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 help
[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 are the following:
Parallel execution of queries.
No Table
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
your
Lokendra Dixit lokendra.di...@rmsi.com 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,
Bruce Momjian br...@momjian.us wrote:
On Mon, Apr 9, 2012 at 02:07:43PM -0500, Kevin Grittner wrote:
Bruce Momjian br...@momjian.us 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
Bruce Momjian br...@momjian.us 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 would be happy
lokendra.di...@rmsi.com 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
Denis Kolesnik lirex.softw...@gmail.com 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
Kevin Grittner kevin.gritt...@wicourts.gov wrote:
Denis Kolesnik lirex.softw...@gmail.com 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
-+--
83
Denis Kolesnik lirex.softw...@gmail.com 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 |
Kevin Grittner kevin.gritt...@wicourts.gov 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 10 ;
[uses index on b and has a long run time
[moving to pgsql-novice]
kapilkuma...@gmail.com 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
alokrawat0...@gmail.com 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
Rikard Pavelic rikard.pave...@zg.htnet.hr 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)
Tom Lane t...@sss.pgh.pa.us wrote:
Kevin Grittner kevin.gritt...@wicourts.gov 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 that a column
Tom Lane t...@sss.pgh.pa.us 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
rikard.pave...@zg.htnet.hr 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
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 dummy;
jo jose.soa...@sferacarta.com 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
Bruce Momjian br...@momjian.us 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
Bruce Momjian br...@momjian.us 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
Pooja Khobragade pooja_khobrag...@persistent.co.in 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
Tom Lane t...@sss.pgh.pa.us 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
Mitesh Shah mitesh.s...@stripes39.com 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
mue...@chetu.com 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:
mng5...@gmail.com 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
dodo...@geoinfo.geof.hr 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
Greg Stark st...@mit.edu 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()
snehal maniyar cuteshauny...@gmail.com 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,
suvisor.r...@gmail.com 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
* suvisor.r...@gmail.com wrote:
Kevin Grittner kevin.gritt...@wicourts.gov ***:
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
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 'Europe/Moscow';
n...@ig.com.br 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
Bruce Momjian br...@momjian.us wrote:
Robert Haas wrote:
stuart.bis...@canonical.com 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
Bruce Momjian br...@momjian.us 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
Alex Matzinger amatzin...@experts-exchange.com 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.
Eye Gee eye...@cmg.com.my 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
[Please keep the list copied. I won't respond to any more emails
directly to me without a copy to the list.]
Tatiana Ortiz tatyp...@gmail.com wrote:
Kevin Grittner kevin.gritt...@wicourts.gov wrote:
Test if you have network connectivity from your client to the
server host using ping
sergipanad...@digalix.com 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
kont...@sandberg-consult.dk 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
[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 tatyp...@gmail.com wrote:
I have the program PostgreSQL with PostGIS extension.
Obtained from where? Installed how?
In
abura...@gmail.com 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,
neeraj.punm...@securetogether.com 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
---
prem tolani premtol...@yahoo.com 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
Aren Cambre a...@arencambre.com 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
Kevin Grittner kevin.gritt...@wicourts.gov wrote:
Aren Cambre a...@arencambre.com 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
Christopher Browne cbbro...@gmail.com wrote:
Nie, Guocong guocong@capgemini.com 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
tatyp...@gmail.com 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
pradeep.vishwaka...@routesms.com 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
j.vre...@aca-it.be 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.
sujatha.pell...@gmail.com wrote:
I have column(string datatype) has a data starting with single
quote as below
'single resource to avoid all job execution'
Now I want write select query to select records which starts with
single quote.
I tried with many option however could not get
hlem...@web.de wrote:
colname = 'value' returns true but
colname LIKE 'value' returns false.
Is the colname of type char(n) or does it contain trailing spaces?
-Kevin
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
[rearranged to avoid top-posting: http://idallen.com/topposting.html]
Vipul Patel wrote:
On Thursday 09 February 2012 10:33 PM, Kevin Grittner wrote:
What locks and blocking do you see when this happens?
http://wiki.postgresql.org/wiki/Lock_Monitoring'
I don't understand why CREATE
vipul.pa...@elitecore.com wrote:
some time call of create table is stuck which is called by PQexec.
What locks and blocking do you see when this happens?
http://wiki.postgresql.org/wiki/Lock_Monitoring'
Have you considered getting an explicit lock with NOWAIT at the
start of your
Kevin Grittner kevin.gritt...@wicourts.gov wrote:
Andrew Alcheyev bu...@telenet.ru wrote:
Well, it does good and the backend hasn't crashed yet, but the
client is still experiencing query problems at some point (not
far, I guess, from where its backend would segfault without the
patch
[moving to pgsql-www with bc to pgsql-bugs]
baxterstock...@gmail.com wrote:
Your projects website is down (tried to visit the pgpool page),
and I didn't know where else to report it.
People are aware of the site failure and hopefully someone with the
appropriate access permissions is
1 - 100 of 497 matches
Mail list logo