Andrew B. Lundgren wrote:
For the moment, I have the inserter set to close its connection and
re-establish it after a block of inserts. This is not really ideal
either as the new schema creation happens only once a day and the
batches complete in about 1-2 seconds.
Is there a way to cause the
Dear psqlers,
I need your help!
I administer/develop an open source PHP accounting software project (webERP)
that was originally mysql only. Since Christmas I and another member of the
team lower cased all the sql and changed some elements of the SQL to allow it
to use postgres as well. All
OK.understand.
I'll exclude relkind IN( 's' , 'c' ) file in backup set.
THANKS Qingqing Zhou tom lane!
Tom Lane wrote:
Qingqing Zhou [EMAIL PROTECTED] writes:
Pg_xactlock is always there as a special relation.
pg_xactlock isn't really a relation. The way I think about it is that
it's
After a few days of working on the problem I can state that - IMHO - this is
the best way:
Using UTC (or any other timezone) with NO DST (this is the most important)
is the only reliable way to store continous data.
On the client we can convert the server time easily to local time. Even if
the
Heather Johnson wrote:
Hello--
I need to make sure that every time a row is inserted into a table
called users rows are automatically inserted into two other tables:
join_bd and behavior_demographics. The inserts on join_bd and
behavior_demographics need to create rows that are keyed to the
Phil Daintree wrote:
There are 2 tables used in the sql we need to optimise .
CREATE TABLE chartdetails (
CREATE TABLE gltrans (
So there is a chartdetail record for every period for every general ledger
account. So if there are 5 years x 12 periods (months) and 200 general
ledger accounts
On Wed, 16 Mar 2005, Michael Fuhr wrote:
[I've changed the Subject back to the thread that started this
discussion.]
On Wed, Mar 16, 2005 at 05:52:02PM +0100, Marco Colombo wrote:
I'm against to any on-the-fly conversion, now.
I don't like the idea of PostgreSQL accepting input in one form
(\r\n)
Hello
We are having problems with pg_dump.
We are trying to dump a 30GB+ database using pg_dump with the --file
option. In the beginning everything works fine, pg_dump runs and we get
a dumpfile. But when this file becomes 16GB it disappears from the
filesystem, pg_dump continues working
I found on http://www.madeasy.de/7/ext2.htm (in german)
ext2 can't have bigger files than 16GB if blocksize is 1k.
Ext3 is ext2 with journaling.
Rafael Martinez Guerrero wrote:
Hello
We are having problems with pg_dump.
We are trying to dump a 30GB+ database using pg_dump with the --file
On Thu, 17 Mar 2005 14:05:35 +0100, Rafael Martinez Guerrero
[EMAIL PROTECTED] wrote:
Hello
We are having problems with pg_dump.
We are trying to dump a 30GB+ database using pg_dump with the --file
option. In the beginning everything works fine, pg_dump runs and we get
a dumpfile. But
Hi
tell me please what is the best way for replication now?
(in pgAdmin hint i read The rserv project in PostgreSQL's contrib directory
can be used for Master - Slave replication.
but PG8.0 docs there is string:Removed contrib/rserv: obsoleted by various
separate projects)
Thanks!
--
On Thu, 2005-03-17 at 15:05, Michael Kleiser wrote:
I found on http://www.madeasy.de/7/ext2.htm (in german)
ext2 can't have bigger files than 16GB if blocksize is 1k.
Ext3 is ext2 with journaling.
[]
We use 4k. And as I said, we can generate files bigger than 16GB with
other
On Thu, 2005-03-17 at 15:09, Lonni J Friedman wrote:
On Thu, 17 Mar 2005 14:05:35 +0100, Rafael Martinez Guerrero
[EMAIL PROTECTED] wrote:
Hello
We are having problems with pg_dump.
We are trying to dump a 30GB+ database using pg_dump with the --file
option. In the beginning
On Thu, 2005-03-17 at 08:11, go wrote:
Hi
tell me please what is the best way for replication now?
(in pgAdmin hint i read The rserv project in PostgreSQL's contrib directory
can be used for Master - Slave replication.
but PG8.0 docs there is string:Removed contrib/rserv: obsoleted by
On Thu, 17 Mar 2005, Rafael Martinez Guerrero wrote:
My question is why is this limit (16GB) there, when my OS does not have
that limit? Is it possible to take it away in a easy way? It looks like
pg_dump is compiled with large-file support because it can work with
files bigger than 4GB.
More
Rafael Martinez Guerrero [EMAIL PROTECTED] writes:
We are trying to dump a 30GB+ database using pg_dump with the --file
option. In the beginning everything works fine, pg_dump runs and we get
a dumpfile. But when this file becomes 16GB it disappears from the
filesystem, pg_dump continues
On Thu, Mar 17, 2005 at 01:03:36PM +0100, Marco Colombo wrote:
OMG! It's indenting the funtion body. I think you can't do that
w/o being syntax-aware. I'm not familiar with the code, why is it
adding a 'def' in front of it at all? I undestand that once you do
it you'll have to shift the code
Martijn van Oosterhout kleptog@svana.org writes:
On Thu, Mar 17, 2005 at 01:03:36PM +0100, Marco Colombo wrote:
OMG! It's indenting the funtion body. I think you can't do that
w/o being syntax-aware. I'm not familiar with the code, why is it
adding a 'def' in front of it at all? I undestand
Thank you! That *is* nicer. And thanks to Michael Fuhr too for his
reference to the appropriate docs and suggestions. Between your two
responses, I have a much better sense of how to go about this and where
to look for extra help.
Heather
Alban Hertroys wrote:
Heather Johnson wrote:
Hello--
I
does postgresql supports GUID data type???
I think, that it is slow to use GUID as varchar...
thanks, miso
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Would it help to use a different filesystem like SGI's XFS ? Would it be
possible to even implement that at you site at this stage ?
Tom Lane wrote:
Rafael Martinez Guerrero [EMAIL PROTECTED] writes:
We are trying to dump a 30GB+ database using pg_dump with the --file
option. In the beginning
On Thu, Mar 17, 2005 at 05:53:52PM +0100, Michal Hlavac wrote:
does postgresql supports GUID data type???
For the benefit of others, could you explain what this type is and
what you want to use it for? Are you referring to a Globally
Unique Identifier?
I think, that it is slow to use GUID as
On Mar 17, 2005, at 11:53 AM, Michal Hlavac wrote:
does postgresql supports GUID data type???
No, not in the core distribution.
There is a GPL project here to add this to PostgreSQL:
http://gborg.postgresql.org/project/pguuid/projdisplay.php
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for
Hi all,
My searches at:
http://archives.postgresql.org/pgsql-general/
haven't been working for the last couple hours; the query times out.
Is this my problem or a real one?
-Kevin
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
Hm, it works for me and for other people on OS X. Look into the
config.log file for more details.
Yeah, I built it on 3 different machines running 10.3.8 just yesterday.
--
Scott Ribe
[EMAIL PROTECTED]
http://www.killerbytes.com/
(303) 665-7007 voice
---(end of
Tried both that URL, and a search, and both appear to be responding for me
...
On Thu, 17 Mar 2005, Kevin Murphy wrote:
Hi all,
My searches at:
http://archives.postgresql.org/pgsql-general/
haven't been working for the last couple hours; the query times out.
Is this my problem or a real one?
[EMAIL PROTECTED] (Marco Colombo) writes:
No I wasn't sure and I actually was wrong. I've never programmed under
Windows. I've just learned something.
Indeed, the Windows C runtime translates CRLF to \n on input, and \n
to CRLF on output, for files in text mode. Unix programmers tend
not to
On Thursday 17 March 2005 23:17, Paul Moore wrote:
offtopic
Ironically, at the lowest level, Windows behaves just like Unix
(files are pure byte streams) - it's only in the C runtime and
application code that CRLF issues arise, and that's a
backward-compatibility hack dating back to the days
Hello,
PostgreSQL is distributed as .RPM files. How do I
install this in Debian?
Thanks
__
Do you Yahoo!?
Yahoo! Small Business - Try our new resources site!
http://smallbusiness.yahoo.com/resources/
---(end of
On Debian install PostgreSQL via APT. If you have APT installed:
1. Change to root.
2. Type apt-update.
3. Type apt-get install postgresql postgresql-client
#2 updates your APT package list to the lastest-and-greatest. #3 installed
the server and client applications.
I'd read up on APT at the
On Fri, 18 Mar 2005 08:39:46 +0800 (CST), S Ram [EMAIL PROTECTED] wrote:
Hello,
PostgreSQL is distributed as .RPM files. How do I
install this in Debian?
apt-get i'd imagine
or build from source.
--
~
L. Friedman
See the syntax for INSERT ... SELECT shown here:
http://www.postgresql.org/docs/8.0/static/sql-insert.html
Instead of doing a nested loop to INSERT new records, do it like this:
For ($period = start; $period end; $period++)
{
INSERT INTO chartdetails (accountcode, period)
SELECT
Note: If you want to know WHY this takes so long, please tell us how
many times each loop executes and how long each query takes.
Be sure to post an EXPLAIN ANALYZE for each of your queries that you are
running. This will show what plans the planner is using and how long
they are actually
On Fri, 2005-03-18 at 08:39 +0800, S Ram wrote:
Hello,
PostgreSQL is distributed as .RPM files. How do I
install this in Debian?
As others have said, apt-get will install PostgreSQL from the standard
Debian repositories. However, if you're running Debian stable, you
might want to use a more
On Thu, Mar 17, 2005 at 10:49:24AM -0500, Tom Lane wrote:
Seems like we have to upgrade that thing to have a complete
understanding of Python lexical rules --- at least enough to know where
the line boundaries are. Which is pretty much exactly the same as
knowing which CRs to strip out. So
Michael Fuhr [EMAIL PROTECTED] writes:
Line-ending CRs stripped, even inside quotes; mid-line CRs converted
to LF. Tests done with Python 2.4 on FreeBSD 4.11-STABLE; I wonder
what Python on Windows would do.
Unfortunately, I don't think that proves anything, because according
to earlier
On Thu, Mar 17, 2005 at 09:48:51PM -0500, Tom Lane wrote:
Michael Fuhr [EMAIL PROTECTED] writes:
Line-ending CRs stripped, even inside quotes; mid-line CRs converted
to LF. Tests done with Python 2.4 on FreeBSD 4.11-STABLE; I wonder
what Python on Windows would do.
Unfortunately, I
Michael Fuhr [EMAIL PROTECTED] writes:
Apparently any CR or LF is considered a line
ending in an ordinary Python script, with CR and CRLF normalized
to LF before being passed to the interpreter, so I'm thinking that
a Python programmer wouldn't expect to be able to embed CRs in a
string
On Fri, Mar 18, 2005 at 12:35:07AM -0500, Tom Lane wrote:
Michael Fuhr [EMAIL PROTECTED] writes:
then concerns about CR conversions potentially messing up a user's
strings might be unfounded.
Yeah, it looks like you are right:
39 matches
Mail list logo