I modify pg_createcluster and add locale options
exec $initdb, '--locale', 'ru_RU.UTF-8', '--encoding', 'UTF-8', '-D', $datadir
then drop and create cluster with my locale. now lower and upper work
good with unicode.
P.S.
it's bad that we can not modify lc_ctype and lc_collate from
On Thu, Mar 24, 2005 at 09:24:11AM +0200, Sim Zacks wrote:
The difference between a Tab and a newline is that tab is a universally
recognized single ascii character while newline is in flux. Aside from this,
a tab is a quasi-viewable character as the cursor will not go to the middle
of the
Hi Edward,
Michael Fuhr's solution worked (Mar 11). I had to write a method to
insert four backslashes into the the path been searched for. For
example if the stored path in the DB was folder1\folder2\folder3\ in
order for PostgreSQL to serach against this i had to search for path
LIKE
Hi
I am new to PostgreSQL and find that the standard documentation is very
thin. I would like to buy a more comprehensive book. All the available
books seem very out of date!!! Firstly, does it matter if I buy a book
that was published in Feb 2003? Will such a book be hopelessly out of
date?
On Thu, 2005-03-24 at 06:37, [EMAIL PROTECTED] wrote:
Hi
I am new to PostgreSQL and find that the standard documentation is very
thin. I would like to buy a more comprehensive book. All the available
books seem very out of date!!! Firstly, does it matter if I buy a book
that was published
On Thu, Mar 24, 2005 at 14:37:59 +0200,
[EMAIL PROTECTED] wrote:
Hi
I am new to PostgreSQL and find that the standard documentation is very
thin. I would like to buy a more comprehensive book. All the available
books seem very out of date!!! Firstly, does it matter if I buy a book
that
[EMAIL PROTECTED] wrote:
I am new to PostgreSQL and find that the standard documentation is
very thin.
It's about 1200 pages, which is thicker than any other book you will
find.
Certainly, some books cover specific topics in more depth or different
style, but you need to decide which topics
On Wed, Mar 23, 2005 at 08:49:22PM -0700, A. Mous wrote:
case, all test win2K machines (Celeron 400 up to pIII 800) retrieved the
data from disk in under 100ms but took an additional 4000ms to send to the
local client. This is observed even if QoS packet scheduler is installed.
If you connect
Hi Bruno
There are a lot of the topics that I feel could have better (or more
comprehensive examples). In particular I am thinking of plpgsql. One
example is information about working with Exceptions (postgresql specific)
and another is the small amount of info about the RAISE Statement.
On Mon, Mar 14, 2005 at 11:35:12PM -0700, Steve - DND wrote:
I was reading through the docs today, and came across a paragraph that
indicated when plpgsql queries are executed on the server, the results are
all written to memory(or disk if necessary), and not streamed as available.
I can't
On Wed, 2005-03-23 at 18:25 -0500, Tom Lane wrote:
Sven Willenberger [EMAIL PROTECTED] writes:
I have been experiencing an issue with plperl and PostgreSQL 8.0.1 in
that after calling a plperl function memory does not get released.
AFAICT the result of spi_exec_query gets released fine, as
Hallo all,
using at least PostgreSQL 7.4.2, one can use the command
COMMENT ON CONSTRAINT constraint_name ON table_name;
to document a constraint defined via
CONSTRAINT constraint_name ...
in the context of a table.
Now, imagine you know the name of a constraint or all of them for
On Thu, Mar 24, 2005 at 03:41:06PM +0200, [EMAIL PROTECTED] wrote:
Craig,
There are a lot of the topics that I feel could have better (or more
comprehensive examples). In particular I am thinking of plpgsql. One
example is information about working with Exceptions (postgresql specific)
and
On Thu, 2005-03-24 at 08:41, [EMAIL PROTECTED] wrote:
Hi Bruno
There are a lot of the topics that I feel could have better (or more
comprehensive examples). In particular I am thinking of plpgsql. One
example is information about working with Exceptions (postgresql specific)
and another is
Martijn van Oosterhout kleptog@svana.org writes:
IMHO, if you're trying to write portably, don't just hit enter when you
want an end of line, use \n or \r to indicate *exactly* what you mean.
Indeed. We are already permissive about line endings in SQL text, so
this discussion really boils down
I'm a little fuzzy on this, and I've been unable to find docs that clear
it up for me. A pointer to a helpful doc would be just as welcome as an
outright explanation ;)
Let's take the following fictional scenerio:
BEGIN;
INSERT INTO table1 VALUES ('somestring');
INSERT INTO table1 VALUES
Let's take the following fictional scenerio:
BEGIN;
INSERT INTO table1 VALUES ('somestring');
INSERT INTO table1 VALUES ('anotherstring');
SELECT user_defined_function();
COMMIT;
In this case, user_defined_function() does a lot more table manipulation.
I don't want that to be done if any
If you are looking for a database theory book, I highly recommend An
Introduction to Database Systems by C.J. Date. It's very theoretical,
but it's precisely worded and very interesting.
Regards,
Jeff Davis
On Thu, 2005-03-24 at 06:54 -0600, Scott Marlowe wrote:
On Thu, 2005-03-24 at
Wolfgang Drotschmann [EMAIL PROTECTED] writes:
Now, imagine you know the name of a constraint or all of them for a given
table, e.g. destilled via
SELECT *
FROM information_schema.table_constraints
WHERE table_name = 'table_name';
How can I get the comment for each of
Robert Treat [EMAIL PROTECTED] writes:
On Thu, 2005-03-24 at 08:41, [EMAIL PROTECTED] wrote:
Refering to my mention of exceptions above, the following is information
that I could not find in the standard docs:
How to use(Return using RAISE) the actual exception code and message once
you have
There's actually a list of recommended books up on techdocs:
http://techdocs.postgresql.org/#books
It could use a little updating, but is still pretty good.
Robert Treat
On Thu, 2005-03-24 at 09:57, Jeff Davis wrote:
If you are looking for a database theory book, I highly recommend An
Bill Moran [EMAIL PROTECTED] writes:
Let's take the following fictional scenerio:
BEGIN;
INSERT INTO table1 VALUES ('somestring');
INSERT INTO table1 VALUES ('anotherstring');
SELECT user_defined_function();
COMMIT;
In this case, user_defined_function() does a lot more table manipulation.
Web based application that utilizes PostgreSQL (7.45 currently).
A debate is raging in the office regarding the idea of switching from
using a connection pool (that utilizes a single god-like database user)
to a model where each web user would have a mirror postgresql user. All
connections to
On Mar 24, 2005, at 12:42 AM, Greg Stark wrote:
There could be some tricky bits around making a deferrable constraint
not
deferrable. And disabling a constraint would be nice too, reenabling
it would
require rechecking but at least it would eliminate the error-prone
manual
process of reentering
Hi!
Does someone know an easy way to get the size (KB) of
the data stored in one or more tables?
I read about the ANALYZE command but it doesnt
deal with such information.
Thanks in advance,
Ricardo.
Jeff Amiel [EMAIL PROTECTED] writes:
Anyone see any issues with having thousands of postgresql users
established? Are there any internal limits?
There's no hard limit. Offhand the only thing I can think of that might
be a bit slow is password lookup during connection --- I think that does
a
...and very interesting.
The Date book should be required reading in computer science 101, but very
interesting implies that your only other hobby is watching grass grow.
Rick
Jeff Amiel [EMAIL PROTECTED] writes:
Could we continue to use our existing connection pool (via our app
server) and every time the application 'gets' a connection (as a
superuser) , we then 'SET SESSION AUTHORIZATION' to the appropriate user
who is performing the action?
That would work
Could we continue to use our existing connection pool (via our app
server) and every time the application 'gets' a connection (as a
superuser) , we then 'SET SESSION AUTHORIZATION' to the appropriate user
who is performing the action?
Under the new scheme, we are limited by max_connections
I wrote:
There's no hard limit. Offhand the only thing I can think of that might
be a bit slow is password lookup during connection --- I think that does
a linear scan through a list of usernames. This is only an issue if you
use passwords of course, but I suppose you probably would. (It
Hello all, I have to build a web application and for
this I have to use one of my client's Windows32
server or workstation.
Is postgresql 8.0 native suitable for a production
environment?
Thanks for any advice.
Fabri
___
Nuovo Yahoo! Messenger:
Sven Willenberger [EMAIL PROTECTED] writes:
Any suggestions on how to trace what is going on? Debug output methods?
The first thing to figure out is whether the leak is inside Perl or in
Postgres proper. If I were trying to do this I'd run the function a
couple times, then attach to the (idle)
I had some interesting issues come up, I'm not sure they're related to
GCC 4, but that's the only thing that I can thing of.
Firstly, the gcc version is :
gcc (GCC) 4.0.0 20050130 (experimental)
1. While running ./configure, it failed on not being able to detect the
type of parameters to
Gianni Mariani [EMAIL PROTECTED] writes:
Firstly, the gcc version is :
gcc (GCC) 4.0.0 20050130 (experimental)
1. While running ./configure, it failed on not being able to detect the
type of parameters to accept().
You probably need a newer gcc4. I know that PG 8.0.1 builds in Red Hat
On Thu, 2005-03-24 at 10:31, fabrizio ravazzini wrote:
Hello all, I have to build a web application and for
this I have to use one of my client's Windows32
server or workstation.
Is postgresql 8.0 native suitable for a production
environment?
Thanks for any advice.
Fabri
That really
On Thursday 24 March 2005 4:37 am, [EMAIL PROTECTED] wrote:
Hi
I am new to PostgreSQL and find that the standard documentation is
very thin. I would like to buy a more comprehensive book.
Funny. I just downloaded and printed the comprehensive manual
available at:
On Thu, 2005-03-24 at 10:59 -0500, [EMAIL PROTECTED] wrote:
...and very interesting.
The Date book should be required reading in computer science 101, but very
interesting implies that your only other hobby is watching grass grow.
Rick
[ referring to An Introduction to Database Systems by
On Thu, 2005-03-24 at 11:34 -0500, Tom Lane wrote:
Sven Willenberger [EMAIL PROTECTED] writes:
Any suggestions on how to trace what is going on? Debug output methods?
The first thing to figure out is whether the leak is inside Perl or in
Postgres proper. If I were trying to do this I'd run
Sven Willenberger [EMAIL PROTECTED] writes:
On Thu, 2005-03-24 at 11:34 -0500, Tom Lane wrote:
The first thing to figure out is whether the leak is inside Perl or in
Postgres proper. If I were trying to do this I'd run the function a
couple times, then attach to the (idle) backend with gdb
Check out dbsize in contrib.
-tfo
--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
Strategic Open Source Open Your i
http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
615-260-0005
On Mar 24, 2005, at 9:53 AM, Ricardo Fonseca e Campos wrote:
Hi!
At 1:51 PM -0500 3/24/05, Tom Lane wrote:
What you probably ought to do next is build Postgres with a debugging
malloc library to learn more about who's eating up what. I am not sure
whether libperl will automatically use the malloc attached to the main
executable or whether you need to whack it
Title: sort array optimisation in pl/perl
Hi,
I create an array which is result of query on postgresql database and then I want to sort rows in a particular way (impossible by query on database).
My solution consists to put a rows (indice m+1) in a temporary other and then move all element
Dan Sugalski [EMAIL PROTECTED] writes:
... I'm pretty sure for embedding use it uses whatever routines
the embedder defines, but it's been a while since I've poked around
in there.
Hmm. plperl is definitely not doing anything to try to manipulate that
behavior; maybe it should? Where can
On Thu, 2005-03-24 at 13:51 -0500, Tom Lane wrote:
Sven Willenberger [EMAIL PROTECTED] writes:
On Thu, 2005-03-24 at 11:34 -0500, Tom Lane wrote:
The first thing to figure out is whether the leak is inside Perl or in
Postgres proper. If I were trying to do this I'd run the function a
At 3:14 PM -0500 3/24/05, Tom Lane wrote:
Dan Sugalski [EMAIL PROTECTED] writes:
... I'm pretty sure for embedding use it uses whatever routines
the embedder defines, but it's been a while since I've poked around
in there.
Hmm. plperl is definitely not doing anything to try to manipulate that
On Thu, 2005-03-24 at 15:49 +0100, GIROIRE Nicolas (COFRAMI) wrote:
I create an array which is result of query on postgresql database and
then I want to sort rows in a particular way (impossible by query on
database).
can you give us more details on this particular sort order?
My solution
Sven Willenberger [EMAIL PROTECTED] writes:
Yes, on these systems, perl was build with -Dusemymalloc (and
concurrently -Ui_malloc) so there could very well be an issue with
malloc pools going awry. Doing a quick dig reveals that Linux tends to
build perl (by default) with the system malloc
Tom Lane [EMAIL PROTECTED] writes:
(Come to think of it, doesn't Perl normally use its very own private malloc?
Maybe there's an issue right there ...)
Perl can be built either way. It should work to have two different malloc's
running side by side as long as the correct free() is always
Jeff Amiel wrote:
Web based application that utilizes PostgreSQL (7.45 currently).
A debate is raging in the office regarding the idea of switching from
using a connection pool (that utilizes a single god-like database
user) to a model where each web user would have a mirror postgresql
On Thu, 2005-03-24 at 15:52 -0500, Tom Lane wrote:
Sven Willenberger [EMAIL PROTECTED] writes:
Yes, on these systems, perl was build with -Dusemymalloc (and
concurrently -Ui_malloc) so there could very well be an issue with
malloc pools going awry. Doing a quick dig reveals that Linux tends
Guy Rouillier wrote:
Do you really want to try to administer
1000s of database user accounts in addition to whereever you maintain
these same accounts for non-DB authentication. This assumes, of course,
that if you are interested in accountability at all that you
authenticate somewhere. And I
We intended to do that very thing (read the earlier parts of the thread
between myself and Tom Lane)
Jeff
Guy Rouillier wrote:
Jeff Amiel wrote:
The issue is really propogating the authenticaion credentials to the
database itself.it's our ON INSERT/ON UPDATE/ON DELETE triggers
that are
Jeff Amiel wrote:
The issue is really propogating the authenticaion credentials to the
database itself.it's our ON INSERT/ON UPDATE/ON DELETE triggers
that are doing the auditing and they need the user ID to accurately
log changes. In lieu of any other per-connection persistant data
I get the following message in a psql command prompt:
Warning: Console code page (437) differs from Windows
code page (1252)
8-bit characters may not work correctly. See
psql reference
page Notes for Windows users for details.
The problem stops a JDBC connection.
Any easy
Hi all,
I'm already able to get Refcursor from a stored procedure. But now I
need to get a SETOF refcursor and I can't make it work... Is that
possible to do this via JDBC?
He is the code I did. The rsTmp.next() throws a Connection is
closed. Operation is not permitted. Exception.
On Thu, 24 Mar 2005, David Gagnon wrote:
I'm already able to get Refcursor from a stored procedure. But now I
need to get a SETOF refcursor and I can't make it work... Is that
possible to do this via JDBC?
He is the code I did. The rsTmp.next() throws a Connection is
closed.
Dan Sugalski [EMAIL PROTECTED] writes:
Anyway, if perl's using its own memory allocator you'll want to rebuild it
to not do that.
You would need to do that if you wanted to use a debugging malloc. But there's
no particular reason to think that you should need to do this just to work
properly.
Greg Stark [EMAIL PROTECTED] writes:
Two mallocs can work fine alongside each other. They each call mmap or
sbrk to allocate new pages and they each manage the pages they've
received. They won't have any idea why the allocator seems to be
skipping pages, but they should be careful not to touch
Jeff Amiel wrote:
We intended to do that very thing (read the earlier parts of the
thread between myself and Tom Lane)
Sorry, you're correct. Somehow I missed that exchange (just read the
archives.)
--
Guy Rouillier
---(end of broadcast)---
Hi Kris,
I don't get error with the rsTmp.close() statement but with
(rsTmp.next()) . The arraycopy is because I want to shrink the
original array (size 50) to it real size. It's not intended to be a
deep copy.
Plpgsql function can return multiple refcursor .. so the question is how
I
On Thu, 24 Mar 2005, David Gagnon wrote:
Hi Kris,
I don't get error with the rsTmp.close() statement but with
(rsTmp.next()) . The arraycopy is because I want to shrink the
original array (size 50) to it real size. It's not intended to be a
deep copy.
Right, my bad. I see
Hi, I'm a new guy from Portugal
Can anyone tell me what is a relid, a relname and
schemaname data outputs resulting from the SQL: select
* from pg_stat_all_tables;
There are also other data outputs that I don´t
understand but they are probably related:
indexrelid (oid)
indexrelname (name)
I
Hi Kris,
I use this the code found here.
http://www.postgresql.org/docs/7.4/interactive/jdbc-callproc.html But I
don't think there is a way to make it work with SETOF RefCursor.
I will try your code wich seem to work.
SQL STRING: ? = call usp_Comptabilite_JournalVentes (?, ?, ?, ?, ?
I'm trying to build 8.0.1 on OS X, and after a simple ./configure
without any options, the build progresses smoothly until, when building
pg_ctl:
pg_ctl.c: In function `test_postmaster_connection':
pg_ctl.c:439: error: `PQnoPasswordSupplied' undeclared (first use in
this function)
I'm trying to install tsearch2 into an empty database on a new 8.0.1
postgres install. The machine already has an older 7.4 install of
postgres on it, so I gave configure a --prefix=/usr/local/pg801 option.
Postgres installed and started fine (after changing the port), and I
was able to create
Ben [EMAIL PROTECTED] writes:
I'm trying to build 8.0.1 on OS X, and after a simple ./configure
without any options, the build progresses smoothly until, when building
pg_ctl:
pg_ctl.c: In function `test_postmaster_connection':
pg_ctl.c:439: error: `PQnoPasswordSupplied' undeclared (first
Ben [EMAIL PROTECTED] writes:
make installcheck tries to connect to the older postgres install (I
don't see an option to set the port it attempts to use),
Set PGPORT, eg
export PGPORT=
regards, tom lane
---(end of
I have been using the win32 version of PG 8.0 on a windows 2003 server since
sept 2004 and it's for a financial daily pricing application using apache
2.5x.
I have a Delphi win32 app that the users use to update the database with data
from a spreadsheet, the app then updates the tables used
Nifty.
On Mar 24, 2005, at 7:34 PM, Tom Lane wrote:
Ben [EMAIL PROTECTED] writes:
make installcheck tries to connect to the older postgres install (I
don't see an option to set the port it attempts to use),
Set PGPORT, eg
export PGPORT=
regards, tom lane
On Thu, Mar 24, 2005 at 11:01:23PM -0300, Edson Vilhena de Carvalho wrote:
Hi, I'm a new guy from Portugal
Bem-vindo!
Can anyone tell me what is a relid, a relname and
schemaname data outputs resulting from the SQL: select
* from pg_stat_all_tables;
relid = object ID (oid) of the relation
Did you try 'make clean' first ?
On Thu, 24 Mar 2005, Ben wrote:
I'm trying to install tsearch2 into an empty database on a new 8.0.1 postgres
install. The machine already has an older 7.4 install of postgres on it, so I
gave configure a --prefix=/usr/local/pg801 option. Postgres installed and
I tried it in the tsearch2 directory, not the postgres src directory.
On Mar 24, 2005, at 9:35 PM, Oleg Bartunov wrote:
Did you try 'make clean' first ?
On Thu, 24 Mar 2005, Ben wrote:
I'm trying to install tsearch2 into an empty database on a new 8.0.1
postgres install. The machine already has
Michael Fuhr [EMAIL PROTECTED] writes:
On Thu, Mar 24, 2005 at 11:01:23PM -0300, Edson Vilhena de Carvalho wrote:
Can anyone tell me what is a relid, a relname and
schemaname data outputs resulting from the SQL: select
* from pg_stat_all_tables;
relid = object ID (oid) of the relation
73 matches
Mail list logo
