I was.
I stopped my live instance, reran 'make check', and make check passed.
Thanks for the pointers.
Tim Hart
Software Consultant
615-713-9956 :cell
tjhart :AIM
th...@me.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription
All,
I've been installing postgres from source on os x for years, but I haven't
generally run 'make check' before I install. I don't feel that running 'make
check' is terribly necessary in this case - it's a personal sandbox on my
laptop, with no production value. Regardless, I realize that it'
On 8/10/09 12:08 PM, "Sam Mason" wrote:
> On Tue, Aug 11, 2009 at 12:41:47AM +0800, Juan Backson wrote:
>> I used PQstatus(conn) function to check connection status, but I found that
>> it still returns CONNECTION_OK even after postgres is restarted. Does
>> anyone know if there is another comm
On Jan 11, 2009, at 8:16 PM, Jeff Davis wrote:
On Sun, 2009-01-11 at 17:13 -0600, Tim Hart wrote:
Would it be worthwhile to specify this in the documentation? One of
the sources of my confusion was the following statement:
http://www.postgresql.org/docs/8.3/interactive/app-psql.html
On Jan 11, 2009, at 4:41 PM, Jeff Davis wrote:
On Sun, 2009-01-11 at 15:33 -0600, Tim Hart wrote:
tjhart=# set search_path to foo, public;
SET
tjhart=# \d
List of relations
Schema | Name| Type | Owner
+---+---+
foo| bar_table | table | tjhart
This is a minor issue. Not really a problem for me at the moment, but
I wanted to understand if it was intended:
tjhart=# \d
No relations found.
tjhart=# \dn
List of schemas
Name| Owner
+--
information_schema | postgres
pg_catalog |
).
But in the general case, do I have to pay special attention with
unions in subselects?
Tim Hart
615-713-9956 :cell
timothyjhart :Y!
tjh...@me.com :AIM
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Feb 18, 2008, at 12:10 AM, Tom Lane wrote:
Would it have been reasonable to expect some kind of notice or warning
message stating that 'position' was special, and
position would be used instead?
The way you phrase that makes me think you misunderstand what's
happening here. The name of th
On Feb 17, 2008, at 11:21 PM, Tom Lane wrote:
The reason "position" is special is that the SQL spec calls out weird
specialized syntax for it:
Given the spec, I completely understand.
Given the roundabout way I discovered the nature of the problem, I'm
curious:
At the time I executed the
I sent the original question. I
sent a follow-up covering that. What I didn't state in that e-mail was
that I tried to create an enum type that was another name in the list
which was non-reserved (cannot be function or type). In that case, I
did see the automatic quoting behav
ted. ;)
Tim
Begin forwarded message:
From: Tim Hart <[EMAIL PROTECTED]>
Date: February 17, 2008 8:24:44 PM CST
To: pgsql-general@postgresql.org
Subject: Question about the enum type
I was playing around with the enum type today. I was toying around
with a schema to model information abo
ate type select as enum('foo');
ERROR: syntax error at or near "select"
LINE 1: create type select as enum('foo');
^
I'm just toying around, so this isn't high priority. I'll probably
change the name of the enum to fielding_p
I can’t say for certain from the detail
you’ve given, but partial indexes may be an acceptable solution to your
problem.
http://www.postgresql.org/docs/8.1/interactive/indexes-partial.html
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On
Behalf Of Roy Souther
Sent: Th
Wouldn't you run into driver problems if you tried to restore a 20 year old
image? After all, you probably won't be using the same hardware in 20
years...
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Jan Wieck
Sent: Wednesday, July 12, 2006 9:26 AM
To:
>From a brief and similar session (below), perhaps the best solution is to
simply insert a space between the '=' and the '-'??
Welcome to psql 8.1.4, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql co
I'm coming in a bit late to this conversation, so forgive me if I've missed
something. Isn't this problem the reason that connection pools were created?
In a connection pool, connections are only associated with a particular
user for the duration of a transaction. Once the transaction is complet
This reminds me of my favorite Bertrand Russell quote:
"The difference between theory and practice is: in theory there is no
difference, but in practice, there is"
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Florian G. Pflug
Sent: Wednesday, June 28,
While this statement is accurate, it isn't very precise. Needs change.
Requirements change. Usage changes. Any one of these changes can
invalidate a very correct initial analysis. A wise designer anticipates
change to minimize impact on both current work *and* future development
effort. Artific
ty. This isn't anything I have a
real need for.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Tom Lane
Sent: Wednesday, June 07, 2006 9:37 AM
To: Tim Hart
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] What are the characteristics of a good us
the matter?
Tim Hart
List,
I have a client process that is causing some performance issues with my app. On
my current platform, the standard automated profiling tools are not available.
Consequently, I can't easily determine where the bottleneck is in the process.
I have an inkling that rewriting the client process
e
database', whether it be in schema design or triggers, and how much
should be in the software that accesses the database. All opinions on
this are welcome.
Tim Hart
Senior Java/J2EE developer
[EMAIL PROTECTED] :email
(312)560-4267 :phone
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
22 matches
Mail list logo
