that row numbers
being out of order would never happen between two rows that do not have
ordinal equivalence?
Best,
Fred
(If so, in these scenarios I could safely order by row_number as secondary
ordering without losing the correct primary sorting order. Of course, for
cursor-based paginat
mic-schema generation action happening here and are using
unions for at least the time-being. Potential perf issues aside, we just
wanted to be aware of the limits if there were any.
Thanks again.
On Oct 30, 2010, at 3:22 AM, Scott Marlowe wrote:
> On Fri, Oct 29, 2010 at 3:11 PM, Fred Miller w
What is the maximum number of tables allowed in a union in 8.4 and 9.0?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
What is the max number of tables allowed in a union (in 8.4 and 9.0)?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
some data and use pgAdmin III 1.8.4 to view the
date "View date> first top100 rows". the question is: in what timezone are
the fields showed in pgAdmin? no timezone (as stored), the server time zone
or the time zone of the computer where pgAdmin runs?
Thanks
Fred
Thanks Gerhard, interesting but I wonder if it is a maintained project, the
files date from May 2008 and there is not much forum activity. I'll out it
on my list of "To be investigated".
Fred
On Wed, Aug 26, 2009 at 22:26, Gerhard Heift <
ml-postgresql-20081012-3...@gheift
ddate) and point to that from my events table. That
would eliminate the duplicate ranges, costing a join to find the events
within a date range, but maybe improving the search performance for events
that overlap a certain date range. Any feedback on that?
Thanks
Fred
On Tue, Aug 25, 2009 at 18:52
ch the pdf docs and online without finding what an "operator class"
for DATE would be. Would a multi-column index help in that case (OVERLAPS
and dates comparison) anyway? Or should I just define an index for each of
the dates?
Below are the table and index defintions.
Thanks
Fred
On 10/1/06, Fred Tyler <[EMAIL PROTECTED]> wrote:
> However, my machine looses between 500 M and 800 M in two weeks, and
> within that time, I restart pg only very few times, say 3-4 times.
> Does pg allocate other shmem blocks? If there is really a kernel memory
> problem i
OK, that kills the theory that the leak is triggered by subprocess exit.
Another thing that would be worth trying is to just stop and start the
postmaster a large number of times, to see if the leak occurs at
postmaster exit.
It is not from the exit. I see the exact same problem and I never
rest
> Tonight I am going to upgrade postgres on the first machine and see if
> it makes any difference, but it'll be about a week before I know for
> sure if memory is still being lost (it's such a slow leak that you
> cannot tell with just a couple days).
I use the latest 8.1.4 postgres software on
However, my machine looses between 500 M and 800 M in two weeks, and
within that time, I restart pg only very few times, say 3-4 times.
Does pg allocate other shmem blocks? If there is really a kernel memory
problem in shmem, how can I loose so much memory?
This is the same thing I am seeing --
at character 284
LINE 7: WHERE t2.name = 'blood_coagulation' and g.term1_id=1
Let me know if you need details concerning the tables but I don't think
it is necesseray.
Hopefully I did a newbie mistake.
Thanks in advance,
Fred
---(end of broadcast)
g at start of the installation.
Does any one have any idea what is going.
Thanks
Fred Cunningham
that worked :) thanks for your input
fred
On Tue, 2005-03-15 at 18:00 +, Ragnar Hafstað wrote:
> On Tue, 2005-03-15 at 18:18 +0100, Fred Blaise wrote:
> > While I have accomplished what I needed with the pgedit script given by
> > John, I am still curious as to why mine
of PL/pgSQL function "fred_on_all" near line 8
If anyone could shade some lights...
Much appreciated.
fred
On Tue, 2005-03-15 at 15:35 +0100, Fred Blaise wrote:
> Hello all
>
> I am trying to grant privs to a user on all tables. I think I understood
> there was no co
On Tue, 2005-03-15 at 09:58 -0500, John DeSoi wrote:
> Hi Fred,
>
> On Mar 15, 2005, at 9:35 AM, Fred Blaise wrote:
>
> > I am trying to grant privs to a user on all tables. I think I
> > understood
> > there was no command to do that :// so I wrote the fol
yscript.sql. It returns CREATE
FUNCTION, but I cannot see anything. The tables are not granted, etc...
Also I am trying to find out how to debug this. How can I print out to
STDOUT the value of t for example?
Thanks for any help
Best,
fred
signature.asc
Description: This is a digitally signed message part
the help.
Best,
))fred
signature.asc
Description: This is a digitally signed message part
g is crashed
and these errors do not seem to affect the query
results.
What do these errors
mean and how can I correct them ? Do they have any impact on the performance of
my queries (I am doing a performance test on a large volume of
data) ?
TIA.
Fred
Did you know what is the maximum character length for a name of :
a database or schema ?
a table or a view ?
a column ?
a constraint ?
an index ?
thanks
--
Frédéric BROUARD, MVP SQL Server. Expert SQL / spécialiste Delphi, web
Livre SQL - col. Référence : http://sqlpro.developpez.com
.
What is Slony-I ? Is it a commerical software ? Is there a website I can
read more about it ?
Thanks.
Fred
- Original Message -
From: "Gregory Wood" <[EMAIL PROTECTED]>
To: "Andrew Sullivan" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thur
On Wed, 2004-03-10 at 15:30, Tom Lane wrote:
> "Fred Moyer" <[EMAIL PROTECTED]> writes:
> >> This is just a Seq Scan where a numeric field must be updated to
> >> NULL but if I run it you can see that this simple query takes
> >> forever (762868
but the documentation there is quite sparce. I'd also like to
know the meaning of the fields in pg_ts_parser and what to do if I want to
configure my own parser into tsearch2.
Thanks.
Fred
er will fill it on the above sql.
the log file if filled with blank lines?!
over 4 gig of em in just a few minutes.
any ideas?
I expect the sql to grow by at least another 25 AND clauses. Is this sql too
long?
where would I look for docs specifying the length of an SQL statement?
Thank You
Fr
A
|NULL | NULL | NULL | |
| pinndx | 1 | valuendx |1 | value | A
|NULL | 30 | NULL | |
++++--+-+---
+-+--++
; 2^24
> LONGBLOB,
> LONGTEXT L+4 bytes, where L < 2^32
> ENUM('value1','value2',...) 1 or 2 bytes, depending on the number of
> enumeration values (65535 values maximum)
> SET('value1','value2',...) 1, 2, 3, 4 or 8 bytes, depe
27;,...) 1 or 2 bytes, depending on the number of
enumeration values (65535 values maximum)
SET('value1','value2',...) 1, 2, 3, 4 or 8 bytes, depending on the number of
set members (64 members maximum)
Fred
-Original Message-
From: Bruce Momjian [mailto:[EMAIL PRO
in the
PostgreSQL database, it is unclear to me what is taking up so much space.
Performance and capabilities (and the cost of disk space) aside, this is a
major problem for me. If anyone can shed some light on this I would
appreciate it.
Thanks, Fred
PostgreSQL schema
CREATE SEQUENCE
\usr\local\pgsql\bin\postgres.exe: ***
> recreate_mmaps_after_fork_failed
--
Fred Yankowski [EMAIL PROTECTED] tel: +1.630.879.1312
Principal Consultant www.OntoSys.com fax: +1.630.879.1370
OntoSys, Inc 38W242 Deerpath Rd, Batavia, IL 60510, USA
d .bashrc files won't apply to the
service since it isn't run in the context of bash/sh. The Cygwin
/usr/bin (or /bin) folder should be in PATH too so that
postmaster/postgres can call system() on utilities like 'rm' and 'cp'.
--
Fred Yankowski [EMAIL P
ipc-daemon so that it can install and
run itself directly as an NT service.
I've also thought about hacking postgres to run directly as an NT
service, but that plan got only a tepid response when I proposed it to
the 'hackers' list, so I'm shelving it for now.
--
Fred Ya
http://www.neuro.gatech.edu/users/cwilson/cygutils/V1.1/cygipc/index.html
--
Fred Yankowski [EMAIL PROTECTED] tel: +1.630.879.1312
Principal Consultant www.OntoSys.com fax: +1.630.879.1370
OntoSys, Inc 38W242 Deerpath Rd, Batavia, IL 60510, USA
configuration that caused the regression
test data files to be interpreted in 'textmode', thereby causing
spurious differences.
--
Fred Yankowski [EMAIL PROTECTED] tel: +1.630.879.1312
Principal Consultant www.OntoSys.com fax: +1.630.879.1370
OntoSys, Inc 38W24
I see that the genbki.sh file in backend/catalog has some sed strings
like these:
-e "s/[ ]NameData/\ name/g" \
-e "s/^NameData/\name/g" \
Those look bogus to me. I wonder if that '\n' becomes newline for
some versions of shell and/or sed?
--
F
following error:
> "ERROR: Error: unknown type 'ame'." still with this version. Clearly
> something is wrong. Does anyone have any ideas?
--
Fred Yankowski [EMAIL PROTECTED] tel: +1.630.879.1312
Principal Consultant www.OntoSys.com fax: +1.630.
risons in a WHERE clause between
'date' and 'timestamp' values? I have a case where I want to select
all calendar events whose date is the current date or later. The date
of the calendar item/row is given by a daStart column of type 'date',
and I've been doing
I thought I just answered this a day or two ago. Check out freshmeat.net for
pgaccess. It's a TCL program that looks real similar to MS Access but is for
contacting PostgreSQL databases. Runs on Unix and Windows.
HTH,
Fred Reimer
On Fri, 11 Apr 2036, "Germán" Largo Urr
38 matches
Mail list logo
