)
Filter: ((text2ltree(COALESCE(replace((ancestry)::text, '/'::text,
'.'::text), ''::text)) || (id)::tex…
…t) <@ '{71}'::ltree[])
Rows Removed by Filter: 1322
-> rows=1
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
ase=apedevdb host=statusclick.bieosthoes.net port=58441
2013-10-13 11:14:53 CEST LOG: connection received:
host=statusclick.bieosthoes.net port=58442
2013-10-13 11:14:54 CEST LOG: connection authorized: user=apedev
database=apedevdb
2013-10-13 11:14:54 CEST LOG: statement: INSERT INTO foo (ed, bar) VALUES
(6, 'cool') RETURNING *;
2013-10-13 11:14:54 CEST LOG: disconnection: session time: 0:00:00.077
user=apedev database=apedevdb host=statusclick.bieosthoes.net port=58442
--->%---
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
.postgresql.org/docs/9.3/static/libpq-misc.html.
Regards,
Marko Tiikkaja
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
337
> deletePQCharPointer = _deletePQCharPointer
We have successfully tested the new function and it would be nice if this is
in a future release of postgresql ;)
Regards
Ben
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/BUG-8461-PostgreSQL-9-3-pg-
> --
> john r pierce 37N 122W
> somewhere on the middle of the left coast
>
>
>
> --
> Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/**mailpref/pgsql-bugs<http://www.postgresql.org/mailpref/pgsql-bugs>
>
pierce 37N 122W
somewhere on the middle of the left coast
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
chLinux
> Description:
>
> We've recently migrated an application from MySQL to Postgres and I've been
> experiencing some really strange and random bugs. The application is a
> pretty simple Rails application and the Postgres setup is the default one
> provided by ArchLinux.
&g
ux, but I don't believe they
have a MMU, so they can't run a 'regular' linux kernel.
frankly, these don't seem like good candidates for a relational database
server to me.
--
john r pierce 37N 122W
somewhere on the middle of the left
;re
reporting).
regards
Tomas
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
more suitable lists - for example pgsql-hackers.
Again, post as much info as possible.
All mailing lists on postgresql.org (incl. pgsql-bugs, pgsql-hackers)
are operated by community, with participants from various companies. If
you decide you need a commercial support, the best place to start is
Dear sir,
We are trying to port the PostGreSQL on the m68K platform, we've
compiled it well, but failed to run it on the 54450 platform. I am wondering
who we could refer to for help? Is there any commercial service that we could
use for that kind of technical support?
I know the Information Schema is a SQL standard, but it's somewhat lacking.
I was trying to write a web page that showed a db table,it's columns and
foreign keys.
All went well and I was able to get this tool working great using the
information_schema, problem is that some of the information_sche
er has all the information to notify the
programmer of a mistake, but isn't. This violates a fundamental principle of
software engineering--take every opportunity to prevent errors.
Dwayne
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your
tool to
encryption in Windows OS . can some one please help me in encrypting the
disk.
Thanks
David jaya Kumar. K
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
g them. To
do that it'd have to be volatile, so if we had a restriction like this
the function would fail when invoked within a stable function.
You can imagine various ways around such issues, but it would add a lot
of complication.
regards, tom lane
--
Sent via p
s fix anything.
regards, tom lane
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
On Oct 11, 2013, at 9:21 AM, Dimitri Fontaine wrote:
> Inter function dependencies is a hard topic indeed. I still would like
> to see some kind of progress being made someday. The general case is
> turing complete tho, because you can use EXECUTE against programatically
> generated SQL.
>
> You
imited in scope static analysis for the cases where
it's possible to do so would be great. With pg_depend tracking so that
you know you're doing something wrong at DROP FUNCTION time.
Regards,
--
Dimitri Fontaine
http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support
--
ensuring that the relation have to be present.
--
Michael
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
artment
NEC Soft, Ltd.
E-Mail: anzai-na...@mxu.nes.nec.co.jp
---
pg_ctl.c.patch
Description: pg_ctl.c.patch
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
if we revert, will it still be clear what is MD5 and what is MD5 hash?
I mean, will it be clear what is MD5 crypt and what is MD5 hash?
--
Bruce Momjian http://momjian.us
EnterpriseDB http://enterprisedb.com
+ Everyone has their own god. +
--
Sent v
t;crypt-md5
> >
> > How can the later entry not be MD5 hash?
>
> Because what you pass to the functions is 'md5', not 'md5 hash', which
> is what the new text appears to indicate.
So if we revert, will it still be clear what is MD5 and what
t;
> > > !md5 hash
>
> Uh, the table already has a mention of md5 crypt above:
>
>crypt-md5
>
> How can the later entry not be MD5 hash?
Because what you pass to the functions is 'md5', not 'md5 hash', which
is what the new text appears to indicate.
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
o prevent errors.
Well, we can't walk the function tree to know all called functions, and
those they call, so we don't even try.
--
Bruce Momjian http://momjian.us
EnterpriseDB http://enterprisedb.com
+ Everyone has their own god. +
--
Se
1348,1354
> > OpenBSD sys/crypto
> >
> >
> > ! MD5 hash and SHA1
> > WIDE Project
> > KAME kame/sys/crypto
> >
>
Again, "MD5 crypt" is mentioned in the same table above:
MD5 cryp
LE from calling VOLATILE functions.
--
Bruce Momjian http://momjian.us
EnterpriseDB http://enterprisedb.com
+ Everyone has their own god. +
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
t; Date: Sun Jun 23 11:05:02 2013 +0100
Good news, thank you.
--
Kind regards,
Sergey Konoplev
PostgreSQL Consultant and DBA
http://www.linkedin.com/in/grayhemp
+1 (415) 867-9984, +7 (901) 903-0499, +7 (988) 888-1979
gray...@gmail.com
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresq
errerahttp://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
ow to check if this patch was
included in 9.2.5 or not?
--
Kind regards,
Sergey Konoplev
PostgreSQL Consultant and DBA
http://www.linkedin.com/in/grayhemp
+1 (415) 867-9984, +7 (901) 903-0499, +7 (988) 888-1979
gray...@gmail.com
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgres
. for instance, at a CMD ('dos') prompt, type the
command,
ECHO %COMSPEC%
and you should get something like...
C:\WINDOWS\system32\cmd.exe
p.s please direct replies to pgsql-bugs@postgresql.org and not me
personally.
--
john r pierce
you're installing, is it tested and supported on win7?
p.s please direct replies to pgsql-bugs@postgresql.org and not me
personally.
--
john r pierce 37N 122W
somewhere on the middle of the left coast
--
Sent via pgsql-bugs mailing list (
Hello, how to solve this error (please see attachment)?
Regards,
AnDi
<>
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
his problem ?
Thank you,
Regards,
Sémy
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
g on expand.
I wonder if is this intended for Big Endian processing or is just
wrong coded.
Have a nice day !
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
tability-violation happens
$$ LANGUAGE SQL STABLE; -- this is a lie
According to the documentation, f() should be marked VOLATILE also, since
calling f() produces side effects. PostgreSQL does not give a warning (or
better yet, an error); I think it should.
--
Sent via pgsql-bugs mailing list (pg
343,1349
> OpenBSD sys/crypto
>
>
> ! MD5 and SHA1
> WIDE Project
> KAME kame/sys/crypto
>
> --- 1348,1354
> OpenBSD sys/crypto
>
>
> ! MD5 hash and SHA1
>
s and I've been
experiencing some really strange and random bugs. The application is a
pretty simple Rails application and the Postgres setup is the default one
provided by ArchLinux.
Basically, at some point a query, update or insert will not work and
complain about a table not existing, but
relation 421062806 error in postgresql log. can anyone tell me significant
of this error.
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
Hi,
I *think* I fixed this problem. We will release updated packages
tomorrow, along with the PostgreSQL minor release updates. Please let me
know if they still don't work. :)
Regards, Devrim
On Fri, 2013-10-04 at 13:26 +, kyri...@alumni.princeton.edu wrote:
> The following bug has been log
seems that if there are more than one nulls before field c in union
PostreSQL thinks merged field's data type is text.
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
Hi,
I am getting "getsockopt(TCP_KEEPALIVE) failed: Option not supported by
protocol" log message in the PG Logs whenever I run a query referencing
"pg_catalog.pg_settings" on Solaris 10 (both Sprac and x86-64).
You can reproduce this case by running a query like: SELECT name, setting,
unit FROM
Dear Support,
I would like to install the newest postgresql to win 8 but something wrong
with that... At the end I got a message about some problem and I don't know
why. The problem is the postgresql can not connect to the host ( 127.0.0.1
). How can I fix it?
Thanks!
t;
privileges if the column is used there. But not if the column only exists
as a target-column.
David J.
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/BUG-8512-Can-t-use-columns-I-can-t-read-in-the-where-clause-of-a-select-tp5773752p5773757.html
Sent from the PostgreSQL - bugs mailing list archive at Nabble.com.
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
* k...@roeckx.be (k...@roeckx.be) wrote:
> Allows SELECT from any column, or the specific columns listed, of the
> specified table, view, or sequence. Also allows the use of COPY TO. This
> privilege is also needed to reference existing column values in UPDATE or
> DELETE.
>
>
> I read that a
ld
someone please clarify?
Kurt
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
. Thanks for the suggestions.
--
Bruce Momjian http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for everything to be true. +
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subs
We shouldn't have a problem with using pg_upgrade with the hard link option to upgrade from postgreSQL 9.1.6 after I get the spatial component upgraded to postgis 2.1, then straight to postgreSQL 9.3, Right? thanks
Original Message
Subject: Re: [BUGS] Installing/Upgr
upgrade to PostgreSQL 9.3?
Sorry, I have no idea how to upgrade PostGIS.
--
Bruce Momjian http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for everything to be true. +
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
On Tue, Oct 8, 2013 at 1:32 PM, wrote:
> The following bug has been logged on the website:
>
> Bug reference: 8511
> Logged by: Tejas
> Email address: shahtejas2...@gmail.com
> PostgreSQL version: Unsupported/Unknown
> Operating system: Linux
> Description:
>
> cache lookup f
/docs/current/static/bug-reporting.html
oh, direct further correspondence to the bug list,
pgsql-bugs@postgresql.org and not me personally
--
john r pierce 37N 122W
somewhere on the middle of the left coast
--
Sent via pgsql-bugs mailing list (pgsql
pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
icacls E:\ /grant "NT AUTHORITY\NetworkService":(NP)(RX)
>
>
> The installation took over 1 hour.
> I install postgresql on C: and the database in E:\database
>
>
> Regards,
> Ronny
>
>
>
> --
> Sent via pgsql-bugs mailing list (pgsql-bugs@po
can we just use pg_upgrade with the hard links option, instead of copying files to the new cluster option to upgrade to PostgreSQL 9.3?
Original Message ----
Subject: Re: [BUGS] Installing/Upgrading PostgreSQL 9.1.6 to 9.3 known
bugs?
From: Bruce Momjian <br...@momjian.us>
Date:
velopment, 24x7 Support, Training & Services
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
sir,
I want to do bug fixing for your project.At present i am pursuing b.tech in
computer science.c and c++ are the languages of my interest.
i would be very delightful if i could work for your company.
Thank you
Aditya srivastava
regards
com
--
Álvaro Herrerahttp://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
hat would perhaps allow me to get it done in time.
--
Álvaro Herrerahttp://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
anies and their staff who contribute in other ways are. Further, the
> PostgreSQL installers are offered as 'official' releases on the community
> website, so it is quite reasonable for users to report bugs here.
OK, sorry for my misunderstanding.
--
Michael
--
Sent via pgsql-bugs
w-0001oj...@wrigleys.postgresql.org
> >
> > Someone who knows XML needs to take leadership on this and propose a
> > patch.
Added to TODO.
--
Bruce Momjian http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible
ed as 'official' releases on the community
website, so it is quite reasonable for users to report bugs here.
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
by community.
Regards,
--
Michael
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
with
9.2 but timed out after 3 minutes on 9.3.0. And even without a loop
that amplifies this, just a single 'select for update' inside a
subtransaction is significantly slower in 9.3.
Thanks,
Oskari
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your
3.1 though.
--
Álvaro Herrerahttp://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
ust escaped when serialized
>> to XML. If were to actually contain "<", it'd be serialized as
>> "<". It should not be possible to be blindly cast to a text type, but
>> explicitly serialized as such.
>>
>>
>> At least the rev
s well. At the very least, please ensure that version
2.0.x of the packages remains available in the future. Better still, provide
alternative postgis21_92-* packages, for those wishing to use the latest
version, without affecting those that use the previous version.
--
Sent via pgsql-bugs
KEYS_UPDATED))
+ if (!(old_infomask & HEAP_XMAX_INVALID))
{
TransactionId update_xid;
However, the differences in behavior this causes (visible by running the
isolation tests) don't look good to me. It's quite possible that there
a
27;ll see if
I can do some tests there.
Mit freundlichen Grüßen,
Christoph Berg
--
Tel.: +49 (0)21 61 / 46 43-187
credativ GmbH, HRB Mönchengladbach 12080, USt-ID-Nummer: DE204566209
Hohenzollernstr. 133, 41061 Mönchengladbach
Geschäftsführung: Dr. Michael Meskes, Jörg Folz, Sascha Heuer
--
rom
>> being executed.
>>
>
It is strange - I used pg ODBC driver together with MS Excel without any
issue.
Regards
Pavel
>
> I'm afraid you'll have to provide a lot more details for anyone to be able
> to help you.
>
> - Heikki
>
>
> --
> S
etails for anyone to be
able to help you.
- Heikki
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
Disregard my bug complaint. Stupid user error.
Thanks,
Regina
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
something?
Sorry if this is an oversight on my part.
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
it seems hard to control - as proven here - that it doesn't
make any calls to functions using palloc() in some edge cases.
Greetings,
Andres Freund
--
Andres Freund http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
allowed to use palloc.
regards, tom lane
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
To reproduce do something like:
# become root
su
# change into root-only directory
cd /root
# switch user, without changing directory
su postgres
# execute postgres
/path/to/postgres -D frakbar
Greetings,
Andres Freund
--
Andres Freund http://www.2ndQuadrant.com/
PostgreSQL Deve
not be failing.
I am surprised it got an oid that was one less than the desired one,
18803. Is there any mention of 18803 in the SQL file? If you create a
cluster with just your schema and no data, can you upgrade that cleanly?
--
Bruce Momjian http://momjian.us
EnterpriseDB
such.
>
>
> At least the reviewer at:
>
>
> http://www.postgresql.org/message-id/201106291934.23089.rsmog...@softperience.eu
There are two other similar bug reports on this from February and March
of this year:
http://www.postgresql.org/message-id/e1u1fkl-0002rd...@
3 years
*** gen_salt(type text [, iter_count integer
*** 380,386
! md5 numbers are from mdcrack 1.2.
--- 385,391
! md5 hash numbers are from mdcrack 1.2.
*** gen_random
> spread across disk storage mediums; fiber, nas. Are there any known
> issues,
> bugs with using pg_upgrade to move from 9.1.6 to pg 9.3?
>
>
>
> having multiple tablespaces on different mount points complicates things.
> I'm
> not sure how or if pg_upgrade
on-existing file (perhaps only when
> ON_ERROR_STOP is set to 1?).
The problem is how would we decide what psql actions should trigger a
rollback, and how would we show the user we did that.
--
Bruce Momjian http://momjian.us
EnterpriseDB h
sort of a connection with the database. SQL commands fail from
being executed.
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
would be better raising this
issue with them!
Cheers
Mark
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
sts some tricks, but it doesn't
work for 2D arrays. You can write relative simply C extension, and solve
problem there.
Regards
Pavel Stehule
>
>
> Thank you very much.
>
>
>
> --
> Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs
>
27;m doing bad?
Thank you very much.
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
Ltd.
RSVP.
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
(\"s_bigint\",\"s_binary1\",\"s_binary99\",\"s_varbinary1\",\"s_varbinary99\")
VALUES
(:P1,:P2,:P3,:P4,:P5) ".
Data for insert have char type. Help me please. Why does this error happen?
How can it be solved? Thanks.
--
Sent via pgsql-bugs mai
ot;NT AUTHORITY\NetworkService":(NP)(RX)
The installation took over 1 hour.
I install postgresql on C: and the database in E:\database
Regards,
Ronny
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
this, the (es_ES) Spanish User Interface option don't work. It
seems overwritten by French or something.
Best regards
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
problem next week.
--
Álvaro Herrerahttp://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
ock on transaction
>> 659103; blocked by process 29631.
>> Process 29631 waits for ExclusiveLock on tuple (0,153) of relation
>> 16385 of database 16384; blocked by process 29630.
>> Process 29630: UPDATE t SET col3 = 'c' WHERE col1 = 3 AND
MVC 4, using the code below to insert:
NpgsqlConnection connection = new NpgsqlConnection(connectionString);
connection.Open();
(new NpgsqlCommand("The query", connection)).ExecuteNonQuery();
connection.Close();
)
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
languaje not the spanish
> > one.
>
> You should report this to the pgadmin developers on one of their email
> lists:
>
> http://www.pgadmin.org/support/list.php
>
Actually, this has already been fixed. My fault, my fix :)
--
Guillaume
http://blog.gui
). execute psql.
3). You receive the message 'could not find a "psql" to execute'.
4). Add the Directory without double quotes to the %PATH% environment
variable.
5). execute psql.
6). You do not receive the message 'could not find a "psql" to exec
sts:
http://www.pgadmin.org/support/list.php
--
Bruce Momjian http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for everything to be true. +
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
T
stic;
ERROR: could not create unique index "pg_statistic_relid_att_index"
DETAIL: Table contains duplicated values.
..came across this thread
http://www.spinics.net/lists/pgsql-admin/msg05911.html and I tried
simply deleting all the stuff in pg_statistic, reindex then vacuum and
es, containing 4633 live
rows and 0 dead rows; 4633 rows in sample, 4633 estimated total rows
INFO: analyzing "information_schema.sql_features"
INFO: "sql_features": scanned 7 of 7 pages, containing 649 live rows
and 0 dead rows; 649 rows in sample, 649 estimated total rows
ERRO
ter fetter.org> writes:
> >
> > Upgrade to 9.1.3 and let us know whether that fixes the problem.
>
> I've run into this issue as well on postgres 8.4.14. Aside from upgrading
> to a
> newer release is there any manual fixup that can be done ?
>
> Thanks,
>
David Fetter fetter.org> writes:
>
> Upgrade to 9.1.3 and let us know whether that fixes the problem.
I've run into this issue as well on postgres 8.4.14. Aside from upgrading to a
newer release is there any manual fixup that can be done ?
Thanks,
David
--
Sent via pgsq
c values to the 4.0 range
where b.gpa between 0.0 and 4.0
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
1 - 100 of 36649 matches
Mail list logo
