Hi Craig,
Thank you for your reply and for all of the pointers. I didn't include the
Gui code (It would have taken too much space), just the simple query code
that already works in printing out the results I wanted. Basically I just
wanted to find out how to use this code which works, inside of a
On Mon, May 25, 2009 at 1:29 PM, mARK bLOORE wrote:
> The table listing what I want to delete has just the key values.
>
> If I just do
>
> DELETE FROM backlinks b USING bad_links bl WHERE b.key = bl.key;
>
> then it grinds for an hour or so and runs out of memory.
>
> If I do
>
> DELETE FROM back
Thanks for the pointers will try them.
On 25/05/2009, Stephen Frost wrote:
> Greetings,
>
> * Intengu Technologies (sindile.bi...@gmail.com) wrote:
>> What I would like to do is
>>
>> If field1=1 make table1 and insert the rest of field1=1 into this table
>> If field1=2 make table2 and insert the
Version 8.3.7
On 25/05/2009, Grzegorz Jaśkiewicz wrote:
> what's the postgrtesql version there ?
> (just do "select version();", or psql --version);
>
--
Sindile Bidla
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postg
I have a table of about 1 G rows, and I want to delete about 5 M rows,
listed in another table.
The big table is
Table "public.backlinks"
Column | Type | Modifiers | Description
-+---+---+-
key | bytea | not null |
back
I had the same problem as OP.
With Windows 7 x64 & postgresql Version 8.3.7-1
It seems like running tuning wizard changes the permissions of the
postgres.conf file so that the .postgres account is not able to read it.
Similar to OP's situation, postgres was working fine until ran the tuning
wiz
queries wrote:
> Hi Everyone,
>
> I need to build a simple gui front end with jdbc access to my Postgres
> database. I have the front end ready and I have some code which retrieves
> records from my database, but for some reason I keep on getting errors
> (lately just freezes without errors) when
Tom Lane wrote:
> Craig Ringer writes:
> Not sure how you tested that, but index_drop() clearly takes
> AccessExclusiveLock on the table too. (I'm not sure it really needs
> to --- the comment therein defending the reasoning seems out of date
> --- but it definitely does.)
I just re-checked, an
OK... never mind, everyone. The problem was elsewhere in the code.
Regards,
Eric
On May 25, 2009, at 5:31 PM, Tom Lane wrote:
Eric Smith writes:
Seems to work just fine. If, on the other hand, I issue the same
command from within the C API:
NSString* query = [NSString stringWithFormat:@
Very interesting.
when I set log_statement='all', I see entries for various queries, but
I see nothing for the query I list below. If I just use printf() to
print out the c-string, it looks just like all the other queries.
Eric
On May 25, 2009, at 5:31 PM, Tom Lane wrote:
Eric Smith wr
Alrighty so, how do I turn on log_statement?
Thanks,
Eric
On May 25, 2009, at 5:31 PM, Tom Lane wrote:
Eric Smith writes:
Seems to work just fine. If, on the other hand, I issue the same
command from within the C API:
NSString* query = [NSString stringWithFormat:@"SELECT usename FROM
Eric Smith writes:
> Seems to work just fine. If, on the other hand, I issue the same
> command from within the C API:
> NSString* query = [NSString stringWithFormat:@"SELECT usename FROM
> pg_catalog.pg_user"];
> postgresResult = PQexec(myConnection, [query UTF8String]);
> I get an e
OK,
So I gave up on the universal binary, and just built a PPC version of
postgres. If I execute the command:
SELECT usename FROM pg_catalog.pg_user;
from within psql, I get:
usename
-
esmith
radiovision
(2 rows)
Seems to work just fine. If, on the other hand, I issue t
Why is it not possible to create domain on composite type ?
Consider the example, I got (a bytea, b timestamp, c timestamp). Where
b < c always, and both b and c have some default value, a can stay
null.
Now, I don't want to go berserk, and create aditional table for that,
because type is shared b
2009/5/25 Stephen Frost :
>
> Right, that would be option #3 from my list. :)
Aye,
The reason I am asking about version, is because 8.1 can't import CSV
using COPY.
--
GJ
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.pos
* Grzegorz Jaśkiewicz (gryz...@gmail.com) wrote:
> On Mon, May 25, 2009 at 4:12 PM, Stephen Frost wrote:
>
> > This currently can't be done with the COPY command directly. There are
> I would put it in postgresql as is, and than do "CREATE TABLE foo AS
> SELECT CASE ... END ;"
Right, that
On Mon, May 25, 2009 at 12:10:21AM -0700, Scara Maccai wrote:
> is there any chance to get the "Planner Cost Constants" right enough to get a
> "good" estimate in seconds of how long a query is supposed to run?
> The "rowcount" estimates are always good (there is no skew data at all in the
> db,
On Mon, May 25, 2009 at 4:12 PM, Stephen Frost wrote:
> This currently can't be done with the COPY command directly. There are
I would put it in postgresql as is, and than do "CREATE TABLE foo AS
SELECT CASE ... END ;"
--
GJ
--
Sent via pgsql-general mailing list (pgsql-general@postgr
Greetings,
* Intengu Technologies (sindile.bi...@gmail.com) wrote:
> What I would like to do is
>
> If field1=1 make table1 and insert the rest of field1=1 into this table
> If field1=2 make table2 and insert the rest of field1=2 into this table
>
> Hence in this example one will have table1, ta
what's the postgrtesql version there ?
(just do "select version();", or psql --version);
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Dear List
I have a csv file that I would like to import into Postgresql, the
structure of the csv file is in this format:
"field1","field2","field3","field4"
"1","2","RD","1"
"2","2","RD","1"
"4","2","RD","1"
"4","2","RD","1"
"5","2","RD","1"
"5","2","RD","1"
"5","2","RD","
- Original Message -
From: "Lew"
To:
Sent: Saturday, May 23, 2009 2:18 PM
Subject: Re: [GENERAL] Daylight saving time question
Bayless Kirtley wrote:
Thanks Tom and Scott. You got me looking in the right direction. In this
case
the client and server are on the same machine (testin
Craig Ringer writes:
> The locking docs:
> http://www.postgresql.org/docs/8.3/static/explicit-locking.html
> don't say anything about which lock DROP INDEX takes on a relation. A
> quick test shows it takes an AccessExclusiveLock on the affected index,
> and appears to take no lock at all on the t
APseudoUtopia wrote:
2. I do not want to get rid of any comments, even if the user is
deleted (on the application level, I'd display something like
UnknownUser or UnknownUser#1234). Right now, I just have it ON DELETE
RESTRICT, but that obviously prevents any users who have commented
from being d
Hi Everyone,
I need to build a simple gui front end with jdbc access to my Postgres
database. I have the front end ready and I have some code which retrieves
records from my database, but for some reason I keep on getting errors
(lately just freezes without errors) when I apply that same code to
O podrías escribir,
select campo1,
campo2,
campo1 - campo2 as campo_virtual,
campo3,
case when campo1 - campo2 = 1 then 5 else 0 end as segundo_campo_virtual
from tabla;
Saludos.
R.
On May 25, 2009 6:18am, Alban Hertroys
wrote:
On May 25, 2009, at 4:56 AM, marco santillan wrote:
Hola
On May 25, 2009, at 10:58 AM, Ramiro Diaz Trepat wrote:
The table with the atmosphere pixels, currently has about 140MM
records, and the one the values about 1000MM records. They should
both grow to about twice this size.
Did you tune postgres to use the available resources? By default it
On May 25, 2009, at 4:56 AM, marco santillan wrote:
Hola a todos:
Tengo la siguiente inquietud. En una consulta com la siguiente:
select campo1,
campo2,
campo1 - campo2 as campo_virtual,
campo3,
case when campo_virtual = 1 then 5 else 0 end as segundo_campo_virtual
from tabla;
Esto lo puedo h
Hello,
I'd try to use postgis ( http://postgis.refractions.net ), that allows
you to geolocalize your data. We use such an extention here for the
same kind of data you use. It will lighten up table size, and queries.
Otherwise, partitioning and cluster are good things to do. I would
increase defau
You might want to try CREATE CLUSTER. I had a 40M row table that was
taking ages to access, I tried partitioning it into 12000 sub-tables,
and obtained a modest speed up. Using CREATE CLUSTER on an
un-partitioned table resulted in an enormous speed up though.
You will need to choose the axis you w
Try partitioning. It should sort you out.
-Peter-
On 5/25/09, Ramiro Diaz Trepat wrote:
>
> Hello list,I will try to make this as brief as possible.
> I have a brother who is a scientist studding atmospheric problems. He was
> trying to handle all of his data with flat files and MatLab, when I
Hello list,I will try to make this as brief as possible.
I have a brother who is a scientist studding atmospheric problems. He was
trying to handle all of his data with flat files and MatLab, when I stepped
in and said, wait, you need a RDBMS to handle all this data.
So, he basically has 2 very s
Tom Lane wrote:
Ron Mayer writes:
Sam Mason wrote:
You get an error because " 123 11" isn't a valid literal of an
(undecorated) INTERVAL type.
Hmm. should it be?
Well, we do allow it if it's *explicitly* stated to be a day to hour
interval:
regression=# select interval '123 11' day t
Hi,
is there any chance to get the "Planner Cost Constants" right enough to get a
"good" estimate in seconds of how long a query is supposed to run?
The "rowcount" estimates are always good (there is no skew data at all in the
db, values are pretty much "plain" distributed)
--
Sent via p
34 matches
Mail list logo
