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
postgresql.conf
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 folder1
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?
Does
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 publis
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
> th
[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 conne
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.
Refering
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
Hallo all,
using at least PostgreSQL 7.4.2, one can use the command
COMMENT ON CONSTRAINT ON ;
to document a constraint defined via
CONSTRAINT ...
in the context of a table.
Now, imagine you know the name of a constraint or all of them for a given
table, e.g. destilled via
SELEC
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)
> an
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 anothe
Martijn van Oosterhout 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 only to whether
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 ('anot
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 statement
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 = '';
> How can I get the comment for each of thes
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
>>
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
> Intro
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 manip
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 th
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 doesn’t
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
"...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 w
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 accept(
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: http://www.postgresql.org
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
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
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 wit
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 a
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 c
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 functi
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 solutio
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 mallo
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 c
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 Lin
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 cer
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 doi
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 wa
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.
pu
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
properl
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
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
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
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 know
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)
pg_ctl.c:439:
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 (
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 broadcast)-
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 fo
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 relati
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
s
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 an
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 relati
73 matches
Mail list logo
