Ziff Davis Media eSeminars: The Online Seminar Standard
Realizing the Value of Enterprise Open Source Databases:
How Sony Online Entertainment Replaced Oracle with EnterpriseDB
October 12, 2006 @ 12:00 p.m. Eastern/9:00 a.m. Pacific
Duration: 60 minutes
Register Attend Online
On Mon, 2006-10-16 at 14:56 -0400, Harpreet Dhaliwal wrote:
Hi,
I have a timestamp field in my table and want to set a default value
of current date/time for it.
What should i enter as its default value? is there any function like
now() in postgres?
Thanks,
~Harpreet
test=# select
John McCawley wrote:
Here's a little tool I wrote:
http://www.hardgeus.com/projects/pgdesigner/
I have a Windows binary up there. The build process is currently a
mess, sorry.
It's a pretty decent little tool for quick-and-dirty visualization,
which is all I really use it for.
nyenyec
On Fri, 2007-01-26 at 12:16 -0800, [EMAIL PROTECTED] wrote:
I am looking for some sample code using the libpqxx (C++) API for
Postgresql. I have found some tutorials
(http://thaiopensource.org/devprojects/libpqxx/doc/2.6.8/html/Tutorial/
On Tue, 2007-07-10 at 14:32 +0200, Zlatko Matic wrote:
Hello.
Is there any free program/utility for batch imports from .csv files, that
can be easily scheduled for daily inserts of data to PostgreSQL tables?
Regards,
Zlatko
---(end of
Chris Hoover wrote:
I need some help. I am trying to replicate a function from Sybase
ASA, and am having difficulty.
I need to be able to subtract 2 date (or timestamps) and return the
results expressed in days, weeks, month, quarters, or years. How do I
do this?
I believe Postgres is
Chris Hoover wrote:
I need some help. I am trying to replicate a function from Sybase
ASA, and am having difficulty.
I need to be able to subtract 2 date (or timestamps) and return the
results expressed in days, weeks, month, quarters, or years. How do I
do this?
I believe Postgres is
On Wed, 2007-08-01 at 13:29 +0200, [EMAIL PROTECTED] wrote:
Hello,
I bought a Dell server and I am going to use it for installing PostgrSQL
8.2.4. I always used Windows so far and I would like now to install a
Linux distribution on the new server. Any suggestion on which distribution
?
Andrej Ricnik-Bay wrote:
On 8/2/07, Reid Thompson [EMAIL PROTECTED] wrote:
If it's a dedicated production server, look at UBUNTU 6.10 server.
If you're planning to connect a monitor and run X-windows ( i.e. I
bought a server, but i'm going to use it as a learning platform for
LINUX
On Wed, 2007-08-22 at 18:57 -0400, Geoffrey wrote:
We are looking for a reporting tool that will enable users to generate
their own reports. Something like Crystal Reports.
Anyone using something like this with Postgresql?
agata, datavision, jasper reports, birt, openRPT -- google shows
I've a db table generating the error below on pg_dump. Per the
archives, i've tried creating a clog file 1559 but w/o success (
continue to get the same error) even when i extended the clog file to
64K. Are there other options to recovering this table? Do i need to
extend clog 1559 to a
Tom Lane wrote:
Reid Thompson writes:
$ pg_dump -f table_dump.sql -t table_with_error dbname
FATAL 2: read of clog file 1559, offset 0 failed: Success
You've got a clobbered tuple header in that file (ridiculous
xmin or xmax value). Alternatively, given the evident age of
this server
[EMAIL PROTECTED] wrote:
I'm sorry, but I know only the basics about DBMs, but I think is not
possible to put a image file INSIDE a database. You can put in a
database the path of the file...
(Maybe I'm wrong...)
See ya!
---(end of
Someone questioned a while back about hosting providers for PostgreSQL
-- a recent post led to finding http://www.planetargon.com/hosting/
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
Crystle Numan wrote:
Dear all:
I am fairly knowledgeable about PostgreSQL but this behaviour is
stumping me. Any help would be wonderful. If you think it is a bug,
let me now and I'll file one.
(select values in DB (date stamps) between Jan 1, 2000 and Jan 1,
2005, no results)
Michael Fuhr wrote:
[Please copy the mailing list on replies so others can
contribute to and learn from the discussion. Also, please
don't top-post, as it destroys the flow of the discussion;
I've moved your questions to a more logical place.]
On Wed, Aug 31, 2005 at 03:49:57PM -0600,
Title: Message
see
the contrib directory,,, i think there is also a simple example in the
docs...
reid
-Original Message-From: Cristian Prieto
[mailto:[EMAIL PROTECTED] Sent: Thursday, September 01,
2005 4:10 PMTo: pgsql-general@postgresql.orgSubject:
[GENERAL] ECPG
Title: Message
http://tutorials.findtutorials.com/read/id/185/headline/Professional+Linux+Programming+Part+3+-+ECPG
reid
-Original Message-From: Cristian Prieto
[mailto:[EMAIL PROTECTED] Sent: Thursday, September 01,
2005 4:10 PMTo: pgsql-general@postgresql.orgSubject:
Example:
assume a table of 10 columns, three of which are fname, lname, and dob.
If an index is created on (fname, lname, dob), will a query that
utilizes two of the columns ( select 'data' from table where fname = 'X'
and lname = 'Y') utilize the index?
thanks,
reid
Alvaro Herrera wrote:
On Mon, Sep 12, 2005 at 09:43:57AM -0400, Reid Thompson wrote:
Example:
assume a table of 10 columns, three of which are fname, lname, and
dob. If an index is created on (fname, lname, dob), will a query that
utilizes two of the columns ( select 'data' from table where
Richard Huxton wrote:
CSN wrote:
Probably wishful thinking, but who knows - maybe
there's something in contrib! I have a bunch of csv
data with the field names specified on the first line
of the various files. Is there any such utility that
will create a table schema using the field names
Title: Message
provide an example of what you're trying to
do.
test=select
date_part('month',current_date); date_part
--- 9(1
row)
test= select
length(date_part('month',current_date));length
1(1 row)
reid
-Original Message-From: Alex Turner
Scott Marlowe wrote:
On Mon, 2005-09-19 at 12:54, Alex Turner wrote:
I thought a char field was supposed to return a padded string, and
varchar was supposed to return a non-padded string?
I just checked though:
create table test (
stuff char(10)
);
insert into test values ('foo');
If i have a pg_dump that is using COPY, and midway through the copy an
insert fails due to a unique constraint, will the COPY continue with the
rest of the records, or will it abort? If it aborts, will it perform a
rollback on the inserts up to that point?
thanks,
reid
I've written a simple getting started, 'PostgreSQL and Dev-Cpp Dev-C++
on Windows example'. I was wondering if this would be pertinent to post
to pgsql-general or one of the other PG lists?
reid
---(end of broadcast)---
TIP 3: Have you checked
I thought it might be of interest to some to post steps to using
PostgreSQL on
Windows with the Dev-Cpp/MINGW IDE/compiler.This example is C, but the
steps for configuring the IDE/Project to use the PostgreSQL libs/headers
should be the same or very similar for C++/ecpg.
Install PostgreSQL for
http://linux.sys-con.com/read/139427_2.htm
reid
---(end of broadcast)---
TIP 6: explain analyze is your friend
Original Message
From: Trent Shipley [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 02, 2005 7:27 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] FOSS Reporting tools (was Oracle 10g
Express - any danger for Postgres?)
On Wednesday 2005-11-02 13:11, Jim C. Nasby wrote:
On
Bill Bartlett wrote:
I hit this exact same problem, and my initial reaction was the same as
yours -- psql was hanging. After much head-banging, I discovered that
it is not in fact hanging, but is instead getting confused by being run
from inside Putty, Cygwin, xterm, rxvt terminal, etc.
On Mon, 2007-02-12 at 15:16 -0500, HT NB wrote:
Hi,
How are you doing?
First, I am testing if this email address is valid. It is the first
time that I am using this account. I have a question about how to
start write embedded SQL in C programming code. What are the basic
requirements in
On Mon, 2007-02-26 at 14:54 +0100, peter pilsl wrote:
I need to export several tables as csv. I use the \f-command to set the
seperator and pipe the output of my select directly to a file.
Unfortunately thats all the control I have over the created csv-file. I
cannot
set the
On Mon, 2007-02-26 at 13:20 -0500, Reid Thompson wrote:
On Mon, 2007-02-26 at 14:54 +0100, peter pilsl wrote:
I need to export several tables as csv. I use the \f-command to set the
seperator and pipe the output of my select directly to a file.
Unfortunately thats all the control I have
On 10:44 Sun 18 Mar , Jeff Ross wrote:
Hi,
Is there a simple way to determine with a shell script if PostgreSQL is
ready to accept connections?
PostgreSQL is started and controlled by daemontools. This shell script
is called by the /etc/netstart script as a part of bringing up the
Marc wrote:
what version of PostgreSQL?
what version of the jdbc driver?
The bottom line question is can an applet served to a client machine
other than the one the postrgres db resides on read that db?
I can't see why not.
An applet I’ve written and tested on the same box as my
On Thu, 2007-04-19 at 10:05 -0500, Tony Caduto wrote:
David Potts wrote:
Can any body recommend a generic opensource data entry tool that can be
used to make some simple forms for entering data in to postgres?
---(end of broadcast)---
Hello list,
We are using PostgreSQL 8.0.3. Some background, and a couple of
questions..
We have a database table called jobq on the database machine,
and 2 networked server machines.
One of the network server machines has around 20 server processes
connecting over the network using ODBC.
These
On Mon, 2008-02-18 at 17:46 +, Raymond O'Donnell wrote:
On 18/02/2008 13:14, pgsql_user wrote:
so wouldnt I run out of ids one day, if there are lot of failed insert
statements, lets say for every successful insert there are 50
unsuccessful inserts, so ids would be 1, 50, 100, and once
akshay bhat wrote:
HELLO
i have psql file which is to be used for loading a database
it was downloaded from this link http://conceptnet.media.mit.edu/
the description says
The ConceptNet 3 database, as a PostgreSQL input file. You will need to
be running a PostgreSQL server to install
On Sun, 2008-03-09 at 19:41 +, Raymond O'Donnell wrote:
On 09/03/2008 15:34, Reid Thompson wrote:
you'll also probably have to add the parameter -h 127.0.0.1
psql defaults to connecting to the local machine unless you tell it
otherwise, so this is redundant; though it certainly
On Mon, 2008-03-10 at 06:55 +, Raymond O'Donnell wrote:
On 09/03/2008 22:33, Reid Thompson wrote:
On Sun, 2008-03-09 at 19:41 +, Raymond O'Donnell wrote:
On 09/03/2008 15:34, Reid Thompson wrote:
you'll also probably have to add the parameter -h 127.0.0.1
psql defaults
Is there any solution to this other than adding memory, or am I
mis-understanding the error?
pg_dump: ERROR: Memory exhausted in AllocSetAlloc(875574064)
pg_dump: lost synchronization with server, resetting connection
pg_dump: SQL command to dump the contents of table table_name failed:
Tom Lane wrote:
Reid Thompson [EMAIL PROTECTED] writes:
Is there any solution to this other than adding memory, or am I
mis-understanding the error?
pg_dump: ERROR: Memory exhausted in AllocSetAlloc(875574064)
pg_dump: lost synchronization with server, resetting connection
My bet
Original Message
Subject:Sun backs open-source database PostgreSQL | Topic:
everything | ZDNet News Alerts
Date: Thu, 17 Nov 2005 13:10:34 -0800 (PST)
From: ZDNet News Alerts[EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Claire McLister wrote:
Hi All,
The only objection that I've heard to using Google maps is there are
some 'copyright issues'. AFAIK, Google Maps come with a fairly liberal
license. As long as you use it in a web application that is freely
accessible to users, you are within their terms of
Pamela wrote:
Sure so long as they decide to go with this solution. It would be greatly
appreciated. Have you looked at Ruby which is quite helpful when dealing
with PHP Perl CGI and C/C++. I haven't a lot of programming experience, my
degree is in BA Adv Mgmt and Financial Acctg and Diploma
Russ Brown wrote:
On Thu, 5 Jan 2006 15:11:49 -0500
Jaime Casanova [EMAIL PROTECTED] wrote:
Anyone know who came up with the term in the first place?
FWIW --- as defined by ORACLE http://www.orafaq.com/glossary/faqglosa.htm
ACID
The basic properties of a database transaction:
Hoping that perhaps someone here has already been down this road and may be
willing to provide some pointers.
Can anyone direct me to information regarding the use of PostgreSQL with other
references to verify/flag bad telephone number data?
I've tables with 'people' data ( f/lname, addr,
of interest perhaps...
http://news.zdnet.com/2100-9593_22-6040197.html?tag=zdnn.alert
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
John Zubac wrote:
Isn't this article false in stating that Ingres is tring to build a high end
open source database package. Isn't postgres based on Ingres if I'm correct in
my history lesson. And postgres IS a high end open source database package.
falcon wrote:
Hi,
Most of the web applications I work on are nothing more than front-ends
to postgresql. I have used Perl (CGI), Java, C# and am now looking at
Django. Each generation of frameworks lessens the pain of donig
web-apps, but it still seems redundant.
Does any one know of a
Hi all,
I'm querying for feedback/comments. Wondering what the list thinks of
the following.
Assume this is to provide a production database for a small company or a
department. Production hours 5am-9pm for the most part so night-time
downtime if/when necessary would not be a problem.
Scott Marlowe wrote:
Then yeah, php or perl are your only choices. Again, as is often the
case, better to tell us what you're tying to do, and ask for
suggestions, then to tell us what tool you think you need, and leave us
guessing as to motivation. Happens a lot though, don't worry about it.
Tomi NA wrote:
I'd like to dump a postgresql database from my (java) app and copy the
dump file to the client machine.
This backup strategy prooved invalueable in the past (given enough
room on the harddrives, which I have) and I'd like to implement it now
with postgresql.
Is there something
Ian Harding wrote:
I'm wondering if I could get some suggestions as to how implement
this quickly and simply? I was thinking a web interface using PHP
would be the fastest way of going about it.
If you used Ruby on Rails, you'd be finished by now. It slices, it
dices, it makes
: [GENERAL] Is this a Stupid Question ?
Thread-Index: AcRcef4JWQko20oQQ+GuDme6wR5unwAlT2FA
From: Reid Thompson removed
To: Adam Smith adamsmith at econ dot com
I'd suggest looking at the original installations manifast/package
listing and then verifying that all parts of said listing are removed
Alberto Cabello Sanchez wrote:
On Sun, Nov 21, 2004 at 05:50:30PM +, Chris Green wrote:
I'm after a good report generator for a postgresql database. I am
using Rekall at the moment which is quite good but I'm not quite able
to do some of the things I want.
Has anyone got any
http://www.linuxjournal.com/article/8986
Play Ball: Introducing Fungoes
By Mat Kovach http://www.linuxjournal.com/user/801609 on Thu,
2006-04-20 01:00. Webmaster
http://www.linuxjournal.com/taxonomy/term/16 Follow along as a
life-long baseball fan turns his hobby into an open-source
Geoffrey wrote:
How do folks handle the death of the postmaster in their applications?
Assuming the postmaster dies after an application has connected to the
database, but before it makes a request. What should I look for?
Currently our application that's in development does not handle the
Steve Atkins wrote:
On May 8, 2006, at 11:05 PM, Guido Neitzer wrote:
On 09.05.2006, at 0:33 Uhr, Karen Hill wrote:
What is your favorite front end for end users to interact with your
postgresql db? Is it java, .net, web apache + php, MS-Access, ruby on
rails? Why is it your favorite? Which
PG_VERSION 8.1 - windows XP - 1GB RAM -- Desktop workstation, PG used
for test/dev.
This installation has been working fine for quite a while. I've used it
minimally.
I rebooted yestderday- log file from reboot
2006-05-18 12:24:32 LOG: database system was shut down at 2006-05-18
12:23:08
Reid Thompson wrote:
PG_VERSION 8.1 - windows XP - 1GB RAM -- Desktop workstation, PG used
for test/dev.
This installation has been working fine for quite a while. I've used
it minimally.
I rebooted yestderday- log file from reboot
2006-05-18 12:24:32 LOG: database system was shut down
Eliana Providel wrote:
Hola a todos
Estoy trabajando con postgresql y tengo el siguiente problema
cuando intento listar todas las bases de datos existentes con psql -l
me sale el siguiente error:
ERROR: no existe la relación pg_catalog.pg_user
Puedo crear bases de datos y acceder a ellas
Jasbinder Bali wrote:
Hi
Can anyone help me with the usage of ECPG??
Like how to go about it, what all header files to include in my C file
and other things that i need to give due considerations before using ECPG
~Jas
see headOfPgSourceTree/src/interfaces/ecpg ( test has several examples )
Using a legacy installation ( 7.2.3 ).
Occasionally the system will reach a state where attempted psql
connection attempts fail, with the following error in the postgresql
log:
postmaster: StreamConnection: accept: No such device or address
Will also occasionally get no connection to server
Larry Rosenman wrote:
Reid Thompson wrote:
Using a legacy installation ( 7.2.3 ).
Occasionally the system will reach a state where attempted psql
connection attempts fail, with the following error in the postgresql
log:
postmaster: StreamConnection: accept: No such device or address
On Sat, 2008-08-09 at 04:59 -0400, Fouad Zaryouh wrote:
Hi Aravind,
Run the following query
SELECT relname, reltuples, relpages * 8 / 1024 AS MB FROM pg_class
ORDER BY relpages DESC;
relname = table name
relpages = size in MB
reltuples = number of rows.
Hope this help.
I'm getting this failure on compilation. Could someone point me in the
direction of a fix?
Thanks,
reid
System: AIX 5.3
$ uname -a
AIX aix53-dev-1 3 5 000B357F4C00
Configuration params:
./configure --prefix=/usr/local/pgsql833 --without-readline --disable-shared
The Error:
...SNIP...
On Fri, 2008-08-15 at 11:03 -0400, Tom Lane wrote:
Reid Thompson Woulwrites:
I'm getting this failure on compilation. Could someone point me in the
direction of a fix?
You probably ought to inquire into the cause of these:
gmake[2]: stat:regress.so: There are too many levels
On Fri, 2008-08-15 at 16:37 -0400, Tom Lane wrote:
Reid Thompson [EMAIL PROTECTED] writes:
Would plpgsql.so get built with..
./configure --prefix=/usr/local/pgsql833 --without-readline --disable-shared
Uh
On Fri, 2008-09-05 at 11:44 +0200, Filip Rembiałkowski wrote:
is the server running (see process list, ps ax | grep postgres)
does the socket file exist? (see filesystem, ls -l /tmp/.s.PGSQL.5432)
Since you say things work for several days, then stop -- make sure
there's no braindead
Keith D. Evans wrote:
We usually run postgresql on a private machine (gravity) but due to
space, we have moved the database to a different machine through afs (a
local network at the university). We do not want the private machine to
be accessible to outside users, so our web pages are on the
On Wed, 2009-07-01 at 16:16 -0500, Anthony Caduto wrote:
I am looking for something similar to:
http://www.arcanadev.com/adtempus/ but without the MS SQL server
dependency.
Thanks,
Tony
http://www.opensymphony.com/quartz/ might fit the bill
--
Sent via pgsql-general mailing list
may be of interest --
http://blogs.sun.com/jkshah/entry/igen_with_postgresql_8_4
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Assuming the examples on
http://www.postgresql.org/docs/8.3/static/ddl-partitioning.html
where measurement has children as noted
CREATE TABLE measurement (
city_id int not null,
logdate date not null,
peaktempint,
We have a set of tables that we're partitioning by year and month -
e.g. payments_parent, partitioned into payments_200901, payments200902, ...
and inquiries_parent, partitioned into inquiries_200901, inquiries_200902, ...
Each table has a timestamp field import_ts that can be used to partition
On Mon, 2009-09-28 at 12:42 -0400, Merlin Moncure wrote:
the best way to do this is very version dependent. the basic trick is
to use text cast to pass a composite type into the query sting.
one way:
execute 'insert into foo_something select (' || new::text || '::foo).*';
you can try:
On Mon, 2009-09-28 at 11:05 -0400, Reid Thompson wrote:
We have a set of tables that we're partitioning by year and month -
We can't seem to quite get it right...
This is our quick stub test.
--
-- Tables:
--
CREATE TABLE payments (
id serial,
payment_name varchar
On Tue, 2009-09-29 at 07:54 -0400, Merlin Moncure wrote:
you are missing some quotes in there. also, don't use 'values', use
select. see my example above:
execute 'insert into foo_something select (''' || new::text || '''::foo).*';
the actual query should look like:
insert into
In the case where a_text is null, I essentially want the same result as the
case when a_text = ''.
would this:
select a_int || coalesce(a_text,'') from test1 where a_int = 102;
be the proper way?
postgres=# \d test1
Table public.test1
Column |
On 05/24/2011 10:49 AM, Scott Marlowe wrote:
Oh good. My first response from google, with safe search turned off,
was much more distressing...
in other news, google trends for cbt just jumped
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
On 05/24/2011 01:02 PM, fork wrote:
A psql prompt and the excellent postgresql documentation?
if you're concerned about mucking something up, download a postgresql livecd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
My postgresql instance was last started on Apr21.
In my temp space directory, I have various files that I believe are orphaned.
Given the information below, can I safely rm the files in
/mnt/iscsi/psql_tmp/tmpdata/41099 that are older than Jun 22?
If yes, should these files have been cleaned up
On 06/23/2011 11:08 AM, Eduard-Cristian Stefan wrote:
D:\me\usr\PostgreSQL\bin/pg_ctl.exe runservice -N pgsql -D
d:/me/etc/PostgreSQL
not very familiar with the windows version, but I think -D is supposed to point to the data directory which in your later info is
listed as
data_directory
On Thu, 2011-06-23 at 13:26 -0700, Adrian Klaver wrote:
On 06/23/2011 01:07 PM, Steve Crawford wrote:
On 06/23/2011 12:30 PM, hernan gonzalez wrote:
On Thu, Jun 23, 2011 at 4:15 PM, Adrian Klaver
adrian.kla...@gmail.com mailto:adrian.kla...@gmail.com wrote:
On 06/23/2011 11:40
On Thu, 2011-06-30 at 10:46 -0400, gnuo...@rcn.com wrote:
I'll need the contrib source, and I don't find it anywhere. I must not be
looking in the right place.
Where might that be?
http://www.postgresql.org/ftp/source/
--
Sent via pgsql-general mailing list
On Fri, 2011-07-22 at 10:11 -0700, Samuel Hwang wrote:
I ran the same tests in SQL Server 2008R2, Oracle10 and PostgreSQL
9.0.4 and found something interesting...
results
=
SQL Server 2008 R2 (with case insensitive data, the ordering follows
ASCII order)
Oracle 10 (data is
On 9/12/2011 9:54 PM, Reid Thompson wrote:
Ack -- i flubbed the subject and sample.
The sample data should be
val val2date
11 2011-01-01
22 2011-01-02
33 2011-01-03
41 2011-01-04
52 2011-01-05
53 2011-01-01
41 2011-01-02
2011-01-08
where any one of these 3
11 2011-01-01
11 2011-01-01
13 2011-01-01
or any one of these 2
31 2011-01-05
32 2011-01-05
are suitable for val = 1, val = 3 respectively.
On 9/12/2011 8:54 PM, Reid Thompson wrote:
Could someone
Could someone point me in the right direction..
Thanks - reid
Given the example data,
how do I write a query that will give me the resultset:
12011-01-01
22011-01-06
32011-01-05
42011-01-09
52011-01-05
62011-01-08
I.E. for each distinct val, return the record with the
On Tue, 2011-09-13 at 16:39 +0200, Hannes Erven wrote:
Reid,
where any one of these 3
11 2011-01-01
11 2011-01-01
13 2011-01-01
or any one of these 2
31 2011-01-05
32 2011-01-05
are suitable for val = 1, val = 3
I believe that there should be no issue, but am asking to be sure.
Thanks,
reid
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Thu, 2011-09-29 at 12:08 -0500, dennis jenkins wrote:
ERROR: could not load library /db/pgsql_micr_parser_64.so: ld.so.1:
postgres: fatal: /db/pgsql_micr_parser_64.so: Permission denied
for a different shared object, but may provide clues...
Error: - adding iplike database function... snip
reporting=# select version();
version
--
PostgreSQL 8.3.7 on x86_64-redhat-linux-gnu, compiled by GCC gcc (GCC)
4.1.2 20071124 (Red Hat
On Tue, 2011-11-22 at 15:55 +, Gregg Jaskiewicz wrote:
for the future it is better to just use text type, and: check
length(field) 35;
thanks to all for the respones.
The above seems a prudent way to go in my future.
My assumption is that converting varchar(n) to text would still force a
On Wed, 2012-01-11 at 20:50 +0100, Kirill Müller wrote:
that would
allow tracing the queries and their runtime while they are executed \
http://www.postgresql.org/docs/8.4/static/auto-explain.html
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
Looking for some quidance or suggestions.
PostgreSQL 9.1.2 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.4.5
20110214 (Red Hat 4.4.5-6), 64-bit
$ uname -a
Linux db1.hw.ateb.com 2.6.32-131.21.1.el6.x86_64 #1 SMP Tue Nov 22 19:48:09 GMT
2011 x86_64 x86_64 x86_64 GNU/Linux
datid|
On Tue, 2012-03-20 at 09:22 -0500, Sam Loy wrote:
I have now tried at least 7 different install methods to get pg up and
running on Lion. I fear that my system is now thoroughly inoculated and will
never be able to run postgres/postgis.
I started with the pg mac installer / stack builder.
On Tue, 2013-05-14 at 14:51 +, S H wrote:
I am doing some experiment to understand the behaviour of manual
vacuum.
I created small table and started doing insertion/deletion/updation on
2 rows in infinite loop. It started bloating around 844 times, but
after it stopped bloating.. what
On Tue, 2013-11-05 at 04:14 -0800, bsreejithin wrote:
Not able to post the attached details as a comment in the reply box, so
attaching it as an image file :
http://postgresql.1045698.n5.nabble.com/file/n5776987/Untitled.png
--
View this message in context:
So we know have data in ~30 partitioned tables.
Our requirements now necessitate adding some columns to all these tables
( done ) which will get populated via batch sql for the older tables and
by normal processing as we move forward.
The batch update is going to result in dead tuples in the
1 - 100 of 137 matches
Mail list logo