On lör, 2010-05-15 at 15:40 -0700, Yang Zhang wrote:
yang=# select * from qapb;
id | pb
+
0 | \012\006hello?\020\000\030\000 \000*\014\012\006hello!\020\000\030\000
(1 row)
On ons, 2010-05-12 at 15:24 +0200, John Gage wrote:
Yes it would. In fact, I have often wondered why this doesn't exist.
How can I do it?
cd doc/src/sgml
make html JADEFLAGS='-V nochunks -V rootchunk'
That will produce an index.html file with the entire documentation in
it.
--
Sent via
On lör, 2010-05-08 at 11:06 +0200, John Gage wrote:
Is the documentation available anywhere as a single page text file?
This would be enormously helpful for searching using regular
expressions in Vim, for example, or excerpting pieces for future
reference.
It would be pretty easy to
On tis, 2010-05-04 at 09:19 +0100, Grzegorz Jaśkiewicz wrote:
2010/5/3 Peter Eisentraut pete...@gmx.net:
It was a convenient choice. You could propose a different method for
generating the specific routine name, but given that it has to fit into
an identifier and has to allow for function
On fre, 2010-04-30 at 17:36 +0100, Grzegorz Jaśkiewicz wrote:
why specific_name column on that view contains also OID ?
This makes two databases that are identical, have different values
there. Is there any specific reason for that ?
It was a convenient choice. You could propose a different
On fre, 2010-04-09 at 18:01 -0400, Josh Kupershmidt wrote:
I often come across tables with either a unique index or a unique
constraint on them, and psql isn't helpful at showing the difference
between the two. Normally, I don't care which is which, except for
when I have to manually drop and
In anticipation of the release of PostgreSQL 9.0, it is once again time
to update the message translations. We are not very near a string
freeze yet, which has traditionally been associated with the first
release candidate, but I feel that things are already stable enough to
begin this work now.
On ons, 2010-03-10 at 12:04 +0600, AI Rumman wrote:
I am getting the following error during Postgresql 8.1 installation:
error: C preprocessor /lib/cpp fails sanity check
Please any suggestion how to solve it.
Check the config.log file. I would guess it's somewhat likely that you
don't
On tis, 2010-01-05 at 16:35 +0100, Claudio Eichenberger wrote:
Hello,
In older PostgreSQL installations 8.4 I used the following pg_hba.conf
syntax:
local all pgsql ident PGSQL
but 8.4.1 8.4.2 require the following syntax:
local all pgsql ident
On tis, 2010-01-05 at 16:06 -0800, Andrew Lardinois wrote:
Poking around in the 8.5 Devel Documentation section 8.13.1, the XML
Type, I noticed that:
The xml type does not validate input values against a document type
declaration (DTD), even when the input value specifies a DTD
I suppose
On mån, 2009-12-14 at 09:27 -0500, Tom Lane wrote:
Alvaro Herrera alvhe...@commandprompt.com writes:
Tom Lane wrote:
Hm, I wonder whether the reason the OP ran into trouble was that he
followed that guide :-(. Relying on manual invocation of configure
is a sure recipe for hitting weird
On mån, 2009-12-14 at 16:58 +0100, Philippe Lang wrote:
My idea was to parse the functions definitions in order to build
dependencies between the functions. I'm not sure how difficult it is,
especially with overloaded functions, which require more than a simple
pattern search inside the
On tor, 2009-12-03 at 10:09 -0500, Tom Lane wrote:
Alvaro Herrera alvhe...@commandprompt.com writes:
Should we recast the attributes and columns views in information_schema?
I notice they still use attnum.
I'd vote against it, at least until we have something better than a
row_number
On ons, 2009-11-18 at 22:33 -0800, Scott Bailey wrote:
The only I/O functions I'm aware of are
send, recv, in and out. What controls converting from/to wire and
on-disk formats?
send and recv
And why is wire format little endian and disk big endian?
The wire format is network order
On lör, 2009-11-14 at 10:12 +, Garry Saddington wrote:
How could I list all the tables in a database that do not contain any data?
I have looked at reltuples but can't quite work out how to use it, any
pointers would be much apreciated.
select * from pg_class where relkind = 'r' and
On tis, 2009-11-10 at 14:10 -0800, Richard Broersma wrote:
On Tue, Nov 10, 2009 at 2:04 PM, Peter Eisentraut pete...@gmx.net wrote:
Well, a lot of hard work. ;-) Just like there are coding standards and
best practices, there are standards and customs in writing and
publishing
On ons, 2009-11-11 at 08:32 -0500, Bill Moran wrote:
In response to Peter Eisentraut pete...@gmx.net:
* The Elements of Style
Hope this doesn't start a flame war, but:
http://chronicle.com/article/50-Years-of-Stupid-Grammar/25497
Yeah, you need to be prepared to reject about 30
On mån, 2009-11-09 at 23:13 +0100, hubert depesz lubaczewski wrote:
configure:27984: checking for DocBook V4.2
onsgmls:/etc/xml/catalog:2:78:E: name expected
onsgmls:/etc/xml/catalog:2:18:E: cannot find PUBLIC; tried
/etc/xml/PUBLIC, /usr/share/sgml/PUBLIC, /usr/share/xml/PUBLIC
Looks like
On mån, 2009-11-09 at 19:49 -0300, Alvaro Herrera wrote:
hubert depesz lubaczewski wrote:
= pacman -Ql docbook-sgml
docbook-sgml /usr/
docbook-sgml /usr/share/
docbook-sgml /usr/share/sgml/
docbook-sgml /usr/share/sgml/docbook-sgml-4.2/
docbook-sgml
On tis, 2009-11-10 at 07:00 -0800, David Fetter wrote:
Well, there's the whole Docbook thing, which was pretty well thought
out. Apart from that, I don't know. Peter?
Well, a lot of hard work. ;-) Just like there are coding standards and
best practices, there are standards and customs in
On mån, 2009-11-09 at 20:16 +0100, hubert depesz lubaczewski wrote:
my docbook related packages:
= pacman -Q | grep -i docbook
docbook-xml 4.5-3
docbook-xsl 1.74.0-1
docbook2x 0.8.8-7
You need the SGML version of DocBook.
--
Sent via pgsql-general mailing list
On mån, 2009-11-09 at 10:57 +, David Edwards wrote:
If we have users from all over the world storing data in our database
with all sorts of languages, which locale should we use to ensure
these string functions behave as they expect?
Try en_US.utf8. It is pretty language neutral.
--
On ons, 2009-10-28 at 14:13 +, Thom Brown wrote:
http://developer.postgresql.org/pgdocs/postgres/release-8-5.html
Thanks Adrian. I just wasn't looking hard enough obviously :) That
list still doesn't appear to be explicit enough though as we have
Multiple improvements in
On ons, 2009-10-28 at 05:45 -0700, Xai wrote:
i want to create a type for an email field but i'm not good with regx
can some one help me?
I suggest that you make use of an already written module in some
language such as Perl. See
http://wiki.postgresql.org/wiki/Email_address_parsing for an
On Thu, 2009-10-22 at 03:13 -0700, Mike Christensen wrote:
It has occurred to me that there might be some advantages of creating
a separate table called OrderArchive which would be used to store
order states 3 or 4. This would allow me to get rid of an index on
order state as well as probably
On Mon, 2009-10-12 at 15:17 +0400, Vasiliy G Tolstov wrote:
Hello.
Today i'm try to install postresql an init database
initdb --pgdata=/media/pgsql --encoding=utf8 --locale=en_US.UTF-8
--auth=crypt --username=postgres --pwprompt
password is crypted $1$qJzh/8AD$Q0wVsHF9XE9NmA/8uKjy2/
On Mon, 2009-10-12 at 16:06 +0400, Vasiliy G Tolstov wrote:
В Пнд, 12/10/2009 в 15:04 +0300, Peter Eisentraut пишет:
Use --auth=md5.
Why? crypt is deprecated?
Yes, and removed in 8.4.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
On Fri, 2009-10-09 at 00:10 -0700, Mike Christensen wrote:
Wouldn't (4,3) let me store 0.000 through 9.999? Maybe I'm still not
following what both numbers mean.
Yes. If you want 0.000 through 0.999, use numeric(3,3). Adding a check
constraint might increase clarity. And put it in a domain
On Fri, 2009-10-09 at 11:46 -0700, Christophe Pettus wrote:
Domains are basically type aliases with an optional CHECK clause, so
you could do something like:
CREATE DOMAN sales_tax_rate AS DECIMAL(5,5) CHECK (VALUE = 0);
Then, you can use the type sales_tax_rate in your tables,
On Sat, 2009-10-03 at 11:33 +0100, Thom Brown wrote:
I've found that I unwittingly compiled PostgreSQL on my web server
without specifying locale,
PostgreSQL isn't compiled with a locale or without one.
and now the money type is represented in dollars. In order to change
that, it would
On Tue, 2009-09-29 at 03:21 -0600, Scott Marlowe wrote:
On Tue, Sep 29, 2009 at 2:52 AM, Paul Gaspar devl...@revolversoft.com wrote:
Hi!
We have big problems with collation in ORDER BY, which happens in binary
order, not alphabetic (lexicographical), like:.
A
B
Z
a
z
Ä
Ö
On Mon, 2009-09-28 at 10:08 -0700, John wrote:
On Monday 28 September 2009 09:56:33 am Filip Rembiałkowski wrote:
BTW, you did not specify what exactly did not work when you tried apgdiff.
this would help others to help you.
To be honest I could not determine how to start the app.
On Thu, 2009-09-24 at 20:36 -0400, Tom Lane wrote:
BTW, are port numbers still limited to 16 bits in IPv6?
Port numbers are in TCP, not in IP.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
On fre, 2009-09-18 at 14:05 +1000, Johnson, Trevor wrote:
Using Moodle with PostgreSQL 8.4 and we get warning messages...
2009-09-18 13:48:11 ESTWARNING: nonstandard use of escape in a string
literal at character 209
2009-09-18 13:48:11 ESTHINT: Use the escape string syntax for
escapes,
On Mon, 2009-09-14 at 00:36 +0200, Daniel Schuchardt wrote:
I know you are true with definition's and standards, however, that code
works for about 6 years ;o)
Well, we will change our parser behavoir. We will check out that
standard_conforming_strings parameter too but i see a lot of
On sön, 2009-09-13 at 18:51 +0200, Daniel Schuchardt wrote:
UPDATE belzeil_frei SET bz_zubez= '*', bz_zubez_rtf=
'{\\rtf1\\ansi\\deff0{\\fonttbl{\\f0\\fnil\\fcharset0
Arial;}}\r\n\\viewkind4\\uc1\\pard\\lang1031\\fs20 *\r\n\\par }\r\n\0'
WHERE dbrid=295116
Result : ERROR: invalid byte
On sön, 2009-09-13 at 22:21 +0200, Daniel Schuchardt wrote:
First:In Postgres81 everything is working fine.
In general, older versions of PostgreSQL treated encoding issues much
mroe loosely, which subsequently lead to user errors, bugs, and
confusion. Later versions are more strict.
On Fri, 2009-09-11 at 13:17 +0700, Ricky Tompu Breaky wrote:
It seems that the aptitude can not find the postgresql.
Please post the exact output from the screen.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
On Sun, 2009-08-16 at 21:10 +0100, Andre Lopes wrote:
I need a plpgsql function to validade e-mail addresses. I have google
but I can't find any.
My question: Anyone have a function to validate e-mails?
I recommend something based on the following recipe in PL/Perl.
On Tuesday 28 July 2009 04:38:03 Jeff Davis wrote:
On Mon, 2009-07-27 at 21:05 -0400, Robert James wrote:
1) Introduction to Database Systems
http://www.amazon.com/Introduction-Database-Systems-Kannan-Swamynathan/dp
/B001BVYKY4/ref=sr_1_5?ie=UTF8s=booksqid=1248742811sr=1-5
and
2)
On Tuesday 28 July 2009 02:53:19 Christophe Pettus wrote:
I'm moving from a long time in BSD-land to using Linux. I've always
been in the habit of building PostgreSQL from the source tarballs. On
Linux, is there an advantage either way to using the RPMs as opposed
to building from source?
On Monday 20 July 2009 19:46:01 Radek Novotný wrote:
query_to_xml('select Nazev as TITLE, Datum as DATE, Autor_Akce as meta
rel=''action_author'',
gave me
table xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance;
row
TITLETest/TITLE
DATE2009-07-20/DATE
On Tuesday 21 July 2009 04:36:41 Phoenix Kiula wrote:
On Mon, Jul 20, 2009 at 2:04 PM, Peter Eisentrautpete...@gmx.net wrote:
On Monday 20 July 2009 06:45:40 Phoenix Kiula wrote:
explain analyze select * from sites where user_id = 'phoenix' order by
id desc limit 10;
On Monday 20 July 2009 06:45:40 Phoenix Kiula wrote:
explain analyze select * from sites where user_id = 'phoenix' order by
id desc limit 10;
QUERY PLAN
---
On Wednesday 15 July 2009 23:02:47 Abraham, Danny wrote:
Actually the command is:initdb --encoding=LATIN1.
It fails on Windos. fails on Windows
The same command worked fine on PG 8.2.4.
Now, using 8.3.7, the command succeeds only with encoding 1252.
It comments something on wrong
On Thursday 16 July 2009 09:03:09 Steve Choi wrote:
Hello. Thank you for your int
If I queryed on PostgreSQL, SELECT Item_ID FROM Engine,
I want to export the result to Single XML file. How can I make it? Have a
nice day. Thank you for your answer. :)
On Thursday 16 July 2009 12:14:48 Rafael Martinez wrote:
ERROR: incompatible library /usr/local/lib/pg_uname_8.4.so: magic
block mismatch
DETAIL: Server has FLOAT8PASSBYVAL = true, library has false.
You need to recompile your module.
--
Sent via pgsql-general mailing list
On Thursday 16 July 2009 02:12:05 ANdreas Wenk wrote:
Hi,
I recognized in psql using the internal help (\?) that the *+* sign is
missing for the shortcut \du:
# \du
List of roles
Role name | Attributes | Member of
--+--+---
# \du+
On Tuesday 14 July 2009 13:02:14 Nenad Milasinovic wrote:
Hello,
I am interested can PostgreSQL be used in commercial applications, and
what is licensing policy. I know that PostgreSQL is released under BSD
licence,
but still i want to be sure are there any costs when distributing
On Saturday 04 July 2009 02:57:35 Scott Bailey wrote:
On ubuntu from command line:
createlang -h localhost -p 5433 plpythonu template1
createlang: language installation failed: ERROR: could not load library
/opt/postgres/8.4/lib/postgresql/plpython.so: libpython2.3.so.1.0:
cannot open
On Friday 03 July 2009 06:09:37 Scott Bailey wrote:
I'm having trouble installing plpython in 8.4. I tried under Windows
(one click installer from EDB) and under Ubuntu (linux binary). In both
cases I was told:
could not load library 8.4/lib/postgresql/plpython.(so|dll)
Both systems have
On Tuesday 16 June 2009 03:16:19 gvimrc wrote:
I'm fairly new to PostgreSQL and completely new to using pl/pgsql though
I've used MySQL's procedural language a little. I heard pl/pgsql is similar
to Oracle's pl/sql so would it be possible, given that pl/pgsql literature
is a bit thin on the
On Thursday 11 June 2009 21:48:22 Dave Page wrote:
Can you embed the files on the PUGs page like JD suggests? What I want
to avoid is an ad-hoc website springing up on media.postgresql.org
that ends up in Google and being linked from who-knows-where.
While there is a point to that, having the
On Monday 01 June 2009 12:53:08 Grzegorz Jaśkiewicz wrote:
is there any way currently to convert xml file in format like below,
to a table ?
I have some code that does this, but it was written a long time ago and will
probably need some polishing.
One main problem is how you specify that
On Tuesday 12 May 2009 02:30:56 Vikram Patil wrote:
I was able to compile on all of the platforms but I want to know about
minimum and recommended version requirements for these systems. I am
concerned about performance of these binaries and looking to achieve
performance of these binary as
On Thursday 23 April 2009 18:30:27 Dan Armbrust wrote:
I had a test system (read as not backed up, sigh) which had the disk
go full while PostgreSQL was loaded, consequently, PostgreSQL will no
longer start.
It is logging an error about detecting an invalid shutdown, trying to
replay
On Thursday 23 April 2009 20:33:56 zach cruise wrote:
is it recommended to change encodings for template0 and template1 to
utf8 (by recreating databases) for 8.1?
Not if you don't have a specific reason for doing so.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To
On Tuesday 21 April 2009 20:26:24 marek.patr...@gmail.com wrote:
I was wondering if dropping a table is more efficient in PostgreSQL
8.x in comparison to deleting it's content ?
Yes, but if you are asking that question, you probably really want to use
TRUNCATE.
--
Sent via pgsql-general
On Sunday 19 April 2009 19:57:40 Raymond O'Donnell wrote:
I remember some time back there was a discussion about implementing a
single catch-all command for PostgreSQL, to replace (or perhaps rather
encompass) the various other utilities we currently use (psql, pg_dump,
createdb, etc etc).
On Sunday 22 March 2009 13:03:29 Gregory Stark wrote:
Peter Eisentraut pete...@gmx.net writes:
This will, however, only work with GNU Gettext (as used in Linux and BSD
distributions) and Solaris 9 or later, and it is not easy to provide a
backward compatible mode.
Eh? I thought
Sam Mason wrote:
On Thu, Mar 19, 2009 at 04:22:56PM +0200, Peter Eisentraut wrote:
Joins nest from left to write, so
tbl_c NATURAL JOIN tbl_a NATURAL JOIN tbl_b
means
(tbl_c NATURAL JOIN tbl_a) NATURAL JOIN tbl_b
If you want a different order, you can set the parentheses differently
There is a proposal being discussed on the hackers list about adding
gettext plural support to the national language support (NLS) feature
(--enable-nls) in the upcoming PostgreSQL 8.4. This would mean that
plurals of translated messages (e.g., in psql: 1 row/n rows) will work
properly in
Thom Brown wrote:
SELECT tbl_a.location, tbl_b.language
FROM tbl_c
NATURAL INNER JOIN tbl_a
NATURAL INNER JOIN tbl_b
The confusion comes when 2 of those tables reference the 3rd table using
the same column.
So are natural joins only allowed to join 2 tables? If not, how can it
be used for
On Wednesday 18 March 2009 19:50:17 Jeffrey Trimble wrote:
I've got a question regarding ./configure.
In v. 8.013 (okay, I'm running old stuff) we had the following options:
--with-java
--with-multibyte
--with-unicode
In attempting to upgrade to 8.3.7, those flags are ignored. That's
On Thursday 05 March 2009 00:19:02 Daniel Verite wrote:
SET DATESTYLE takes predefined keywords such as ISO or US as arguments,
but I can't find a way to specify a custom format string for
timestamps.
There is no support for that.
What I'd like to find is an equivalent to Oracle's
ALTER
On Thursday 05 March 2009 18:39:11 Stuart Luppescu wrote:
Hello, I'm trying to install phpScheduleIt (an on-line calendaring
application) on my system that has postgres 8.0.15 running. I have to
admit upfront that I have very little idea how postgres works; my
small-business accounting system
Xavier Bugaud wrote:
Postgresql is supposed to have the correct Mauritius timezone since 8.3.5
(http://www.postgresql.org/docs/8.3/interactive/release-8-3-5.html).
From a debian box configured in the Mauritius timezone :
PostgreSQL on Debian uses the operating system's time zone database.
On Friday 27 February 2009 19:09:57 Enrico Sirola wrote:
Hello,
I have a pgsql database hosting xml data in xml columns. The data,
have !DOCTYPE declarations at the beginning, so it is saved with
XMLPARSE (DOCUMENT text)
when I try to restore a database from dump, pg_restore complains
On Thursday 19 February 2009 16:46:42 Francisco wrote:
Hi List,
I have installed postgreSQL 8.3 in my Ubuntu Hardy Heron.
I want to use xpath functions (like xpath_table), but I can't. An error
appears xpath_table does not exists.
How could I intregrate xpath funtions with my postgreSQL
Serge Fonville wrote:
Can PostgreSQL use DRBD as its storage?
Yes, many deployments use this.
Since the in-memory database would be synchronized with the on-disk
database.
If this would be done with every query, this would greatly impact
performance.
Performance with DRBD is usually
Serge Fonville wrote:
So, DRBD dual primary and Cybercluster multimaster, cannot be combined?
If you have questions on Cybercluster, you should perhaps ask there for
details. For normal PostgreSQL, using DRBD dual primary is not possible.
My endgoal is a two node cluster with load
Gregory Stark wrote:
I'm putting together a talk on PostgreSQL Pet Peeves for discussion at
FOSDEM 2009 this year.
Perhaps you could post a conclusion to this, with some worst of
statistics or something. I didn't see your talk, but I was getting a
sense that the feedback seen on this list
On Wednesday 11 February 2009 18:00:31 Tom Lane wrote:
Peter Eisentraut pete...@gmx.net writes:
Tom Lane wrote:
Reflecting on the bigger picture ... I would imagine that the vast
majority of existing applications depend on client_encoding settings
that come from postgresql.conf, ALTER
Tom Lane wrote:
Reflecting on the bigger picture ... I would imagine that the vast
majority of existing applications depend on client_encoding settings
that come from postgresql.conf, ALTER USER SET, ALTER DATABASE SET, or
just the default (== database encoding). I don't think a solution that
Tom Lane wrote:
I believe the only real fix is to guarantee that messages are sent
as untranslated ASCII until we have sent an encoding indicator at
the end of the startup sequence. Which has its own pretty clear
downside: no more translation of authorization failures.
We should process the
SHARMILA JOTHIRAJAH wrote:
Ive been struggling to query some of my oracle tables from postgres
using the dbi_link and its not working.
Have anyone tried ora2pg for querying the oracle database from postgres?
ora2pg is not really made for that. It is for a one-time conversion.
--
Sent via
Bruce Momjian wrote:
Can someone comment on this?
Looks like a horrible hack to me. Recoding stuff to the client encoding
in the server outside the existing recoding mechanism looks pretty evil
to me. Plus, it does not address the problem of what happens to
messages sent before this, it
Alvaro Herrera wrote:
A trivial, stupid implementation is perhaps not too difficult. The
problem is getting the smarts right, i.e. an optimized version. You
certainly don't want to be executing a query against a large table for
every INSERT on another one, for example; it's better if if you
Grzegorz Jaśkiewicz wrote:
also, how hard would it be to implement CREATE ASSERTION, and where
do you see it (and maybe Tom could anwer that one too).
Would you say, it would be possible for someone with my knowledge of
postgresql internals (vague), but with very good C to do it
I think you
On Wednesday 04 February 2009 20:36:24 Grzegorz Jaśkiewicz wrote:
I dream about db wide checks on tables, without need to write
expensive triggers.
Basically, something that would run a select query after
insert/update/delete and based on result commit or rollback.
unless there's something
On Wednesday 04 February 2009 19:39:42 John DeSoi wrote:
Somewhat related, it would be nice if columns had a unique identifier
in the catalog rather than just a sequence number for the table. This
would make it possible to distinguish between altering a column versus
dropping/adding when
On Wednesday 04 February 2009 15:48:41 A B wrote:
From the manual I read that timestamps are stored as double but they
can also be stored as 8 byte integers.
The advantage of the integer storage is mainly that calculations and
comparisons have a predictable error and don't suffer from some of
Gregory Stark wrote:
So, what do people say? Is Postgres perfect in your world or does it do some
things which rub you the wrong way?
* No offer of anything-but-CVS on pgfoundry.org
* Lack of REINDEX CONCURRENTLY
* Too many obscure configuration options: memory management, autovacuum
On Tuesday 20 January 2009 03:27:14 Henry Interiano wrote:
Hola a todos
necesito ayuda como configurar mi base de datos como aceptar conexiones ssl
desde cualquier ip, mi base de datos esta instalada en Windows:
- pgsql-es-ay...@postgresql.org
--
Sent via pgsql-general mailing list
A. Kretschmer wrote:
Not sure, but host is a reserved word, see:
http://www.postgresql.org/docs/8.1/interactive/sql-keywords-appendix.html
That list says that HOST is reserved in SQL:1999, but not in PostgreSQL.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
On Wednesday 31 December 2008 20:23:47 Tom Lane wrote:
The proper fix is probably to include the client encoding in the
connection startup message.
What of errors occurring before such an option could be applied?
Connection errors are handled by the client, which knows the client encoding.
On Wednesday 31 December 2008 18:57:29 Karsten Hilbert wrote:
The solution is to find the right layer to take control of the encoding but
this is eventually only possible if the encoding is *known*. Thus the plea
for 7-bit-ascii English by default until the encoding *can* be known.
Going to
Joshua J. Kugler wrote:
OK, that makes sense. There was nothing on the TRUNCATE page to suggest
that TRUNCATE would lock the tables. Maybe an addition to the
documentation is in order? Where do I go to suggest that?
I have added something to document this.
--
Sent via pgsql-general
novnov wrote:
I have restored a postgres 8.2.4-1 db onto a postgres 8.3.1-1 server, and
when I try to work with a table I get this error:
Error: Operator does not exist: char = integer
Hopefully that is enough of a clue to be useful. Maybe this is the first
time I've tried moving one of my
On Wednesday 17 December 2008 11:40:18 Thomas Kellerer wrote:
as the Enterprise DB distribution (One Click Installer) seems to be the
recommendation from the Postgres team for a binary download, I wonder what
the exact difference between Postgres and Postgres Plus is.
There is actually a bit
On Wednesday 17 December 2008 12:18:04 Joshua J. Kugler wrote:
Begin
Truncate table1, table2
for row in file1:
insert into table1
sleep(0.001) # see note below
for row in file2:
insert into table2
sleep(0.001) # see note below
Commit
During the time where the insert
Letinarh wrote:
I have a large XML file (about 130 Mb) and I want to parse it using
plpg/sql. here comes two questions:
1. How can I upload it? (only by means of `Large Object`?)
You can just insert it normally using INSERT or whatever other method
you use for getting data into the database.
Andrus wrote:
Peter,
You probably want et_EE. (Language and country codes are not always
consistent.)
I don't understand this.
Command line which I posted uses et_EE
What is the exact command line ?
Uh, forget that.
Does locale -a show the locale you want?
If not, run dpkg-reconfigure
Thomas Guettler wrote:
My naive first solution was quite slow. Why is it so slow?
I guess (select d.master_id from detail as d) gets executed for every
master-row. But why? Shouldn't
it be possible to calculate it once and then reuse it?
Please show exact schema dumps and your PostgreSQL
Andrus wrote:
How to create cluster with et_EE locale ?
You probably want et_EE. (Language and country codes are not always
consistent.)
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
On Friday 21 November 2008 19:10:45 Tom Lane wrote:
Yeah, I think this is most probably explained by repeat postings
of successive versions of large patches. Still, Ron might be on to
something. I had not considered message lengths in my previous
numbers ...
Also consider that since we
David wrote:
[EMAIL PROTECTED]:/etc/init.d$ sudo /etc/init.d/postgresql-8.2 start
* Starting PostgreSQL 8.2 database server
* Error: specified cluster does not exist
[fail]
and the same error when passing stop
The cluster clearly
Alvaro Herrera wrote:
Tom Lane escribió:
However, the interval version of the function can capture the time case
because there's an implicit cast from time to interval:
regression=# select casttarget::regtype,castcontext,castfunc::regprocedure from
pg_cast where castsource = 'time'::regtype;
Tom Lane wrote:
Alvaro Herrera [EMAIL PROTECTED] writes:
Tom Lane escribi�:
regression=# select casttarget::regtype,castcontext,castfunc::regprocedure from
pg_cast where castsource = 'time'::regtype;
BTW it very much looks like we should have a pg_casts view that displays
these things in a
Craig Ringer wrote:
So - it's potentially even worth compressing the wire protocol for use
on a 100 megabit LAN if a lightweight scheme like LZO can be used.
LZO is under the GPL though.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
101 - 200 of 934 matches
Mail list logo