On Tue, 2007-06-05 at 16:51 -0400, Andrew Sullivan wrote:
> On Tue, Jun 05, 2007 at 07:29:02PM +0100, Peter Childs wrote:
> > Unfortunately you still need to store them somewhere, and all systems can
> > be hacked.
>
> Yes. I agree, in principle, that "don't store them" is the best
> advice --
riate
> subscribe-nomail command to [EMAIL PROTECTED] so that your
>message can get through to the mailing list cleanly
>
--
Guy Fraser
Network Administrator
The Internet Centre
1-888-450-6787
(780)450-6787
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
On Tue, 2007-08-07 at 17:46 -0500, Decibel! wrote:
> On Sun, Aug 05, 2007 at 08:18:08PM +0530, Merlin Moncure wrote:
> > On 8/3/07, Guy Fraser <[EMAIL PROTECTED]> wrote:
> > > On Wed, 2007-08-01 at 07:14 +0530, Merlin Moncure wrote:
> > > > On 8/1/07
On Thu, 2007-10-25 at 08:57 -0600, Josh Tolley wrote:
> On 10/24/07, Bob Pawley <[EMAIL PROTECTED]> wrote:
> > Is there any way of converting text from an AutoCad (.dwg ot .dxf) file into
> > a PostgreSQL Database??
> >
> > Bob Pawley
>
> I know nothing of AutoCad, but your message has been sitti
One of my associates swears SMARTY is the best thing since sliced
bread. I think it uses PHP an PEAR, but is more abstract. I looked
at it and it did some cool things with only a few lines of code.
Being an old dog, I have built many different "libraries" in C
and PHP and prefer to use them. Th
On Sun, 2005-03-07 at 23:14 +0300, Andrus Moor wrote:
> > Does the application really need superuser privileges or is that
> > just a convenience? It's usually a good idea to follow the "Principle
> > of Least Privilege" -- do some searches on that phrase to learn
> > more about it and the rationa
On Thu, 2005-07-07 at 08:30 +0100, Richard Huxton wrote:
> Ben-Nes Yonatan wrote:
> > Richard Huxton wrote:
> >
> >>> Can anyone tell me if Pl/PgSQL can support a multi dimensional array
> >>> (of up to 5 levels top I guess) with about 100,000 values?
> >>> and does it stress the system too much?
On Tue, 2005-30-08 at 21:00 -0700, Chris Travers wrote:
> Antimon wrote:
>
> >Hi,
> >I'm working on a new web project based on php and i decided to use
> >PostgreSQL 8.x as
> >dbms. For triggers, views, stored procedures etc. I was going to write
> >a simple wrapper class and use pg_* functions. B
On Wed, 2005-21-09 at 07:48 -0700, Tony Wasson wrote:
> On 9/20/05, Matthew Peter <[EMAIL PROTECTED]> wrote:
> > Wondering if there's a way for postgres to return how
> > many elements are in a array as a single integer? For
> > instance, returning 10 (items in array) instead of
> > [-5:4]
> >
> >
On Thu, 2005-22-09 at 12:43 -0400, Greg Stark wrote:
> Guy Fraser <[EMAIL PROTECTED]> writes:
>
> > So to answer his question he would likely want :
> >
> > SELECT
> > array_upper(item,1) - array_upper(item,0) + 1 as elements
> > FROM
> > arrayt
On Thu, 2005-22-09 at 21:52 -0500, Bruno Wolff III wrote:
> On Thu, Sep 22, 2005 at 14:16:48 -0600,
> Guy Fraser <[EMAIL PROTECTED]> wrote:
> > On Thu, 2005-22-09 at 12:43 -0400, Greg Stark wrote:
> > > Guy Fraser <[EMAIL PROTECTED]> writes:
> > >
On Fri, 2005-23-09 at 09:48 -0700, Matthew Peter wrote:
>
> --- Guy Fraser <[EMAIL PROTECTED]> wrote:
>
...snip...
> > OK what I jotted down was totally wrong.
> >
> > This is slightly more correct :
> >
> > SELECT
> > array_upper(item,1)
On Thu, 2005-06-10 at 16:14 +0100, Richard Huxton wrote:
> Bart van den Eijnden wrote:
> > Hi list,
> >
> > I am trying to transfer the following from MySQL to PostgreSQL:
> >
> > load data local
> > infile 'D:/tmp/InterAcces- MySQL/03102005/bedrijven.txt'
> > into table bedrijven
> > fields ter
On Thu, 2007-01-18 at 17:48 -0800, Richard Troy wrote:
> On Thu, 18 Jan 2007, Joshua D. Drake wrote:
> > >
> > > Spam is spam. I don't care what they're selling. Anyone dumb enough to
> > > send spam in 2006 should be fired on the spot.
> >
> > That is a bit extreme. One persons SPAM is another p
ales
are in any way less competent than white males, but by removing
them from the pool does not make things better. The biggest
problem with quotas is not hiring less qualified staff, it is
that less qualified staff know why they were hired and know that
they are very unlikely to be fired
party has no education nor experience and the latter have earned
> > doctorates and decades of experience), but no one has said anything
> > about such people being employed on the projects to which I referred.
> > But this is an aspect of our present society that is bound
On Sat, 2007-03-10 at 08:07 -0300, Jorge Godoy wrote:
> omar <[EMAIL PROTECTED]> writes:
>
> > I'm curious what people think about the following statement considering the
> > database typing talk being brought up here. My experience is that more
> > times
> > than not I have to put data validati
be used, for
> the purpose of: (A) avoiding penalties that may be imposed under the
> Internal Revenue Code; nor (B) promoting, marketing or recommending to
> another party any transaction or matter addressed herein.
> ***
>
> ---(end of broadcast)------
On Wed, 2007-03-14 at 12:12 -0400, Tom Lane wrote:
> Jaime Silvela <[EMAIL PROTECTED]> writes:
> > ... before doing that I'd like to find out what's the
> > problem with the DST not taking.
>
> > The timezone is 'EST5EDT', and
>
> Is it really 'EST5EDT', or 'est5edt' ? 8.1 is case sensitive abo
eric I mean)
Please correct me if I am wrong..
Shridhar
--
Guy Fraser
Network Administrator
The Internet Centre
780-450-6787 , 1-888-450-6787
There is a fine line between genius and lunacy, fear not, walk the
line with pride. Not all things will end up as you wanted, but you
will certainly disc
idea to
store usage in days:hours:minutes:seconds because they are static
and stable, if you discount the deceleration of the earth and
corrections in leap seconds for atomic clocks [see
http://tycho.usno.navy.mil/leapsec.html ].
Trivia: In approximately 620 million years a day will be twice a
day every 4000 years. ;-)
--
Guy Fraser
Network Administrator
The Internet Centre
780-450-6787 , 1-888-450-6787
There is a fine line between genius and lunacy, fear not, walk the
line with pride. Not all things will end up as you wanted, but you
will certainly discover things the meek and t
Gaetano Mendola wrote:
Guy Fraser wrote:
Trivia: In approximately 620 million years a day will be twice as
long as it is today.
Do you think then that Postgres628M.0 will fix it ? :-)
Regards
Gaetano Mendola
I just hope, I don't have to work an equivalent fraction of the day for the
sam
-
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
.
--
Guy Fraser
Network Administrator
The Internet Centre
780-450-6787 , 1-888-450-6787
There is a fine line between genius and lunacy,
> > 3,"The quick brown fox"
> >
> > \.
> >
> > --END EXAMPLE
> >
> >
> >
> > The above example produces this output:
> >
> >
> >
> > CREATE TABLE
> >
> > psql:test2.sql:8: ERROR: unterminated CSV quoted
Have you considered dumping the data, dropping the table and
building the replacement table with the correct properties
then repopulating the table with the dumped data?
On Thu, 2006-05-01 at 23:02 -0800, Daniel Kunkel wrote:
> Why do I want to include 6 fields in the primary key?
>
> Good que
On Tue, 2006-14-03 at 07:45 -0500, Andrew Rawnsley wrote:
> One doesn't 'install' oracle. That implies you have control of the
> situation. One attempts to convince it to condescend to install itself onto
> your machine.
>
> Of course, this is like convincing my 3 year old to go to bed on time.
On Thu, 2006-16-03 at 13:51 -0500, Robert Treat wrote:
> On Wednesday 15 March 2006 18:14, Alen Garia - IT wrote:
> > Hi,
> >
> > We are currently planning the deployment of our next generation
> > enterprise database and we are wondering whether or not PostgreSQL could do
> > the heavy lifting t
On Thu, 2006-16-03 at 19:05 -0500, Robert Treat wrote:
> On Thursday 16 March 2006 14:46, Joshua D. Drake wrote:
> > Tony Caduto wrote:
> > > I have two Postgresql 8.1 servers each one is in a DMZ and each one
> > > has a apache server running on it.
> > > What I want to do is have real time 2 way
On Wed, 2006-22-03 at 11:34 -0800, Benjamin Smith wrote:
> On Wednesday 22 March 2006 03:06, Jimbo1 wrote:
> > Hello there,
> >
> > I'm a freelance Oracle Developer by trade (can almost hear the boos now
> > ;o)), and am looking into developing my own Snowboarding-related
> > website over the next
On Fri, 2006-24-03 at 14:53 -0600, Scott Marlowe wrote:
...snip...
> Only my most recent personal experience, when I was explaining to the
> guy from MySQL how frustrating it was that installing MySQL broke my
> build of PHP and meant I had to use the mysqli libs, not the mysql
> ones. The answer
On Sat, 2006-25-03 at 10:11 -0800, Chris Travers wrote:
> Leif Jensen wrote:
>
> > Hello,
> >
> > I have with great interrest been following this thread. We have a
> >(small) flame war in house about this and I'm very happy about all the
> >arguments I have seen. I'm a long time user of Postgre
On Wed, 2006-05-04 at 22:29 +0100, Simon Riggs wrote:
> On Wed, 2006-04-05 at 15:42 -0400, Bob Powell wrote:
>
> > I have a systems admin that is backing up our Linux computers
> > (postgres) by backing up the directory structure. This of course
> > includes all the files that pertain to my post
On Thu, 2006-06-04 at 15:21 -0400, Douglas McNaught wrote:
> Guy Fraser <[EMAIL PROTECTED]> writes:
>
> > How do you suggest one does PITR ?
> >
> > It has been a while since I read the Docs, but do not recall
> > any tools that allow one to do such a thing.
It does not get mail for a long time. ;^)
It also can not establish a connection to the listener.
If you are on the same machine as the db, you could check
to see if the process is running. You could also setup
an inetd listener that indicates the status of the
postmaster. I have not done that
On Mon, 2006-26-06 at 11:08 -0500, Scott Marlowe wrote:
> On Mon, 2006-06-26 at 08:59, Tony Caduto wrote:
> > MG wrote:
> > > Hello,
> > >
> > > we are using PostgreSQL 8.0.3 together with RAID on OpenServer 6.
> > >
> > > When we do a big SELECT-query the whole maschine becomes very very
> >
On Fri, 2006-07-07 at 22:41 +, [EMAIL PROTECTED] wrote:
> > [mailto:[EMAIL PROTECTED] On Behalf Of Adrian Klaver
> >
> > I guess the solution depends on what is a 'large amount of data'. The
> > most time consuming part is going to be converting the single data
> > elements at the top of eac
On Mon, 2006-10-07 at 10:33 -0700, Karen Hill wrote:
> Hello,
>
> How would one go about creating a US telephone type in the format of
> "(555)-555-" ? I am at a loss on how it could be accomplished in
> the most correct way possible while not going into the various
> different country styles
On Thu, 2006-13-07 at 06:52 -0700, Adrian Klaver wrote:
> Dates don't transfer correctly. When I try it the date moves two days ahead.
Thanks for the heads up, I will continue to avoid using
Open Office for Spreadsheet and DB activities. I
prefer Gnumeric for Spreadsheet activities, and am very
Baldur Norddahl wrote:
Quoting Martijn van Oosterhout <[EMAIL PROTECTED]>:
...
You could create a new operator, but that means you'll have difficulty
moving it to any database that doesn't have that operator (which is most of
them).
Any commercial database vendor would be happy to make such
CSN wrote:
Is there much difference between using subqueries and
separating out them into separate queries?
That would depend on what results your expecting, and how you intend on using the results.
For example if you want all the data in a single statement, you can't break it up, but
the req
ter (Jakarta or whatever).
---(end of
broadcast)---
TIP 8: explain analyze is your friend
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresq
But for a web app in a fast enviroment like AOLserver, it is
unlikely you will see any performance difference, there are too many
factors influencing that and your actual code on the page is a tiny
fraction. (database access being the worst offender)
...snip...
--
Java {Not that MS cruft, but real Sun Java} then
anything woth a Java VM would work. I could then write the server in
what ever I wanted {probably C}.
This is way off the topic, though. The question was about PHP and JSP not
gtk client/server application efficiencies.
--
Guy F
Christopher Browne wrote:
Centuries ago, Nostradamus foresaw when [EMAIL PROTECTED] (Clodoaldo Pinto Neto) would write:
How to make sure COPY TO writes the table lines to the file in the same order
they were inserted?
You probably want to rewrite PostgreSQL then.
I'm producing html pag
Dann Corbit wrote:
A following VACCUM brings back return times to 'start' -
but I cannot
run VACUUM any other minute (?). And it exactly vaccums as
many tuples
as I updated.. sure thing:
Why not? You only have to vacuum this one table. Vacuuming it
once a minute
Philipp Buehler wrote:
On 22/04/2004, Guy Fraser <[EMAIL PROTECTED]> wrote To [EMAIL PROTECTED]:
Shouldn't the Database server be the entity that decides when vacuum is
needed?
How is the database supposed to know when you want to purge records?
Once a vacuum has been run, th
If you are using php, the two functions below should help.
http://ca.php.net/manual/en/function.pg-escape-bytea.php
http://ca.php.net/manual/en/function.pg-unescape-bytea.php
Taber, Mark wrote:
We’re implementing our first PostgreSQL database, and enjoying it very
much. However, we have a table th
AIL: System catalog modifications are currently disallowed.
How can i change this permissions?
--
Guy Fraser
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
Maybe try something like this :
SELECT
task_id,
CASE
WHEN task_count = '0'
THEN '0'::int4
ELSE (task_duration *
task_duration_type /
task_count) as hours_allocated
END
FROM
(SELECT
task_id,
task_duration,
task_duration_type,
count(user_tasks.task_id) as task_count
FRO
self sufficient people and organizations. If you
like throwing money around donate it to PostgreSQL and or go
out and pay a fair bit for RedHat Database, which is just Linux
and PostgreSQL which have been optimized for each other and are
supported by a single vendor {not enough to convince me}.
Guy F
t diamond logo, let me know if this is a bad idea !
>
> Regards,
>
> Gilles Darold
>
> ---(end of broadcast)---
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
Hi
So far so good.
Guy
Lee Harr wrote:
>
> On 24 Aug 2001 05:43:37 -0700, Christoph <[EMAIL PROTECTED]> wrote:
> > Working with oracle I used the command
> > @/home/lange/textfile.sql
> > to run scripts. Does anyone happen to know how this works with postgres?
> >
>
> In psql, you could use:
>
> \i /home/lange/textfi
Hi
I had to "rpm --rebuild postgresql-7.1.3-1PGDG.src.rpm" on a RedHat 6.2
machine.
After I rebuilt the software I attempted to install all the compiled
packages but got the error message :
error: failed dependencies:
mx is needed by postgresql-python-7.1.3-1PGDG
This "/root/.cpan/buil
Sorry if I insulted the wrong people.
Like I said in the message, "The odd comparison is OK" was poorly
stated, I was tired of having to go through all the posts from people
who appear to be close to anti PostgreSQL. I was trying to indicate that
suggesting feature enhancements that are SQL92 and
ing tables determined from the data
being imported.
I wrote this software a long time ago and have spent little time
patching or rewriting. Since the script was initially written, I now
know some better ways of performing some of these tasks. I don't have
time to rewrite the script and it has
66179
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
--
Guy Fraser
Network Administrator
The Internet Centre
780-450-6787 , 1-888-450-6787
There is a fine line between genius and lunacy,
Running mozilla on linux and having my mail processed by postini,
_http://www.postini.com_, I haven't had any problems other that lots of
quarantined mail at postini. Having the mail quarantined off site saves
bandwith as well.
I work at an ISP and we use postini for all email that ends up on o
Thanks that is extremely helpfull.
Guy
Jonathan Bartlett wrote:
What is the size limit of bytea, I thought it was 8K?
No limit that I've found. Some are several meg.
How do you dump your database when you have bytea, do you need to do a
binary dump?
Nope. pg_dump automagicall
s/faqs/FAQ.html
--
Guy Fraser
Network Administrator
The Internet Centre
780-450-6787 , 1-888-450-6787
There is a fine line between genius and lunacy, fear not, walk the
line with pride. Not all things will end up as you wanted, but you
will certainly discover things the meek and timid w
autotest-# \g
coords
(0 rows)
Any ideas?
Thanks,
Dennis
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
--
Guy Fraser
Network Administrator
The Internet Centre
780-450-6787 , 1-888-450-6787
The
Hi
I have been using this method for over a year now.
NOTE: Beware of "\" (escape) characters.
If you have to use them, they must be changed to "\\".
This is a sample of something similar to what I do:
/bin/cat tab-delimited.txt | /usr/bin/psql -c "copy table1 from stdin;"
database1
quot;Time-Used";
} else {
insert into details "User-Name","Realm","Time-Used";
}
I have not seen any documentation specifying what pragmatic operators
are available if any.
Thank You In Advance
Guy Fraser
mailto:[EMAIL PROTECTED]
63 matches
Mail list logo
