Hello Bjørn,
we are running a handfull of PostgreSQL installations on Windows Server
2000 and 2003 for web-mapping applications and they are running well for
the last 8 months.
Bjørn T Johansen wrote:
How stable is the windows version of pgsql 8? Is it as stable as the Linux
version or
shou
i see you wrote on this page
http://archives.postgresql.org/pgsql-general/2005-07/msg00319.php
test exsample:
create or replace function test()
returns void as
'
begin
delete from regiondata;
rollback;
end;
'lang
>>your_function adds some rows but the last one gives an error, because
>>all statements that are out of a transaction block are in its own
>>transaction the select calling your_function is inside a
>>transaction... so, the answer is yes... the statements inside the
>>function will be rolled back
pgsql-general,
On 7/12/05, Craig Bryden
wrote:
> Hi
>
> I am trying to get a better understanding of how transactions work in
> pl/pgsql functions. I found the following text in the help:
> "It is important not to confuse the use of BEGIN/END for grouping statements
> in PL/pgSQL wi
pgsql-general:
How to use rollback in function with 'pgsql'?
Nee.Mem
2005-07-13
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
Greg Stark <[EMAIL PROTECTED]> writes:
> Personally I would settle for a fuller set of small fixed size datatypes. The
> "char" datatype is pretty much exactly what's needed except that it provides
> such a quirky interface.
I'm not actually against inventing an int1/tinyint type. I used to be
w
Tom Lane <[EMAIL PROTECTED]> writes:
> Certainly the idea of not having to store a length word for CHAR(1) fields
> is not going to inspire anyone to invest the effort involved ;-)
That's a pretty big motivation though. Storage space efficiency is a huge
factor in raw sequential scan speed.
Per
On Jul 12, 2005, at 11:43 PM, Joshua D. Drake wrote:
Matthew Terenzio wrote:
I 'm storing things in a table with now() and I want to select * from
theTable WHERE the Timestamp is > the current time - 20 minutes
Anyone know the correct syntax. I was trying something like:
WHERE timestamp_field
Matthew Terenzio wrote:
I 'm storing things in a table with now() and I want to select * from
theTable WHERE the Timestamp is > the current time - 20 minutes
Anyone know the correct syntax. I was trying something like:
WHERE timestamp_field > (timestamp now() - interval '20 minutes')
sel
I 'm storing things in a table with now() and I want to select * from
theTable WHERE the Timestamp is > the current time - 20 minutes
Anyone know the correct syntax. I was trying something like:
WHERE timestamp_field > (timestamp now() - interval '20 minutes')
and will continue reading the
Enrico Riedel wrote:
> Has anyone an idea on how or any pointer into the right direction to
> accomplish the above task?
>
> Thanks already in advance!
If you don't mind having plpythonu installed in your database, a lot of this
sort of thing becomes trivial:
CREATE OR REPLACE FUNCTION sha1(tex
> It depends what language you want to sort. Lots of languages do not
> have a sort alphabet. For example, Japanese. It can be quite
> difficult to sort unusual languages like this. I am not aware of any
> standard technique for sorting Japanese text other than keeping an
> arbitrarily sort
> Hello
>
> I run PostgreSQL 7.4.6 on Linux with a JDBC client.
>
> I initialised my database cluster with the following initdb command:
>
> initdb --locale=en_GB.UTF-8 --encoding UNICODE
>
> I have now discovered that my database cannot distinguish Japanese names or
> words - it throws unique
On Tue, Jul 12, 2005 at 10:52:24AM -0700, Greg Patnude wrote:
>
> Performing an update to an inherited table system from inside of a stored
> procedure (PLPGSQL) seems to be unusually sluggish...
Is the update slower when done inside a function than when doing
it directly (e.g., from psql)? That
On Tue, Jul 12, 2005 at 03:43:43PM -0700, TJ O'Donnell wrote:
> Until now I have been content to have the superuser CREATE
> FUNCTION...LANGUAGE 'C'
> because I noticed that ordinary users could not:
>
> ERROR: permission denied for language c
>
> I would like to allow a user to create C langua
On Tue, Jul 12, 2005 at 10:52:50PM +0200, mail TechEvolution wrote:
>
> i would like to export my PostGreSQL database and import it on another
> pc. i seem not to find this possibility in 'pgAdmin III', can someone
> help me on how to do this?
See the documentation regarding backup and restore
On Jul 12, 2005, at 1:15 PM, Bjørn T Johansen wrote:
BTW, is PGSQL 8 supported on Windows NT 4?
It may work, but is not supported:
1.2) I heard that NT4 is supported. Is that true?
Although not officially supported, PostgreSQL will run on Windows NT4
with a few minor issues including:
T
TJ O'Donnell wrote:
Until now I have been content to have the superuser CREATE FUNCTION...LANGUAGE
'C'
because I noticed that ordinary users could not:
ERROR: permission denied for language c
I would like to allow a user to create C language functions, but can't
find just which privilege I ne
Tony Smith wrote:
When I was trying to connect my databse with jdbc, I
got the following error message:
org.postgresql.util.PSQLException: Connection
rejected: FATAL: no pg_hba.conf entry for host
"mydomain", user "", database "myDB", SSL off.
You need to setup your pg_hba.conf to allow r
Until now I have been content to have the superuser CREATE FUNCTION...LANGUAGE
'C'
because I noticed that ordinary users could not:
ERROR: permission denied for language c
I would like to allow a user to create C language functions, but can't
find just which privilege I need to grant. The user
When I was trying to connect my databse with jdbc, I
got the following error message:
org.postgresql.util.PSQLException: Connection
rejected: FATAL: no pg_hba.conf entry for host
"mydomain", user "", database "myDB", SSL off.
When I run in dos console "psql myDB..." it works
fine.
My jdbc c
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> I don't see how UCS-16 could always use only 2 bytes.
Simple: it fails to handle Unicode code points above 0x1. (We only
recently fixed a similar limitation in our UTF8 support, by the by, but
it *is* fixed and I doubt we want to backpedal.)
The p
Alvaro Herrera wrote:
On Tue, Jul 12, 2005 at 05:37:32PM -0400, Joe wrote:
If it stored character data in Unicode (UCS-16) it would always take
up two-bytes per character.
Really? We don't support UCS-16, for good reasons (we'd have to rewrite
several parts of the code in order to support '0
On Tue, Jul 12, 2005 at 05:37:32PM -0400, Joe wrote:
> Tom Lane wrote:
> >Because the length specification is in *characters*, which is not by any
> >means the same as *bytes*.
> >
> >We could possibly put enough intelligence into the low-level tuple
> >manipulation routines to count characters in
Janning Vygen <[EMAIL PROTECTED]> writes:
> I have a guess, what happens here: The order of the subselect statement is
> dropped by the optimizer because the optimizer doesn't see the "side-effect"
> of the ranking function.
That guess is wrong.
I think the problem is that you are trying to upd
Marco Gaiarin <[EMAIL PROTECTED]> writes:
> The application work well, apart some query that took some *MINUTES* to
> complete, when on 7.2 take (half of) second(s).
Could we see EXPLAIN ANALYZE results for the problem query on both
versions?
regards, tom lane
---
"Joshua D. Drake" <[EMAIL PROTECTED]> writes:
>> The "factory default" has never been 1; AFAIR it's always been 3,
>> and like many of the other defaults that's aimed for small-and-slow
>> machines. If you're not short of disk space, something like 30
>> is reasonable. (Note this can cost you 32M
It's been suggested in the past that we ought to document multiple sets
of parameter choices from "small test platform" to "big fast machine";
MySQL have done something of the sort for a long time.
That is probably a good idea.
regards, tom lane
--
Your PostgreSQL
Tom Lane wrote:
Because the length specification is in *characters*, which is not by any
means the same as *bytes*.
We could possibly put enough intelligence into the low-level tuple
manipulation routines to count characters in whatever encoding we happen
to be using, but it's a lot faster and m
The "factory default" has never been 1; AFAIR it's always been 3,
and like many of the other defaults that's aimed for small-and-slow
machines. If you're not short of disk space, something like 30
is reasonable. (Note this can cost you 32MB per increment, so a
setting of 30 means you're willin
What is the query that is slow?
What is the schema for the tables involved in the slow query?
What do you see when you do an EXPLAIN ANALYZE on the query?
Is the machine and disk subsystem identical?
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:pgsql-general-
> [EMAIL PROTECTE
Hi,
in postgresql you have several possibilites to get the rank of items. A thread
earlier this year shows correlated subqueries (not very performant) and other
tricks and techniques to solve the ranking problem:
http://archives.postgresql.org/pgsql-general/2005-05/msg00157.php
The possibility
On Tue, 2005-07-12 at 15:55, Greg Patnude wrote:
> -Original Message-
> From: Scott Marlowe [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, July 12, 2005 11:40 AM
> To: Greg Patnude
> Cc: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Checkpoints are occurring too frequently...
>
> On T
>> Meanwhile, am I correct in assuming that re-initialising my database cluster
>> with "--locale=C" will solve the problem?
>
> AFAIK it should --- of course you won't get any very intelligent sorting
> or case folding, but at least it can tell the difference between
> different characters ;-).
Joe <[EMAIL PROTECTED]> writes:
> I never would've imagined *that* amount of overhead for CHAR(1)! I
> would've imagined that it would take up one byte (or two with a NULL
> indicator). After all, we're not talking about VARCHAR(1) [which is
> sort of useless]. Don't the catalogs know the declar
"Greg Patnude" <[EMAIL PROTECTED]> writes:
> From: Scott Marlowe [mailto:[EMAIL PROTECTED]
>> So, how often is this running? Once a second, once a minute, once and
>> hour? If it's only running once an hour, then something else is wrong.
> I've been running it about 2 or 3 times a minute on ave
[I'm not subscribed to this list, and i'm sending this because the man
that develop our internal application is away... so i'm not aware of
most of the detail, i'm only seeking to some quick fix, wait tomorrow
for some better and deeper info.]
[[so, please, keep me in CC]]
In our organization we
Dawid Kuroczko wrote:
smallint takes two bytes. Numeric(1) will take around 10 bytes and char(1) will
take 5 bytes (4 bytes for length of data).
I never would've imagined *that* amount of overhead for CHAR(1)! I would've
imagined that it would take up one byte (or two with a NULL indicator).
Hello
i would like to export my PostGreSQL database and import it on another
pc. i seem not to find this possibility in 'pgAdmin III', can someone
help me on how to do this?
greetZ
wes
---(end of broadcast)---
TIP 4: Have you searched our lis
-Original Message-
From: Scott Marlowe [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 12, 2005 11:40 AM
To: Greg Patnude
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Checkpoints are occurring too frequently...
On Tue, 2005-07-12 at 13:29, Greg Patnude wrote:
> "Scott Marlowe"
index_right.php fixed now also ...
On Tue, 12 Jul 2005, Marc G. Fournier wrote:
I've email'd Chris about this, since I'm getting some really odd behvaiours
when hitting the web site ... namely, its trying to load an index_right.php
file from venus.hub.org, but I can't find any references to
Bruno Wolff III <[EMAIL PROTECTED]> writes:
> Andrus <[EMAIL PROTECTED]> wrote:
>> SHOW ALL command returns the following:
>>
>> "client_encoding";"UNICODE"
>> "lc_collate";"Estonian_Estonia.1257"
>> "lc_ctype";"Estonian_Estonia.1257"
>> "lc_messages";"Estonian_Estonia.1257"
>> "lc_monetary";"Es
I've email'd Chris about this, since I'm getting some really odd
behvaiours when hitting the web site ... namely, its trying to load an
index_right.php file from venus.hub.org, but I can't find any references
to index_right.php in the code (the file is there, but nothing seems to
reference it
On Tue, Jul 12, 2005 at 03:11:35PM -0500, Scott Marlowe wrote:
> On Tue, 2005-07-12 at 15:06, Mark Rae wrote:
> > I think its more a case of AMD now having solid evidence to back
> > up the claims.
>
> Wow! That's pretty fascinating. So, is the evidence pretty
> overwhelming that this was not s
Bjørn T Johansen wrote:
How stable is the windows version of pgsql 8? Is it as stable as the Linux
version or
should I look elsewehere after a good sql srv for Windows?
This is a tough question to answer and you will probably get a wide
range or responses. Many people on these lists beli
On Tue, 2005-07-12 at 15:06, Mark Rae wrote:
> On Tue, Jul 12, 2005 at 01:41:14PM -0500, Scott Marlowe wrote:
> > On Tue, 2005-07-12 at 13:24, Mohan, Ross wrote:
> > > From AMD's suit against Intel. Perhaps relevant to some PG/AMD issues.
> > Well, this is, right now, just AMD's supposition about
On Tue, Jul 12, 2005 at 22:09:40 +0300,
Andrus <[EMAIL PROTECTED]> wrote:
> > Sort order depends on the locale used in initdb. If you want data sorted
> > by the codes used to represent the data, then you might want to initdb
> > with a locale of "C". Doing an initdb will require a dump and reloa
On Tue, Jul 12, 2005 at 01:41:14PM -0500, Scott Marlowe wrote:
> On Tue, 2005-07-12 at 13:24, Mohan, Ross wrote:
> > From AMD's suit against Intel. Perhaps relevant to some PG/AMD issues.
> Well, this is, right now, just AMD's supposition about Intel's
> behaviour, I'm not sure one way or the othe
Most odd ... just restarted it, taking a look to see if there is a reason
why the web server is stopping :(
On Tue, 12 Jul 2005, Scott Marlowe wrote:
Looks like gborg is having issues again. The slony home page isn't
showing up.
---(end of broadcast)---
How stable is the windows version of pgsql 8? Is it as stable as the Linux
version or
should I look elsewehere after a good sql srv for Windows?
Regards.
BTJ
--
---
Bjørn T Johansen
[EMAIL PROTECTED]
> LOG: checkpoints are occurring too frequently (19 seconds apart)
> HINT: Consider increasing the configuration parameter
> "checkpoint_segments".
> LOG: checkpoints are occurring too frequently (12 seconds apart)
> HINT: Consider increasing the configuration parameter
> "checkpoint_segments
# [EMAIL PROTECTED] / 2005-07-12 12:11:45 -0500:
> On Tue, Jul 12, 2005 at 17:35:35 +0200,
> Roman Neuhauser <[EMAIL PROTECTED]> wrote:
> > # [EMAIL PROTECTED] / 2005-07-12 10:08:37 -0500:
> > > On Sun, Jul 10, 2005 at 15:05:30 -0300,
> > > David Pratt <[EMAIL PROTECTED]> wrote:
> > > > I was t
As promised, here are two runs of VACUUM VERBOSE on the problem table ...
There was a lot of activity on the campaign_email table on Friday
(Saturday's VACUUM) as compared with Monday (Tuesday's VACUUM)
Thanks,
Dave
VACUUM VERBOSE from 1:30am Saturday July 9
INFO: vacuuming "xxx.campaign_email
> Sort order depends on the locale used in initdb. If you want data sorted
> by the codes used to represent the data, then you might want to initdb
> with a locale of "C". Doing an initdb will require a dump and reload.
Bruno, thank you.
SHOW ALL command returns the following:
"client_encoding";
Looks like gborg is having issues again. The slony home page isn't
showing up.
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Thanks a stack. That has answered by question.
Craig
- Original Message -
From: "Douglas McNaught" <[EMAIL PROTECTED]>
To: "Craig Bryden" <[EMAIL PROTECTED]>
Cc: "pgsql"
Sent: Tuesday, July 12, 2005 8:46 PM
Subject: Re: [GENERAL] Transaction Handling in pl/pgsql
> "Craig Bryden" <[EM
"David Esposito" <[EMAIL PROTECTED]> writes:
>> BTW, the tail of the VACUUM VERBOSE output ought to have
>> something about
>> overall usage of the FSM --- what does that look like?
> INFO: free space map: 528 relations, 172357 pages stored; 170096 total
> pages needed
> DETAIL: Allocated FSM s
"Craig Bryden" <[EMAIL PROTECTED]> writes:
> OK. I have read that. The part that sticks out is "A block containing an
> EXCEPTION clause is significantly more expensive to enter and exit than a
> block without one. Therefore, don't use EXCEPTION without need. ".
> Performance is paramount to me.
>
> I am trying to get a better understanding of how transactions work in
> pl/pgsql functions. I found the following text in the help:
> "It is important not to confuse the use of BEGIN/END for grouping statements
> in PL/pgSQL with the database commands for transaction control. PL/pgSQL's
> BEGIN/E
Harry Mantheakis <[EMAIL PROTECTED]> writes:
> Meanwhile, am I correct in assuming that re-initialising my database cluster
> with "--locale=C" will solve the problem?
AFAIK it should --- of course you won't get any very intelligent sorting
or case folding, but at least it can tell the difference
What if the select calling my function is not in it's own explicit
transaction block?
Thanks
Craig
- Original Message -
From: "Jaime Casanova" <[EMAIL PROTECTED]>
To: "Craig Bryden" <[EMAIL PROTECTED]>
Cc: "pgsql"
Sent: Tuesday, July 12, 2005 7:37 PM
Subject: Re: [GENERAL] Transaction H
On Tue, 2005-07-12 at 13:29, Greg Patnude wrote:
> "Scott Marlowe" <[EMAIL PROTECTED]> wrote in message
> news:[EMAIL PROTECTED]
> > On Tue, 2005-07-12 at 13:04, Greg Patnude wrote:
> >> LOG: checkpoints are occurring too frequently (19 seconds apart)
> >> HINT: Consider increasing the configura
OK. I have read that. The part that sticks out is "A block containing an
EXCEPTION clause is significantly more expensive to enter and exit than a
block without one. Therefore, don't use EXCEPTION without need. ".
Performance is paramount to me.
If I ommit the EXCEPTION clause will all the stateme
On Tue, 2005-07-12 at 13:24, Mohan, Ross wrote:
> From AMD's suit against Intel. Perhaps relevant to some PG/AMD issues.
>
> "...125. Intel has designed its compiler purposely to degrade performance
> when a program
> is run on an AMD platform. To achieve this, Intel designed the compiler to
>
> Hmm, is that actually the correct spelling of the locale? On my Linux
> box, locale -a says it's "en_GB.utf8". I'm not sure how well initdb can
> verify the validity of a locale parameter, especially back in the 7.4
> branch. It could be that you are actually using a locale that doesn't
> use
On Tue, Jul 12, 2005 at 20:45:37 +0300,
Andrus <[EMAIL PROTECTED]> wrote:
>
> How to force the correct sort order or at least move accented characters
> ÕÄÖÜ to end of sorted list ?
Sort order depends on the locale used in initdb. If you want data sorted
by the codes used to represent the data,
"Scott Marlowe" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> On Tue, 2005-07-12 at 13:04, Greg Patnude wrote:
>> LOG: checkpoints are occurring too frequently (19 seconds apart)
>> HINT: Consider increasing the configuration parameter
>> "checkpoint_segments".
>> LOG: checkpoi
>From AMD's suit against Intel. Perhaps relevant to some PG/AMD issues.
"...125. Intel has designed its compiler purposely to degrade performance when
a program
is run on an AMD platform. To achieve this, Intel designed the compiler to
compile code
along several alternate code paths. Some paths
It's very stable, I have been using it for a Apache DSO application
since the first beta (July/Aug 2004) and It just runs and runs and runs.
The app is not super busy, but I have never had a issue with the database.
I replaced a old MS SQL server 7 install with Postgresql win32 and never
looked ba
On Tue, 2005-07-12 at 13:04, Greg Patnude wrote:
> LOG: checkpoints are occurring too frequently (19 seconds apart)
> HINT: Consider increasing the configuration parameter
> "checkpoint_segments".
> LOG: checkpoints are occurring too frequently (12 seconds apart)
> HINT: Consider increasing th
LOG: checkpoints are occurring too frequently (19 seconds apart)
HINT: Consider increasing the configuration parameter
"checkpoint_segments".
LOG: checkpoints are occurring too frequently (12 seconds apart)
HINT: Consider increasing the configuration parameter
"checkpoint_segments".
LOG: che
On Tue, 2005-07-12 at 12:15, Bjørn T Johansen wrote:
> > On Tue, 2005-07-12 at 11:29, Bjørn T Johansen wrote:
> >> How stable is the Windows version of PGSQL 8? Is it as stable as the
> >> Linux
> >> version or should I be looking for something else?
> >
> > For certain values of stable, yes, it i
I insalled Postgres 8 in Windows XP with default settings
I xreated database with encoding unicode.
I noticed that the sort order of accented characters is
B
Ü
Ö
C.
Ä
Õ
C
this is totally incorrect! It is interesting that names beginning with C
are not contiguous: between C. and C are accented c
"Craig Bryden" <[EMAIL PROTECTED]> writes:
> I am trying to get a better understanding of how transactions work in
> pl/pgsql functions. I found the following text in the help:
> "It is important not to confuse the use of BEGIN/END for grouping statements
> in PL/pgSQL with the database commands f
Performing an update to an inherited table system from inside of a stored
procedure (PLPGSQL) seems to be unusually sluggish... Does anyone have a
faster solution ? I am updating 50 records and it takes approximately 4.375
seconds + or -
The inherited table has an ON INSERT DO INSTEAD and t
On 7/12/05, Craig Bryden <[EMAIL PROTECTED]> wrote:
> Hi
>
> I am trying to get a better understanding of how transactions work in
> pl/pgsql functions. I found the following text in the help:
> "It is important not to confuse the use of BEGIN/END for grouping statements
> in PL/pgSQL with the dat
Hi
I am trying to get a better understanding of how transactions work in
pl/pgsql functions. I found the following text in the help:
"It is important not to confuse the use of BEGIN/END for grouping statements
in PL/pgSQL with the database commands for transaction control. PL/pgSQL's
BEGIN/END are
Hi Bruno and Roman. I am attempting to implement your advice. Bruno,
how do I make a foreign key deferable since this sounds like an
interesting approach.
I have got another problem on top of the first. For the first two
inserts I need to insert a multi-dimensional array into one of the
field
> On Tue, 2005-07-12 at 11:29, Bjørn T Johansen wrote:
>> How stable is the Windows version of PGSQL 8? Is it as stable as the
>> Linux
>> version or should I be looking for something else?
>
> For certain values of stable, yes, it is.
>
> However, if for no other reason than the fact the the port
On Tue, Jul 12, 2005 at 17:35:35 +0200,
Roman Neuhauser <[EMAIL PROTECTED]> wrote:
> # [EMAIL PROTECTED] / 2005-07-12 10:08:37 -0500:
> > On Sun, Jul 10, 2005 at 15:05:30 -0300,
> > David Pratt <[EMAIL PROTECTED]> wrote:
> > > Hi Roman. Many thanks for your reply. This is interesting and will
On Tue, 2005-07-12 at 18:29 +0200, Bjørn T Johansen wrote:
> Is it as stable as the Linux
> version
>From http://www.postgresql.org/docs/whatsnew:
"Although tested throughout our release cycle, the Windows port does not
have the benefit of years of use in production environments that
PostgreSQL h
Hello Ets!
I think that you should use Format, so
that Access can understands bools.
I have done it in this way:
In Access Query Builder use alias for field,
for example
AliasName:
Format([FieldName])
In Criteria use "True" or
"False" instead of -1
Tell me if it works for you. In my
On Tue, 2005-07-12 at 11:29, Bjørn T Johansen wrote:
> How stable is the Windows version of PGSQL 8? Is it as stable as the Linux
> version or should I be looking for something else?
For certain values of stable, yes, it is.
However, if for no other reason than the fact the the port is fairly
new
I need to convert hundreds of Oracle stored procs across several
developing databases. I'm focusing on scripting as much of this as
possible, and I'm currently stuck on converting PL/SQL's NO_DATA_FOUND
behavior. What approaches have other people used? I'm targeting
PostgreSQL 8.1.
The problem
Harry Mantheakis <[EMAIL PROTECTED]> writes:
> I run PostgreSQL 7.4.6 on Linux with a JDBC client.
> I initialised my database cluster with the following initdb command:
> initdb --locale=en_GB.UTF-8 --encoding UNICODE
> I have now discovered that my database cannot distinguish Japanese names or
"David Esposito" <[EMAIL PROTECTED]> writes:
> As promised, here are two runs of VACUUM VERBOSE on the problem table ...
BTW, the tail of the VACUUM VERBOSE output ought to have something about
overall usage of the FSM --- what does that look like?
regards, tom lane
-
How stable is the Windows version of PGSQL 8? Is it as stable as the Linux
version or should I be looking for something else?
Regards,
BTJ
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Hello
I run PostgreSQL 7.4.6 on Linux with a JDBC client.
I initialised my database cluster with the following initdb command:
initdb --locale=en_GB.UTF-8 --encoding UNICODE
I have now discovered that my database cannot distinguish Japanese names or
words - it throws unique constraint errors on
# [EMAIL PROTECTED] / 2005-07-12 10:08:37 -0500:
> On Sun, Jul 10, 2005 at 15:05:30 -0300,
> David Pratt <[EMAIL PROTECTED]> wrote:
> > Hi Roman. Many thanks for your reply. This is interesting and will I
> > give this a try and let you know how it works out. With this you are
> > right, appl
It depends what language you want to sort. Lots of languages do not
have a sort alphabet. For example, Japanese. It can be quite
difficult to sort unusual languages like this. I am not aware of any
standard technique for sorting Japanese text other than keeping an
arbitrarily sorted diction
[EMAIL PROTECTED] wrote:
Our product will be storing its character data in utf-8 format (unicode
encoding).
What is the best way to achive cultural sensitive sorting using the
utf-8 data?
See below.
Is it possible have the locale apply to a connection?
A locale applies to a whole databas
Hi all,
I've dropped a schema in my database with this command
:
delete from pg_namespace where nspname = "toto";
I know ... I 've done a big mistake :( . I will prefer
"drop schema toto" the next time.
Now I can't do a pg_dump because some objects of the
removed schema are still referenced in
On Sun, Jul 10, 2005 at 15:05:30 -0300,
David Pratt <[EMAIL PROTECTED]> wrote:
> Hi Roman. Many thanks for your reply. This is interesting and will I
> give this a try and let you know how it works out. With this you are
> right, application logic and transaction don't have to be separate
>
On 07/12/2005 09:15:20 AM, Michael Fuhr wrote:
On Mon, Jul 11, 2005 at 07:43:48PM +, Karl O. Pinc wrote:
> Is there any way to get the DB and schema name into
> error messages, particularly when the errors
> are logged?
To see how logging can be configured, refer to "Error Reporting and
Log
Our product will be storing its character data in utf-8
format (unicode encoding).
What is the best way to achive cultural sensitive sorting
using the utf-8 data?
Is it possible have the locale apply to a connection?
If so, is the cultural sorting support mature in
PostgreSQL?
What type o
> -Original Message-
> From: Tom Lane [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, July 12, 2005 10:14 AM
>
> "David Esposito" <[EMAIL PROTECTED]> writes:
> > As promised, here are two runs of VACUUM VERBOSE on the
> problem table ...
> > There was a lot of activity on the campaign_email
On Tue, Jul 12, 2005 at 01:16:07AM -0400, Joe wrote:
> I have a MySQL database that I'm converting to PostgreSQL which has 10
> columns with TINYINT type, i.e., a one-byte integer. Only one of them
> qualifies as a true BOOLEAN. Two are entity identifiers (for limited range
> "classes" or "cat
On 7/12/05, Joe <[EMAIL PROTECTED]> wrote:
> I have a MySQL database that I'm converting to PostgreSQL which has 10 columns
> with TINYINT type, i.e., a one-byte integer. Only one of them qualifies as a
> true BOOLEAN. Two are entity identifiers (for limited range "classes" or
> "categories") and
Hello !
I use psql ODBC v.8.00.0101 with MS-Access 2002
under XP Pro.
If I use a System Data Source configured with
:
Datasource using :
- Bool AS Char,
- True is -1.
So Query with criteria "true" work
but checked fields don't work !?
If Datasource use :
- Bool NOT char,
- True is -1.
So
On Mon, Jul 11, 2005 at 07:43:48PM +, Karl O. Pinc wrote:
> Is there any way to get the DB and schema name into
> error messages, particularly when the errors
> are logged? I'd like to be able to distinguish
> errors coming from the test databases from those
> coming from the live databases.
1 - 100 of 104 matches
Mail list logo