>
> max_connections = 400
>
> www3:/etc/postgresql# ulimit -a
> max user processes(-u) 256
> im totaly bogus, any ideas ?
>
Well, your allowing postgres to have 400 connection which is at least 400 processes if
not a few more.
And you are ulimiting the postgres user to 256 proces
On Sat, 30 Oct 2004 01:42 am, C G wrote:
> Dear All,
>
> I have a simple join query
>
> SELECT c1 FROM t1
> INNER JOIN
> t2 ON t2.c2 = t1.c2 WHERE t3.c3= t2.c3;
>
Instead
SELECT c1 FROM t2, t1 INNER JOIN t2 ON t2.c2 = t1.c2 WHERE t3.c3=t2.c3
OR
SELECT c1 FROM t1 INNER JOIN t2 ON t2.c2 = t1.c2
Thanks again for the help. I did manage to find that after a bunch of
searching in the mailing list. There should really be a portion of the
docs dedicated to array handling.
On Fri, Oct 29, 2004 at 10:40:57PM -0600, Michael Fuhr wrote:
> On Fri, Oct 29, 2004 at 05:13:02PM -0500, Jim C. Nasby wrot
On Thu, 28 Oct 2004 04:14 am, Eric wrote:
> Is there something to interface postgreSQL with QMail to store mails in
> pgsql instead of using mbox or maildir?
>
> Or maybe it's not a good idea to do that?
>
> I think there is some adavantages...
also look at http://www.dbmail.org/
>
>
>
>
On Fri, Oct 29, 2004 at 05:13:02PM -0500, Jim C. Nasby wrote:
> Ok, next stupid question that I can't find in the docs... How would I
> join a table to an array? IE: if I have an array of primary keys for
> some table and I want to get the name field from that table and turn it
> back into an array
Vinko Vrsalovic <[EMAIL PROTECTED]> writes:
> [EMAIL PROTECTED] sources 20:55:07]$ telnet mymachine 5431
> Trying 192.168.0.169...
> telnet: Unable to connect to remote host: Connection refused
Looks to me like you forgot to enable TCP connections in the 8.0
installation. Note that the relevant p
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Friday 29 October 2004 08:42 am, C G wrote:
> Dear All,
>
> I have a simple join query
>
> SELECT c1 FROM t1
> INNER JOIN
> t2 ON t2.c2 = t1.c2 WHERE t3.c3= t2.c3;
^
Your join doesn't alias anything
Hello,
I've got one 7.4 installation and a brand new 8.0 beta4
running on the same machine.
Both installations are configured to use the same port
(5431) to avoid reconfiguring the apps running on
top of the DB.
The following paragraphs illustrat
What does this mean?
WARNING: Rel pg_class: TID 17/13: InsertTransactionInProgress 106004881 -
can't shrink relation
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
What solution to use depends how many other tables and the relative
sizes of tables, but the following option has a reasonably good chance:
Suppose you have basetable, and joined1, and joined2.
Basetable.tablename tells which of the secondary tables to join against
(contains either 'joined1' o
Cott Lang wrote:
ERROR: could not convert UTF-8 character 0x00ef to ISO8859-1
Running 7.4.5, I frequently get this error, and ONLY on this particular
character despite seeing quite a bit of 8 bit. I don't really follow why
it can't be converted, it's the same character (239) in both character
sets.
Thanks. Good to hear that the easiest solution for me is also the fastest.
On Fri, 29 Oct 2004, Martijn van Oosterhout wrote:
> The number of dead tuples is the number of UPDATE statements you make.
> You if you just do a straight UPDATE x set f1=x, f2=y, ... that will be
> as optimal as you can
Karsten Hilbert <[EMAIL PROTECTED]> writes:
> However, the question still holds true: Is there any
> particular reason those operators aren't found in my PG
> installation despite being listed as added since 7.2 ?
The only thing that was added in 7.2 was xid equality.
There was some talk recently
Ok, next stupid question that I can't find in the docs... How would I
join a table to an array? IE: if I have an array of primary keys for
some table and I want to get the name field from that table and turn it
back into an array, how would I do that?
On Thu, Oct 28, 2004 at 05:21:52PM -0600, Mich
> Try a cast, or just use UNION ALL
Thanks.
Casting didn't work (it was missing the proper cast function
from xid to int4) but using UNION ALL worked. This was also
possible to use in my case since both parts of the UNION do
indeed return distinct sets of rows so UNION ALL does not
produce duplica
The number of dead tuples is the number of UPDATE statements you make.
You if you just do a straight UPDATE x set f1=x, f2=y, ... that will be
as optimal as you can get.
The only exception may be toasted fields, which would only apply if you
had fields with more than 2K of data or so...
Hope this
[EMAIL PROTECTED] writes:
>>Two: If a
>> single process in a multi-process application crashes, that process
>> alone dies. The buffer is flushed, and all the other child processes
>> continue happily along. In a multi-threaded environment, when one
>> thread dies, they all die.
>
> So this mean
[EMAIL PROTECTED] writes:
> Why is it that PostgreSQL chooses to have features like replication,
> fulltext indexing and GIS maintained by others outside of the sourcetree?
>
> I appreciate any answers.
Part of the answer is that "there are many answers."
As Jan Wieck will mention, there are mult
Sally Ruggero wrote:
I need advice on archiving data from our production database.
Each night I would like to save and remove a day's data from two weeks
ago, from all the tables. I know how to delete the data--though our
schema does not specify cascaded deletes. However, I can't figure out
ho
I need advice on archiving data from our production
database.
Each night I would like to save and remove
a day's data from two weeks ago, from all the tables. I know how to delete
the data--though our schema does not specify cascaded deletes. However, I can't
figure out how to save the d
I'm designing a system where I'll be making frequent updates to rows, but
some columns will change far less frequently than others. All columns will
be read with equal frequency, though probably by means of a materialized
view. Updates will happen via a stored proc.
Which makes the most sense?
Hi,
I'm trying to write a recordset-returning function that returns a
values from a base table, and one column from a joined table, where the
joined table varies according to a field of the base table. I'm looking
for an efficieint way to do this, and I don't think I know enough about
Postg
I was just wondering why the btrim syntax that takes only a single
argument is not documented in 9.4 in the documentation (I checked both
7.4 and 8.0 docs).
This is in a 7.4.5 installation:
pg=# \df btrim
List of functions
Result data type | Schema | Name | Argument d
On Fri, Oct 29, 2004 at 10:11:00AM -0600, Sídar LC wrote:
> exists in postgresql the way to store some tasks on server that can be
> executed on predefined schedule? how?
No; standard advice is to use the cron system. See the crontab manpage.
--
Alvaro Herrera ()
"La verdad no siempre es bonit
Correction: Four things that need to be done, THREE if you're not
serving up html. Sorry for the editing error.
- Mike
At 01:19 PM 10/29/2004, J. Michael Crawford wrote:
In my experience, there are just some characters that don't want to be
converted, even if they appear to be part
=?UTF-8?B?U8OtZGFyIExD?= <[EMAIL PROTECTED]> writes:
> exists in postgresql the way to store some tasks on server that can be
> executed on predefined schedule? how?
Most people use the standard Unix "cron" utility for this.
regards, tom lane
---(
On Fri, Oct 29, 2004 at 11:14:31 -0600,
Guy Fraser <[EMAIL PROTECTED]> wrote:
>
> 1 day should always be calculated as 24 hours, just as an hour
> is calculated as 60 minutes...
If you want 24 hours you can use 24 hours. Days are not constant length,
just like months aren't constant length.
>
In my experience, there are just some characters that don't want to be
converted, even if they appear to be part of the normal 8-bit character
system. We went to Unicode databases to hold our Latin1 characters because
of this. There was even a case where the client was cutting and pasting
a
Yes For example :
MST = GMT - 7 hours
MDT = GMT - 6 hours
The GMT time remains constant no mater if it is or is not
daylight savings time.
You still want to bill someone for 1 hour of usage from
02:00 MDT to 02:00 MST, but you don't want to bill an
hour from 02:00 MST to 03:00 MDT.
Unless you are u
Stuart Bishop <[EMAIL PROTECTED]> writes:
> If you add a 'day' to a timestamp, it should be identical to adding 24
> hours.
No, it should not --- at least not when the addition traverses a DST
switchover time.
> For example, what is '2am April 3rd 2004 US/Eastern + 1 day'? 2am on
> April 4th 2004
ERROR: could not convert UTF-8 character 0x00ef to ISO8859-1
Running 7.4.5, I frequently get this error, and ONLY on this particular
character despite seeing quite a bit of 8 bit. I don't really follow why
it can't be converted, it's the same character (239) in both character
sets. Databases are i
exists in postgresql the way to store some tasks on server that can be
executed on predefined schedule? how?
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
Hmm, I'm using another SMTP server now that actually informs me when it
is unable to deliver. Apparently it bounces intermittently with this
message:
Your message of Fri, 29 Oct 2004 17:08:35 +0200 entitled:
Re: [GENERAL] Question regarding the mailing list.
could not be delivered to the follow
Try a cast, or just use UNION ALL
On Fri, Oct 29, 2004 at 04:44:37PM +0200, Karsten Hilbert wrote:
> Dear all,
>
> some of my views are created with help of the UNION operator.
> Now, I also need to include the base table XMIN system column
> into those views. Which works fine (as long as I alias
Dear All,
I have a simple join query
SELECT c1 FROM t1
INNER JOIN
t2 ON t2.c2 = t1.c2 WHERE t3.c3= t2.c3;
Which gives the expected result but I get the message
NOTICE: adding missing FROM-clause entry for table "t3"
How do I get rid of this NOTICE, i.e. how should I construct my select
query.
Ma
Marc G. Fournier wrote:
I'm seeing all of your notes, and am not in the CC either ...
You see the posts that doesn't show up in the archives or on the
newsgroups ?!
If you do, you will see exactly 3 posts on the subject "Reasoning behind
process instead of thread based" that are addressed to Marco.
"M.A. Oude Kotte" <[EMAIL PROTECTED]> writes:
> When I try to execute "CREATE DATABASE somename" while connected to
> database template1 as a non-superuser with createdb-rights, I get the
> error message "source database "template1" is being accessed by other
> users". This is correct, as I'm co
On Fri, 29 Oct 2004, Thomas Hallgren wrote:
Marco,
I've seen something similar, but I know it's my fault. I've set a Role up
in Pine, that _should_ change the From: to the correct one. This list
accepts messages only from subscribed users, and, as you may have guessed,
the address I'm subscribed wi
Marco,
I've seen something similar, but I know it's my fault. I've set a Role up
in Pine, that _should_ change the From: to the correct one. This list
accepts messages only from subscribed users, and, as you may have
guessed,
the address I'm subscribed with is different from my main one.
The probl
On Fri, 29 Oct 2004, Thomas Hallgren wrote:
On several occations I have replied to mails originating from someone on the
pgsql-general list. I send the reply to:
To:
CC: [EMAIL PROTECTED]
The person in question receives the mail but it never shows up in the list
archive or in the newsgroup. Has
On several occations I have replied to mails originating from someone on
the pgsql-general list. I send the reply to:
To:
CC: [EMAIL PROTECTED]
The person in question receives the mail but it never shows up in the
list archive or in the newsgroup. Has anyone here had similar
experiences? What
Sorry for the noise. We resolved it:
On Fri, 29 Oct 2004 12:36:54 +0900
Joel <[EMAIL PROTECTED]> wrote
> ...
>
> We get the following error:
>
> > Auth_PG_grp_group_field takes one argument, the name of the group-name field.
>
> on the directive
>
> Auth_PG_grp_group_field rid
>
> The
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
> I would like all those on the same street grouped together. Is there any
> tricks to getting the street names sorted first, possibly where numbers
> and strings separate?
As some have demonstrated, this can be a difficult problem. Your best bet
> When I try to execute "CREATE DATABASE somename" while connected to
> database template1 as a non-superuser with createdb-rights, I get the
> error message "source database "template1" is being accessed by other
> users". This is correct, as I'm connected to the same server using
> pgAdmin II
Martijn,
thanks for your clarification.
> You need to look at it (XMIN) in conjunction with XMAX. A newly insert row has
> XMIN set and XMAX null. When a row is updated the XMAX of the old row
> is set and a new row is created with an XMIN. When you delete a row it
> just sets the XMAX.
But, as y
Hi All,
I'm unsure if this is the correct mailinglist for my question. I have a
problem with CREATE DATABASE, but as the docs state that officially this
is not an SQL statement, I was unsure if I should subscribe to pgsql-sql
or pgsql-general.
NOTE: I've searched on google, postgresql.org, FAQ'
On Fri, Oct 29, 2004 at 09:22:42AM +0200, Karsten Hilbert wrote:
> The docs say that XMIN is the transaction ID of the *inserting*
> transaction for this row version. IOW updates will change XMIN.
> Will XMIN also be changed by a *deleting* transaction ? I guess
> it depends on how deletion is hand
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Bruno Wolff III wrote:
| Recently there has been some discussion about attaching a timezone to
| a timestamp and some other discussion about including a 'day' part
| in the interval type. These two features impact each other, since
| if you add a 'day'
> > begin;
> > select ... for update;
> > update ... set ... where
> > my_pk=
> > AND
> > xmin=
>
> I think you can skip the SELECT FOR UPDATE altogether if you do it that
> way. Otherwise it looks fine.
Except that there will be other clients accessing those rows,
too, of
Hello,
i installed the new Beta. And first everything seams to work fine.
But sometimes I get this error Message:
(FATAL: terminating connection due to administrator command
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or w
Hello folks,
I have installed PgSQL8 beta4 via pginstaller to WinXP. I must tell
you I am more familiar with Linux, so maybe my problem is trivial to
solve:
I made myself a table with PgAdmin III (I was lazy to use psql) that
I tried to reach via ODBC. I created connection to my database,
51 matches
Mail list logo
