On Sat, 06 Nov 2004 22:27:08 -0600, Dave Balderstone
> You're way too impatient. Things don't happen here in time scales that
> are measured in hours or days. Hang in there. You've got a good start
> and some good people supporting what you want to do.
>
> Relax, take your time (and the advise of
Although it is not Free I think that you should give EMS Postgres
Manager a try (www.ems-hitech.com), it Does pretty much everything that
MS-SQL Enterprise manger does, including a good Diagramming tool.
Embarcardo Technologies have some very good, (but expensive) Db design
tools , mostly for w
Hello,
I need to use COPY (instead of INSERT) within plperl function. I know
that COPY will work if data will be taken from file - however I need to
use STDIN. I tried this:
spi_exec_query("COPY sometable (field1, field2) FROM
stdin;"."\n"."sometext"."\t"."sometext"."\n"."\.")
But it didn't wor
PostgreSQL doesn't provide pre-configured support for materialized views as
such, but using some PL/pgSQL and triggers, one can easily implement any kind
of materialized view as seen fit for the specific intended purpose (Snapshot,
Eager, Lazy, Very Lazy).
You may find an excellent tutorial on
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Thanks for your answers Greg & Vincent.
Although I solved the problem by a change of schema - I'm happy that I have
something to digest I didn't know before. One never learns enough ...
U.C.
On Saturday 06 November 2004 03:13 pm, Uwe C. Schroeder
(re-post)
Dear list,
Please let me know if this is not the list to ask this kind of question.
I am trying to optimize a query that joins two relatively large (75 rows in
each) tables. If I do it using a subselect, I can "force" the planner to choose
the fastest path. Now, my question is:
If
Hi all.
I'm working (well, rather, reworking) a database schema that, in part,
models a company organizational structure. For example:
group
company
division
head office
department
depa
You could try DbDesigner(4) at http://dbdesigner.sourceforge.net/
-Message d'origine-
De : Johan Wehtje [mailto:[EMAIL PROTECTED]
Envoyé : lundi 8 novembre 2004 09:51
À : Postgres General
Objet : Re: [GENERAL] Visual DATA MODEL Designer in linux?
Although it is not Free I think that you
On Mon, 8 Nov 2004, Morten K. Poulsen wrote:
> Please let me know if this is not the list to ask this kind of question.
>
> I am trying to optimize a query that joins two relatively large (75 rows
> in
> each) tables. If I do it using a subselect, I can "force" the planner to
> choose
> the
On Mon, Nov 08, 2004 at 04:54:40AM -0800, Stephan Szabo wrote:
> > If I have a subselect with an ORDER BY, and I LEFT JOIN the result with the
> > other table, is the order maintained? Or is PostgreSQL free to return the
> > rows in any order, after the join?
>
> AFAIK, you have no guarantees as t
Hi Everybody,
I am having problems while installing pgbench program. I followed
the below procedure to install according to the docs:
(1) Configure and build the standard Postgres distribution.
You can get away with just running configure at the top level
and doing "make all" in src
At 10:20 PM 11/7/2004, you wrote:
Andy wrote:
> Someone posted this official proposal to create
> comp.databases.postgresql.general again. He wrote his own charter. As
> far as I know, he did not consult any of the postgresql groups first.
> There may be an upcoming vote on this, so please stay inf
I am posting this to the General and JDBC groups so that it's in the
archive -- I know many people have had problems with Latin1 characters, and
I'd like to share what has worked for us. If anyone can add this
information to a more permanent FAQ, I'd be much obliged.
---
Using Postgres with
On Mon, 8 Nov 2004, Gary L. Burnore wrote:
DataBasix carries it even though it wasn't an officially created group
because some of our users requested it and they read it.
To improve speed, do you want to setup an inter-connect between our news
server and yours?
Then I've noticed some notes here
On Mon, 8 Nov 2004, J. Michael Crawford wrote:
>
>Even in Java, where you can do all sorts of character-encoding
> translation, it can be impossible to translate data retrieved from Postgres
> if it's in the wrong encoding. We've tried changing the JVM encoding,
> altering the jdbc drive
Yes you can use the copy command. Check for
copy TABLE NAME from 'c:\\bcpdata\\Files\\FILENAME.txt' with delimiter
as '\t' NULL as '';
When creating a table, use an incremental column (data type is serial).
Hope the above helps.
- Goutam
> -Original Message-
> From: [EMAIL PROTECTE
Why can you not use simple insert statements (sql insert).
Copy is meant to transfer large amount of data from text files to
databases and vice versa.
- Goutam
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Marek Lewczuk
> Sent: Monday, Novembe
Goutam Paruchuri wrote:
Why can you not use simple insert statements (sql insert).
Copy is meant to transfer large amount of data from text files to
databases and vice versa.
"Insert" is much slower if there are many (hundreds, thousands) data to
be inserted - and in my case there will be thousand
Russell Smith <[EMAIL PROTECTED]> writes:
> now() and CURRENT_DATE, are and cannot be planned as constants.
> So the planner cannot use an index for them.
It's not that it cannot use an index, but that it doesn't know it should use
an index. The planner knows that it can't count on now() to be c
Hello everyone,
I have received any error message in my Postgres error log as follows:
"The Postmaster has informed me that some other backend died abnormally
and possibly corrupted shared memory. I have rolled back the current
transaction and am going to terminate your database system connectio
Hello,
2 questions
!
Question 1
Iam trying to load
binary data from sql server to postges. Do i have to write a script ..
??
Question 2
How i do load text
data with newlines into postgres database .. (as newline is the default row delimiter and cannot be changed in the column table).
Markus,
Thank you for your hint!
I spent the better part of last night working on this and finally was
able to get it to work the way I wanted. The short version: I am
continually amazed by the flexibility in Postgres, this isn't the sort of
thing I'd want to go back years from now and digest w
At 11:48 AM 11/8/2004, you wrote:
On Mon, 8 Nov 2004, Gary L. Burnore wrote:
At 11:01 PM 11/7/2004, you wrote:
On Sun, 7 Nov 2004, Gary L. Burnore wrote:
User makes a comment in USENet. Post gets seen on usenet servers around
the world. Moderator chooses not to approve.
Unless ist Spam, moderator
On Mon, 8 Nov 2004, Gary L. Burnore wrote:
It receives those posted to USENet just as it would any other group.
That's why those gated don't make it to databasix.com for days after
they're actually posted. So each appears twice. Once as the original
USENet post and once as a post forwarded by
<>
Well then, perhaps we shouldn't share the procedure with other folks. I
apologize if I'm introducing some misinformation.
However, this has been the only way to get our system to work on more
than one JVM. People from this group provided many suggestions, people
from other groups did t
Brian {Hamilton Kelly} wrote:
> On Saturday, in article <[EMAIL PROTECTED]>
> [EMAIL PROTECTED] "Mike Cox" wrote:
>
>> Woodchuck Bill wrote:
>>
>> > Mike Cox <[EMAIL PROTECTED]> wrote in
>> > news:[EMAIL PROTECTED]:
>> >
>> >> I cannot handle the volume of email that a mailing list would
J. Michael Crawford wrote:
Encoding translations that didn't work:
a) Getting encoded bytes from the result set. We tried the following
block five times, once for each different encoding we were trying to
test with the database:
b) Getting a string, turning it bytes, and then translating. Sam
On 2004-11-08, Woodchuck Bill <[EMAIL PROTECTED]> wrote:
> [EMAIL PROTECTED] ("Marc G. Fournier") wrote in
> news:[EMAIL PROTECTED]:
>
>> Unless its spam, it goes through ... I don't (nor have I ever) refused a
>> post based on content other then spam ... even if its anti-PostgreSQL
>> *shrug*
>
In article <[EMAIL PROTECTED]>,
Greg Stark <[EMAIL PROTECTED]> wrote:
>
>Russell Smith <[EMAIL PROTECTED]> writes:
>
>> now() and CURRENT_DATE, are and cannot be planned as constants.
>> So the planner cannot use an index for them.
>
>It's not that it cannot use an index, but that it doesn't know
On Mon, 8 Nov 2004, Andrew - Supernews wrote:
On 2004-11-08, Woodchuck Bill <[EMAIL PROTECTED]> wrote:
[EMAIL PROTECTED] ("Marc G. Fournier") wrote in
news:[EMAIL PROTECTED]:
Unless its spam, it goes through ... I don't (nor have I ever) refused a
post based on content other then spam ... even if i
[EMAIL PROTECTED] ("Miquel van Smoorenburg" ) writes:
> techdb2=> explain select * from lines where (removed > CURRENT_DATE AND
> removed < '-01-01');
> With 7.3, this query used the index, while with 7.4 it doesn't.
Perhaps you hadn't ANALYZEd in 7.3? AFAICS 7.3 and 7.4 behave
essentially
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Mon, 1 Nov 2004, Marcel Gsteiger wrote:
I wanted to install postgreSQL 7.4 on my ia32e box (x86_64 dual xeon PL370G4)
running WBEL3.0. I looked for binary RPMs but did not find any. So I tried to
rpmbuild --rebuild --define 'build9 1' postgresq
<>
That was the first thing we tried. Sorry I didn't mention it.
The next step was getting a string, turning it into bytes, and
translating the bytes. The third step was getting bytes. Nothing worked
in our Java GUI, the console, or the web page returned.
Maybe it was just something we
I have a simple function which I use to set up a users' expiry date. If
a field in a table contains an interval then
this function returns a timestamp some time in the future (usually two
weeks), null otherwise. I can't pass the
interval from the table into a variable properly within the function
A power failure led to failed postmaster restart using 7.4.6 (see output
below). The short-term fix is usually to delete the pid file and restart.
I often wonder why ipcs never seems to show the shared memory
block in question? Am I using the wrong command? Does the key
mentioned by pgsql map
"Bob Powell" <[EMAIL PROTECTED]> writes:
> I have received any error message in my Postgres error log as follows:
> "The Postmaster has informed me that some other backend died abnormally
> and possibly corrupted shared memory.
Is there a core dump from this event? A backtrace from the core dump
On Mon, Nov 08, 2004 at 04:15:34PM -0800, Ron St-Pierre wrote:
> SELECT INTO exptime current_timestamp + INTERVAL ''intval'';
You're using the literal value 'intval' instead of its value, thus
the syntax error. You can simplify the statement to this:
exptime := current_timestamp + intval;
But
Hi guys, I'm wondering what the easy way to grant user/group access on all
tables
in a db. I just migrated about 200 tables from my MySQL database using a cool
migration script, but now all the tables are owned by me in the schema public.
That is all fine and all, but I wish I could run a comman
"Ed L." <[EMAIL PROTECTED]> writes:
> A power failure led to failed postmaster restart using 7.4.6 (see output
> below). The short-term fix is usually to delete the pid file and restart.
> I often wonder why ipcs never seems to show the shared memory
> block in question?
The shared memory block
On Mon, Nov 08, 2004 at 05:00:49PM -0800, Kenji Morishige wrote:
> I'm wondering what the easy way to grant user/group access on all tables
> in a db.
This comes up from time to time -- search the archives for phrases
like "grant" and "all tables". The responses usually suggest writing
a script
On Mon, 08 Nov 2004 12:55:06 -0800
Mike Cox <[EMAIL PROTECTED]> wrote
> ...
> There is also the point of having to post. If I post and I subscribe to the
> digest version or if I post with the option of no emails (since my inbox
> cannot handle the load), how would I respond to a thread I created
On Sun, Nov 07, 2004 at 09:29:30 +,
Jerry III <[EMAIL PROTECTED]> wrote:
> But if you do build an index over "id" then pgsql would only have to do a
> sequential scan on that index, which might be a lot faster if your table
> contains a lot of other data, won't it?
A full table index scan
On Monday November 8 2004 6:16, Tom Lane wrote:
> "Ed L." <[EMAIL PROTECTED]> writes:
> > A power failure led to failed postmaster restart using 7.4.6 (see
> > output below). The short-term fix is usually to delete the pid file
> > and restart.
> >
> > I often wonder why ipcs never seems to show t
On Monday November 8 2004 7:24, Ed L. wrote:
> On Monday November 8 2004 6:16, Tom Lane wrote:
> > "Ed L." <[EMAIL PROTECTED]> writes:
> > > A power failure led to failed postmaster restart using 7.4.6 (see
> > > output below). The short-term fix is usually to delete the pid file
> > > and restart
Hi
I'd like to know if there is a way to specify different transaction
isolation levels for different tables in the db. The reason i'm asking
this (rather bizarre sounding, i know ;-) ) question is the following:
I'm importing about 2 million records into my application each day (the
data is mo
"Ed L." <[EMAIL PROTECTED]> writes:
> A power failure led to failed postmaster restart using 7.4.6 (see
> output below). The short-term fix is usually to delete the pid file
> and restart.
Thinking some more about this ... does anyone know the algorithm used
in Linux to assign shared memory segme
On Tue, Nov 09, 2004 at 04:34:16AM +0100, Florian G. Pflug wrote:
> My import sometimes crashed, becausse the meta-information tables are
> changed while importing (e.h, I pass a id to a function, the function
> does some calculations, than tries to select the row with the given id,
> but fails
On Monday November 8 2004 8:41, Tom Lane wrote:
>
> BTW, do you know what all those shmem segments are for? My Linux box
> shows only one segment in use besides the ones Postgres is using.
Looks like Ximian Evolution apps, X, Mozilla, Wombat, etc ...
Ed
---(end of broad
I'm wrestling with tracking down a deadlock. Here's a 7.4.6 deadlock
message:
ERROR: deadlock detected
DETAIL: Process 15655 waits for ShareLock on transaction 9381; blocked by
process 15600.
Process 15600 waits for ShareLock on transaction 9388; blocked by process
15655.
I know the origin
49 matches
Mail list logo
