On Tuesday, March 7, 2017 3:35 PM, John Iliffe
wrote:
>
> Trying to compile pgsql 9.6.2 on Fedora 25
>
> I get the following message:
>
> configure:9345: error: readline library not found
> If you have readline already installed, see config.log for details on the
> Use --without-r
On Wed, Jan 16, 2013 at 11:45 AM, Rob Sargent wrote:
> What environment are you in. In jdbc you can address the resultset by
> column name.
C++, so it's quite inefficient to always use names.
Chris Angelico
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes
Hi! (I'm Chris Angelico posting from a work account - usually I'm here
under the name ros...@gmail.com.)
I've run into a bit of an awkwardness in PostgreSQL setup and am
hoping for some expert advice.
Several of the tables I work with have two groups of fields: standard
fields and "free fields".
I am also evaluating Drupal + PostgreSQL at the moment. We are building
a local government website/intranet that doesn't need to be lightning
fast or handle millions of hits a day, but it does need to be rock solid
and potentially needs to manage complex business processes. So
PostgreSQL seems
Sorry folks, a perennial one I'm sure ...
I have read the manual and Googled for a couple of hours but still can't
connect to PostgreSQL 8.3.4 (the PGDG RPMs running on an up to date
CentOS 5.2).
I continually get this message:
psql: could not connect to server: No such file or firectory
Is
Sorry if this is the wrong list, I'm not totally up with the PG ecosystem.
I'm looking for RHEL/CentOS RPMs for version 8.4 for testing purposes
(with Drupal). I can find an RPM to install a yum repo at
yum.pgsqlrpms.org, but not the RPMs themselves. The yum repo is not much
use to me as the m
with the time to pursue them.
I'm the first to admit I know little about the art and science of
relational database design and admin. But up to this point, I haven't
needed to. It doesn't take rocket science to store and retrieve some
text for a few web pages in a database.
I'm facing a very similar problem where I work (local govt) where we
want to put around 100 forms online. The idea of 100 seperate database
tables is too painful to contemplate.
Depending on the nature of the data, I suppose, both the structured text
string and the serialised object options so
Is there any special reason to use PHP? There are
a couple other scripting languages useable for the
web which do all have better abstration available.
(afaic even PHP does have some more abstration to
just using pg* functions)
Well, yes, there are alternatives of course and I could write this
You need something like this:
$query = "select id, name from tablename";
$result = pg_query($query);
while ($row = pg_fetch_array($result)) {
$content = $row[0];
}
That's actually what I was using.
The scoping wasn't the issue either.
Today I switched back to pg_connect() from pg_pconnect(),
Thanks again for replies.
I know those questions were pretty vague.
I need to set up some methodical test scripts that replicate my
problems, so that it is clear what is going on.
There does seem to be some evidence of problems historically with PHP
and persistent connections in PostgreSQL, on
First, thanks to everyone who responded to my newbie questions
yesterday, all clear now.
I spent most of today struggling with apparently inconsistent behaviour
while running SELECT statements on PG 8.1.9 using PHP 5.1.6 (these are
both as supplied with CentOS 5.1, a fairly conservative distro
I've worked as a web developer on mostly small business websites for the
past seven years, and while I've had some limited experience with older
versions of PostgreSQL (7.* ??), I've mostly used MySQL all this time.
I now work for local govt and am building a large intranet-like system
which u
.
But how could i compile the int8 corectly?
- Original Message -
From: "Tom Lane" <[EMAIL PROTECTED]>
To: "admin" <[EMAIL PROTECTED]>
Cc: "Jerome Raupach" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: 27 septembrie 2000 08:43
Subjec
nsert it into the table.
But on the alpha i got no error message no worning and inserts a wrong
number if the number is bigger than 10^13 .
regard Hanos Felix
- Original Message -
From: "Jerome Raupach" <[EMAIL PROTECTED]>
To: "admin" <[EMAIL PROTECTED]>
S
- Original Message -
From: "Tom Lane" <[EMAIL PROTECTED]>
To: "admin" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: 26 septembrie 2000 16:31
Subject: Re: [GENERAL] Int8 problem
I send you the outputs maybe you will find an answer.
Than
Hi
I have intalled Postgres 7.0.2 on a Compaq Alpha with DigitalUnix.
If I insert a bigger number like 10^13 in an int8 type field i'm getting no
error messages, no warnings, but if I check the value inserted i receive
totaly wrong number like 2543
If you have any suggestions please let
I've had the same question, I believe the best it gets will be something
like running rsync over an encrypted (if needed for security) tunnel (ssh).
But you'll have to user some dump utility as far as I know.
Cheers Wim.
- Oorspronkelijk bericht -
Van: Differentiated Software Solutions
configset pgsql-general delivery_rules << ENDAAK
/(\.fi|\.no|\.dk|\.se)$/
sort
maxaddrs=50
minseperate=5
hosts=(towerguard.unix.edu.sollentuna.se=(esmtp,pipelining,onex))
backup=(hub.org=(esmtp,pipelining,onex))
/(\.nz)$/
sort
maxaddrs=50
minseperate=5
hosts=(postgresql.godzone.net.nz=(esmtp,pipe
Hi, I'm trying to do something with dates which is proving to be a bit
tricky.
I'm trying to get the current "date" and add 3 days to this.
I've tried:
$date = "(now::date) + ('3 days'::interval)";
DBD::Pg::st execute failed: ERROR: parser: parse error at or near "3"
... and :
$date = "(n
How can I update on select?
>From the User's Guide, it seems triggers can only be used on INSERT,
UPDATE and DELTE events. As for rules, the guide says they can be used on
SELECT. When I actually tried updating on select using rules, here's what
I got:
test=> CREATE RULE tab_rule AS ON select
te
I have unfortunately deleted a message to pgsql-general today which
contained a query like:
SELECT tab1.b, tab2.c FROM tab1, tab2 WHERE tab1.a=tab2.a;
There was also a UNION following, but my memory fails me. My question is
though, can an index be used for the above query? When I try it with an
What is maxusers set to in your kernel? One prolem I had was that
postgresql was using more filedescriptors that my kernel could handle. If
you'd like to check your current filedescriptor status and your max, try:
pstat -T. If that is your problem, change your maxusers to a suitable
number and rec
Did you upgrade from source or from the freebsd ports?
> We upgraded to version 6.5.2 recently, running on FreeBSD 3.0. Now we are
> having problems with moderately complex queries failing to complete (backend
> terminating unexpectedly; last one crashed the server). The most likely
> explanati
> > I'm trying to use an index on a varchar(32) field, but explain keeps
> > retuning a sequential scan. This is my table and index:
>
> I had a similar problem last year when trying to use an index on a
> char(8) field. Two solutions worked for me: 1) use "bpchar_ops", and
> 2) leave out the o
k I'll change a few to char(). What are the advantages of using
char() instead of varchar(). For a sequential scan, explain returned a
cost of 105.44 for a char() field as opposed to 95.44 for a varchar().
Thanks again,
Marc
> --- admin <[EMAIL PROTECTED]> wrote:
> > > I&#x
Yes, I did try vacuum analyze, but my search query still uses a sequential
scan.
> > I then tried changing the btree index to a hash talbe and went through the
> > same procedure of vacumming and restarting a psql session. Yet again, the
> > index wasn't being used.
>
> But did you try vacuum an
Excellent point, your last comment gives me a tangible incentive for using
hash instead of btree. Since I don't need to use other operators than '=',
there is really no need to spend extra time creating a btree while all I
need is a hash table. In the end, both are as fast for searching, but I
gai
My results were exactly the same for btree and hash, even when vacumming
between each index creation. Here's my query:
SELECT * FROM prod_base WHERE mid='2';
Here's my result:
Index Scan using prod_mid_idx on prod_base (cost=2.05 rows=2 width=120)
My database is perhaps not big enough to run som
I've been reading the postgresql manual and I find there is very little
discussion about hash compared to btree. Most of the focus seems to be on
using btree indices even that the default for 'create index' is btree
also. From the documentation, it seems the only difference between either
searchin
Is there a way to make queries using the 'like' operator quicker, more
specifically for queries that look like:
select name from table where name like '%abc%';
Thanks,
Marc
I am trying to optimise a query which looks like:
select prod_base.*, manu_base.name from prod_base, manu_base where
prod_base.mid=manu_base.mid;
manu_base is a table consisting of 3000 manufacturer with an id (not
unique to support synonyms) and a name (declared as varchar(32)).
prod_base is a t
Quick question:
Is there a way to update fields in a table within limits, similarly to
using a select. In other words, something like this:
update from table1 field1='blah' where id=(select id from table2 limit
5,5);
Thanks,
Marc
Hi all,
we are using Postgresql 6.4.2 on FreeBSD 2.2.8 and have a lot of
problems with suddenly dying backend processes. We have already
changed kernel parameters to get more shared memory and start the
postmaster with -B 1024. The postmaster's virtual memory limit is
currently 300MByte and our l
36 matches
Mail list logo
