Scott Marlowe ha scritto:
On Mon, Jul 14, 2008 at 1:54 PM, Chris Hoy <[EMAIL PROTECTED]> wrote:
Hi
I have a number of tables in my database where the queries appear to
ignoring the primary key and doing a seq scan instead, however other tables
appear to be fine. I can see any difference between
Dann Corbit wrote:
The current version of the Installer installs a native build. Cygwin
has not been used in the standard Windows build for a long time.
Go here:
http://www.postgresql.org/ftp/binary/v8.3.1/win32/
Get this:
http://wwwmaster.postgresql.org/download/mirrors-ftp?file=%2Fb
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of ken andrew
Sent: Sunday, July 13, 2008 10:27 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Installing PostgreSQL without using CygWin
Hi,
I would like to know if there is a way to install PostgreSQL in Windows NT
Server 2
[EMAIL PROTECTED] wrote:
I am doing a query via psql on a huge database, and I want to have its
output piped to other unix processes.
As the result set is very big, I've got: "out of memory for query
result".
How can I manage that, without playing with cursors, as I do not want
to change the sql
We have a database that grows in size quite quickly. Of course we
backup nightly and keep a weeks worth of data
However we need to keep a few months data online, but the rest can be
archived as it will be unlikley that it will be used again.
As I see it we can:
1) Run a query to drop/delete old d
> I think we've seen this before: do you have utf8_and_euc_jis_2004.c
> in that directory? There seem to be some broken versions of tar out
> there that can't deal with extracting such a long file name from the
> distribution tarball.
Thanks Tom,
The "c" on the end was missing.
Fixed that, how ab
Tom Lane wrote:
> "Harvey, Allan AC" <[EMAIL PROTECTED]> writes:
> > Compile issue I was hoping someone might have a suggestion for:
>
> > make[3]: Entering directory
> > `/removeExt2/postgresql-8.3.3/src/backend/utils/mb/conversion_procs/utf8_and_euc_jis_2004'
> > make[3]: *** No rule to make ta
Hello,
I am doing a query via psql on a huge database, and I want to have its
output piped to other unix processes.
As the result set is very big, I've got: "out of memory for query
result".
How can I manage that, without playing with cursors, as I do not want
to change the sql query ?
Under mysq
Hi,
I would like to know if there is a way to install PostgreSQL in Windows NT
Server 2003 without installing CygWin. The client insists on not installing
CygWin.
Please help. :D
Thanks.
Ken Andrew
Send instant messages to your online friends http://uk.messenger.yahoo.com
Hi, having an issue with Tsearch2 and how stop words lexemes are
sometimes being utilized and sometimes not. I would expect the
behavior for to_tsquery for the three variations of "what", "what's"
and "whats" to be consistent (using 'en_stem') and for all variations
to be ignored since the
"Harvey, Allan AC" <[EMAIL PROTECTED]> writes:
> Compile issue I was hoping someone might have a suggestion for:
> make[3]: Entering directory
> `/removeExt2/postgresql-8.3.3/src/backend/utils/mb/conversion_procs/utf8_and_euc_jis_2004'
> make[3]: *** No rule to make target `utf8_and_euc_jis_2004.
Bruce Momjian escribió:
> Dan Dascalescu wrote:
> > I'd like to submit a correction for question "2.1) How do I setup a
> > datasource?" in the FAQ. The existing text reads:
> >
> > "For Windows, use the ODBC Administrator in Control Panel. Here you
> > can add, modify, or delete data sources."
>
Hi All,
Compile issue I was hoping someone might have a suggestion for:
Did
./configure --prefix /removeExt2/pgsql8.3
make
make[3]: Entering directory
`/removeExt2/postgresql-8.3.3/src/backend/utils/mb/conversion_procs/utf8_and_euc_jis_2004'
make[3]: *** No rule to make target `utf8_and_euc_ji
Dan Dascalescu wrote:
> I'd like to submit a correction for question "2.1) How do I setup a
> datasource?" in the FAQ. The existing text reads:
>
> "For Windows, use the ODBC Administrator in Control Panel. Here you
> can add, modify, or delete data sources."
>
> On Windows XP, however, there is
Bayless Kirtley wrote:
An old app is giving a new error message. I query a table and make one
update. Later I come back to query the table again and get this error:
ERROR: current transaction is aborted, commands ignored until end of
transaction block
The error only occurs after I have made
On Mon, 2008-07-14 at 19:44 -0500, Bayless Kirtley wrote:
> An old app is giving a new error message. I query a table and make one
> update. Later I come back to query the table again and get this error:
>
> ERROR: current transaction is aborted, commands ignored until end of
> transaction block
An old app is giving a new error message. I query a table and make one update.
Later I come back to query the table again and get this error:
ERROR: current transaction is aborted, commands ignored until end of
transaction block
The error only occurs after I have made an update. As long as no u
On 15/07/2008, JD Wong <[EMAIL PROTECTED]> wrote:
> Hey all I'm want to use plperl but directory does not exist and I did not
> specifically enable it during installation. -Does anybody know how to
> install it post-install?
Which OS is this on? If it's Linux, which distro? And how did you instal
On Mon, Jul 14, 2008 at 3:08 PM, Mason Hale <[EMAIL PROTECTED]> wrote:
> Vacuum operations on several tables are taking much longer than they
> previously were.
> We currently have 3 autovacuum processes that have been running more than 3
> days each.
> The tables are large (between 40 and 90GB eac
Hey all I'm want to use plperl but directory does not exist and I did not
specifically enable it during installation. -Does anybody know how to
install it post-install?
Thanks
-JD
Scott Marlowe wrote:
> On Mon, Jul 14, 2008 at 1:02 PM, Tom Lane <[EMAIL PROTECTED]> wrote:
> > "Scott Marlowe" <[EMAIL PROTECTED]> writes:
> >> I just got hoisted by my own petard when a pg_dump failed due to
> >> statement timeout and I didn't notice because I was running the dump
> >> nohup and
Vacuum operations on several tables are taking much longer than they
previously were.We currently have 3 autovacuum processes that have been
running more than 3 days each.
The tables are large (between 40 and 90GB each).
Postgresql version is 8.3.1
maintenance_work_mem is 512MB (on a 32GB server
Scott Marlowe wrote:
> On Thu, Jul 10, 2008 at 8:18 AM, aravind chandu <[EMAIL PROTECTED]> wrote:
> > Hello,
> >
> > Can you please how much space does postgresql database occupies?
>
> A good rule of thumb is that it will take about 1.5 times as much
> space in the db as it does in a
On Mon, Jul 14, 2008 at 1:54 PM, Chris Hoy <[EMAIL PROTECTED]> wrote:
>
> Hi
>
> I have a number of tables in my database where the queries appear to
> ignoring the primary key and doing a seq scan instead, however other tables
> appear to be fine. I can see any difference between them.
>
> Is thei
Hi
I have a number of tables in my database where the queries appear to
ignoring the primary key and doing a seq scan instead, however other tables
appear to be fine. I can see any difference between them.
Is their any way of determination why the otimizer isn't picking up the
primary key?
Vers
On Jul 8, 2008, at 7:49 PM, Goldeneye Solutions Information wrote:
I’m been reading up on FOR UPDATE NOWAIT and it looks like It was
added in 8.1.
How difficult is it to add FOR UPDATE SKIP LOCKED or something
similar? (basically skip locked rows / oracle syntax)
More background here:
http
On Mon, Jul 14, 2008 at 1:02 PM, Tom Lane <[EMAIL PROTECTED]> wrote:
> "Scott Marlowe" <[EMAIL PROTECTED]> writes:
>> I just got hoisted by my own petard when a pg_dump failed due to
>> statement timeout and I didn't notice because I was running the dump
>> nohup and didn't read the nohup.out file
"Scott Marlowe" <[EMAIL PROTECTED]> writes:
> I just got hoisted by my own petard when a pg_dump failed due to
> statement timeout and I didn't notice because I was running the dump
> nohup and didn't read the nohup.out file to see the errors. It wasn't
> a big deal, the data wasn't critical opera
Viktor Rosenfeld <[EMAIL PROTECTED]> writes:
> the script below runs very fast when executed alone. But when I call
> it from within a transaction block it's so slow that I have to abort
> it after a while. Specifically the second-to-last UPDATE seems to
> take forever within a transaction
"Fco. Mario Barcala" =?ISO-8859-1?Q?Rodr=EDguez?= <[EMAIL PROTECTED]> writes:
> Is it possible to remove the possibility of searching the parts of a
> word which include a hyphen? I know that the default parser identifies
> all possibilities (the compound word and the individual part ones), but
> I
I just got hoisted by my own petard when a pg_dump failed due to
statement timeout and I didn't notice because I was running the dump
nohup and didn't read the nohup.out file to see the errors. It wasn't
a big deal, the data wasn't critical operational data or anything.
But it got me to thinking
> I'm wondering how much of the conference we have access to with an
> exhibitor badge? Obviously not tutorials, but what about regular
> technical sessions?
You get into the exhibit hall when it is closed to regular attendees.
You get lunch. I'm not sure that there are any perks beyond that.
-
>-Original Message-
>From: [EMAIL PROTECTED]
>[mailto:[EMAIL PROTECTED] On Behalf Of Daniel Johnson
>Sent: Monday, July 14, 2008 10:07 AM
>To: gabrielle
>Cc: [EMAIL PROTECTED];
>pgsql-general@postgresql.org; [EMAIL PROTECTED]
>Subject: Re: [pdxpug] Pg booth staffing at OSCON
>
>On Sun,
Hi all:
I have been searching the mailing lists about hyphens but I coudn't find
the answer to this question:
Is it possible to remove the possibility of searching the parts of a
word which include a hyphen? I know that the default parser identifies
all possibilities (the compound word and the in
On Sun, Jul 13, 2008 at 4:31 PM, gabrielle <[EMAIL PROTECTED]> wrote:
> OSCON is fast approaching - just one more week!
>
> I need some people to help out with booth staffing for Thursday. Sign up here:
> http://wiki.postgresql.org/wiki/Oscon_2008_signup
>
> Staffing the booth is a ton o' fun and a
Hello
look to fuzzystrmatch module
http://www.postgresql.org/docs/8.3/interactive/fuzzystrmatch.html
Regards
Pavel
2008/7/14 Fco. Mario Barcala Rodríguez <[EMAIL PROTECTED]>:
> Is there in PostgreSQL something like the full-text NEAR operator of
> Oracle? That is, to obtain the documents which i
Hi,
the script below runs very fast when executed alone. But when I call
it from within a transaction block it's so slow that I have to abort
it after a while. Specifically the second-to-last UPDATE seems to
take forever within a transaction while it completes in about 3
seconds outside
Markus Mehrwald <[EMAIL PROTECTED]> writes:
> I tried to insert an image in my database with lo_import. The error I
> get is "invalid large object descriptor: 0".
lo_import has to be called within a transaction block (BEGIN/COMMIT).
The documentation is not very clear about that :-(
(Actually, ra
Is there in PostgreSQL something like the full-text NEAR operator of
Oracle? That is, to obtain the documents which include two words
separated by less than an specified numbers of words (distance).
I didn't find anything related with this issue inside the documentation
or mailing list archives.
Hello,
I tried to insert an image in my database with lo_import. The error I
get is "invalid large object descriptor: 0". If I try to create an oid I
get a valid one but with lo_import it seems not to work. The connection
is ok as well.
The folloing code produces the output after the code.
if (PQ
On 14/07/2008 10:47, ken andrew wrote:
I would like to know if there is a way to install PostgreSQL in Windows
NT Server 2003 without installing CygWin. The client insists on not
installing CygWin.
Sure - there's been a native Win32 port for quite some time now. You can
compile from source o
Hi,
I would like to know if there is a way to install PostgreSQL
in Windows NT Server 2003 without installing CygWin. The client insists
on not installing CygWin.
Please help. :D
Thanks.
Ken Andrew
Send instant messages to your online friends http://uk.messenger.yahoo.com
42 matches
Mail list logo
