Sean Chittenden wrote:
If you want to suppress *all* pg_temp_ schemas from the \dn listing,
that would be defensible maybe. I'd be inclined to say that
pg_toast should be hidden as well if that approach is taken, because
then you are basically saying that \dn is not the truth but only
I have heard that postgres will not use an index
unless the field has a not null constraint on it. Is that
true?
Tom, this discussion brings up something that's been bugging me about the
recommendations for getting more performance out of PG.. in particular the
one that suggests you put your WAL files on a different physical drive from
the database.
Consider the following scenario:
Database on drive1
WAL
scott.marlowe wrote:
Was there a performance difference in the set with write cache on or off?
Yes - just in the process of a little study concerning this - I will
post some preliminary results soon
cheers
Mark
---(end of broadcast)---
TIP
Ron wrote:
...
If you are just running the occasional query and want the results placed
into an Excel spreadsheet, you should look at pgAdmin. You run it from
your windows box and you can run queries and have the results displayed
- on screen, -written to a file, -or to an Excel spreadsheet.
Thanks! Now it is much, much more clear. It leaves me with a few
additional questions though.
Question 1:
we have no portable means of expressing that exact constraint to the
kernel
Does this mean that specific operating systems have a better way of dealing
with this? Which ones and how? I'm
Rick Gigger [EMAIL PROTECTED] writes:
we have no portable means of expressing that exact constraint to the
kernel
Does this mean that specific operating systems have a better way of dealing
with this? Which ones and how?
I'm not aware of any that offer a way of expressing write these
Rick Gigger wrote:
I have heard that postgres will not use an index unless the field has
a not null constraint on it. Is that true?
I have never heard that. There are some oddities with using an Index.
For example,
if you are using a bigint you need to '' the value or if you are using
an
On Tue, Oct 28, 2003 at 12:17:59AM -0500, Tom Lane wrote:
Rick Gigger [EMAIL PROTECTED] writes:
Do serial ATA drives suffer from the same issue?
Um, not an expert, but I think ATA is the same as IDE except for bus
width and transfer rate. If either one allows for multiple concurrent
Hi everybody, can anyone tell me if there's a way to retrieve the select
instruction executed from the catalogs, or maybe via some structure in a
trigger?
The reason is that i have some selects constructed on-the-fly (just part of
it) and i want to save that in a table in order to know what
Martijn van Oosterhout [EMAIL PROTECTED] writes:
Well, some googleing around seems to indicate that Serial ATA I/ATA-6 has
Tagged Command Queueing (TCQ) which is adding this feature specifically.
Whether it is a mandatory part of the spec I don't know.
Yeah? If so, and *if fully implemented*
Hi!
We're trying to call a set-returning stored procedure
from Excel (MS Query). To do this we type:
select * from getStudents()
(where getStudents() is the stored procedure).
The problem is that MS Query interprets this as if
getStudents was a table, and complains that there is
no table called
Hi,
This might be useful
www.etooss.com
Ben
Thanks Shridhar!
Works like a charm!
/tomas, Patrik and Siv.
--- Shridhar Daithankar
[EMAIL PROTECTED] wrote:
On Tuesday 28 October 2003 16:06, Tomas Larsson
wrote:
Hi!
We're trying to call a set-returning stored
procedure
from Excel (MS Query).
Create a dummy table and a rule
I haven't used PostgreSQL for nearly a year now, and when I was last
using it there was some discussion on versioning control being
introduced as a feature. Basically, for some data, I'd like to keep
track of who changed it, when, and to what. I know I could include
multiple values in the schema,
On Tuesday 28 October 2003 16:06, Tomas Larsson wrote:
Hi!
We're trying to call a set-returning stored procedure
from Excel (MS Query). To do this we type:
select * from getStudents()
(where getStudents() is the stored procedure).
The problem is that MS Query interprets this as if
Are presently converting from mysql to postgresql, and my first
newbiequestion is how to make all the rows in a result from a select
just swosh by? That is, I dont want to see them page for page; just
to scroll by so I can se the last line with the number of corresponding
rows.
And is there a
hi,
i have a table with test_field of type TEXT. when i do:
select test_field from test where id=1;
the connection (with psql) hangs and no output is received, so i have to
kill psql.
this occurs, at first sight, if length(test_field)32748.
i think, in more general, the problem occurs, when
On Tue, Oct 28, 2003 at 12:37:29 +0100,
Christian Wetzig [EMAIL PROTECTED] wrote:
i can do the same without any problems, if i connect without ssl or via
local socket. the problem also occurs with DBI. so, i think it's not a
psql issue.
i'm using Postgres 7.3.4 on slackware 9.0 with
On Tue, 2003-10-28 at 07:04, Shridhar Daithankar wrote:
On Tuesday 28 October 2003 17:13, Alex Page wrote:
I haven't used PostgreSQL for nearly a year now, and when I was last
using it there was some discussion on versioning control being
introduced as a feature. Basically, for some data,
2003-10-28 kl. 14.33 skrev Jeff:
1. in psql, \pset pager will turn paging off.
Although, if you really want a row count, a much better way to do that
is select count(*) from [rest of select statement]
Thanks.
I'm not new to SQL, just to postgresql, so I know about the
Count-function ;)
Reason
On Tuesday 28 October 2003 17:13, Alex Page wrote:
I haven't used PostgreSQL for nearly a year now, and when I was last
using it there was some discussion on versioning control being
introduced as a feature. Basically, for some data, I'd like to keep
track of who changed it, when, and to what.
On Tue, Oct 28, 2003 at 09:03:12AM +, Jaime Casanova wrote:
Hi everybody, can anyone tell me if there's a way to retrieve the select
instruction executed from the catalogs, or maybe via some structure in a
trigger?
You could turn on query logging and read the Postgres logs.
A
--
On Wed, Oct 29, 2003 at 01:24:56AM +1100, Brendan Jurd wrote:
from your question that you are), then the results are reported back via
the utility less (or a less-like program internal to psql, can someone
else clarify?)
Actually, it's your $PAGER environment variable (and there's the
usual
And here are are the default settings for OS X 10.2.6:
sysctl -w kern.sysv.shmmax=4194304
Well, I can only say that if I lower shmmax to that value, initdb picks
max_connections = 50
shared_buffers = 300
I just did a fresh install of 7.4b5 on a fresh install of MacOS 10.3, and initdb
Ron Johnson wrote:
On Tue, 2003-10-28 at 07:04, Shridhar Daithankar wrote:
Actually it could be a nice feature if we could access them. For certain
applications, having entire database audited is like dream come true. Of
course it has to provide timestamps/transaction ids as well but in general
Slightly off topic confirmations...
And here are are the default settings for OS X 10.2.6:
sysctl -w kern.sysv.shmmax=4194304
Seems to be the default on 10.2.8 as well.
10.1.5 doesn't seem to have a kern.sysv.* section:
[broccoli:~] erics% sysctl kern.sysv.shmmax
second level name sysv in
hi
I have menu table:
id | integer | not null default
nextval('public.menu_id_seq'::text)
parent_id | integer |
description | text|
I do select:
test= SELECT * FROM connectby('menu','id','parent_id','2',0,'~') t(id
integer, parent_id integer, level int, branch
BenLaKnet wrote:
I use postgresql 7.2.3
How can I use connectby ??
Must I install files ? or packages ? or it is recommanded to upgrade
dataserver ?
You need to upgrade. Either install 7.3.4 or wait a few weeks and
install 7.4 when it is released.
Joe
---(end of
29 matches
Mail list logo