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
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
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
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.
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, rather
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
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
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 great
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
-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, Jul 13,
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.
--
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
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 would
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 while
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 operational
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 to see the
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:
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?
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 their any way
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 flat file.
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
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 didn't read the
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
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 each).
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 install,
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
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
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
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 no Control
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
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.
On Windows
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.o',
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 they all
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
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
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 target
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 about
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
[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
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
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:
41 matches
Mail list logo
