...
- http://schemas.microsoft.com/win/2004/08/events/event";>
-
0
2
0
0x80
10901
Application
JWIN2012-11_1_2
-
Timed out waiting for server startup
v/r
Troy R. Hardin
From: Jeff Janes
Sent: Thursday, September 14,
up.
Are there known reasons why I might be having this issue? Anyone have
experience getting past something similar?
v/r
Troy R. Hardin
Hi,
I am looking for a way to get ora2pg on HP-UX11i23 with PG 9.3.2.
Thanks in advance,
Didier TROY
AP-HP/DSI/ATI/PACT
01 40 27 37 68
/bakineggs/recurring_events_for
--
Troy Rasiah
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
m sure i'm missing something obvious, can anyone help me
understand this better ?
Thanks
--
Troy Rasiah
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
(id)
"idxfti_idx" gist (idxfti)
"keyword_data_idx" btree (category)
"keyword_data_idx1" btree (keyword)
Foreign-key constraints:
"keyword_data_fk" FOREIGN KEY (category) REFERENCES categorys(categoryid)
ON UPDATE CASCADE ON DELETE CASCADE
g
Scott Marlowe wrote:
> On Sun, Aug 24, 2008 at 10:19 PM, Troy Rasiah <[EMAIL PROTECTED]> wrote:
>>
>> Scott Marlowe wrote:
>>> On Sun, Aug 24, 2008 at 8:43 PM, Troy Rasiah <[EMAIL PROTECTED]> wrote:
>>>> Sorry for bringing up an old post...If
Scott Marlowe wrote:
> On Sun, Aug 24, 2008 at 8:43 PM, Troy Rasiah <[EMAIL PROTECTED]> wrote:
>> Sorry for bringing up an old post...If you have a generic set of tables..
>>
>> eg. table of countries / post codes etc which are used across several
>> databas
up and db_link isn't needed anymore. I hope I won't run into
> anymore problems. :-)
> Regards.
Sorry for bringing up an old post...If you have a generic set of tables..
eg. table of countries / post codes etc which are used across several
databases what is the best way to access / s
Apologies if this has been posted somewhere else but what is the
equivalent of perl's \b in postgres regular expressions ?
--
Troy Rasiah
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/
http://archives.postgresql.org/pgsql-general/
--
Troy Rasiah
---(end of broadcast)---
TIP 6: explain analyze is your friend
sted, the user's browser is likely offering the user's tz
>> info...but I am interested in seeing someone's mature system for
>> returning the user's local time based their tz as stored in their
>> profile.
>
> I wouldn't trust the browser's TZ, and you would need a way to override
> it. So storing it in a table seems the easiest way.
>
--
Troy Rasiah
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
On Fri, 23 Feb 2007, David Fetter wrote:
> On Fri, Feb 23, 2007 at 08:28:06AM -0800, Richard Troy wrote:
> > On Fri, 23 Feb 2007, David Fetter wrote:
> > > On Fri, Feb 23, 2007 at 10:23:56AM +0100, Ben Edwards wrote:
> > > > Anyone know of any guidelines for
er versions. (We support versions of all five since about 1997 and,
as there were so many small changes along the way, we provide a
configuration mechanism where you can tell it the limitations of your
version such as attribute length, maximum length of varchar, etc.)
Regards,
Richard
--
Richa
hut down.
Try telling Postgres about your new pg_hba.cfg file by using
pg_ctl reload
I'm not aware why you couldn't just stop it with
pg_ctl stop
even with the wrong pg_hba.conf file.
HTH,
Richard
--
Richard Troy, Chief Scientist
Science Tools Corporation
510-924-1363 or 202-
at are NTP clients.
Regards,
Richard
--
Richard Troy, Chief Scientist
Science Tools Corporation
510-924-1363 or 202-747-1263
[EMAIL PROTECTED], http://ScienceTools.com/
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
likely find a summary and some URLs to
more complete information.
Richard
--
Richard Troy, Chief Scientist
Science Tools Corporation
510-924-1363 or 202-747-1263
[EMAIL PROTECTED], http://ScienceTools.com/
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
On Wed, 31 Jan 2007, Tom Lane wrote:
> David Fetter <[EMAIL PROTECTED]> writes:
> > On Tue, Jan 30, 2007 at 04:43:14PM -0800, Richard Troy wrote:
> >> ... different in my opinion if only Unix didn't have this asenine view
> >> that the choice between a
tem was down.
> It ticked me off because we ended up eating at some pricey cafe next
> door. I guess I'm a typical dumb American, traveling all the way to
> Paris to eat at McDonald's.
>
>
> Richard Troy wrote:
> > On Tue, 30 Jan 2007, Mark Walker wrote:
> >
aved!
Sure wish the Open Source OS people would get a clue; paying a percent or
so for reliability pays for itself thousands of times over and most
people, if knowledgeable, would choose to spend the overhead to have a
system that really is reliable.
Richard
--
Richard Troy, Chief Scienti
;t mean it's always good to go hog wild with any particular tool
set just because you can. Sometimes people over-use engine-side features,
forgetting that there are nearly always more cycles available on clients
than servers...
Richard
--
Richard Troy, Chief Scientist
Science Tools Cor
o do this cleanly is to use a
program that has the suid bit set so it runs as the program's file owner
(optionally group), and this program accesses the password and provides
the database access.
Richard
--
Richard Troy, Chief Scientist
Science Tools Corporation
510-924-1363 or 202-747-1263
[EM
e matter is a substantial
penalty for the offending party as this community is their target customer
base, so your obvious anger can be at least somewhat satiated.
Richard
--
Richard Troy, Chief Scientist
Science Tools Corporation
510-924-1363 or 202-747-1263
[EMAIL PROTECTED], http://ScienceTools.com
es material." So, rest
assured.
Richard
>
> Sincerely,
>
> Joshua D. Drake
>
>
>
>
--
Richard Troy, Chief Scientist
Science Tools Corporation
510-924-1363 or 202-747-1263
[EMAIL PROTECTED], http://ScienceTools.com/
---(end of broadcast)
ny
> > potential hits against the main table. And if
> > something like that does not exist yet, how difficult would it be to
> > construct such a solution out of many "spare parts"
> > that come with PG?
>
Try moving where the hash takes place - ie, us
the source code. Best would be in
the official documentation/on a web page.) On occasion, I could *really*
use such a list! (If such already exists, please point me at it!)
Thing is, Tom, not everybody has the same level of information you have on
the subject...
Regards,
Richard
--
Richard Troy, Chief S
> Richard Troy <[EMAIL PROTECTED]> writes:
> > See my post from a few minutes ago, but simply put, time/date is at least
> > as challenging as money or multibyte character. And, simply put, the
> > Postgres implementation of timezone is INSUFFICIENT.
>
> Reall
at it'll
always give me back the _same_exact_bits_ as what I gave it! Anything else
is horribly broken and is, to quote Tom Lane, "about as good a definition
of corrupted data as I can think of." - with appologies to Tom, of course.
Regards,
Richard
--
Richard Troy, Chief Scien
nothing broken about "timestamp without timezone"
within either the engine or the JDBC drivers, but I'd also caution to
always punt on the question of whether or not someone should or shouldn't
use Postgres' time zone feature. Perhaps a "for most people" qualifie
7 = hermaphrodite
8 = declined to state
9 = Neuter - Not applicable
Hmmm... Easy to write the various functions making this a new datatype...
Richard
--
Richard Troy, Chief Scientist
Science Tools Corporation
510-924-1363 or 202-747-1263
[EMAIL PROTECTED], http://ScienceTools.com/
-
sible in English anyway?
There are dozens if not hundreds of androgenous names - Pat and Tracy come
immediately to mind, and there are countless others!
RT
--
Richard Troy, Chief Scientist
Science Tools Corporation
510-924-1363 or 202-747-1263
[EMAIL PROTECTED], http://ScienceTools.com/
On Wed, 29 Nov 2006, Ritesh Nadhani wrote:
>
> Hello
>
> I have been working with wxWidgets and I didnt face a problem. What
> specific thing were broken in wxWidgets for Windows?
>
> Ritesh
PLEASE take this offline - it's not even close to Postgres related.
Richar
t do the job?
The answer is, it won't have the user base you're looking for.
Seems to me, you need to get back to square one: What problem(s) are you
trying to solve? And an answer that says, "Oh, all this DBMS admin stuff
and - eventually! - an app builder too!" is not
sion RDBMS in a way that's easily extensible,
or configurable, if you will. I think it's a lot harder to do than might
sound.
>
> I am cross posting this to various db mailing lists as well as relevant
> newsgroups to get maximum idea about it. You can also contact me
> direct
f course be wrong, though! OTOH, it would be much
faster. If the only down-side is occasionally giving users an incorrect
count, then perhaps call it a "row estimate", and let them marvel at how
accurate the estimate is most of hte time!
Good luck,
Richard
--
Richard Troy, Chief Scie
ely database and OS portable (or can be, at least), there's no
need for any super-user capability of any kind, you can use any kind of
trigger you like, and there's no permission leakage problem, either... I
guess all you need is functioning nohup capability (which Windows systems
ma
+0100
> From: Matthias Lüdtke <[EMAIL PROTECTED]>
> To: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Modifying SQL parser with extensions?
>
>
> Richard Troy wrote:
> > Our package lets you pass individual statements or entire files full
> > of SQL with emb
ts you pass individual
statements or entire files full of SQL with embeded comments as it's not
that uncommon among SQL dialects - they're just stripped out before
getting to the engine, as Alvaro suggested.
Regards,
Richard
--
Richard Troy, Chief Scientist
Science Tools
itches; the library that does this
magic is written in Java, and, it's not free. -smile-
Richard
--
Richard Troy, Chief Scientist
Science Tools Corporation
510-924-1363 or 202-747-1263
[EMAIL PROTECTED], http://ScienceTools.com/
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
ty, some twelve plus years after the
company's demise, still hangs to gether as Ex-Ingres - "Ingres Corporate
Culture without the corporation!"
In closing, I'd very much enjoy meeting folks from the PostgreSql team,
especially the core members. You'll find me at this talk/reception -
at or near "%"
--2) CREATE TYPE type1 AS (tvar_1 T_TABLE1.C_COL1, tvar_2 INTEGER);
XX ERROR: schema "T_TABLE1" does not exist
I don't want to asign it at the ROW level just Column. I got this stuff
all over and need a good conversion solution.
Any
huh never heard of that - I'll hold out testing it for now but thats
good info. (how does it know which partition - if there's 2?)
Troy H
---(end of broadcast)---
TIP 4: Have you searched our list archives?
ing partitions
will lose data structure - reformat required).
You could just pop in an additional harddrive (slave) and have it
formatted NTFS - then install it on that drive D:/postgres/
Not the answer you'd want but good luck.
Troy
---(end of broadcast)-
r know the difference. Put
just Postgres on the second hard drive (FORMAT IT NTFS FIRST).
hope it helps
Troy H
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
7;shorthand'. (I waisted a lot
of time not knowing this.)
Thanks
P.S. - Tom if the return of func2 = var_X = (10,5) how can I parse the
varible out like:
var_Y = var_X[1] -- first ARRAY item
to get var_Y = 10?
Troy H
---(end of broadcast)--
Unless I missed something, I think you can select on a fresh install
but not after. I doubt even an image could be switched but I could be
wrong, I am too often.
Troy
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ
to parse
results within functions.. any suggestions for me?
Thank you
Troy
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
pe is useful - good luck
Troy
---(end of broadcast)---
TIP 6: explain analyze is your friend
ted backup file and reinsert what you need...
Just my 2 cents
Troy
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
RAISE NOTICE ''found X = %'', X;
var_1 := X;
END
'
LANGUAGE 'plpgsql' VOLATILE;
- --- -
SELECT INTO returns first returned row. So if you called "SELECT
func1('P');" you'd get any books starting with the letter P. I'm sure
th
Yes, I'm a Newbie but I really like it so far except a few
misunderstandings I have, like INOUT. (I am using 8.1 beta 3 on both
WIN and FC w/ pgadmin III.)
I cannot use multiple in/out/inouts within functions to return results.
How can I use INOUTS the right way? Here I thought I'd get an updated
I was able to install PostgreSQL 8 Beta 2 with pgInstaller on Windows XP Professional
without any problems.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of BARTKO, Zoltán
Sent: Thursday, September 30, 2004 5:54 AM
To: [EMAIL PROTECTED]
Subject: [GENERAL
Title: PostgreSQL Optimizer
Hello,
Is PostgreSQL’s optimizer cost based or syntactical based?
Thank you!
right direction?
Thank you!
~ Troy Campano ~
user that has the privileges to only SELECT, INSERT, UPDATE, DELETE from objects in a certain database.
How do I grant these privs?
How do I prevent a user from dropping objects?
Thank you!
Troy Campano
Liberty Mutual
Infrastructure Software Engineering
Database Management
desk: (603) 245
write "CREATE" statements, and then build inserts from this data,
but this would be very time consuming and difficult to do.
Thanks!
~ Troy Campano ~
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Richard Huxton
Sent: Monday, June 07, 2004
= true
stats_reset_on_server_start = true
thank you!
Troy Campano
this:
a. CREATE DATABASE
mydb01 WITH LOCATION = ‘PGDATA01’;
b. CREATE DATABASE mydb02 WITH LOCATION = ‘PGDATA02’;
c. CREATE DATABASE mydb02 WITH LOCATION = ‘PGDATA03’;
Is this correct to get databases created on separate filesystems?
Thank you!
Troy Campano
3:23 PM
To: Joshua D. Drake
Cc: Campano, Troy; Postgres general mailing list
Subject: Re: [GENERAL] Database Size Limiting
Joshua D. Drake wrote:
> Hello,
>
> You could use Filsystem quotas but I strongly suggest against it as it
> will probably bring about database corruption.
ke [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 27, 2004 2:12 PM
To: Campano, Troy
Cc: Postgres general mailing list
Subject: Re: [GENERAL] Database Size Limiting
Hello,
You could use Filsystem quotas but I strongly suggest against it as it
will probably bring about database corruption.
A bette
limit how big a database can
be? Can you allocated space when the database is set up so you can say db1 can
only be 100 MB?
Thank you!
Troy Campano
Is there any way with SQL to get what I'm trying to get?
Where (in this month, April):
April 1 - 3 (Week 1)
April 4 - 10 (Week 2)
April 11 - 17 (Week 3)
April 18 - 24 (Week 4)
April 25 - 30 (Week 5)
Thank you!
~ Troy Campano ~
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[
te |to_char |to_char
2004-04-29 14:29:47.289369-04|2004-04-28 11:40:35|5/04/2004|4/04/2004
2004-04-29 14:29:47.289369-04|2004-04-29 13:26:34|5/04/2004|5/04/2004
thank you!
Troy Campano
Title: db_space
Is there a way to get the size of your PostgreSQL database using sql?
I need this for an inventory program.
Thanks!
Troy Campano
Liberty Mutual
Infrastructure Software Engineering
Database Management
desk: (603) 245 4092
cell: (603) 219 5539
[EMAIL PROTECTED]
Apologies for responding to my own post, but the URL I gave was wrong. I
meant:
http://www.postgresql.org/comp-comparison.shtml
Troy Hanson
Troy Hanson wrote:
>
> I can't find a definitive answer as to whether Postgres has been ported to
> SCO OpenServer 3.2.
>
> The
ql.org/docs/faq-english.shtml#1.2
Which is correct? I need to know as soon as possible, so thanks for any
help you can offer.
regards,
Troy Hanson
[EMAIL PROTECTED]
66 matches
Mail list logo
