naming pattern used in the
system catalogs: 3 letters indicating the catalog, plus additional
letters or words. It is useful to use the same name in views such as
pg_stat_replication, so you can easily join different views and catalogs.
--
Peter Eisentraut http://www.2ndQuadrant.com/
Post
://www.postgresql.org/docs/9.5/static/sql-createindex.html#SQL-CREATEINDEX-CONCURRENTLY
A fix for this has been committed. Once 10.1 comes out (next week), the
old-style anchors will work again.
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support
it, but confusing the first time you encounter it.
>
> Yes, right. Let's update as you suggest.
>
>
> new version looks good.
committed
I changed to links to xrefs, which automatically generated the correct
target texts.
--
Peter Eisentraut http://www.2ndQuadrant.
ugh exactly how
to present this in the user interface.
Another longer-term solution here is to implement conflict resolution
mechanisms. So if you don't like local updates to break the incoming
replication stream, a remote-update-wins policy would help.
--
Peter Eisentraut
s of all the types involved don't change, and you
can use the standard functions to look up the types of your arguments
and the associated array types.
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
--
Sent via
t's applicable, is it still valid or too many things have changed?
That doesn't seem related.
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
--
Sent via pgsql-general mailing list (pgsql-general@p
k all those places down and then see whether I need to make
analogous changes there.
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
T
39922 17769 0 15:39 ?00:00:00
> /usr/pgsql-9.3/bin/postgres -D /bases/postgresql/scl/data -i -p 5450 -h
> bd-sillage.info.
It appears that the second one is a process forked off from the first
one. That looks normal to me.
--
Peter Eisentraut http://www.2ndQuadrant.
ed distribution packages, even if they are not
directly from your vendor.
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes t
t find that "C" works instead, don't know for sure.
>
> I think this is actually a bug, because the collations code clearly
> means to allow clones of the C/POSIX locales --- see eg lc_collate_is_c,
You seem to say that we should support a "POSIX" locale even on sy
ality can be expected to trickle into core eventually.
One advantage of the in-core feature is that the initial table
synchronization can be parallelized, which can make the initial setup
faster and more robust. pglogical will probably support that too at
some point once PG10 is out.
--
Peter E
On 6/21/17 22:04, Maeldron T. wrote:
> * Logical replication is in 10.0 Beta 1. I might be oldschool but I
> would install 10.1 or maybe 10.0.2 into production
There are also other logical replication options such as pglogical and
londiste.
--
Peter Eisentraut http
ogical replication. That would save you the bandwidth for
updating all the indexes at least. It might work for you.
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
--
Sent via pgsql-general mailing list (pgsql-
ation stored anywhere in the catalog?
It is not.
> Or I
> need to store it myself? Is there any plan to add such meta data
> information to the catalog as a feature? Thanks a lot!
You could write an event trigger to record it.
--
Peter Eisentraut http://www.2ndQua
On 5/10/17 11:48, Sandeep Gupta wrote:
> Currently, the postgres database by has SQL_ASCII encoding.
> Is it possible to start the postgres database with UTF-8 encoding, instead
> of modifying it later.
This is done when initdb is run, with the --locale and/or --encoding option.
presume that in this case the string
> will end with just \0, correct? It's not going to be \0\0 like with MSVC.
I don't know what you mean by \0\0 with MSVC, but it is correct that the
error message string will end with \0, like any C string.
--
Peter Eisentraut http://www.2ndQua
to use both at the same time?:
>
> 9.4 ---> 10(instance 1)---> 10(instance 2)
> pglogicalpglogical
> builtinbuiltin
That is possible.
pglogical will continue to exist, so you can also keep using it if you
already have it.
db85c738364fe8f7965209e08c6be about how the
internal representation was changed.
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
_type;
>
> I wonder what the benefit of a typed table is and when this would be useful?
One use is with PL/Proxy. You create the type on the proxy, thus
allowing you to define functions using the type. Then create the table
on the backend from the type, thus ensuring they are
e, you can check out
the tag REL9_4_BETA1 from git and built it yourself.
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to
own and being worked on. It's only a deprecation
warning, so you can ignore it for now.
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
On 9/15/15 1:48 AM, Ben Chobot wrote:
> We're in a situation where we would like to take advantage of the pgpass
> hostname field to determine which password gets used. For example:
>
> psql -h prod-server -d foo # should use the prod password
> psql -h beta-server -d foo # should use the beta
On 7/30/15 6:13 AM, Renato Oliveira wrote:
We have a Nagios plugin, which monitors pg_locks and almost daily we see
3000 to 4 pg_locks.
Can we just ignore them, can we let them grow without worrying?
How many pg_locks are considered unsafe for any given postgres server?
That depends
On 5/18/15 10:52 AM, Filipe Pina wrote:
But one of the functions I need to create needs to accept an array of
records.
PL/Python doesn't support that. Some more code needs to be written to
support that. You did everything correctly. I don't know of a good
workaround.
--
Sent via
On 5/28/15 5:35 PM, Randall Lucas wrote:
Can I compile my own version of uuid_out and update the system
catalogs, or create a uuid_dashless type that uses my own custom
uuid_dashless.c that's hacked to remove dashes?
Either one would work.
--
Sent via pgsql-general mailing list
On 5/21/15 12:12 PM, Andomar wrote:
Hi,
Today I installed pgbouncer. I added a second installation as a hot
standby. Before starting the standby, I configured recovery.conf to
connect to pgbouncer.
This results in an error message:
Pooler Error: Unsupported startup parameter:
On 5/9/15 10:47 AM, Bill Moran wrote:
https://wiki.postgresql.org/wiki/RPM_Packaging
The link to the specfiles and other data at
http://svn.pgrpms.org/repo/ gives a 404.
It's been move to git. I have updated the wiki page with the new URL.
--
Sent via pgsql-general mailing list
On 4/20/15 6:09 PM, Bruce Momjian wrote:
On Mon, Apr 20, 2015 at 07:06:37PM -0300, Alvaro Herrera wrote:
ISTM there's a documentation bug here: in the code, the dump method
checks for tablespaces and raises an error if they are found, but the
upgrade method does not check. I think the
On 3/14/15 3:27 PM, Миша Тюрин wrote:
should we add disclaimer in pitr documentation about cp and fsync?
cp does not fsync.
and dd for example can do fsync.
only on some platforms
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
On 2/13/15 1:48 PM, Jeff Janes wrote:
I waste an inordinate amount of time retyping select lists over into the
group by list, or copying and pasting and then deleting the aggregate
clauses. It is an entirely pointless exercise. I can't fault
PostgreSQL for following the standard, but its too
pgsql-hackers are discussing some housekeeping in contrib.
Is anyone using the oid2name tool?
Otherwise, we might deprecate and eventually remove it.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
On 12/12/14 9:25 AM, Bruce Momjian wrote:
On Fri, Dec 12, 2014 at 09:18:53AM -0500, Peter Eisentraut wrote:
pgsql-hackers are discussing some housekeeping in contrib.
Is anyone using the oid2name tool?
Otherwise, we might deprecate and eventually remove it.
Uh, if we remove it, what tool
On 11/14/14 2:10 PM, Jonathan Vanasco wrote:
I ran into an issue migrating from 9.1 to 9.3 on ubuntu using pg_upgrade
the default ubuntu package, and the one from postgresql.org, both store
`postgresql.conf` in etc as `/etc/postgresql/VERSION/main/postgresql.conf`
however, the pg_upgrade
On 10/15/14 5:56 PM, Tom Lane wrote:
Hm ... this was changed in commit 6f6b46c9c0ca3d96. Peter, did
you consider efficiency here?
Fixed.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
On 10/15/14 5:58 PM, Jonathan Rogers wrote:
BTW, I would rewrite the 9.1 example to be shorter while
behaving the same:
CREATE FUNCTION usesavedplan() RETURNS trigger AS $$
plan = SD.get(plan)
if plan is None:
If we're going for shortness, how about
if not plan:
?
On 9/15/14 1:30 PM, cowwoc wrote:
Any chance you guys could help cleaning up the build/deploy process?
This is a pretty big hurdle to overcome for new users.
I'm glad to hear that PL/Java is still working well for some people.
Last I saw it was stuck in a transition of the build system from
On 9/15/14 1:46 PM, Pavel Stehule wrote:
I am strong sceptic. There is relative slow progress in JDBC driver,
that is 100x more important project than PL/Java - so It is hard to
believe, so there can be 3 developers, who start work on PL/Java.
Stupid, completely offensive guess: Most Java
On 5/29/14, 11:59 AM, Bob Moyers wrote:
When I try this update:
UPDATE REPORT_STYLE SET JASPER_STYLE = XMLPARSE(DOCUMENT ?) WHERE
(REPORT_STYLE_NAME = ?)
I get:
org.postgresql.util.PSQLException: ERROR: invalid XML content
Detail: line 2: StartTag: invalid element name
On 3/14/14, 11:12 AM, Tim Kane wrote:
clone=# select xml_is_well_formed(' ');
xml_is_well_formed
t
(1 row)
clone=# select xpath_exists (‘//test', ' ');
ERROR: could not parse XML document
DETAIL: line 1: Start tag expected, '' not found
There are several
On 2/11/14, 6:25 PM, Vik Fearing wrote:
I personally find Markdown to be more pleasing to the eye than AsciiDoc.
Markdown can embed HTML tables, so there is nothing that we need to
implement.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
On 1/29/14, 4:59 PM, Neil Harkins wrote:
Why are those exclusive locks present?
Can't the database rely on mvcc for those reads
without locking? The autocommit should be
increasing the xid used for the reads, so the
ALTER should be able to slip in-between?
One would think so, but it's more
Commit fest 2014-01, the fourth and final commit fest in the PostgreSQL
9.4 development cycle, has started. What is a commit fest?
https://wiki.postgresql.org/wiki/CommitFest
As before, we need more people to help review submitted patches. How do
you help reviewing?
On Wed, 2013-11-20 at 14:57 -0500, Steven Dodd wrote:
I've read that setting LC_COLLATE to something other than C /
POSIX negatively affects performance, and disables use of indexes
for LIKE, etc...
It doesn't disable the use of indexes, you just need to create different
indexes.
Does the
Commit fest 2013-11, the third commit fest (out of four) in the
PostgreSQL 9.4 development cycle, will start this Friday, November 15.
What is a commit fest?
https://wiki.postgresql.org/wiki/CommitFest
We always need more people to help review submitted patches. You don't
have to be an
On 11/11/13, 1:33 AM, Jeffrey Walton wrote:
The analyzer is reporting some findings, and some of the findings look
legitimate.
We have been tracking clang scan-build results for some time, and fixed
quite a few of them. Most of the remaining ones are false positives.
Maybe there are still a
On 10/25/13, 7:20 AM, Marc Mamin wrote:
Hello,
I'm evaluating pg_upgrade and there seems to be something wrong with my test:
the data get copied within the old data directory instead of the new one
Do I have to explicitely set more option or define some environment variables
?
If this
On Sat, 2013-10-19 at 02:17 +0900, Amit Langote wrote:
Hi,
In 9.2 docs, the first link (i18ngurus) in the further reading section here:
http://www.postgresql.org/docs/9.2/static/multibyte.html
seems to be broken. Should it be updated/removed?
(I see it's removed in 9.3 docs)
I have
On 10/18/13 12:28 PM, bobJobS wrote:
If I analyze our database during a transaction and the transaction fails
(rollback occurs), with the table statistics rollback to their original
values?
Yes.
ANALYZE isn't really that special. It reads data from some tables, does
some math on it, and
In anticipation of the release of PostgreSQL 9.3, it is once again time
to update the message translations. We are now in a string freeze, which has
traditionally been associated with the first release candidate, so it's a
good time to do this work now.
If you want to help, see
On 8/7/13 10:43 AM, Seref Arikan wrote:
When a pl/python based function is invoked, does it keep a python
runtime running across calls to same function? That is, if I use
connection pooling, can I save on the python runtime initialization and
loading costs?
The Python interpreter is
On 6/6/13 11:49 PM, Rad Cirskis wrote:
Hi John,
have you managed to get it to link with external shared libs?
Sure, many extensions to that. Do something like
SHLIB_LINK += -lfoo
in your Makefile.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to
On 5/21/13 2:41 PM, Bruce Momjian wrote:
I have thought about this and there are potentially several options
specified to pg_upgrade that could be passed into scripts:
-O, --new-options=OPTIONS new cluster options to pass to the server
-P, --new-port=NEWPORTnew cluster port
On 3/20/13 4:28 PM, Sean Chittenden wrote:
For a while now I've known that sending a SIGINT can trigger a CHECKPOINT,
but I don't know if this is intentional or a bug.
It's intentional. If you don't want that, use SIGQUIT. That's how they
are different.
Of course, when using SIGQUIT, you
On 9/12/12 2:31 PM, Tom Lane wrote:
C is the official name of that locale. Not sure how you got it to say
POSIX ... maybe we didn't have normalization of the locale name back
then?
Says who? I think C and POSIX are distinct locales that just happen to
behave the same way.
--
Sent via
On Tue, 2012-09-11 at 01:21 -0400, Tom Lane wrote:
Mike Christensen m...@kitchenpc.com writes:
Oh reading the online docs, it looks like what I may have wanted was:
--format=custom
Right. That does everything tar format does, only better --- the only
thing tar format beats it at is you
On Fri, 2012-09-07 at 22:41 +0300, Gražvydas Valeika wrote:
What is the problem to provide both plpython2 and plpython3, or keep
same (2 or 3) plpython available by default on both platforms?
It is the decision of the respective packagers which version they
provide and how much effort they want
On Fri, 2012-08-24 at 15:48 -0600, Mathieu Fenniak wrote:
Hi pgsql-general,
Has anyone else ever noticed how slow it can be to rsync or tar a pgdata
directory with hundreds of thousands or millions of files?
Yes:
On Wed, 2012-08-29 at 10:31 -0700, Aleksey Tsalolikhin wrote:
What is the difference between C and en_US.UTF8, please?
There are many differences, but here is a simple one:
$ (echo a; echo A; echo b; echo B) | LC_ALL=C sort
A
B
a
b
$ (echo a; echo A; echo b; echo B) | LC_ALL=en_US.utf8 sort
a
A
(preferably on 9.2 Beta 3).
Not that I know of. There are Coverity reports on the Postgres source,
and I think Peter Eisentraut is familiar with them.
I am not familiar with pc-lint or anyone having used it with PostgreSQL.
I have used Coverity and the clang static analyzer, and they are both
work
On tor, 2012-06-21 at 07:49 +0200, P. Broennimann wrote:
select query_to_xml('select * from table12', true, true, '') into ...
The result is OK but there is always an empty line:
row xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance;
*-- Empty line here*
On mån, 2012-05-07 at 11:08 -0400, Randy Johnson wrote:
Hello,
I have a redhat E5 installation with PostgreSQL 7.4 installation. I have
been tasked with upgrading it to 9.x
I have read that I can install both versions at the same time via YUM and
edit the config file on the new
On tis, 2012-05-01 at 12:56 -0700, Mark Rostron wrote:
hi
I want to install madlib into a postgresql9.1.3 installation.
i am trying to:
a) make python2.7
b) configure postgresql to point at the python2.7 working directory,
and
c) install postgresql9.1.3 (using python2.7)
cd
On fre, 2012-04-20 at 09:15 +0100, Thom Brown wrote:
I had a look at the unaccent.rules file and noticed the following
characters aren't properly converted:
ß (U+00DF) An eszett represents a double-s SS but this replaces it
with one S. Shouldn't this be replace with SS?
Probably, but it
On ons, 2012-04-18 at 10:08 -0400, Tom Lane wrote:
Now having said that, you could certainly try adjusting the
DOCTYPE declaration in the docs and seeing if they'd build with 4.5.
It should work.
The problem, as I recall it, with DocBook 4.5 was that the are some
problems in the source
On fre, 2012-01-06 at 15:53 +0100, Damiano ALBANI wrote:
Do you plan on supporting SQL/MED features concerning DATALINKs?
I've seen DATALINK mentionned on the Wiki [1] but I couldn't find it on the
TODO list [2].
I'm not aware of any plans. What would be your use case?
By the way, do you
On tor, 2011-12-22 at 18:29 +0200, Andrus wrote:
How to force command
CREATE DATABASE yourdbname TEMPLATE = template0
to use et_EE.UTF-8 locale by default ?
If you don't want to re-initdb, you could just update the datctype and
datcollate columns of pg_database for template0.
If you want
On fre, 2011-12-23 at 17:32 +0200, Andrus wrote:
If you don't want to re-initdb, you could just update the datctype and
datcollate columns of pg_database for template0.
Thank you.
where to find sql update statement which does this ?
Is
update pg_database set datctype ='et_EE.UTF-8',
On sön, 2011-11-20 at 12:09 +0200, Andrus wrote:
Debian seems to require update-rc.d and Centos chkconfig
How to use single command for every distro ?
apt-get install chkconfig
/etc/init.d/postgresql start works in all distros. Adding to
postgresql to startup requires different commands in
On mån, 2011-11-14 at 08:08 -0800, MikeW wrote:
When I open *.sql files in my emacs it highlights the SQL and Postgres
syntax correctly. But does anybody know how to make it behave like
that also after invoking \e command in psql (so that I don't need to
say: M-x sql-mode each time). My
On ons, 2011-11-02 at 22:40 -0300, Martín Marqués wrote:
2011/11/2 John R Pierce pie...@hogranch.com:
On 11/02/11 11:21 AM, Martín Marqués wrote:
Don't worry, they are both x86 arch, so I'll just install 32bit
postgresql on the 64 bit server. That should make it work, right?
yes, that
On sön, 2011-10-02 at 15:45 -0400, Joseph S wrote:
Mismatch of relation names: database dbname, old rel
pg_toast.pg_toast_1280475, new rel pg_toast.pg_toast_1202320
Failure, exiting
This will be fixed in 9.1.2 (or get the code already from git).
--
Sent via pgsql-general mailing list
I don't have an answer for you, but this report looks suspiciously
similar to the one I posted the other day at
http://archives.postgresql.org/pgsql-hackers/2011-08/msg01224.php,
which, now that I think about it, also manifested itself after the
upgrade to 8.4.8.
On tis, 2011-08-30 at 15:24
On ons, 2011-08-31 at 10:42 +0300, Peter Eisentraut wrote:
I don't have an answer for you, but this report looks suspiciously
similar to the one I posted the other day at
http://archives.postgresql.org/pgsql-hackers/2011-08/msg01224.php,
which, now that I think about it, also manifested itself
In anticipation of the release of PostgreSQL 9.1, it is once again time
to update the message translations. We are now in a string freeze, which has
traditionally been associated with the first release candidate, so it's a
good time to do this work now.
If you want to help, see
On tor, 2011-08-25 at 14:05 +0200, Massa, Harald Armin wrote:
conclusion was that it's not documented because it's internal and
you're not supposed to use/rely on it.
My impression is that people are allready using it, relying their sharding
on it, even building indexes on it.
I think a
On tor, 2011-08-18 at 11:20 -0700, alexondi wrote:
Can I call initdb with some params as regular user (not root or postgres)?
Sure.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On mån, 2011-07-11 at 18:54 -0700, Lynn Dobbs wrote:
I am using query_to_xml with nulls set to false in postgresql 9.0.4.
(I believe the behavior was also present in 8.4.)
The documentation for query_to_xml says that if set to true, nulls
with be treated with xsi:nil=true and An appropriate
On mån, 2011-03-21 at 11:22 +0100, Durumdara wrote:
The language is Windows 1250 (ISO-8859-2).
I remembered that when I tried in 8.1 to create database as same in Windows:
CharSet: Win1250
Collation: - (disabled, and it is handled as HUN - iso-8859-2)
then I failed.
Because in Linux
On mån, 2011-02-07 at 12:44 +0100, rsmogura wrote:
I have test database with UTF-8 encoding. I putted there XML
aЁĄ¡/a, (U+0401, U+0104, U+00A1). I changed client encoding to
iso8859-2, as the result of select I got
ERROR: character 0xd081 of encoding UTF8 has no equivalent in
LATIN2
On tis, 2011-01-18 at 10:33 +1100, raf wrote:
p.s. if anyone in debian locale land is listening,
'E' does not sort before ','. what were you thinking? :-)
What is actually happening is that the punctuation is sorted in a second
pass after the letters. Which is both correct according to the
On fre, 2010-12-10 at 10:47 -0200, Henrique de Lima Trindade wrote:
I'm trying to find a regular expression that removes all small (length N)
words from a string. But, until now I've not been successful.
Here is a start:
select regexp_replace('Tommy Lee Jones', $$\y\w{2,3}\y$$, ' ', 'g' );
On tis, 2010-12-07 at 11:49 +0800, Craig Ringer wrote:
This is driving me nuts when working with PgJDBC via various ORM
layers (I know, I know, but they're life at this point) that would
work happily with these types if they were implicitly castable to/from
strings, but don't understand how to
On tor, 2010-12-02 at 19:53 +0200, Andrus wrote:
I'm trying to create portable application which can automatically
create
database using estonian locale in any server.
Postgres returns different values for same locale:
In Fedoraet_EE.UTF8
Other linuxeset_EE.UTF-8
In Windows
On ons, 2010-12-01 at 10:26 +0200, Andrus wrote:
How to get list of available locale names from Postgres ?
Why Postgres does not have command which returns available locale
names ?
How to use same locale names in every platform?
There is no portable operating system interface to get the
On mån, 2010-11-29 at 21:57 +0530, Mohammed Rashad wrote:
when i start postgresql using
/etc/init.d/postgresql-8.4 start
I am getting this error
IST FATAL: could not create lock file
/var/run/postgresql/.s.PGSQL.5432.lock: Permission denied
You probably need to run this command as root.
On mån, 2010-11-15 at 11:06 +0200, Andrus wrote:
Possibly someday the standard will actually standardize the things,
and then maybe we can work with them usefully ...
From http://tools.ietf.org/html/rfc4007#section-11.2
implementation SHOULD
support the following format:
On tor, 2010-11-11 at 20:33 +0200, Andrus wrote:
Windows uses % as subnet mask delimiter.
This is not a subnet mask but a zone index, but it should probably still
be supported.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
On sön, 2010-11-14 at 16:46 -0500, Tom Lane wrote:
Peter Eisentraut pete...@gmx.net writes:
On tor, 2010-11-11 at 20:33 +0200, Andrus wrote:
Windows uses % as subnet mask delimiter.
This is not a subnet mask but a zone index, but it should probably still
be supported.
I believe we
On sön, 2010-10-24 at 15:41 +0200, Reuven M. Lerner wrote:
But is there any way for me to get, in 8.3, the
number of rows over which a cursor has skipped? Keep in mind that
after
this count has executed, we're then going to rewind the cursor,
chunking
through the result set with a
On ons, 2010-10-06 at 18:18 -0700, Mike Christensen wrote:
ERROR: could not load library
/opt/PostgreSQL/9.0/lib/postgresql/uuid-ossp.so: libuuid.so.16:
cannot open shared object file: No such file or directory
SQL state: 58P01
apt-get install libossp-uuid16
--
Sent via pgsql-general
On tis, 2010-10-05 at 09:33 +0200, Massa, Harald Armin wrote:
Now I would love to have an additional check is the used psycopg2
linked to an advanced-enough libpq, to be able to set bytea_output to
'escape' if the libpq is not worthy.
This is really something that psycopg2 should work out for
On ons, 2010-08-25 at 00:15 -0700, wstrzalka wrote:
I'm currently playing with very large data import using COPY from
file.
As this can be extremely long operation (hours in my case) the nice
feature would be some option to show operation progress - how many
rows were already imported.
A
On fre, 2010-07-30 at 16:45 -0500, Derek Arnold wrote:
Has there ever been any interest in adding a keyword option for
returning row lists rather than dicts?
I don't think so, but it sounds like a reasonable idea. Other possible
approaches are
- Using a factory class like psycopg
On fre, 2010-06-18 at 02:43 +0800, Craig Ringer wrote:
The xml datatype documentation should probably mention that whole
documents must be loaded with an XMLPARSE(DOCUMENT 'doc_text_here),
they
cannot just be cast from text to xml as happens when you pass an xml
document as text to a
On lör, 2010-06-19 at 22:56 +0100, David Goodenough wrote:
These projects need help to realise that adding Postgresql is not a
big
job, especially for those using JDBC which can already connect to all
DBs. It strikes me that if the project could write a few pages
gleaned
from other porting
On lör, 2010-06-12 at 11:18 +0200, John Gage wrote:
A one file html version would be a godsend.
I've committed a build target for that now. Use 'make postgres.html' in
doc/src/sgml/.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
On lör, 2010-06-12 at 09:10 -0400, Tom Lane wrote:
Peter Eisentraut pete...@gmx.net writes:
On lör, 2010-06-12 at 11:18 +0200, John Gage wrote:
A one file html version would be a godsend.
I've committed a build target for that now. Use 'make postgres.html' in
doc/src/sgml/.
Huh
On tis, 2010-06-08 at 11:04 +0200, John Gage wrote:
Yet, the only one file edition of the Postgres documentation is
in...pdf format. Huh?
I know. I know. I have already brought this up. And various ways
of
creating a one file text edition of the documentation have been
proposed
On tis, 2010-05-25 at 12:05 -0400, Richard Wallace wrote:
1) When using cursor_to_xml in a plpgsql function, the FOUND variable does
not seem to get set, so there is no way to exit a loop that is iterating over
the cursor. Below is the function code; it loops indefinitely when it is run.
On lör, 2010-05-15 at 22:50 -0700, Yang Zhang wrote:
On Sat, May 15, 2010 at 10:20 PM, Peter Eisentraut pete...@gmx.net wrote:
You have null bytes in the data value, which is not supported very well
in PL/Python. Try the 9.0 beta version; it should be fixed there.
Thanks. Out of curiosity
1 - 100 of 934 matches
Mail list logo