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
> LD_RUN_PATH="/usr/local/p
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 via
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 a
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 'login_
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 positives,
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. W
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 overal
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 al
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,
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 pg_hba.con
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-clas
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 cha
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_re
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 aft
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 cat
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 rec
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
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 does
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
http://www.amsoftwared
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: selec
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 includ
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 trying
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?
http://www.commandprompt.co
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 PQresultErrorFie
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.
>
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
>
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 opposit
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
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 FULL
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 t
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 stu
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 track
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 forc
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, includ
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 fro
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 Pos
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 hard
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 contro
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 MTBF
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 PROTECTED]
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
> >
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
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 replace
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,
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:
> > >>
> > >>
> > >> http://www.seagate.com/content/docs/pdf/whitepaper/D2c_More_than_In
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:
> > > >>
> > > >>
> > > >> http://www.seag
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
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 t
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 so
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 e
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
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 -
Fr
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 us
On Thu, May 11, 2006 at 09:52:41 -0600,
Mark Gibson <[EMAIL PROTECTED]> 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?
You probably want to use 'text
71 matches
Mail list logo
