See my comments below.
On Thu, 2004-12-16 at 21:01, Greg Stark wrote:
> Csaba Nagy <[EMAIL PROTECTED]> writes:
>
> > The only advantage would be that an in-database solution would be OS
> > independent
>
> That kind of argument leads to monstrosities like Oracle that reimplement
> everything th
Am Freitag, 17. Dezember 2004 05:06 schrieb Greg Stark:
> However I do not see any Postgres 8.0 packages. It would have been nice
> since it would have increased the population testing the beta or RC
> releases quite a lot. However it takes time to prepare Debian packages for
> a new release especi
Am Freitag, 17. Dezember 2004 01:59 schrieb Michael Fuhr:
> > Initialize the database cluster with a locale setting other than "C".
>
> Hmmm...did I misunderstand something when I recommended using
> ORDER BY LOWER(person.lastname)?
Those are two different ways to achieve the same effect in this p
On 14 Dec 2004 at 9:27, Tom Lane wrote:
> See the article on techdocs.postgresql.org about rebuilding template1
> to find out about all the gotchas and workarounds needed to do this.
Found it - thanks!
--Ray.
-
Raymond O'Donnell
On Thu, 16 Dec 2004, Christopher Browne wrote:
A "cron implementation using PostgreSQL as data store" would have a
wonderfully natural place to record log information in a usefully
structured fashion.
When a job runs, it would be a splendid idea to record such things as:
- Job ID (perhaps an OID, o
On Friday 17 Dec 2004 3:20 pm, Marco Colombo wrote:
> Is the Oracle one _just_ that? A cron/at replacement? What about porting
> every UNIX utility to the DB engine (that would be a cross-platfrom Unix
> - wow)?
> Why don't they put web and application server functionality (apache and
> PHP) in the
--- Shridhar Daithankar <__> wrote:
> On Friday 17 Dec 2004 3:20 pm, Marco Colombo wrote:
> > Is the Oracle one _just_ that? A cron/at replacement? What about
> porting
> > every UNIX utility to the DB engine (that would be a cross-platfrom
> Unix
> > - wow)?
> > Why don't they put web and applic
Hi ALL!
I need to check before selection records from table - does this table
exist
How can i do that?
Thanx in advance
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
ON.KG wrote:
Hi ALL!
I need to check before selection records from table - does this table
exist
How can i do that?
You could:
1. Look in the INFORMATION_SCHEMA
2. Check pg_class
3. Examine the output of "psql -E", \d to see how psql gets its information.
--
Richard Huxton
Archonet Ltd
--- "ON.KG" <__> wrote:
> Hi ALL!
>
> I need to check before selection records from table - does this table
> exist
> How can i do that?
>
> Thanx in advance
>
>
> ---(end of
> broadcast)---
> TIP 1: subscribe and unsubscribe commands go to
> [E
I blew the parenthesis around the conditional expression also. Hence the
*old* comment.
(Embedded image moved to file: pic14771.jpg)
Bru
Sorry: I forgot to add something to option 2
--- "ON.KG" <__> wrote:
> Hi ALL!
>
> I need to check before selection records from table - does this table
> exist
> How can i do that?
>
> Thanx in advance
>
>
> ---(end of
> broadcast)---
> TIP 1:
Richard Huxton & Riccardo G. Facchini
Thank you very much!
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
This has considerable merit.
One thing that is unfortunate about cron is that it provides little
verifyable feedback. It logs some things, sort of...
A "cron implementation using PostgreSQL as data store" would have a
wonderfully natural place to record log information in a usefully
structured f
Hi
A few weeks ago, I reported that ANALYZE gives the error
"cannot compare arrays of different element types"
in one of my databases.
I now constructed a small testcase that is able to reproduce the problem:
---
-- The databa
I'm trying to make a trigger, fired by DELETE. The associated function
needs to know what rows were deleted in order to perform a DELETE in
another table as well. (Foreign keys are not acceptable.) I don't seem
to be able to find this kind of info being passed to the function. The
special vars don'
Ignore my previous question. The special variable OLD is defined
for DELETE fired triggers as well.
--
Ciprian Popovici
---(end of broadcast)---
TIP 8: explain analyze is your friend
Florian G. Pflug wrote:
A few weeks ago, I reported that ANALYZE gives the error
"cannot compare arrays of different element types"
in one of my databases.
I now constructed a small testcase that is able to reproduce the problem:
-
On Thu, Dec 16, 2004 at 23:33:00 -0500,
Greg Stark <[EMAIL PROTECTED]> wrote:
>
> Chris Smith <[EMAIL PROTECTED]> writes:
>
> > Would doing it this way require an index:
> >
> > create index lower_lastname on table x lower(lastname);
>
> Well it doesn't *require* but it may be a good idea. It
On Thu, 2004-12-16 at 19:10, Alex wrote:
> I actually am more interested to hear if there are an recommended
> systems or setups.
> Also with regard to 2/4 CPUs or 32/64 bit etc.
Sorry to have gotten off on a tangent there. Posts in the last year or
so to the -performance mailing list have show
Hello,
I am very new to postgresql and was excited to see that pl/perl was able
to do more in the newest version. So I created a database to learn some
of is feature. But when I try to to do:
createlang plperl test
I get:
createlang: language installation failed: ERROR: could no
Csaba Nagy <[EMAIL PROTECTED]> writes:
> Now, cron isn't exactly part of the OS, is it ?
Yes, it is.
--
greg
---(end of broadcast)---
TIP 8: explain analyze is your friend
Bruno Wolff III <[EMAIL PROTECTED]> writes:
> Using an index to do an order by is an order N operation.
No, using an index to do an order by is actually still n*log(n). You have to
traverse all the parent pages in the binary tree of the index as well.
This only goes to show how small the log(n
Bruno Wolff III <[EMAIL PROTECTED]> writes:
> Greg Stark <[EMAIL PROTECTED]> wrote:
>> where postgres won't bother with the index since it will be slower than just
>> resorting the entire table.
> Using an index to do an order by is an order N operation. Doing a sort
> is an order N log N operatio
unsubscribe pgsql-general
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
unsubscribe pgsql-general
On Fri, Dec 17, 2004 at 10:52:07AM -0600, Robert Boone wrote:
> Hello,
>
> I am very new to postgresql and was excited to see that pl/perl was able
> to do more in the newest version. So I created a database to learn some
> of is feature. But when I try to to do:
>
> createlang plperl tes
Greg Stark <[EMAIL PROTECTED]> writes:
> Bruno Wolff III <[EMAIL PROTECTED]> writes:
>> Using an index to do an order by is an order N operation.
> No, using an index to do an order by is actually still n*log(n). You have to
> traverse all the parent pages in the binary tree of the index as well.
unsubscribe pgsql-general
[EMAIL PROTECTED] (Marco Colombo) writes:
> On Thu, 16 Dec 2004, Christopher Browne wrote:
>> None of this means forcing it into the database implementation; it
>> just means that it would be useful. "pgcron" sounds like an
>> utterly splendid idea.
>
> Is the Oracle one _just_ that? A cron/at rep
At 12:14 PM 12/17/2004 -0500, Tom Lane wrote:
Bruno Wolff III <[EMAIL PROTECTED]> writes:
> Greg Stark <[EMAIL PROTECTED]> wrote:
>> where postgres won't bother with the index since it will be slower
than just
>> resorting the entire table.
> Using an index to do an order by is an order N operati
Tom Lane <[EMAIL PROTECTED]> writes:
> Greg Stark <[EMAIL PROTECTED]> writes:
> > Bruno Wolff III <[EMAIL PROTECTED]> writes:
> >> Using an index to do an order by is an order N operation.
>
> > No, using an index to do an order by is actually still n*log(n). You have to
> > traverse all the par
I *think* the 10.3.7 upgrade broke my postgresql implementation...
I am getting this error at startup.
FATAL: could not create shared memory segment: Cannot allocate memory
DETAIL: Failed system call was shmget(key=5432001, size=10403840,
03600).
HINT: This error usually means that PostgreSQL's
Greetings,
Are there any alternatives to vacuum (and, i'm aware of autovacuum)?
thanks,
Lonni
--
~
L. Friedman[EMAIL PROTECTED]
LlamaLand http://netllama.linux-sxs.org
-
On Fri, Dec 17, 2004 at 15:36:58 -0500,
Greg Stark <[EMAIL PROTECTED]> wrote:
>
> Isn't that still nlog(n)? In the end you're going to have read in every page
> of the index including all those non-leaf pages. Aren't there nlog(n) pages?
The depth of the tree is log N, but there are only N node
"Florian G. Pflug" <[EMAIL PROTECTED]> writes:
> A few weeks ago, I reported that ANALYZE gives the error
> "cannot compare arrays of different element types"
> in one of my databases.
> I now constructed a small testcase that is able to reproduce the problem:
Thanks for the example. It turns ou
On Fri, Dec 17, 2004 at 15:12:18 -0600,
Bruno Wolff III <[EMAIL PROTECTED]> wrote:
> On Fri, Dec 17, 2004 at 15:36:58 -0500,
> Greg Stark <[EMAIL PROTECTED]> wrote:
> >
> > Isn't that still nlog(n)? In the end you're going to have read in every page
> > of the index including all those non-lea
"Florian G. Pflug" <[EMAIL PROTECTED]> writes:
> Since postgres disallows empty array literals (array[] gives an syntax
> error), I guess creating empty array by removing the last element is
> quite hackish too... Will empty arrays be eventually supported, or will
> they be forbidden entirely (e.g,
Ok, I got postgres to start...
I used these settings.
kern.sysv.shmmax: 167772160
kern.sysv.shmmin: 1
kern.sysv.shmmni: 32
kern.sysv.shmseg: 8
kern.sysv.shmall: 65536
kern.sysv.semmni: 87381
kern.sysv.semmns: 87381
kern.sysv.semmnu: 87381
kern.sysv.semmsl: 87381
kern.sysv.semume: 10
On Dec 17, 2004
On Fri, Dec 17, 2004 at 12:50:42 -0800,
Lonni J Friedman <[EMAIL PROTECTED]> wrote:
> Greetings,
> Are there any alternatives to vacuum (and, i'm aware of autovacuum)?
What problem are you trying to solve?
---(end of broadcast)---
TIP 5: Have you
Bruno Wolff III <[EMAIL PROTECTED]> writes:
> Greg Stark <[EMAIL PROTECTED]> wrote:
>> Isn't that still nlog(n)? In the end you're going to have read in every page
>> of the index including all those non-leaf pages. Aren't there nlog(n) pages?
> The depth of the tree is log N, but there are only N
Lonni J Friedman <[EMAIL PROTECTED]> writes:
> Are there any alternatives to vacuum (and, i'm aware of autovacuum)?
CLUSTER is frequently a competitive alternative to VACUUM FULL.
In 8.0, there are some flavors of ALTER TABLE that rewrite the whole
table; this would work too, and should be faster
I'm running pg 7.4.6 on fedora core 2.
I'm trying to set unix_socket_directory for some clustering I'm trying
to accomplish, but get an error when I try to set it in postgresql.conf:
FATAL: syntax error in file "postgresql.conf" line 36, near token "/"
It goes away if I comment out the line, an
Scott Marlowe <[EMAIL PROTECTED]> writes:
> unix_socket_directory = /home/pgmaster/tmp
Not sure, but I think you need quotes:
unix_socket_directory = '/home/pgmaster/tmp'
regards, tom lane
---(end of broadcast)---
TIP 3: i
Hi.
I am thinking about building a login, where the logged in users are
stored in a table logins. To make it shure and documented the users have
entered a password I want to store the MD5(pw) in logins. To make it
impossible to fake logins entries I plan to store the MD5(MD5(pw)) in
the users tabl
Scott Marlowe wrote:
> unix_socket_directory = /home/pgmaster/tmp
> The directory I'm trying to use is world writable. Am I missing
> something simple here?
Yes, single quotes around the parameter value.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(
Scott Marlowe <[EMAIL PROTECTED]> writes:
>> Not sure, but I think you need quotes:
>> unix_socket_directory = '/home/pgmaster/tmp'
> Wow, that was way too simple.
> So, is there a reason some things in the postgresql.conf file need '
> marks around them and other things, like client_min_messages
On Fri, 2004-12-17 at 16:05, Tom Lane wrote:
> Scott Marlowe <[EMAIL PROTECTED]> writes:
> > unix_socket_directory = /home/pgmaster/tmp
>
> Not sure, but I think you need quotes:
> unix_socket_directory = '/home/pgmaster/tmp'
Wow, that was way too simple.
So, is there a reason some things in t
Joachim Zobel <[EMAIL PROTECTED]> writes:
> I am thinking about building a login, where the logged in users are
> stored in a table logins. To make it shure and documented the users have
> entered a password I want to store the MD5(pw) in logins. To make it
> impossible to fake logins entries I pla
ON.KG wrote:
> Hi ALL!
>
> I need to check before selection records from table - does this table
> exist How can i do that?
One thing to consider: you are making a trip to the database to
determine if a table exists. If it exists, you are then making another
trip to the database to get rows fro
Jerry LeVan <[EMAIL PROTECTED]> writes:
> Ok, I got postgres to start...
> I used these settings.
FWIW, I just updated to 10.3.7 from 10.3.6 and compared the kern.sysv.*
sysctl settings before and after. I see no indication that the default
values have changed.
regards, t
On Fri, 2004-12-17 at 16:18, Tom Lane wrote:
> Scott Marlowe <[EMAIL PROTECTED]> writes:
> >> Not sure, but I think you need quotes:
> >> unix_socket_directory = '/home/pgmaster/tmp'
>
> > Wow, that was way too simple.
>
> > So, is there a reason some things in the postgresql.conf file need '
> >
Here is a real world example where a scheduler in PostgreSQL would be
helpful. We collect usage statistics from our network throughout the
day (raw stats.) After midnight, we roll up those raw stats into daily
statistics.
We have a very large amount of data, about 2 million rows a day a
growing
Well, what might be some good settings for a smallish db with
the default configuration?
Jerry
On Dec 17, 2004, at 5:40 PM, Tom Lane wrote:
Jerry LeVan <[EMAIL PROTECTED]> writes:
Ok, I got postgres to start...
I used these settings.
FWIW, I just updated to 10.3.7 from 10.3.6 and compared the kern.
I have many such tasks. Depending on implementation, it has the potential
to be a TINY amount of less work to schedule such tasks from inside
the database, but it takes all of about a minute to schedule it through
cron. Including the amount of time it takes to refer to the man page.
Additionally,
Hi,
Tom answered a question from me and when I attemped to reply
I got the following stuff...
(I am running MacOSX with a postfix (output server). Most of
the time after I get a complaint about non delivery I tell
postfix to use my providers (Adelphia ) mail agent. This does
not work for Mr Lanes m
I'm getting the same error now too, although postgres was running
without problem this morning (I updated the OS yesterday). OS X 10.3.7
Server, PostgreSQL 8.0RC1. Basically, I did a pg_dump, stopped the
server and then tried to start it again.
Any ideas?
On Dec 17, 2004, at 2:41 PM, Jerry Le
In the last exciting episode, [EMAIL PROTECTED] ("Guy Rouillier") wrote:
> Here is a real world example where a scheduler in PostgreSQL would be
> helpful. We collect usage statistics from our network throughout the
> day (raw stats.) After midnight, we roll up those raw stats into daily
> statis
On Fri, 17 Dec 2004 15:28:30 -0600, Bruno Wolff III <[EMAIL PROTECTED]> wrote:
> On Fri, Dec 17, 2004 at 12:50:42 -0800,
> Lonni J Friedman <[EMAIL PROTECTED]> wrote:
> > Greetings,
> > Are there any alternatives to vacuum (and, i'm aware of autovacuum)?
>
> What problem are you trying to solve?
Scott Marlowe wrote:
> On Fri, 2004-12-17 at 16:18, Tom Lane wrote:
> > Scott Marlowe <[EMAIL PROTECTED]> writes:
> > >> Not sure, but I think you need quotes:
> > >> unix_socket_directory = '/home/pgmaster/tmp'
> >
> > > Wow, that was way too simple.
> >
> > > So, is there a reason some things i
On Fri, Dec 17, 2004 at 18:53:42 -0800,
Lonni J Friedman <[EMAIL PROTECTED]> wrote:
> On Fri, 17 Dec 2004 15:28:30 -0600, Bruno Wolff III <[EMAIL PROTECTED]> wrote:
> > On Fri, Dec 17, 2004 at 12:50:42 -0800,
> > Lonni J Friedman <[EMAIL PROTECTED]> wrote:
> > > Greetings,
> > > Are there any a
On Fri, Dec 17, 2004 at 18:29:10 -0500,
Jerry LeVan <[EMAIL PROTECTED]> wrote:
> Hi,
>
> Tom answered a question from me and when I attemped to reply
> I got the following stuff...
>
> (I am running MacOSX with a postfix (output server). Most of
> the time after I get a complaint about non deli
Adelphia is not a small isp, it seems strange that
all of Adelphia would be blocked...
Jerry
On Dec 17, 2004, at 11:49 PM, Bruno Wolff III wrote:
On Fri, Dec 17, 2004 at 18:29:10 -0500,
Jerry LeVan <[EMAIL PROTECTED]> wrote:
Hi,
Tom answered a question from me and when I attemped to reply
I got t
Jerry LeVan <[EMAIL PROTECTED]> writes:
> Is Tom's mail address output only?
No, but my spam filters have been described as possessing fangs ;-)
After review of my mail logs I've unblocked your adelphia.net IP range;
it looks like the spam flux from there has subsided.
re
On Fri, Dec 17, 2004 at 23:46:46 -0500,
Jerry LeVan <[EMAIL PROTECTED]> wrote:
> Adelphia is not a small isp, it seems strange that
> all of Adelphia would be blocked...
I get crap from them. I had them mostly blocked for a while, but had to
whitelist them because I need to get email from someon
Timothy Perrigo <[EMAIL PROTECTED]> writes:
> I'm getting the same error now too, although postgres was running
> without problem this morning (I updated the OS yesterday). OS X 10.3.7
> Server, PostgreSQL 8.0RC1. Basically, I did a pg_dump, stopped the
> server and then tried to start it agai
Lonni J Friedman <[EMAIL PROTECTED]> writes:
> I'd like to be able to run vacuum in a 'test' or read-only mode where
> i'd see what it would do before actually running it.
Er ... what possible value would that have? ISTM it would expend 80% of
the effort to achieve 0% of the result.
> We have a very large amount of data, about 2 million rows a day a
> growing, so I want this whole operation done on the database server.
> It's all database work, just summing up data from one table and
> putting the result in another table. We have all that logic in a
> stored procedure. So wh
http://www.newsforge.com/pollBooth.pl?qid=54§ion=mainpage&aid=4
Marcelo
Cid
Analista de Sistemas
PRODAM/DIDET/DAA/VEA5080-9227
Hello PGSQL community members,
I am trying to gauge the level of interest of people who wish to be
involved in the planning and staffing of a community booth at Linux
World Expo Boston. For this to come together we will need volunteers to
man the booth, and persons to do setup and tear down, as
Well, here is the simple solution to my problem:
Turn the firewall down
The firewall was doing what it was supposed to do
Thanks for all your help.
NK
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Nadia Kunkov
Sent: Tuesday, December 14, 2004 4:55
Hi,
I just started looking into PostgreSQL (coming from Mysql before), but have
a question:
Is it possible to have a sequence (as a multirow prim key), where sequence
(id) only increase per group of data (grp).
E.g.
+++-+
| grp| id | name|
+++-+
|
Hi all. I'm getting the following error message when I try to update
a row in a table:
ERROR: 54000: index row size 2720 exceeds btree maximum, 2713
Does anyone know how to to change the btree maximum row size? How did
it come up with 2713 as a max row size?
Thanks.
-Ernie
-
Tom Lane <[EMAIL PROTECTED]> writes:
> Lonni J Friedman <[EMAIL PROTECTED]> writes:
>
> > I'd like to be able to run vacuum in a 'test' or read-only mode where
> > i'd see what it would do before actually running it.
>
> Er ... what possible value would that have? ISTM it would expend 80% of
> t
"Guy Rouillier" <[EMAIL PROTECTED]> writes:
> So why do I need to set up a cron job and a shell script whose only task is
> to connect to the database and start up the stored procedure? Wouldn't it be
> much simpler just to have a schedule in PostgreSQL that says "at 12:01, run
> this stored proc
75 matches
Mail list logo
