On Tue, Mar 31, 2009 at 2:26 PM, Tom Lane wrote:
> Does anyone want to argue for keeping it the same? Or perhaps
> argue that a zero-element array is a more sensible result than
> a one-element array with one empty string? (It doesn't seem
> like it to me, but maybe somebody thinks so.)
>
My fi
Sorry for top-posting--blame apple.
Hm my first instinct was indeed to make it a zero-length array. I was
thinking of the input as a "list" and surely there are no elements in
a list which empty. I had to think a while until a length-1 array made
sense.
I suppose the thinking was string_t
Bingo!
I doubled each of the entries below, and the two servers are now
running together quite happily!
Regards,
Eric
On Mar 30, 2009, at 7:56 PM, Eric Smith wrote:
... as a reminder, this is running on mac os 10.5
Eric
On Mar 30, 2009, at 7:53 PM, Eric Smith wrote:
Ahhh! Can't seem t
... as a reminder, this is running on mac os 10.5
Eric
On Mar 30, 2009, at 7:53 PM, Eric Smith wrote:
Ahhh! Can't seem to make this go away!
Here is the log file entry:
FATAL: could not create shared memory segment: Cannot allocate memory
DETAIL: Failed system call was shmget(key=5432001,
On Tue, Mar 31, 2009 at 11:10 AM, Tom Lane wrote:
> Stuart Bishop writes:
>> On Tue, Mar 31, 2009 at 8:59 AM, Tom Lane wrote:
>>> What's the actual size of that relation now? Is it growing rapidly?
>>> (I'm trying to figure out whether those writes *should* have succeeded,
>>> or whether the bl
On Mar 30, 2009, at 8:26 PM, Tom Lane wrote:
Does anyone want to argue for keeping it the same? Or perhaps
argue that a zero-element array is a more sensible result than
a one-element array with one empty string? (It doesn't seem
like it to me, but maybe somebody thinks so.)
Hrm. There seems
Stuart Bishop writes:
> On Tue, Mar 31, 2009 at 8:59 AM, Tom Lane wrote:
>> What's the actual size of that relation now? Â Is it growing rapidly?
>> (I'm trying to figure out whether those writes *should* have succeeded,
>> or whether the block numbers were corrupt in memory.)
> I can't seem to
Tom Lane wrote:
I agree this seems less than consistent though, especially seeing
that you *don't* get a null for a zero-length separator, which if
anything is a more poorly defined case.
I doubt it'd be a good idea to back-patch a change for this,
but I could see altering the definition for 8.4
On Tue, Mar 31, 2009 at 8:59 AM, Tom Lane wrote:
Stuart Bishop writes:
I just had a brief outage on a production server running 8.3.6, which
I suspect was triggered by me running a table bloat report making lots
of pgstattuple calls.
The first I got of it was the script I'd just kicked off
Just because a result is unexpected
does not mean its an incorrect result. No postgresql follows the order
of operations as expected.
Now looking at the 2 For loops the First does not have a where clause
and the Second has a Where not null this could be the cause of the
problem.
Anothe
Steve Crawford writes:
> I have a query that converts a string to an array with the
> string_to_array function. Sometimes the input is an empty string (not a
> null, but a string of zero-length). I had expected the result to be a
> one-element array with an empty string as the first and only el
Eric Smith writes:
> Following the queue on the postgres web page, I created /etc/
> sysctl.conf and added the following five entries:
> kern.sysv.shmmax=4194304
> kern.sysv.shmmin=1
> kern.sysv.shmmni=32
> kern.sysv.shmseg=8
> kern.sysv.shmall=1024
> But when I try to start two servers, I ge
Ahhh! Can't seem to make this go away!
Here is the log file entry:
FATAL: could not create shared memory segment: Cannot allocate memory
DETAIL: Failed system call was shmget(key=5432001, size=4030464,
03600).
HINT: This error usually means that PostgreSQL's request for a shared
memory s
Eric Smith writes:
> Log file says "could not create shared memory segment". It also says
> that I should change max_connections or shared_buffers.
> Error message claims that max_connections is 23, but postgresql.conf
> has this listed as 20.
The autovacuum workers get added on.
> Error m
Stuart Bishop writes:
> I just had a brief outage on a production server running 8.3.6, which
> I suspect was triggered by me running a table bloat report making lots
> of pgstattuple calls.
> The first I got of it was the script I'd just kicked off died:
> could not open segment 1 of relation 1
I don't think I understand how PG implements fulltext searching or if my
search actually needs to use fulltext search.
basically, I have a btree index on a SERIAL_NUMBER which is of sort like
ABC12345 or AAA123434 or AAB131441
I would like to have search on the specific text of the SERIAL_NUMBER
That's it!
Log file says "could not create shared memory segment". It also says
that I should change max_connections or shared_buffers.
Error message claims that max_connections is 23, but postgresql.conf
has this listed as 20.
Error message claims that shared_buffers is 300, but postgresq
Hi all!
I'm developing an algorithm with PL/PGSQL using statistical operations from
a table. I have several differences between expected results and the results
generated by the function.
I want to know if there are differences in arithmetic operation sintax or if
there's any special arithmetic
On Mar 30, 2009, at 10:14 , shiguoying wrote:
Hello:
I have a problem with juding some words contain chinese word.
I found that with oracle.but i can't find it in postgresql.
oracle? has acsiistr and lengthb to deal with it.i wonna to know
postgresql how to !
??? thx !
You are fetching an Oracle LOB locator. I am not a guru of OCI let alone
JDBC but AFAIK you should create a LOB descriptor, bind it to the locator
and load the LOB data that you can insert into postgres.
Using Postgresql 8.2.11 on Ubuntu 7.10.I am writing a J2EE project but do not want user specific schemas because this application sits on a production floor and any production employee can walk to a workstation and access the database to punch work time. I know that the public schema is not suppose
2009/3/30 Jennifer Trey :
> Hi,
> During the development of my application I once, somehow through an
> installed postgresql software got me to a page where I could find
> information on how to tune my db.
> I can't seem to find to that link again. I think it was to a page within the
> EnterpriseDB
Hi,
During the development of my application I once, somehow through an
installed postgresql software got me to a page where I could find
information on how to tune my db.
I can't seem to find to that link again. I think it was to a page within the
EnterpriseDB but that page seems to have significa
Hi,
Im reading from an Oracle table and inserting the values to a postgres table
thro' jdbc. Everything works fine except for the BLOB data in Oracle.
My code snippet ...
while (rs1.next())
{
for (int m=1;m<=colCount;m++)
{
pstmt.set
Eshelman, James wrote:
We’re running PG 8.1 on CentOS 5.0. When postgres starts the following
processes apparently required by the DB itself get created:
postgres 23784 1 0 13:55 ? 00:00:00 /usr/bin/postmaster -p 5432 -D
/var/lib/pgsql/data
postgres 23786 23784 0 13:55 ? 00:00:00 postgres:
ray wrote:
> I am sorry for not providing a clear description of my problem. I
> want to us Python 2.6 but the PLPython seems to me looking for 2.5
> which is not on my machine. Is there a way to have PostgreSQL work
> with Python 2.6?
Recompile PostgreSQL, or at least the PL/Python extension,
It's a normal pg connection server created by our own code. Nothing native to
pg startup.
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Eshelman, James
Sent: Monday, March 30, 2009 3:29 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Po
Jennifer Trey wrote on 30.03.2009 21:39:
Point me to latest JDBC for pgSQL (plus) standard server?
http://jdbc.postgresql.org
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
We're running PG 8.1 on CentOS 5.0. When postgres starts the following
processes apparently required by the DB itself get created:
postgres 23784 1 0 13:55 ?00:00:00 /usr/bin/postmaster -p 5432 -D
/var/lib/pgsql/data
postgres 23786 23784 0 13:55 ?00:00:00 postgres: logger
Point me to latest JDBC for pgSQL (plus) standard server?
Is it possible that what you want is a lookup table with a string index,
i.e. attribute-value pairs?
If so, that would be represented as a hash in Perl, or a map in C++. In
a database, you could design a very simple schema for it.
Or do you just have unclear requirements, as others have suggeste
On Mon, Mar 30, 2009 at 8:20 PM, Jennifer Trey wrote:
> Hmm, cant find it.. but.. if I install the regular (not plus), could I later
> upgrade easily to other versions ? Is that possible? In that case I could
> just start with the one I already are familiar with.
It's quite straightforward, yes.
Hmm, cant find it.. but.. if I install the regular (not plus), could I later
upgrade easily to other versions ? Is that possible? In that case I could
just start with the one I already are familiar with.
Jen
On Mon, Mar 30, 2009 at 9:03 PM, Dave Page wrote:
> On Mon, Mar 30, 2009 at 7:36 PM, Jen
On Mon, Mar 30, 2009 at 08:50:59PM +0200, A B wrote:
> Well, the requirement is: keep a lot of data stored, don't loose any
> of it, and you will not know what you will have to store (changing
> number of fields and of different types)
As you've not said anything about getting said data back; it d
2009/3/31 A B :
> One option is, put it in a db as a huge text (or in textfiles, one
> per object) and parse it when you need it. That might also work.
>
> Why are you demanding sanity? I need crazy ideas to get this to work ;-)
Heh ... sorry, but "dynamic table" just SCREAMS "design flaw!!" ...
On Mon, Mar 30, 2009 at 11:04:06AM -0700, David Fetter wrote:
> On Mon, Mar 30, 2009 at 05:39:19PM +0200, A B wrote:
> > Hi,
> > In the next project I'm going to have a number of colums in my tables,
> > but I don't know how many, they change.
>
> Stop right there. You need to get some sanity int
On Mon, Mar 30, 2009 at 7:36 PM, Jennifer Trey wrote:
> I am sorry, but it seems that I replied to only one of you instead of to the
> mailing list.
> I am just about to install a version on my "Server computer" (Windows web
> server 2008 x64) and I am stuck on what I should go with.
> I have been
I have a query that converts a string to an array with the
string_to_array function. Sometimes the input is an empty string (not a
null, but a string of zero-length). I had expected the result to be a
one-element array with an empty string as the first and only element but
instead it returned n
2009/3/30 David Fetter :
> On Mon, Mar 30, 2009 at 05:39:19PM +0200, A B wrote:
>> Hi,
>> In the next project I'm going to have a number of colums in my tables,
>> but I don't know how many, they change.
>
> Stop right there. You need to get some sanity into your project,
> either by changing that
I am sorry, but it seems that I replied to only one of you instead of to the
mailing list.
I am just about to install a version on my "Server computer" (Windows web
server 2008 x64) and I am stuck on what I should go with.
I have been developing on the standard postgreSQL but like that the
Enterpr
- "Emanuel Calvo Franco" wrote:
> To run servers at diferent ports you must use postgres binary.
>
> postgres -D data1 -p 5432 -l logfile &
> postgres -D data2 -p 5433 -l logfile &
That is not true. You can set the port in the postgresql.conf for each cluster
to be different and use pg_ct
From: michaelblack75...@hotmail.com
To: gentosa...@gmail.com
Subject: RE: [GENERAL] [GENEAL] dynamically changing table
Date: Mon, 30 Mar 2009 16:05:52 +
The simplest way is to plan for the maximum number of columns that will be
required (say 14 - 2 weeks of data assuming that is dail
On Mon, Mar 30, 2009 at 05:39:19PM +0200, A B wrote:
> Hi,
> In the next project I'm going to have a number of colums in my tables,
> but I don't know how many, they change.
Stop right there. You need to get some sanity into your project,
either by changing that requirement, or by not using an RD
> Well, not as such. Except that deleting a column doesn't really delete
> it, it hides it, so it never really goes away. So the number of
> "columns" in your table will only go up and eventually you're going to
> reach the point (around 1600 IIRC, probably earlier) where it will
> simply stop work
To run servers at diferent ports you must use postgres binary.
postgres -D data1 -p 5432 -l logfile &
postgres -D data2 -p 5433 -l logfile &
I never used pg_ctl to run postgres and don't ask me why.
2009/3/28, Eric Smith :
> All,
>
> I'm trying to run two database clusters on a single machine,
On Mon, Mar 30, 2009 at 05:39:19PM +0200, A B wrote:
> Hi,
> In the next project I'm going to have a number of colums in my tables,
> but I don't know how many, they change. They all use integers as
> datatype though.. One day, I get 2 new columns, a week later I loose
> one column, and so on in a
IMHO one of the possible solutions is to review the table and storage
externaly the
stable columns. So when you run 'alter table ' it was less
expensive (i never
test this, but maybe its true :P )
So the mutable columns will be separated from the others and the
phisical structure
could be more
Without knowing to much currently..
can you create one table with enough columns?
Then create a view to query the table and 'reflect' the changes and
correct column names.
Using rule you could also even simulate the update to the view and
update to the correct columns.
This so that you don't
On Mar 30, 2:55 am, dp...@pgadmin.org (Dave Page) wrote:
> On Mon, Mar 30, 2009 at 1:51 AM, ray wrote:
> > I am trying to get Python 2.6 and PostgreSQL 8.3 to work together
> > under Windows 2000.
>
> > When I try to add Python to PostgreSQL via:
> > createlang plpythonu dbname
>
> > But when doin
Hello:
I have a problem with juding some words contain chinese word.
I found that with oracle.but i can't find it in postgresql.
oracle? has acsiistr and lengthb to deal with it.i wonna to know postgresql
how to !
??? thx !
Hi,
In the next project I'm going to have a number of colums in my tables,
but I don't know how many, they change. They all use integers as
datatype though.. One day, I get 2 new columns, a week later I loose
one column, and so on in a random pattern.
I will most likely have a few million rows of
Adrian Klaver writes:
> I think you are going to have to show us the exact command you are using.
What *I* want to see is the postmaster log, which should certainly
contain an error message explaining why it failed to start.
regards, tom lane
--
Sent via pgsql-general m
On Sunday 29 March 2009 7:59:19 pm Eric Smith wrote:
> Thomas,
>
> When I start the servers, I use different ports via the -p option. Is
> that equivalent to using different listener ports in postgresql.conf?
>
> Thanks,
> Eric
>
I think you are going to have to show us the exact command you are
On Mon, Mar 30, 2009 at 2:52 PM, Joseph, Ray wrote:
> Dave,
>
> I am sorry that I was not clear. I want to use 2.6 but the stack seems to
> direct me to 2.5.
That's exactly what I understood from your email - however my fingers
weren't working properly at that time in the morning :-(. What I wa
esemba writes:
> Is it possible to have 2 gin indexes and OR the search of them?
Sure. They need to be fairly restrictive though, or the planner might
decide that a seqscan is cheaper.
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.
Markus Wanner wrote:
> Hi,
>
> Martijn van Oosterhout wrote:
>> And fsync better do what you're asking
>> (how fast is just a performance issue, just as long as it's done).
>
> Where are we on this issue? I've read all of this thread and the one on
> the lvm-linux mailing list as well, but still
Dave Page, 30.03.2009 14:28:
On Mon, Mar 30, 2009 at 1:06 PM, Thomas Kellerer wrote:
OK, thanks. I received very strange error messages last week when I accessed
that page. (Velocity Template not found and similar errors). But now it's
working.
Yeah, we had a big website update and that page
On Mon, Mar 30, 2009 at 1:06 PM, Thomas Kellerer wrote:
>
> OK, thanks. I received very strange error messages last week when I accessed
> that page. (Velocity Template not found and similar errors). But now it's
> working.
Yeah, we had a big website update and that page got messed up along
the w
Is it possible to have 2 gin indexes and OR the search of them?
Problem is, I need to search 5 columns and there is limitation of only 4
weights, so I want to have one index of 4 vectors and second index of 1
vector and need to OR the search.
When I try to search them separately, or use AND, it w
On 30/03/2009 07:18, aravind chandu wrote:
> Thanks for your reply guys.My aim is to run multiple queries.Will
> joins come under multiple queries? or it just mean two or more
Not sure what you're getting at herea query that includes a JOIN is
still one query.
> different queries like one se
Dave Page, 30.03.2009 10:34:
EnterpriseDB used to provide 8.4 "builds" for Windows, but the page I
bookmarked does not longer work.
Does anybody know if EnterpriseDB stopped this service?
No - in fact we refreshed the builds just a few days ago:
http://www.enterprisedb.com/products/pgdevdownloa
Hello Cédric,
Cédric Villemain [2009-03-30 12:08 +0200]:
> I have started some work on that.
Whoops, sorry. So did I yesterday evening. I just fixed the branch
enough to build now [1].
I just need to update postgresql-common to work with 8.4. Some things
changed, e. g. pg_controldata doesn't rep
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Cédric Villemain a écrit :
> Martin Pitt a écrit :
>> Cédric Villemain [2009-03-15 23:58 +0100]:
>>> Any plan for 8.4 pre-beta package ? (Devrim Gunduz provide usefull rpm
>>> package,
>>> I'd like to have the same in debian).
>>>
>>> Can it be in the
Thanks for your reply guys.My aim is to run multiple queries.Will joins come
under multiple queries? or it just mean two or more different queries like one
select statement and another select statement? Does postgresql itself supports
to run multiple queries or we have to use pgpool-II tool?
Bruno Baguette wrote:
Hello !
I have a table that contains two timestamps (and some other fields that
does not matter here).
the_table
--
pk_planning_id ==> INT8 (primary key)
timestamp_start ==> (not null timestamp without time zone)
timestamp_stop =+> (not null timestamp without t
On Tue, Mar 24, 2009 at 4:53 PM, Jasen Betts wrote:
> On 2009-03-18, cifroes wrote:
>> This is a multi-part message in MIME format.
>>
>> --_=_NextPart_001_01C9A7E6.B32BBA87
>> Content-Type: text/plain;
>> charset="iso-8859-1"
>> Content-Transfer-Encoding: quoted-printable
>>
>> Hi,
>>
>>On Behalf Of Asko Oja
>>Hello
>>We use plProxy (RUN ON ALL) to run queries in parallel.
>>We split our database into 16 shards and distributed it over 4 servers.
>>So now we are running queries on 16 cpu's in parallel :)
Wow.. query time improved How many fold? Any idea?
--
Sent via pgsql-ge
On Sun, Mar 29, 2009 at 08:44:59PM -0400, V S P wrote:
> The same problem was with my set client encoding (my other email)
> both were related problem to the fact that PG I have to issue commits
> even for the 'non sql' statements.
That's something between you and your database driver. PostgreSQL
On Mon, Mar 30, 2009 at 7:56 AM, Thomas Kellerer wrote:
> Devrim GÜNDÜZ, 28.03.2009 10:02:
>>
>> As we are moving very close to 8.4 beta, please join us for testing 8.4
>> release.
>>
>> I just released new RPM sets, which is based on Mar 27 CVS snapshot.
>> Please note that these packages are **n
Devrim GÜNDÜZ, 28.03.2009 10:02:
As we are moving very close to 8.4 beta, please join us for testing 8.4
release.
I just released new RPM sets, which is based on Mar 27 CVS snapshot.
Please note that these packages are **not** production ready. They are
for Fedora 9,10 and RHEL/CentOS 5. I have
On Mon, Mar 30, 2009 at 1:51 AM, ray wrote:
> I am trying to get Python 2.6 and PostgreSQL 8.3 to work together
> under Windows 2000.
>
> When I try to add Python to PostgreSQL via:
> createlang plpythonu dbname
>
> But when doing so, I get an error:
> createlang: language installation failed: ERR
Thomas,
When I start the servers, I use different ports via the -p option. Is
that equivalent to using different listener ports in postgresql.conf?
Thanks,
Eric
On Mar 28, 2009, at 3:51 PM, Thomas Kellerer wrote:
Adrian Klaver wrote on 28.03.2009 23:37:
On Saturday 28 March 2009 3:27:15
Hello
We use plProxy (RUN ON ALL) to run queries in parallel.
We split our database into 16 shards and distributed it over 4 servers.
So now we are running queries on 16 cpu's in parallel :)
regards,
Asko
On Mon, Mar 30, 2009 at 9:20 AM, aravind chandu wrote:
> Hello,
>
>I would li
73 matches
Mail list logo
