Mary Y Wang wrote:
I got this error:
-bash-2.05b$ /usr/local/pgsql/bin/pg_ctl start
server starting
-bash-2.05b$ FATAL: database files are incompatible with server
DETAIL: The data directory was initialized by PostgreSQL
version 7.3, which is not compatible with this version 8.3.8.
I
Albe Laurenz wrote:
If you care about the data in the 7.3 data directory, you will
have to migrate it: start a 7.3 server, export with 8.3's
pg_dumpall, run 8.3's initdb, import the dump.
and thats not that easy with Redhat/Centos/Fedora/etc RPM installs, as
installing 8.x from RPM sources
Albe Laurenz wrote:
To find out what PostgreSQL stuff you have installed (provided
you installed it as RPM and did not compile it from source),
you can run
rpm -qa | grep postgres
Some other useful tricks to know here; most commands take --version:
$ initdb --version
initdb (PostgreSQL)
Hi.
I have a simple function.
CREATE OR REPLACE FUNCTION myf_convert_phone18digits(
in_phone VARCHAR
) RETURNS BIGINT
-- IMMUTABLE
AS $$
DECLARE
t_extent_len BIGINT;
t_phone_18 BIGINT;
t_multiplier BIGINT;
BEGIN
IF in_phone IS NULL OR in_phone = '' THEN
RAISE EXCEPTION 'in_phone[%]
On 26 February 2010 12:02, Anton Maksimenkov anton...@gmail.com wrote:
Hi.
I have a simple function.
CREATE OR REPLACE FUNCTION myf_convert_phone18digits(
in_phone VARCHAR
) RETURNS BIGINT
-- IMMUTABLE
AS $$
DECLARE
t_extent_len BIGINT;
t_phone_18 BIGINT;
t_multiplier BIGINT;
On Thu, 25 Feb 2010 11:41:58 +0100
Pavel Stehule pavel.steh...@gmail.com wrote:
use --enable-assert configure flag?
you can use memory in bad context. So you are alloc good memory,
but when you leave function, then complete memory context is
freeed and you can have a problem.
Meanwhile I
On 26/02/2010 12:15, Thom Brown wrote:
On 26 February 2010 12:02, Anton Maksimenkov anton...@gmail.com wrote:
Hi.
I have a simple function.
CREATE OR REPLACE FUNCTION myf_convert_phone18digits(
in_phone VARCHAR
) RETURNS BIGINT
-- IMMUTABLE
AS $$
DECLARE
t_extent_len BIGINT;
On 26 February 2010 14:33, Raymond O'Donnell r...@iol.ie wrote:
On 26/02/2010 12:15, Thom Brown wrote:
On 26 February 2010 12:02, Anton Maksimenkov anton...@gmail.com wrote:
Hi.
I have a simple function.
CREATE OR REPLACE FUNCTION myf_convert_phone18digits(
in_phone VARCHAR
) RETURNS
Hello all,
I found this conversation in mailing lists archives:
http://archives.postgresql.org/pgsql-general/2007-11/msg01669.php
OP in this conversation exactly describes my current problem (thread
limit for postmaster running on Windows).
I'm running 8.2.5, which predates this
On Fri, Feb 26, 2010 at 17:24, Igor Neyman iney...@perceptron.com wrote:
Hello all,
I found this conversation in mailing lists archives:
http://archives.postgresql.org/pgsql-general/2007-11/msg01669.php
OP in this conversation exactly describes my current problem (thread limit
for
Thom Brown escribió:
On 26 February 2010 14:33, Raymond O'Donnell r...@iol.ie wrote:
On 26/02/2010 12:15, Thom Brown wrote:
On 26 February 2010 12:02, Anton Maksimenkov anton...@gmail.com wrote:
I'm also curious to know why there's an underflow error instead of
overflow. And in fact, even
On Thu, Feb 25, 2010 at 9:42 AM, Terry td3...@gmail.com wrote:
On Wed, Feb 24, 2010 at 10:30 PM, Scott Marlowe scott.marl...@gmail.com
wrote:
On Wed, Feb 24, 2010 at 8:50 PM, Terry td3...@gmail.com wrote:
Hello,
I have an application that is doing something stupid in that it is
tacking on
On Fri, Feb 26, 2010 at 1:46 PM, Terry td3...@gmail.com wrote:
On Thu, Feb 25, 2010 at 9:42 AM, Terry td3...@gmail.com wrote:
On Wed, Feb 24, 2010 at 10:30 PM, Scott Marlowe scott.marl...@gmail.com
wrote:
On Wed, Feb 24, 2010 at 8:50 PM, Terry td3...@gmail.com wrote:
Hello,
I have an
In one of my new roles, one of my projects has been to setup a proof of
concept solution using PostgreSQL, which one emphasis being on performance
monitoring during testing / dev ...
We are mainly a nagios / cacti environment, and I came across:
On Fri, Feb 26, 2010 at 3:16 PM, Scott Marlowe scott.marl...@gmail.com wrote:
On Fri, Feb 26, 2010 at 1:46 PM, Terry td3...@gmail.com wrote:
On Thu, Feb 25, 2010 at 9:42 AM, Terry td3...@gmail.com wrote:
On Wed, Feb 24, 2010 at 10:30 PM, Scott Marlowe scott.marl...@gmail.com
wrote:
On Wed,
Terry td3...@gmail.com writes:
I am somewhat confused. My app is detecting it as a serial data type
but describing the table shows that its an integer. What am I
missing?
dssystem=# \d clients_event_log
Table public.clients_event_log
Column
On Fri, Feb 26, 2010 at 3:46 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Terry td3...@gmail.com writes:
I am somewhat confused. My app is detecting it as a serial data type
but describing the table shows that its an integer. What am I
missing?
dssystem=# \d clients_event_log
Bruce Momjian wrote:
Hiroshi Inoue wrote:
Bruce Momjian wrote:
Where are we on this issue?
Oops I forgot it completely.
I have a little improved version and would post it tonight.
Ah, very good. Thanks.
Attached is an improved version.
regards,
Hiroshi Inoue
? formatting.patch
?
Hi,
I'm writing a book on SQL, with a short section about query tuning and
automatic optimization advisors for different RDBMS platforms, for
instance, extensions to EXPLAIN that recommend new indexes based on
workload and query plans.
When I searched for a solution for PostgreSQL,
19 matches
Mail list logo