On Mon, Nov 11, 2013 at 10:26 PM, Tom Lane wrote:
> Jeffrey Walton writes:
>> From below, I'm thinking --inputdir might not be quite correct. `mkdir
>> ./testtablespace` creates testtablespace in regress/, not input/. I'd
>> like to try --inputdir=./input/.
>
Thanks Tom.
On Mon, Nov 11, 2013 at 8:51 PM, Tom Lane wrote:
> Jeffrey Walton writes:
>> The following dropped out of `make check` for Postgres 9.3.1.
>
> Sure you've got a complete source tree? There ought to be files in
> that directory:
>
> $ ls src/test/regre
The following dropped out of `make check` for Postgres 9.3.1.
Any ideas how to clear the error? I could not locate answers when
searching the phrase.
Thanks in advance.
**
$ make check
...
mkdir ./testtablespace
../../../src/test/regress/pg_regress --inputdir=.
--temp-install=./tmp_che
On Mon, Nov 11, 2013 at 2:00 AM, Tomas Vondra wrote:
>
>> Would someone know the best way to get this to the right folks?
>>
>> Thanks in advance. (And sorry reporting to pgsql-general - the
>> developer list states emails must go elsewhere first).
>
> IMHO pgsql-hackers is the right audience for
I've been tasked with a quick acceptance check of Postgres for an
upcoming project. It's a quick check, so its limited to Clang's
analyzer and sanitizers.
The analyzer is reporting some findings, and some of the findings look
legitimate.
For example, it looks like there's a double `free` occurrin
Good Morning Laurenz,
That worked perfectly.
Thank You
Jeff
_
Jeffrey Schade
Systems Consultant, Technology Engineering
ISO
545 Washington Boulevard
Jersey City, NJ 07310
Voice: (201) 469-3738
FAX: (201) 748-1500
jsch...@iso.com
-Original
suggestions would be appreciated.
Jeff
_
Jeffrey Schade
Systems Consultant, Technology Engineering
ISO
545 Washington Boulevard
Jersey City, NJ 07310
Voice: (201) 469-3738
FAX: (201) 748-1500
jsch...@iso.com <mailto:jsch...@iso.com>
This em
suggestions would be appreciated.
Jeff
_
Jeffrey Schade
Systems Consultant, Technology Engineering
ISO
545 Washington Boulevard
Jersey City, NJ 07310
Voice: (201) 469-3738
FAX: (201) 748-1500
jsch...@iso.com <mailto:jsch...@iso.com>
This em
ving a non-deterministic network.
Thanks for all the help.
Regards,
Jeff
On 15/02/13 10:52, Stephen Frost wrote:
* Jeffrey Jones (jjo...@toppan-f.co.jp) wrote:
I downloaded
http://yum.postgresql.org/9.2/redhat/rhel-6Server-x86_64/repodata/primary.sqlite.bz2
using wget on the afected computer and
Hi Stephen.
On 15/02/13 10:52, Stephen Frost wrote:
* Jeffrey Jones (jjo...@toppan-f.co.jp) wrote:
I downloaded
http://yum.postgresql.org/9.2/redhat/rhel-6Server-x86_64/repodata/primary.sqlite.bz2
using wget on the afected computer and ran md5sum over it with the
following result
really was a problem then I would have
expected sqliteman to fail reading the file.
Also: Is there a way to check the *actual* file that is downloaded by
yum itself?
cheers
Jeff
On 13/02/13 17:31, Jeffrey Jones wrote:
Actually, the URL for the meta-data file is right there in the error
Hello All
I have updated the gist with the correction and tried again this evening
but that error is still occurring.
Thanks
Jeff
On 14/02/13 09:06, Jeffrey Jones wrote:
Hi Devrim
Damn, sorry that was a typo, I had to manually copy the output, sorry.
Thanks
Jeff
On 14/02/13 01:08
Hi Devrim
Damn, sorry that was a typo, I had to manually copy the output, sorry.
Thanks
Jeff
On 14/02/13 01:08, Devrim GÜNDÜZ wrote:
Hi,
On Wed, 2013-02-13 at 17:49 +0900, Jeffrey Jones wrote:
I had to type from console to so maintain formatting I put it on a
paste site:
https
,
On Wed, 2013-02-13 at 17:27 +0900, Jeffrey Jones wrote:
I have run the commands as you specified but unfortunately the error
pops up again when I run yum makecache.
Same error? That is *almost* impossible -- makecache is the parameter to
get rid of that error, not to see that error. Could you
Actually, the URL for the meta-data file is right there in the error
message.
I will do a wget and see if I can see anything obviously wrong.
On 13/02/13 17:27, Jeffrey Jones wrote:
Hello Devrim
I have run the commands as you specified but unfortunately the error
pops up again when I run
information from what has been written already.
Is there a way I can get the metadata file directly so we can see the
raw file and compare it?
Thanks
Jeff
On 13/02/13 17:10, Devrim GÜNDÜZ wrote:
Hi,
On Wed, 2013-02-13 at 12:03 +0900, Jeffrey Jones wrote:
As I can tell the PostgreSQL 9.2 yum
the issue is, but would
you mind giving it another shot..? Things should be calming down at
this point.
Thanks!
Stephen
* Jeffrey Jones (jjo...@toppan-f.co.jp) wrote:
As I can tell the PostgreSQL 9.2 yum repository for use with RHEL6
(64bit) is broken.
On a fresh R
Hello all
As I can tell the PostgreSQL 9.2 yum repository for use with RHEL6
(64bit) is broken.
On a fresh RHEL6.3 (64-bit) installation, as root, run the following
commands:
rpm -i
http://yum.postgresql.org/9.2/redhat/rhel-6-x86_64/pgdg-redhat92-9.2-7.noarch.rpm
yum update
(As stated in
.
All help would be greatly appreciated.
Jeff
_
Jeffrey Schade
Systems Consultant, Technology Engineering
ISO
545 Washington Boulevard
Jersey City, NJ 07310
Voice: (201) 469-3738
FAX: (201) 748-1500
jsch...@iso.com <mailto:jsch...@iso.
(*)>1 )
I'm looking for a better way, since I am just adding the three columns
together right now.
Jeffrey
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
I have a table that looks like this:
homeidcity date measurement pre/post
123 san francisco 1/2/2003 1458 pre
123 san francisco NULL 1932 post
124 los angeles2/4/2005 938 pre
124 NULLNULL
On Apr 9, 12:47 pm, cr...@postnewspapers.com.au (Craig Ringer) wrote:
> On 8/04/2010 2:01 PM, JeffreyOtterywrote:
>
> > Running Windows XP Pro. Have been successfully using and deploying
> > postgres for 2 years.
>
> > When I try to Uninstall PostgreSQL 8.3 using Windows Add/Remove
> > Programs I g
Running Windows XP Pro. Have been successfully using and deploying
postgres for 2 years.
When I try to Uninstall PostgreSQL 8.3 using Windows Add/Remove
Programs I get this message:
Service "PostgreSQL Database Server 8.3' (pgsql-8.3) failed to start.
Verify that you have sufficient privileges to
On Mar 15, 7:23 pm, dp...@pgadmin.org (Dave Page) wrote:
> On Mon, Mar 15, 2010 at 1:04 AM, Jeffrey Ottery
>
> wrote:
> > Anyone have some idea how to do this? I am able to install my Win32
> > application but the postgeSQL install will not work. Any help or at
> > leas
Anyone have some idea how to do this? I am able to install my Win32
application but the postgeSQL install will not work. Any help or at
least a starting point would be appreciated.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://w
All right children. Recess is over, get back to work.
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Ed Koch
Sent: Wednesday, September 16, 2009 8:27 AM
To: 'mgai...@hotmail.com'; 'g...@seespotcode.net'
Cc: 'dmag...@gm
eadline 5.2 was installed during
the suse linux installation but it never installed the readline.h
file. Go figure.
--Jeff
Jeffrey Trimble
System LIbrarian
William F. Maag Library
Youngstown State University
330.941.2483 (Office)
jtrim...@cc.ysu.edu
http://www.maag.ysu.edu
http://digital.maag.ys
d reference to `tgoto'
/usr/local/lib/libreadline.so: undefined reference to `tgetnum'
/usr/local/lib/libreadline.so: undefined reference to `BC'
/usr/local/lib/libreadline.so: undefined reference to `tgetstr'
collect2: ld returned 1 exit status
configure:6370: $? = 1
configure:
e compiler isn't looking in the proper
directory.
Use --without-readline to disable readline support.
Jeffrey Trimble
System LIbrarian
William F. Maag Library
Youngstown State University
330.941.2483 (Office)
jtrim...@cc.ysu.edu
http://www.maag.ysu.edu
http://digital.maag.ysu.edu
On May 19
ib has the
libreadline.so.6, etc.
We are using readline 6.0 on Suse Linux 11. (kernel version:
2.6.27.21-0.1-pae)
Any ideas why configure is not able to find the readline.h when I am
telling where it is?
Thanks in advance.
--Jeff
Jeffrey Trimble
System LIbrarian
William F. Ma
re ignored. That's
fine, but
I need those options, how are they now accomplished with an existing
database
or a creation of a new database.
My assumption is that the java may be taken care of by the jbdc driver.
Any assistance is helpful.
TIA,
Jeffrey Trimble
System LIbrarian
William F
I have a table, queries, with a column value. There is a trigger on
this table that inserts into query_history for each update to value.
I'm trying to graph the query_history table, so I was using a custom
aggregate to turn it into an array:
CREATE AGGREGATE array_accum (anyelement)
(
sfunc = arr
Create a plpgsql function that reformats your row as an array.
Example:
I have a table named task_parameter with three columns:
Table "camera.task_parameter"
Column | Type | Modifiers
--+-
change t.date2< dates.date to t.date2+0= dates.date) and t.date2+0mailto:[EMAIL PROTECTED] On Behalf Of Jeff Amiel
Sent: Thursday, September 25, 2008 10:24 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] The planner hates me.
"PostgreSQL 8.2.4 on i386-pc-solaris2.10, compiled by GCC gcc (G
minor refinement on suggestion:
-- CTAS (create table as) is easiest way to create table with same
structure
create table foo as select * from orig_table;
-- truncate is much more efficient than delete
truncate orig_table;
-- unchanged
insert into orig_table select * from foo;
-- recompute statist
This will also work as long as the table isn't large or product is
indexed.
actually,its more likely product is indexed that criteria_1 or _2...
Note: in this case when there is a tie one provider is arbitrarily
selected
select mx.product,
mx.max_criteria_1,
(select provider fro
if criteria_1 and _2 are indexed:
select
mx.product,
p1.provider as best_provider_1,
mx.max_criteria_1,
p2.provider as best_provider_2
mx.max_criteria_2
from
(select
product,
max(criteria_1) as max_criteria_1,
max(criteria_2) as max_criteria_2
from
products_provi
Hoover, Jeffrey would like to recall the message, "[GENERAL] Complicated GROUP
BY".
Why are there too many to fix with ALTER?
Use SQL and the data dictionary to generate the DDL and pipe it into
psql (or spool it to disk and use that file as a sql script):
psql your_db_name -t -c "select 'alter table '||t.tablename||' rename
\"'||c.column_name||'\" to '||lower(c.column_name)||
On Fri, 2007-11-02 at 14:45 -0700, Joshua D. Drake wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> On Fri, 02 Nov 2007 13:49:27 -0700
> "Jeffrey W. Baker" <[EMAIL PROTECTED]> wrote:
>
> > Nested Loop Left Join (cost=13920.16..225757555
I was thinking that it might be nice to be able to tell postgres to
refuse to execute any plan with an estimated cost above some threshold.
For example, earlier today I produced this extremely bogus execution
plan with the following top line:
Nested Loop Left Join (cost=13920.16..2257575559347.46
On 6/17/07, Andrej Ricnik-Bay <[EMAIL PROTECTED]> wrote:
On 6/18/07, John K Masters <[EMAIL PROTECTED]> wrote:
> I feel somewhat embarrassed to post this but I can't get past the first
> post with Postgresql. I have installed onto a Debian testing system,
> created a space for the database clust
On 4/11/07, Raymond O'Donnell <[EMAIL PROTECTED]> wrote:
Hi all,
This is probably a very simple one, but I just can't see the answer and
it's driving me nuts. I have a table holding details of academic terms,
and I need an SQL query such that for any given term I want to find the
next term by s
On 4/11/07, Raymond O'Donnell <[EMAIL PROTECTED]> wrote:
Hi all,
This is probably a very simple one, but I just can't see the answer and
it's driving me nuts. I have a table holding details of academic terms,
and I need an SQL query such that for any given term I want to find the
next term by s
On 1/30/07, Peter Eisentraut <[EMAIL PROTECTED]> wrote:
This has been discussed about ten thousand times, and the answer is
still no.
How did we go from this?
To this:
It's already in the TODO list.
regards, tom lane
Perhaps we should be more diplomatic in our appr
Not exactly. SQL Analyzer also includes live monitoring of whatever queries
are coming into the database. You can achieve something similar by enabling
query logging in the settings.
On 1/8/07, Ian Harding <[EMAIL PROTECTED]> wrote:
There is no GUI tool that I know of, but there is EXPLAIN wh
How long has that been available for OS X? Last time I looked at it it
wasn't.
On 1/8/07, Dave Page <[EMAIL PROTECTED]> wrote:
> --- Original Message ---
> From: "Ian Harding" <[EMAIL PROTECTED]>
> To: "Jeffrey Melloy" <[EMAIL PRO
I have not heard of such a thing for PostgreSQL, although I am
sure the basic information you want could be obtained from logging
queries and timing.
- Ian
On 1/8/07, Jeffrey Melloy <[EMAIL PROTECTED]> wrote:
> Not exactly. SQL Analyzer also includes live monitoring of whatever
queries
&
On 1/8/07, Jeffrey Melloy <[EMAIL PROTECTED]> wrote:
Not exactly. SQL Analyzer also includes live monitoring of whatever
queries are coming into the database. You can achieve something similar by
enabling query logging in the settings.
On 1/8/07, Ian Harding <[EMAIL PROTECTE
On 24 Nov 2006 04:43:02 -0800, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
I just can't understand the use of this PGDATA variable!
-I am on FC3. (pgl 7.4)
-I am installing rpms and then running /etc/init.d/postgresql start
(which is done by default)
-The resulting "data" directory is in
On 10/20/06, Jean-Christophe Roux <[EMAIL PROTECTED]> wrote:
Hello,[snip]
none
of them will be inserted because the first insert is a primary key
violation. How can I have postgreSQL not mind about the error and
proceed to the next insert. I could send the inserts one at a time but
bundling them
Hopefully your pg_hba.conf files look more like:local all all trusthost all all 192.168.10.0/24 trusthost pgbench all
192.168.3.0/24 trustOn 27 Sep 2006 21:02:47 -0700, blackjadelin <
[EMAIL PROTECTED]> wrote:I have co
On 8/8/06, Michael Fuhr <[EMAIL PROTECTED]> wrote:
On Tue, Aug 08, 2006 at 12:16:18PM -0700, [EMAIL PROTECTED] wrote:
> I'd like to write a C Function for Postgresql that can access data in
> the database, use that to conduct additional queries to find more
> information in the database and event
Hello,
I'd like to write a C Function for Postgresql that can access data in
the database, use that to conduct additional queries to find more
information in the database and eventually return a result. I
currently have the functionality I want implemented as php/C programs
that first connect to
Oscar Picasso wrote:
HI,
I would like to implement a search by distance to my application.
Something like (pseudo sql):
select * from users
where users.location is less than 15 miles from chicago.
Any documentation on how to implements that?
I guess I also need a database of the cities coor
Patrick TJ McPhee wrote:
In article <[EMAIL PROTECTED]>,
Jim Nasby <[EMAIL PROTECTED]> wrote:
% Not sure if it's still true, but DB2 used to limit varchar to 255. I
% don't think anyone limits it lower than that.
Sybase: 254. Silently truncates.
IIRC, Oracle is 4096.
Jeff
---
Jimbo1 wrote:
Hello there,
I'm a freelance Oracle Developer by trade (can almost hear the boos now
;o)), and am looking into developing my own Snowboarding-related
website over the next few years. Anyway, I'm making some decisions now
about the site architecture, and the database I'm going to n
Atomicity, Consistency, Isolation and DurabilitySee:http://cegt201.bradley.edu/projects/proj2003/equiprd/acid.html
On 1/5/06, John Meyer <[EMAIL PROTECTED]> wrote:
Okay, what exactly is ACID compliance?---(end of broadcast)---TIP 6: explain analyze is
Andrus Moor wrote:
I have a table containing month column in format mm.
create table months ( tmkuu c(7));
insert into months values ('01.2005');
insert into months values ('02.2005');
How to create select statement which converts this column to date type
containing last day of month like
Mike Rylander wrote:
Mike Rylander wrote:
On 12/6/05, Marcus Engene <[EMAIL PROTECTED]> wrote:
[snip]
A & (B | (New OperatorTheNextWordMustFollow York))
Actually, I love that idea. Oleg, would it be possible to create a
tsquery operator that understands proximity?
This is a little vague...There is a way to recover the data. Make postmaster come back up. Unless you're talking about postmaster not coming up due to corrupted data files, or a hardware failure.You do need to use pg_dump at regular intervals. It is common practice to back up data, after all.
No
codeWarrior wrote:
SELECT trim(trailing ' ' from city_name) AS city_name FROM sys_cities;
You might consider reading the manual as there are a multitude of string
manipulation functions built into postgreSQL
You didn't answer his question. If you're going to rag on someone for
not read
On Oct 13, 2005, at 12:00 PM, Alex Turner wrote:
>
>Instance Manager: Uniquely MySQL. It allows things like starting
and
>stopping the database remotely.
>
>
I cannot think of a reason ever to need this when we have OpenSSH
I'm just curious, but how does this work for a windows bo
Joshua D. Drake wrote:
Bruce Momjian wrote:
Matthew Terenzio wrote:
As much as I respect Marc and Postgresql.org, I can't see Oracle
hiring him away as a "killer" threat to the community. People would
set up camp somewhere else, like Command Prompt. It would hurt
things for a while but t
Neil Conway wrote:
"COUNT(*) very slow": this is a known issue -- see the -hackers archives
for many prior discussions. MVCC makes this hard to solve effectively
(whether applications should actually be using COUNT(*) on large tables
with no WHERE clause is another matter...)
-Neil
And it's
Greg Stark wrote:
Bruce Momjian writes:
Well, I just added to TODO:
* Allow VIEW/RULE recompilation when the underlying tables change
Is dynamic view a industry-standard name? If so, I will add it to the
TODO.
"DYNAMIC" is something I made up.
"ALTER VIEW RECOMPILE" is O
On Jul 30, 2005, at 2:30 PM, Jon Christian Ottersen wrote:We are trying to find a good way to document our database design – what is the rationale behind each table/field, what kind of information is each field supposed to contain, perhaps also something about the linking between the tables etc. Is
h Group at...
http://groups.yahoo.com/group/electrogravityresearch/
Much respect,
Jeffrey N. Cook
Start your day with Yahoo! - make it your home page
I think a better approach is to handle configuration management with a
table in each schema. Update the schema, update the table. This works
well with automating database upgrades as well, where upgrades are written
as scripts, and applied in a given order to upgrade a database from release
A
D A GERM wrote:
I have been trying to write an sql statement that returns the same
hours in a time stamp no matter what the date.
I can to pull same hours on the the same days but have not been able
to figure out how to pull all the same hours no matter what the date.
Here is the one sql stat
I always thought I would not be the kind of person who writes to this
list asking why the planner is using a sequential scan. I always looked
upon such people as newcomers who would eventually learn the mysterious
wonders of the Pg query execution planner.
But really, this plan is bizarre! Why
Or
select date_part('day', date_trunc('month', '01/10/04') + '1
month'::interval - '1 day'::interval) as days;
or
select date_part('day', to_date('mon', 'Jan') + '1 month'::interval - '1
day'::interval) as days;
Arthur Hoogervorst wrote:
Hi,
Something like this?
SELECT date_part('day',
Chris wrote:
I know this isn't entirely postgresql specific, but it wouldn't be on
another list either so here goes...
I am writing an open source application where I would like to support
at least oracle, and possibly firebird or DB2, in addition to
postgresql which will be the default. I'm not g
Ragnar Hafstað wrote:
On Wed, 2005-01-05 at 13:03 -0800, Jeff Davis wrote:
On Wed, 2005-01-05 at 13:14 -0700, Michael Fuhr wrote:
On Wed, Jan 05, 2005 at 08:15:28PM +0100, Joost Kraaijeveld wrote:
[snip]
PostgreSQL
doesn't have materialized views per se but it does have function
Tom Lane wrote:
Jeffrey Melloy <[EMAIL PROTECTED]> writes:
I attempted to install 8.0 RC 2 alongside 7.4.5 on my OS X box, but
initdb failed with an error about not enough shared memory.
Don't forget that both shmmax and shmall may need attention ... and,
just to confuse matter
it:
http://www.visualdistortion.org/misc/dont_do_this.png)
Jeffrey Melloy
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
messa
If you want to return rows with zeros, you may need to do something like
this:
select b.name as viewer, count(viewerid)
from xenons b left join viewer_movies a on (b.id = a.viewerid)
group by b.name
Eddy Macnaghten wrote:
select b.name as viewer, count(*)
from viewer_movies a, xenons b
where b.id
Tom Lane wrote:
Jeffrey Melloy <[EMAIL PROTECTED]> writes:
I have a couple users trying to install Postgres on OS X. To the best
of my knowledge, both of them are using 7.4.5/10.3.5, and got identical
errors while trying to init the database:
They need to increase the system&#x
I have a couple users trying to install Postgres on OS X. To the best
of my knowledge, both of them are using 7.4.5/10.3.5, and got identical
errors while trying to init the database:
Reducing the shared buffers didn't help.
Any thoughts would be appreciated.
Jeffrey Melloy
[EMAIL PROT
On Wed, 2004-09-15 at 02:39, Michael Paesold wrote:
> Jeffrey W. Baker wrote:
>
> > Current issue:
> >
> > A dual 64-bit Opteron 244 machine with 8GB main memory, two 4-disk RAID5
> > arrays (one for database, one for xlogs). PG's config is extremely
> >
On Tue, 2004-09-14 at 14:45, Jim C. Nasby wrote:
> On Tue, Sep 14, 2004 at 11:11:38AM -0700, Jeffrey W. Baker wrote:
> > procs ---memory-- ---swap-- -io --system-- cpu
> > r b swpd free buff cache si sobibo incs us sy
On Tue, 2004-09-14 at 10:28, Vivek Khera wrote:
> > "SW" == Shane Wright writes:
>
> SW> But, we have now taken the plunge and I'm in a position to do some
> SW> benchmarking to actually get some data. Basically I was wondering if
> SW> anyone else had any particular recommendations (or requ
Oleg Bartunov wrote:
Marcel,
it's very difficult from you message where do you lost.
pgsql version, OS version, cut'n paste of commands you run and
output would be fine.
To install tsearch2 most people need (as postgresql superuser):
1. install postgresql and headers
2. cd contrib/tsearch2
3. make;
Recently, I decided to rename one of my schemas from "adium" to "im".
Then, all inserts started failing.
I recreated a couple functions, changed the search path, and all inserts
are still failing due to referential integrity checks going against
"adium" still. Is there any way I can fix this, sh
On Fri, 2004-05-14 at 20:55, Tom Lane wrote:
> Vivek Khera <[EMAIL PROTECTED]> writes:
> > "TL" == Tom Lane <[EMAIL PROTECTED]> writes:
> > TL> ... On looking at the code I see that it doesn't make any
> > TL> attempt to prune future log segments after a decrease in
> > TL> checkpoint_segments, so
On Thu, 2004-05-13 at 09:28, Tom Lane wrote:
> "Jeffrey W. Baker" <[EMAIL PROTECTED]> writes:
> > Sorry, my last mail got cut off. The server aborted because it couldn't
> > write the xlog. Looks like I omitted this from my last mail:
>
> Selective q
On Thu, 2004-05-13 at 06:10, Tom Lane wrote:
> "Jeffrey W. Baker" <[EMAIL PROTECTED]> writes:
> > Oh sure, it's bleating. Apparently my computer is too fast:
>
> I don't think the checkpoint process is completing.
>
> > May 12 16:37:08 mistra
Dear list,
We are using PostgreSQL with the database and xlogs on (separate) XFS
volumes under Linux 2.4.25. We are simply curious to hear your
experiences with this combination, if you are using it. In only two
days of heavy activity, we've already been able to corrupt one
database. We've also
hello
i have been used RH for over 5 yrs and some of our server are going to
RH AS and most of our workstations are moving to fedora
i have fedora servers in testing right now(PG 7.4 and 7.3) and have not
seen any major problems
as for extended rh9,7.. support you can check out
http://www.tummy.
I am trying to compile postgresql 7.4.1 for sco 5.0.5 and get the following error:
"thread.c", line 269: error: undefined symbol: h_errno
Any ideas?
./configure --with-libs=/usr/local/lib --with-includes=/usr/local/include
herbie!/tmp/postgresql-7.4.1 # gmake
gmake -C doc all
gmake[1]: Entering
On Thursday, October 9, 2003, at 01:42 AM, Shridhar Daithankar wrote:
[EMAIL PROTECTED] wrote:
One of my friend lost data with mysql yesterday.. The machine was
taken down for disk upgrade and mysql apperantly did not commit the
last insert.. OK he was using myisam but still..:-)
It sounds lik
If I'm understanding you correctly, you can do something like:
select cola,
colb,
exists
(select 'x'
from tableb
where colc = colb)
from tablea
Since that has a subselect, you may get better performance with
something li
On Thursday, August 28, 2003, at 09:03 PM, Williams, Travis L, NEO
wrote:
I have a table1 with 2 col (a & b) where b can sometimes be null. I
need a query that if B is null I get back the contents of A.. but if B
is not null I do a "select d from table2 where d like '%b%'" There is
nothing to jo
On Thursday, August 28, 2003, at 08:58 AM, Dennis Gearon wrote:
Heath Tanner wrote:
Not to take anything away from the books on the topic, but my
favorite source is the docs that got installed with postgres
(/usr/local/pgsql/doc/html).
The index isn't great, but easily overcome:
grep -i "sear
Hi,
I'll try to switch from Oracle to postgres for some small applications.
Is it possible to build functions like Oracle's nvl or decode with
pgplsql?
How can I make a function like nvl that works for every datatype?
Best regards,
Christian
Try coalesce. The syntax is the same as nvl.
Jeff
-
I was recently running into performance problems with a query
containing now()::date or CURRENT_DATE. When I went to debug,
'now'::date made efficient use of the index (on a timestamp field).
The docs say that 'now' is turned into a constant right away. Is this
overhead/poor planning simpl
If you don't mind spending a little money and are on Windows, you can
use Microsoft Visio Professional.
On Saturday, August 16, 2003, at 01:38 AM, Ron Johnson wrote:
On Thu, 2003-08-14 at 23:17, David Fetter wrote:
"Tim Edwards" <[EMAIL PROTECTED]> wrote:
I have been request to create a relati
It does if you look at the original email. Maksim must've just
transposed a couple letters when he was writing his demo.
Jeff
Kathy zhu wrote:
If it skips "-", then RMT-* should come before RM-V*, but they don't,
why ??
Maksim Likharev wrote:
en_US locale skips? punctuation from sorting in
If you use a serial datatype, it simply says "the *default* behavior is
to use the next value of sequence a". So you can insert 1, 2,
10,204,492 into the column just fine. However, by inserting data into
something you want to auto-increment, you can run into non-uniqueness.
(Like you were).
drop table A;
create table A (
id SERIAL PRIMARY KEY,
foo int default 5,
bar int default 10
);
insert into A (id, foo, bar) values (1, 1, 1);
insert into A (id, foo, bar) values (2, 2, 2);
insert into A (id, foo, bar) values (3, 3, 3);
insert into A (id, foo, bar) v
1 - 100 of 124 matches
Mail list logo
