A few days ago there was a thread dealing with how a 'week' breaks.
I just had a need to run a transaction total by week and I wanted
a Sunday-Saturday week, not a Monday-Sunday week which is what the
date_trunc function gives.
Here was my solution:
select (date_trunc('week',mtrantime + interva
On Thu, Sep 08, 2005 at 10:02:44AM -0700, Ben Hallert wrote:
> With this in mind, I want to write a query that will list the entries
> in the first table (easy) along with a count() of how many entries in
> the other table start with that path (the hard part).
[...]
> I tried handling this progra
I would like to change to C because it will give us better performance. As it is per-cluster I would have to initib again but what will happen when the dump will be reloaded?
Some characters that we have today in the SQL_ASCII database probably can not be loaded in a LATIN1 database. Am I right
On Sat, Sep 10, 2005 at 10:27:13AM -0700, Matthew Peter wrote:
> ah I swear I never came across any of these
> gems of information in the docs. It was these subtle
> differences that were throwing me.
>From "Regular Expression Escapes" in the "Pattern Matching" section
of the manual:
A
Hrm, I must be missing something, because I don't see how this will
transliterate to ASCII?
On Sep 10, 2005, at 5:30 AM, Mike Rylander wrote:
On 9/9/05, Ben <[EMAIL PROTECTED]> wrote:
I'm working on a problem that I imagine others have had, which
basically
boils down to having nice unicode
Joshua D. Drake wrote:
on another note it seems that the only version of pg_restore.exe that
will accept a password from the command line is 8.0.0.
All later versions prompt for the password, but fail every single
time. The only way to restore a file on anything above 8.0.0
(pg_restore) i
Brian Hirt <[EMAIL PROTECTED]> writes:
> I'm a bit baffled by this, i can't drop a table and I'm getting the
> most bizarre message that doesn't make sense to me. To make things
> worse, I was able to drop it on my test database which is a dump of
> my production database running the same ve
Do you know a postgis / postgres data provider to have acces to
postgres shapefile from any GIS software by only configure driver /data
provider. jump and qgis give access to map and table . pgadmin give acces to
table . Is there a more generalist appllication ( driver ) that
support layout r
on another note it seems that the only version of pg_restore.exe that
will accept a password from the command line is 8.0.0.
All later versions prompt for the password, but fail every single
time. The only way to restore a file on anything above 8.0.0
(pg_restore) is to have the pg_hba.conf
I'm a bit baffled by this, i can't drop a table and I'm getting the
most bizarre message that doesn't make sense to me. To make things
worse, I was able to drop it on my test database which is a dump of
my production database running the same version of postgresql.
The index it's complainin
Am Freitag, den 09.09.2005, 12:56 -0400 schrieb Ryan Griggs:
> I desire to develop an XML-based web application which interfaces with
> a backend PostgreSQL database.
>
> Is there any way to instruct the SELECT statements to return results
> as XML rather than a dataset? Microsoft SQL Server uses
Just as a FYI, having trust in the pg_hba.conf file on win32 is normally
not needed for PGLA to backup a database, I have been unable to
reproduce the error Michael experienced while running on XP sp 2, the
only thing I can think of was the version of pg_dump.exe I was shipping
was corrupted or
Hi there,
I've got a database query that sounded easy at first, but I'm having a
hard time wrapping my head around how to get it to work.
Here's the situation. I have a table that lists about 20-30 server
paths. A program goes through and uses another tool to generate
information (as contents c
> On Fri, 2005-09-09 at 18:54, Jim C. Nasby wrote:
> > On Fri, Sep 09, 2005 at 06:20:21PM -0500, Scott Marlowe wrote:
> > > > pgpool is a connection pool; it has (almost) nothing to do with
> > > > replication. It certainly doesn't work to provide any kind of data
> > > > security on a RAID0 setup.
After several years away from Postgres, I'm back to using it for a small
project.
I installed 7.4.8 on a FreeBSD 5.4-STABLE machine. Then I init'd the db and
added myself as a user, then created a ned db for the prohect. I can
connect fine with psql.
Then I built pgaccess, and p5-DBD-Pg-13 from
I desire to develop an XML-based web
application which interfaces with a backend PostgreSQL database.
Is there any way to instruct the SELECT
statements to return results as XML rather than a dataset? Microsoft SQL Server uses the “for xml
auto” option to return XML results.
Thank you
I'm sharing with 5 other small businesses a dedicated server with 60GB
hard drive, 700GB monthly bandwidth on a 10Mbps link for $49/month.
Where is this available?
Not quite that package and I've never used them (thinking about it), but
layeredtech.com has this as their cheapest:
. Intel Ce
"Michael Schmidt" <[EMAIL PROTECTED]> writes:
> Regarding Chilli Source Database Design Studio, I downloaded a trial =
> copy and when I tried to "reverse engineer" my PostgreSQL database, got =
> an error that pg_relcheck doesn't exist. Since pg_relcheck isn't used =
> in PostgreSQL 8.0, perhaps
In an earlier post, I mentioned that PG Lightning Admin seemed to hang when
I did a dump. Mr. Caduto provided some help with this and the problem was
resolved by setting my connection to "trust" in hba.conf.
Regarding Chilli Source Database Design Studio, I downloaded a trial copy
and wh
ah I swear I never came across any of these
gems of information in the docs. It was these subtle
differences that were throwing me.
I didn't originally catch that regex's were based on
grep/sed/awk syntax which I haven't studied throughly
yet. I've only used some basic operations in bash
> I'm sharing with 5 other small businesses a dedicated server with 60GB
> hard drive, 700GB monthly bandwidth on a 10Mbps link for $49/month.
Where is this available?
The web host that I do programming for pays around $120 a month for a
Debian machine with an AMD Athlon 2200 Processor, 1GB Memo
This seems penny wise and pound foolish. The cost of the remote hosting is
going to be swamped by whatever you are paying somneone to keep an eye on it.
The savings for sharing the host, aren't going to make up for any hassels
involved in sharing the host.
That depends, if they went with a M
Janning Vygen <[EMAIL PROTECTED]> writes:
> i guess the table was dropped but not the corresponding type.
> How can things like this happen?
Corrupted pg_depend table maybe? You might try REINDEXing pg_depend
to be on the safe side. Also please look to see if there are any
relevant entries in i
On Fri, Sep 09, 2005 at 10:11:46PM -0700, Matthew Peter wrote:
> One other thing, when I wrote back I actually used
> 34.31.29.20 (random), not 12.00.00.34 like i showed in
> the example, which is why i said it didn't work on
> digits.
When posting examples, please post something you actually trie
On 9/9/05, Ben <[EMAIL PROTECTED]> wrote:
> I'm working on a problem that I imagine others have had, which basically
> boils down to having nice unicode display text that users are going to
> want to search against without typing it correctly e.g. let a search
> for "sma" match "små". It seems
Matthew Peter <[EMAIL PROTECTED]> writes:
> One other thing, when I wrote back I actually used
> 34.31.29.20 (random), not 12.00.00.34 like i showed in
> the example, which is why i said it didn't work on
> digits.
>
> SELECT substring('34.31.29.20' FROM $$((\w+)\.\2)$$);
> substring
> ---
On Fri, Sep 09, 2005 at 16:21:42 -0700,
Ron Mayer <[EMAIL PROTECTED]> wrote:
> Various people wrote:
> >>>...PostgreSQL...crontab support...pl/pgsql
>
> I've found that with if you can get 5 companies/users to share a
> dedicated server you can be much better off than a hosting plan,
> and hav
On Sat, Sep 10, 2005 at 09:37:32AM +, Henrique Friedrichs wrote:
> I´m worried about our cluster locale and database enconding setting.
> They´re pt_BR and SQL_ASCII respectively. I would like to change them
> to C and LATIN1 but I don´t know what might the side effects of that
> be?
You can't
Hello,
I´m looking for information about "locale" and character set encoding. I searched the mailing lists and found many, many information, mainly issues about performance.
I´m worried about our cluster locale and database enconding setting. They´re pt_BR and SQL_ASCII respectively. I would li
Hi,
i run postgresql 8.0.3 and i have a script which calls a postgresql function
to calculate a materialized View. this function creates a temp table. It does
so with EXECUTE statments to avoid the caching of plans with temporary
tables. It runs on three servers and evrything went fine for a co
30 matches
Mail list logo
