On Wed, May 10, 2006 at 09:12:33PM -0600, Michael Fuhr wrote:
On Wed, May 10, 2006 at 02:50:26PM -0300, Humberto Luiz Razente wrote:
I'm trying to index data characteristics extracted from multimedia
files (like a color distribution histogram from an image), in
order to make k-nearest
On Thu, May 11, 2006 at 02:55:04PM +0930, Luke Vanderfluit wrote:
Hi.
I've been able to compile postgresql on solaris 10.
Now I want to install the perl DBD::Pg module but I get a complaint, namely:
[EMAIL PROTECTED] # make
rm -f blib/arch/auto/DBD/Pg/Pg.so
I have sometimes very long queries, for example in setup-purposed sql
file where plenty of tables of a new database are created in a single
transaction. 600 lines of code or more is common. Sometimes, while
developing, an error may appear after submitting such a query for
testing purposes
Now you're talking about data warehouse design and not optimizing
queries, though they are obviously interrelated. A human looking at the
explain data would not be able to determine that it would be better to
have a summary table either.
However, first you would want to optimize your queries
Hello,
Someone asks for a Login-Procedure like Sybase:
set OPTION PUBLIC.LOGIN_PROCEDURE='meine_tolle_prozedur';
I think, this i possibly a nice feature, either per user or for all
users. We have a 'ALTER USER name SET parameter ...', simply add a new
Parameter 'login_procedure' and call this
A. Kretschmer schrieb:
Hello,
Someone asks for a Login-Procedure like Sybase:
set OPTION PUBLIC.LOGIN_PROCEDURE='meine_tolle_prozedur';
I think, this i possibly a nice feature, either per user or for all
users. We have a 'ALTER USER name SET parameter ...', simply add a new
Parameter
Thanks for the script.
It does a great job of finding exactly which path is taking the most
time. Now for the hard part. Why is that part taking the longest time.
Richard Huxton wrote:
I've got a short perl script that I throw explain output into. It's not
brilliant - can give false
am 11.05.2006, um 11:56:51 +0200 mailte Tino Wildenhain folgendes:
A. Kretschmer schrieb:
Hello,
Someone asks for a Login-Procedure like Sybase:
set OPTION PUBLIC.LOGIN_PROCEDURE='meine_tolle_prozedur';
I think, this i possibly a nice feature, either per user or for all
users. We have a
Anastasios Hatzis [EMAIL PROTECTED] writes:
My problem is that I don't know where the given character number is
inside the query/file. I can search in my code editors (e.g. those of
Eclipse IDE) for line number + character number in given line
number... but I can not search for an overall
A. Kretschmer schrieb:
am 11.05.2006, um 11:56:51 +0200 mailte Tino Wildenhain folgendes:
A. Kretschmer schrieb:
Hello,
Someone asks for a Login-Procedure like Sybase:
set OPTION PUBLIC.LOGIN_PROCEDURE='meine_tolle_prozedur';
I think, this i possibly a nice feature, either per user or for
am 11.05.2006, um 12:30:13 +0200 mailte Tino Wildenhain folgendes:
I wonder what this procedure should do? :-)
For instance:
- the database-administrator can set a flag in one table to deny
user-logins, a syste-wide logon-proc can check this flag.
say like pg_hba.conf? ;)
Yes, but
A. Kretschmer schrieb:
am 11.05.2006, um 12:30:13 +0200 mailte Tino Wildenhain folgendes:
I wonder what this procedure should do? :-)
For instance:
- the database-administrator can set a flag in one table to deny
user-logins, a syste-wide logon-proc can check this flag.
say like
Douglas McNaught wrote:
Emacs has the goto-char function and runs on Windows, so you could
use that (there are probably other editors with this feature as
well)..
Doug, thank you. I will use it. - Ha, I never thought I will ever use
legendary Emacs. Probably I will even become an entry-class
Tino Wildenhain wrote:
A. Kretschmer schrieb:
Someone asks for a Login-Procedure like Sybase:
set OPTION PUBLIC.LOGIN_PROCEDURE='meine_tolle_prozedur';
I think, this i possibly a nice feature, either per user or for all
users. We have a 'ALTER USER name SET parameter ...', simply add a new
From my point of view, more important problem is that log doesn't help
to find the query (in other words, log message doesn't show context)
On 5/11/06, Douglas McNaught [EMAIL PROTECTED] wrote:
Anastasios Hatzis [EMAIL PROTECTED] writes:
My problem is that I don't know where the given
On 5/11/06, Nikolay Samokhvalov [EMAIL PROTECTED] wrote:
From my point of view, more important problem is that log doesn't help
to find the query (in other words, log message doesn't show context)
Yes it does.. but it depends on your logging setup.
in psql:
test=# blah;
ERROR: syntax error
Shoaib Mir [EMAIL PROTECTED] writes:
While running the recovery process I am getting the following errors for
cannot stat:
cp: cannot stat `/data1_node5/arch/0001.history': No such file or
directory
What makes you think this is an error? As pointed out in the docs,
the archive_recovery
Anastasios Hatzis [EMAIL PROTECTED] writes:
I have sometimes very long queries, for example in setup-purposed sql
file where plenty of tables of a new database are created in a single
transaction. 600 lines of code or more is common. Sometimes, while
developing, an error may appear after
Hi,
Where can I find information about installing and
running contrib/reindexdb? I have searched the manuals and appendixes without
much luck. I just know that there is a contrib for reindexing an entire
database.
We run postgresql (v 7.4.x) in Linux RedHat.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Tom Lane
Sent: 11 May 2006 15:00
To: Anastasios Hatzis
Cc: pgsql-general@postgresql.org; pgadmin-hackers@postgresql.org
Subject: Re: [GENERAL] Debugging SQL queries
pgAdmin needs to catch up
That should be true about `/data1_node5/arch/0001.history' since there may not be any timelines created by previous archiver recoveriesBut the messagecp: cannot stat `/data1_node5/arch/00010007''
suggests that it was not able to restore one of the log files while doing the
On Thu, 2006-05-11 at 05:58, Tino Wildenhain wrote:
A. Kretschmer schrieb:
am 11.05.2006, um 12:30:13 +0200 mailte Tino Wildenhain folgendes:
I was not aware so many people working at the psql console
regulary :-)
No? I'm amazed ;-) There are other clients?
I have the
In CVS tip you just see
regression=# select 1 2;
ERROR: syntax error at or near 2
LINE 1: select 1 2;
^
regression=#
We still include at character N if the message is written to the
server log, but the primary message text field of the error report
sent to the client doesn't
Tom Lane wrote:
We have actually removed the at character N bit from the default message
format in CVS
Tom,
What will the error format be for 8.2? Since the char number has been
removed, what will it show?
Line number?
Thanks,
--
Tony Caduto
AM Software Design
Tony Caduto [EMAIL PROTECTED] writes:
Tom Lane wrote:
We have actually removed the at character N bit from the default message
format in CVS
What will the error format be for 8.2?
In CVS tip you just see
regression=# select 1 2;
ERROR: syntax error at or near 2
LINE 1: select 1 2;
On Thu, May 11, 2006 at 10:56:20AM -0400, Tom Lane wrote:
We still include at character N if the message is written to the
server log, but the primary message text field of the error report
sent to the client doesn't have it any more.
Will the text returned by PQerrorMessage still include the
Carlos Oliva wrote:
--
Hi,
Where can I find information about installing and running
contrib/reindexdb? I have searched the manuals and appendixes without
much luck. I just know that there is a contrib for reindexing an entire
database.
We run postgresql (v 7.4.x) in Linux RedHat.
Hi Joshua,
I think that it was installed from a RedHat distribution and the
installation left out reindexdb from the contrib folder. I will look into
this.
In the mean time maybe I can ask you: Does VACUUM FULL ANALYZE of a
database would also reindex the user indexes of a database? I am
Carlos Oliva wrote:
Hi Joshua,
I think that it was installed from a RedHat distribution and the
installation left out reindexdb from the contrib folder. I will look into
this.
In the mean time maybe I can ask you: Does VACUUM FULL ANALYZE of a
database would also reindex the user indexes of a
Hi Tom,
I guess I didn't know there was a error-position field returned, I have
been parsing out the at character xx to get the char number.
Do you know offhand if there is the error-position field is discussed in
the docs anywhere?
Not a C guy but possibly?
Tony Caduto [EMAIL PROTECTED] writes:
I guess I didn't know there was a error-position field returned, I have
been parsing out the at character xx to get the char number.
Do you know offhand if there is the error-position field is discussed in
the docs anywhere?
See PQresultErrorField().
Is there a disadvantage to having the primary key for a table be a text
type vs. an integer type? Performance? Any difference between having a
varchar or char as a primary key?
My instinct tells me that an integer is preferred, but I'm looking for a
more concrete answer.
Thanks,
Mark
On Thu, 2006-05-11 at 10:52, Mark Gibson wrote:
Is there a disadvantage to having the primary key for a table be a text
type vs. an integer type? Performance? Any difference between having a
varchar or char as a primary key?
My instinct tells me that an integer is preferred, but I'm
On Tue, 2006-09-05 at 21:08 +0200, Martijn van Oosterhout wrote:
On Tue, May 09, 2006 at 10:52:32AM -0600, Blair Lowe wrote:
In my test I do not see stuff2 either. The problem here is that I have
sensitive production data, so my tests are hard to read, and not able to
submit here.
You
On Thu, May 11, 2006 at 10:41:51AM -0600, Blair Lowe wrote:
[EMAIL PROTECTED] etc]# psql temp99
Welcome to psql 7.3.4, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g
Scott Marlowe wrote:
If you need a unique constraint on the text field anyway, and it's a
natural key, you're generally better of using that field as the pk.
However, if it's not a natually unique key, then it shouldn't be the pk,
and int is a perhaps better choice.
There are two VERY
On Thu, 2006-11-05 at 18:44 +0200, Martijn van Oosterhout wrote:
On Thu, May 11, 2006 at 10:41:51AM -0600, Blair Lowe wrote:
[EMAIL PROTECTED] etc]# psql temp99
Welcome to psql 7.3.4, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with
Thank you again Joshua.
Perhaps I can ask you another question: How does the VACUUM FULL ANALYZE
differ from a reindex? A VACUUM FULL ANALYZE is outputting messages about
pages recuperated for indexes. Hence I was under the impression that
obsolete index pages were recuperated by the VACUUM
On Thu, 2006-05-11 at 11:43, Mark Gibson wrote:
Scott Marlowe wrote:
If you need a unique constraint on the text field anyway, and it's a
natural key, you're generally better of using that field as the pk.
However, if it's not a natually unique key, then it shouldn't be the pk,
select relname from pg_class where oid = 17736;
relname
-
bbs_auth_access
(1 row)
phpbb_mainlandpc= \q
To access this user's table, I can be logged on as anyone, and that is
expected in SQL when there are public grants.
I am not expecting to get everyone else's
Hi all,
I'm experiencing signal 11 (segmentation fault) failures on the
master node of a 3-node Slony-I cluster. In the past week, we've
averaged a little more than one segfault per day (11 times in the
past 10, including today). Any ideas what's going on?
Would anyone know how to
On May 9, 2006, at 11:26 AM, Joshua D. Drake wrote:
Of course not, but which drives lie about sync that are SATA? Or more
specifically SATA-II?
With older Linux drivers (before spring 2005, I think) - all of
them - since it seems the linux kernel didn't support the
write barriers needed to
It seems PostgreSQL doesn't have a TOP Predicate. Why is that? Here
is an example:
SELECT TOP 10 products from sales;
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
Richard Yen wrote:
Hi all,
I'm experiencing signal 11 (segmentation fault) failures on the master
node of a 3-node Slony-I cluster. In the past week, we've averaged a
little more than one segfault per day (11 times in the past 10,
including today). Any ideas what's going on?
Would anyone
Karen Hill [EMAIL PROTECTED] writes:
It seems PostgreSQL doesn't have a TOP Predicate. Why is that?
It's not in the SQL standard. If we were to implement something like
what I think you're asking for (your example is way underspecified),
it'd probably look like SQL2003's window functions.
On Thu, May 11, 2006 at 12:07:04PM -0700, Richard Yen wrote:
Hi all,
I'm experiencing signal 11 (segmentation fault) failures on the
master node of a 3-node Slony-I cluster. In the past week, we've
averaged a little more than one segfault per day (11 times in the
past 10, including
On Thursday 11 May 2006 16:34, Karen Hill wrote:
It seems PostgreSQL doesn't have a TOP Predicate. Why is that? Here
is an example:
SELECT TOP 10 products from sales;
Just for my understanding: This would return the 10 products with the most
matching sales rows, right?
jan
--
Karen Hill wrote:
It seems PostgreSQL doesn't have a TOP Predicate. Why is that? Here
is an example:
SELECT TOP 10 products from sales;
Just use:
SELECT product from sales limit 10
OR
SELECT products from sales order by products desc limit 10;
Joshua D. Drake
Have you tried using the LIMIT clause?
select porducts from sales limit 10;
http://www.postgresql.org/docs/8.1/interactive/queries-limit.html
On Thu, 11 May 2006, Karen Hill wrote:
It seems PostgreSQL doesn't have a TOP Predicate. Why is that? Here
is an example:
SELECT TOP 10 products
Hi,
I am having trouble with ident authentication. Everything is working
fine except when specifying host for connections on the local machine.
pg_hba.conf:
local all all ident wp
hostall all 10.97.8.0/24 ident wp
pg_ident.conf:
David Link [EMAIL PROTECTED] writes:
Does anyone know how I can test ident?
I'd try sniffing the IP traffic to and from it with a packet sniffer
and/or tracing the daemon's system calls with strace. Manually invoking
the daemon isn't going to prove a lot, you want to watch its reaction
to
Hi allI am writing an app that uses libpq, but because it is threaded I want to make sure that the dynamic library being used has been compiled with the right option.How do I do this?Is there a call such as "bool PQisThreadSafe()" that I can call?ThanksNicolas
On Tue, May 09, 2006 at 08:59:55PM -0400, Bruce Momjian wrote:
Joshua D. Drake wrote:
Vivek Khera wrote:
On May 9, 2006, at 11:51 AM, Joshua D. Drake wrote:
Sorry that is an extremely misleading statement. SATA RAID is
perfectly acceptable if you have a hardware raid
On Tue, May 09, 2006 at 12:10:32PM +0200, Jean-Yves F. Barbier wrote:
I myself can't see much reason to spend $500 on high end controller
cards for a simple Raid 1.
Naa, you can find ATA | SATA ctrlrs for about EUR30 !
And you're likely getting what you paid for: crap. Such a controller
You want an in-depth comparison of how a server disk drive is internally
better than a desktop drive:
http://www.seagate.com/content/docs/pdf/whitepaper/D2c_More_than_Interface_ATA_vs_SCSI_042003.pdf
BTW, someone (Western Digital?) is now offering SATA drives that carry
the same
Hi Martijn.
Martijn van Oosterhout wrote:
On Thu, May 11, 2006 at 02:55:04PM +0930, Luke Vanderfluit wrote:
Hi.
I've been able to compile postgresql on solaris 10.
Now I want to install the perl DBD::Pg module but I get a complaint, namely:
[EMAIL
On Thu, May 11, 2006 at 03:38:31PM -0700, Joshua D. Drake wrote:
You want an in-depth comparison of how a server disk drive is internally
better than a desktop drive:
http://www.seagate.com/content/docs/pdf/whitepaper/D2c_More_than_Interface_ATA_vs_SCSI_042003.pdf
BTW, someone
Joshua D. Drake wrote:
You want an in-depth comparison of how a server disk drive is internally
better than a desktop drive:
http://www.seagate.com/content/docs/pdf/whitepaper/D2c_More_than_Interface_ATA_vs_SCSI_042003.pdf
BTW, someone (Western Digital?) is now offering SATA
Well western digital and Seagate both carry 5 year warranties. Seagate I
believe does on almost all of there products. WD you have to pick the
right drive.
That's nice, but it seems similar to my Toshiba laptop drive experience
--- it breaks, we replace it. I would rather not have to
Joshua D. Drake wrote:
Well western digital and Seagate both carry 5 year warranties. Seagate I
believe does on almost all of there products. WD you have to pick the
right drive.
That's nice, but it seems similar to my Toshiba laptop drive experience
--- it breaks, we replace it.
On Thu, May 11, 2006 at 07:20:27PM -0400, Bruce Momjian wrote:
Joshua D. Drake wrote:
You want an in-depth comparison of how a server disk drive is internally
better than a desktop drive:
Jim C. Nasby wrote:
On Thu, May 11, 2006 at 07:20:27PM -0400, Bruce Momjian wrote:
Joshua D. Drake wrote:
You want an in-depth comparison of how a server disk drive is
internally
better than a desktop drive:
Tom Lane wrote:
Karen Hill [EMAIL PROTECTED] writes:
It seems PostgreSQL doesn't have a TOP Predicate. Why is that?
It's not in the SQL standard. If we were to implement something like
what I think you're asking for (your example is way underspecified),
it'd probably look like SQL2003's
Is there a GUI interface to the database like Enterprise Manager for
Microsoft SQL Server?
Thanks
Bart Butell
Sasquatch Engineering
email:[EMAIL PROTECTED]
cell: 503 703-0044
Carlos Oliva [EMAIL PROTECTED] writes:
In the mean time maybe I can ask you: Does VACUUM FULL ANALYZE of a
database would also reindex the user indexes of a database? I am trying to
eliminate index bloating.
VACUUM FULL not only doesn't do a REINDEX for you, it's more likely to
bloat the
Hmm... I should figure out how to have OS X email me daily log updates
like FreeBSD does...
Logwatch.
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL
Bart Butell wrote:
Is there a GUI interface to the database like
Enterprise Manager for
Microsoft SQL Server?
A couple of big ones are pgAdmin3 and phppgadmin
pgAdmin3 is a desktop app and looks like Enterprise Mgr. If you are
used to Enterprise mgr, it can be almost good
Jan de Visser wrote:
On Thursday 11 May 2006 16:34, Karen Hill wrote:
It seems PostgreSQL doesn't have a TOP Predicate. Why is that? Here
is an example:
SELECT TOP 10 products from sales;
Just for my understanding: This would return the 10 products with the most
matching sales rows,
And then there is PG Lightning Admin (which I like quite a bit). EMS
has a GUI, although it has some limitations and I've heard that the folks that
do the MySQL GUI have developed one for PostgreSQL. Almost an
embarrassment of riches!
Michael Schmidt
- Original Message -
Bart Butell wrote:
Is there a GUI interface to the database like Enterprise Manager for
Microsoft SQL Server?
Thanks
Bart Butell
Sasquatch Engineering
email:[EMAIL PROTECTED]
cell: 503 703-0044
Your in Luck Bart,
Check out PG Lightning Admin, it was developed initially for
70 matches
Mail list logo
