e --disable-triggers ?
>
>
> Yes, this extension needs to work with everyone's normal restore process.
> Otherwise I would have to ask everyone who used my extension to modify
> their pg_restore command.
>
> This also means that I can't rely on a wrapper to pg_res
:
# Manually vacuum tables with the oldest xid (25)
psql -d $1 -t -o /tmp/manual_vacuum_$1.sql -c "select 'vacuum analyze
verbose ' || oid::regclass || ';' from pg_class where relkind in ('r', 't')
and age(relfrozenxid) > 1 order by age(relfrozenxid) desc limit 25"
psql -d $1 -t -a -f /tmp/manual_vacuum_$1.sql > $HOME/manual_vacuum_$1.log
2>&1
Keith
http://www.keithf4.com
I'm working on pgSQL integration with Domino6 (DECS, LCLSX) (there will be
documentation in the coming weeks).
I have a question a couple of questions for you:
1) Are you using Domino 6 or 5.x
2) In your DSN setup on (NT?) do you have the valid
account information to connect to Pg?
3) If you a
Congrats and Welcome to the East Coast from the New Yorker who dwells in Philly.
Quoting Jan Wieck <[EMAIL PROTECTED]>:
> Dear PostgreSQL community,
>
> it is with great pleasure that I would like to let you all know that I
> recently joined Afilias, a domain name registry services company that
Hi,
Can anyone tell me where to find out information about going from 6.3 to 6.5? I have used the "\copy name to name" command to save all of the data to a file. I now want to import this data in 6.5. Any suggestions?-KeithDo You Yahoo!?
Yahoo! Auctions - Buy the things you want at great prices.
a mailing list, not the web]
>
> keith <[EMAIL PROTECTED]> wrote:
> >I get an error that says:
> >"error in loading shared libraries: libpq.so.2.1: cannot open shared
> >object= file: No such file or directory"
> >
> >The file is located at /us
I am lost. I am a developer, new to Linux and to
postgreSQL.
I am trying to install postgreSQL on a linux
machine. Every command I try to run gives me a command not found error. I cannot
seem to do anything. I tried running all the commands. I tried being the root
user as well as other use
- Original Message -
From: keith
To: [EMAIL PROTECTED]
Sent: Wednesday, March 14, 2001 12:17 PM
Subject: Please Help
I am lost. I am a developer, new to Linux and to
postgreSQL.
I am trying to install postgreSQL on a linux
machine. Every command I try to run gives me a command
r a better way to do what I've done, I'd appreciate
it. All I really have it doing now is calling the run_maintenance()
function at a defined interval and don't need it doing more than that yet.
https://gist.github.com/keithf4/0047eae0b3a22829d527
--
Keith Fiske
Database Administrator
OmniTI Computer Consulting, Inc.
http://www.keithf4.com
<http://www.keithf4.com>
On Fri, Apr 10, 2015 at 1:00 PM, Keith Fiske wrote:
>
> On Thu, Apr 9, 2015 at 11:56 PM, Craig Ringer
> wrote:
>
>>
>>
>> On 9 April 2015 at 05:35, Keith Fiske wrote:
>>
>>> I'm working on a background worke
<http://www.keithf4.com>
On Tue, Apr 21, 2015 at 5:47 PM, Keith Fiske wrote:
>
>
>
> <http://www.keithf4.com>
>
> On Fri, Apr 10, 2015 at 1:00 PM, Keith Fiske wrote:
>
>>
>> On Thu, Apr 9, 2015 at 11:56 PM, Craig Ringer
>> wrote:
>>
I have a table:
kr=# create table t (u uuid[]);
CREATE TABLE
Time: 3.742 ms
kr=# insert into t values
('{"0289b709-3cd7-431c-bcbe-f942eb31b4c5","86cc14d6-7293-488e-a85f-384ae6773d28"}');
INSERT 0 1
Time: 1.735 ms
I recently did the following:
kr=# alter table t alter u type text[];
ALTER TABLE
T
On Thu, Jun 11, 2015 at 12:57 PM Tom Lane wrote:
> alter table t alter u type uuid[] using u::uuid[];
>
> The original command worked without a USING because anything-to-text is
> considered an allowable assignment coercion; but the other way around
> requires an explicit cast.
Got it. Thanks!
I
ou've encountered bugs with OmniPITR, please feel free to open an issue
on Github. If you look at the issue and commit history you can see that we
do indeed fix reported issues or respond to help people with problems they
are having.
https://github.com/omniti-labs/omnipitr
--
Keith Fiske
Database Administrator
OmniTI Computer Consulting, Inc.
http://www.keithf4.com
different filesystem. Just make
a 9.5 directory in the same spot when the time comes around. With ZFS
snapshots available, there's really no reason not to use the --link option
to greatly speed up upgrades.
--
Keith Fiske
Database Administrator
OmniTI Computer Consulting, Inc.
http://www.keithf4.com
On Wed, Sep 30, 2015 at 4:58 PM, Benjamin Smith wrote:
> On Wednesday, September 30, 2015 03:49:44 PM Keith Fiske wrote:
> > We've run postgres on ZFS for years with great success (first on
> > OpenSolaris, now on OmniOS, and I personally run it on FreeBSD). The
> >
ntenance.sql#L139
So, not sure if I'm even going about this the right manner for the way I
intend to use the timestamp values. Still fairly new to C and getting use
to postgres internals. Any help, or even an example of using timstamp data
pulled from a table in C with SPI, would be great
On Thu, Jul 28, 2016 at 5:28 PM, Adrian Klaver
wrote:
> On 07/28/2016 02:15 PM, Keith Fiske wrote:
>
>> Working on trying to get a C version of the maintenance function for my
>> pg_partman extension working so I can hopefully make it more flexible
>> and efficient.
>
On Fri, Jul 29, 2016 at 12:53 AM, Vitaly Burovoy
wrote:
> On 7/28/16, Keith Fiske wrote:
> > Working on trying to get a C version of the maintenance function for my
> > pg_partman extension working so I can hopefully make it more flexible and
> > efficient.
> >
>
On Fri, Jul 29, 2016 at 11:49 AM, Vitaly Burovoy
wrote:
> On 7/29/16, Keith Fiske wrote:
> > On Fri, Jul 29, 2016 at 12:53 AM, Vitaly Burovoy <
> vitaly.buro...@gmail.com>
> > wrote:
> >
> >> On 7/28/16, Keith Fiske wrote:
> >> > Working on tr
By reading this,
http://www.postgresql.org/message-id/7e41ba8f0908191624g4501b5f7mcbe29ad2c8139...@mail.gmail.com,
I was wondering if anything has changed on the postgresql front.
I have a large timeseries (2TB worth of uncompressed data). I will be
doing some queries which change at times. Should
Thanks for the responses.
So, it seems what I am trying to do isn't out of the norm. I will get the
column store driver a try. Are there any plans to have this natively
support in Postgresql? That would be a great "killer" feature.
On Tue, Feb 2, 2016 at 7:53 PM, Brent Wood wro
< B2.tt_stop;
And if run on the data below, should pull out customer_no's '2' and '3'.
But does not seem to select any of the rows in which there are gaps in
Customers during the validity of Prop_Owner??
The data I used is as follows:
Customers:
customer_no |customer_na
even possible?
Thanks,
Keith
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
re simply grouped by
subject. If this is such a problem, probably it should be laid out on
the list information page, otherwise how is anyone to know?
Putting this information here would be a good thing:
http://www.postgresql.org/community/lists/
Keith (not scolding, but Hijack is an accusative term)
on [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 11, 2007 6:58 AM
To: Keith Turner
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Hijack!
Keith Turner wrote:
> Someone scolding wrote:
>
> Please don't hijack other threads, the original thread was 'TIMESTAMP
> diffe
On 12/10/07, Keith Turner <[EMAIL PROTECTED]> wrote:
> We are running 8.1 on Windows 2003 server and have had a server crash
> over the weekend. A virus is suspected - we maintain an app server on
> someone else's network, though we do have anti-virus running, the
> symp
et up with an empty parent table pointing to all
the child tables that pulled data into them.
Yes, it was a lot of setup since each of the 512 tables has to be set up
individually. But once it was set up it worked surprisingly well. And it's
honestly a use case I had never foreseen fo
changes at fixed time intervals would certainly
> help reduce the load. I will have to test and see if a good balance can be
> achieved between not having stale data for too long and keeping up with
> writes.
>
> Sébastien
>
>
If you have any questions while evaluating it, feel free to ask or post any
issues to github.
--
Keith Fiske
Database Administrator
OmniTI Computer Consulting, Inc.
http://www.keithf4.com
the gist link
below. You can see the owner has no explicit permissions to the trigger
function and inserts still work even after revoking PUBLIC.
https://gist.github.com/keithf4/83c5c6516e2726609675
--
Keith Fiske
Database Administrator
OmniTI Computer Consulting, Inc.
http://www.keithf4.com
hen you'd have your triggers check if the advisory lock is held and skip
whatever they do if so.
--
Keith Fiske
Database Administrator
OmniTI Computer Consulting, Inc.
http://www.keithf4.com
Scan on partial_functional_index_test
(cost=82.67..4805.55 rows=5000 width=0) (actual time=40.704..1282.955
rows=50 loops=1)
Recheck Cond: (CASE WHEN ((id % 2) = 1) THEN 0 ELSE id END = id)
Heap Blocks: exact=4425
-> Bitmap Index Scan on partial_functional_idx (cost=0.00..81.42
rows=5000 width=0) (actual time=39.657..39.657 rows=50 loops=1)
Planning time: 0.127 ms
Execution time: 2483.979 ms
(7 rows)
--
Keith Fiske
Database Administrator
OmniTI Computer Consulting, Inc.
http://www.keithf4.com
ation or WAL replay. It is determined by setting the
parameter "hot_standby" on the slave and ensuring the master has a minimum
"wal_level" of "hot_standby" as well. So both streaming and wal replay
slaves can be hot standbys.
--
Keith Fiske
Database Administrator
OmniTI Computer Consulting, Inc.
http://www.keithf4.com
which one of these two bloat check
queries is more accurate able to provide some assistance?
--
Keith Fiske
Database Administrator
OmniTI Computer Consulting, Inc.
http://www.keithf4.com
On Tue, Aug 26, 2014 at 5:44 PM, Keith Fiske wrote:
> So I recently wrote this script to help us in monitoring for table/index
> bloat
>
> https://github.com/keithf4/pg_bloat_check
>
> I based my query off of the one contained in check_postgres, since I
> thought it seemed
can remember.
Would there be any issues then just leaving the columns as "timestamp
without time zone"? I know that's not ideal, but that would be a big
project to try and convert every single one of those columns.
Thanks,
--
Keith Fiske
Database Administrator
OmniTI Computer Consulting, Inc.
http://www.keithf4.com
f the other steps besides the kernel loading are needed for
compilation and installation, but could be handy.
--
Keith Fiske
Database Administrator
OmniTI Computer Consulting, Inc.
http://www.keithf4.com
On Mon, Dec 22, 2014 at 2:22 PM, Lacey Powers
wrote:
> Hello Luca,
>
> I had some s
k"
DETAIL: Key (rma_id, rma_status)=(1008122437, r) is not present in table
"rmas".
prod=# rollback;
ROLLBACK
This is running 9.2.4 on CentOS. If anyone can suggest how I can look into
this deeper and find what the problem may be, I'd appreciate it. I'm here
at PGCon if anyo
zero
signs of corruption or other FKs being violated, we asked the for more
information about what had been done recently and they fessed up.
So, relief on one hand that there was no data corruption. But a bit
troubling that the user did that :p
--
Keith Fiske
Database Administrator
OmniTI Com
Due to limitations (perceived or real) within my client application I am
trying to return a complex dataset which I am assembling using an expensive
PL/PGSql function which I would like to wrap in a writeable view.
I have written the function as both a row-level function which returns a
RO
, quote_literal(v_record.min)
, ', '
, v_col
, ' max: '
, quote_literal(v_record.max)
);
RAISE NOTICE 'v_sql: %', v_sql;
END LOOP;
DROP TABLE IF EXISTS test_temp;
END
$$;
keith=# select testing_re
Sorry, forgot to include that I've tested this on PostgreSQL versions 9.2.6
and 9.3.2 and same thing happens on both.
--
Keith Fiske
Database Administrator
OmniTI Computer Consulting, Inc.
http://www.keithf4.com
On Sun, Jan 5, 2014 at 9:31 PM, Keith Fiske wrote:
> Running into an issu
with no issue.
Any chance you can explain what's going on here? Never would've thought to
put the cast there to fix the problem.
--
Keith Fiske
Database Administrator
OmniTI Computer Consulting, Inc.
http://www.keithf4.com
On Sun, Jan 5, 2014 at 11:06 PM, Adrian Klaver wrote:
> On 01/
Actually, that doesn't work right. Gives weird results when the column is
an integer
Example:
keith=# select min(col1), max(col1) from
partman_test.time_static_table_p2014_01_01;
min | max
-+-
86 | 100
(1 row)
keith=# select min(col1::text), max(col1::text)
I can't remove the quote_literal() because the value could potentially be a
string, time, or number. Without the loop, quote_literal() handles the
variable being any one of those types without any issues and quotes (or
doesn't) as needed.
--
Keith Fiske
Database Administrator
OmniT
That is not an option either. This is for a publicly released extension and
I'm really not going to go requiring another scripting language be
installed, especially an untrusted one.
--
Keith Fiske
Database Administrator
OmniTI Computer Consulting, Inc.
http://www.keithf4.com
On Sun,
David,
That seems to have fixed it! I was going down a path of grabbing the
column's type from pg_attribute and trying to work from there, but was
still having some of the same issues.
Thanks everyone else that replied as well!
--
Keith Fiske
Database Administrator
OmniTI Computer Consu
two, but a little simpler to configure if you just need a few tables
replicated.
http://bucardo.org/wiki/Bucardo
http://slony.info/
https://github.com/omniti-labs/mimeo
Hope that helps to answer your questions
--
Keith Fiske
Database Administrator
OmniTI Computer Consulting, Inc.
http://www.keithf4.com
Just wanted to say thanks again for the help to those that responded. For
anyone curious, this helped me get a more advanced constraint exclusion
feature finished for the partition manager I've been working on
http://www.keithf4.com/managing-constraint-exclusion-in-table-partitioning/
--
session identifier?
My security team is asking and I can't find any documentation on this.
Thanks,
Keith
should work, though?
Extension I'm working on: https://github.com/omniti-labs/pg_jobmon
Anyone else having this issue or am I doing something wrong?
--
Keith Fiske
Database Administrator
OmniTI Computer Consulting, Inc.
443.325.1357 x251
--
Sent via pgsql-general mailing list (pgsql-genera
dumps, perhaps another option to pg_dump is needed, and have the
schema-only or data-only options be honored in that case as well.
--
Keith Fiske
Database Administrator
OmniTI Computer Consulting, Inc.
443.325.1357 x251
On Fri, Jun 8, 2012 at 11:38 PM, Tom Lane wrote:
> Keith Fiske writes:
&
is to explicitly name all schemas but the one your
extension is in, which I think is another bug you had actually fixed
for 9.1.3 where extension data was always being dumped.
--
Keith Fiske
Database Administrator
OmniTI Computer Consulting, Inc.
443.325.1357 x251
On Sat, Jun 9, 2012 at 2:56 AM, Keith
27;re documented now.
I think its time to recognize the extension system is more widely
usable than it was originally intended. And that's a good thing! We
just need to try to find ways to make the existing tools work in a
more predictable manner now.
--
Keith Fiske
Database Administrator
OmniT
ob_check_config
214225038 | job_status_text
214972369 | dblink_mapping
(6 rows)
I know this isn't really something that would be done often, but it
just seemed a rather odd behavior so I thought I'd bring it up in case
it's something that can be easily fixed.
--
Keith Fiske
Hello,
I deleted my Postgresql and try to reinstall it. I try to reset the
password by typing in net user postgres *. However, the new password
doesn't work when the installer prompt me to input the password.
Could you please help me?
Thanks,
Keith
--
Sent via pgsql-general mailing
gcc -maix64 -Wall -Wmissing-prototypes -Wpointer-arith
-Wdeclaration-after-statement -Wendif-labels -Wformat-security
-fno-strict-aliasing -fwrapv pg_ctl.o -L../../../src/port -lpgport
-L../../../src/interfaces/libpq -lpq -L../../../src/port -Wl,-bbigtoc
-Wl,-blibpath:'/users/kehand/pgsql_9.1.3/l
ers to reproduce it and see if I'm not
asking for something unreasonable.
--
Keith Fiske
Database Administrator
OmniTI Computer Consulting, Inc.
443.325.1357 x251
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hi,
I need to spoof statistics, and so need to update the stavaluesN columns in
pg_statistics, which are of type anyarray. Can this be done using an UPDATE
statement ? I have tried using array[...] and '{...}' syntax with no luck.
Any other ideas as to how to achieve this ?
Thanks,
Keith.
2009/5/22 Tom Lane
> Keith Hayden writes:
> > I need to spoof statistics, and so need to update the stavaluesN columns
> in
> > pg_statistics, which are of type anyarray. Can this be done using an
> UPDATE
> > statement ? I have tried using array[...] and '{...}
2009/5/22 Keith Hayden
> 2009/5/22 Tom Lane
>
> Keith Hayden writes:
>> > I need to spoof statistics, and so need to update the stavaluesN columns
>> in
>> > pg_statistics, which are of type anyarray. Can this be done using an
>> UPDATE
>> &g
Hi,
I am new to postgresql!
We have a M$SQL server and would like to do a replication from this
server to postgresql.
Would this be possible?
If so, what would be the appropiate method.
Any suggestion?
Thx!
---(end of broadcast)---
TIP 5: Have yo
your desire to choose an index scan if your
joining column's datatypes do not match
Another option is to toss the MS Access altogether and program the front
end entirely in VB. That is what we did.
--
Kind Regards,
Keith
---(end of broadcast)-
-
>>> TIP 9: the planner will ignore your desire to choose an index scan if
>>> your
>>> joining column's datatypes do not match
>>>
>>>
>>
>> Another option is to toss the MS Access altogether and program the
>> front end entirely in VB. That is what we did.
>>
>> --
>> Kind Regards,
>> Keith
>>
> Zlatko Matic wrote:
> You mean VB.NET ?
Actually we wrote our interface using VB6.
--
Kind Regards,
Keith
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Any views on the best way to access postgresql within java?
--
Keith Hutchison
http://balance-infosystems.com http://realopen.org
http://www.kasamba.com/Keith-Hutchison
---(end of broadcast)---
TIP 5: don't forget to increase your free spac
vance
--
Keith Hutchison
http://balance-infosystems.com http://realopen.org
http://www.kasamba.com/Keith-Hutchison
Output of pg_config
$ /c/usr/src/postgresql-8.1.3/src/bin/pg_config/pg_config.exe
BINDIR = c:/usr/src/POSTGR~1.3/src/bin/PG_CON~1
DOCDIR =
INCLUDEDIR =
PKGINCLUDEDIR =
INCLUDEDIR-SERVER =
L
What parameters have to be passed to configure or make to build the
import library files like libpqddll.lib on win32 using msys and mingw?
Thank in advance
--
Keith Hutchison
http://balance-infosystems.com http://realopen.org
http://www.kasamba.com/Keith-Hutchison
/f win32.mak DEBUG=1 from the src folder for
postgresql-8.1.3.
The binaries don't compile but the libraries and dlls do.
--
Keith Hutchison
http://balance-infosystems.com http://realopen.org
---(end of broadcast)---
TIP 1: if posting/re
scott.marlowe wrote:
On Tue, 13 Jan 2004, Keith G. Murphy wrote:
I'm trying to get a feel for what most people are doing or consider best
practice.
Given a mod_perl application talking to a PostgreSQL database on the
same host, where different users are logging onto the web server
Thanks Andrew, I will do some digging on the Postgres-R front to see what
their focus is.
Keith
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Andrew Sullivan
Sent: Thursday, February 26, 2004 4:36 PM
To: [EMAIL PROTECTED]
Subject: Re: [GENERAL
27;ve got a lot of tables and views, and
though I admit that deleting columns is rare, well...
Keith
Stephan Szabo wrote:
> On Fri, 20 Jul 2001, IRWIN,KEITH (Non-HP-Corvallis,ex1) wrote:
>
>
>>Hi--
>>
>>I'm getting the following error:
>>
>> ERROR:
e out the results to
separate the XY co-ords.
Can't find much info at all on the geometric data types at all on the Postgres
site and the doc's are sparse to say the least
Any help appreciated
Keith
lement this (or something
analogous) in a future version of Postgres?
--
Keith Rose (ext. 2144)
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
) = ''::text) AND
((column1)::integer <> (-1)))
The extra trim causes the cast-and-compare to happen before the
trim-and-compare. By my understanding PostgreSQL should not be allowed
to reorder the clause of the subselect before the outer select.
I'm running the Ubuntu postgres
from Member
);
...which is part of the conversion process for data dumped from an
Access database.
--
John Keith Hohm
<[EMAIL PROTECTED]>
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
have to use
one database types, i.e., postgresql.
Thanx,
keith
--
"Nonviolence is not a cover for cowardice, but it is the supreme virtue of the
brave." Mohandas Karamchand Gandhi
===
Keith D. Evans
Joint Center for Earth Systems
?
thanx
keith
Joshua D. Drake wrote:
So, the question is, can someone go through these (public) web pages and
access the postgresql database if the postgresql server is running on
the private machine?
We have other data in the postgresql and would like to only have to use
one database types
on gravity allowing users accessing
through the internet on the public pages to access the data?
thanx,
keith
Raymond O'Donnell wrote:
On 21/05/2009 18:49, Keith D. Evans wrote:
The database is on a public machine (Linux), but the postgresql
postmaster runs on a private machine
esponse to 2.6.9 or .10 but
even before you get into all that. I am curious to know what do you mean by
"standard Linus kernel". Do you not compile your own kernels for the hardware
platform being used?
--
Keith C. Perry, MS E.E.
Director of Networks & Applications
VCSN, In
home of Mammoth PostgreSQL - S/ODBC and S/JDBC
> Postgresql support, programming shared hosting and dedicated hosting.
> +1-503-667-4564 - [EMAIL PROTECTED] - http://www.commandprompt.com
> PostgreSQL Replicator -- production quality replication for PostgreSQL
>
>
The only additiona
ows variants so for security sake increased an network complexity is
justified.
My point is that along with the performance issues this thread has point out,
data security is another reason to consider a non-windows platform to run your
production database.
--
Keith C. Perry, MS E.E.
Di
iding that setting.
>
> richard
>
> ---(end of broadcast)---
> TIP 3: Have you checked our extensive FAQ?
>
>http://www.postgresql.org/docs/faq
>
--
Keith C. Perry, MS E.E.
Direct
h Usenet, please send an appropriate
>subscribe-nomail command to [EMAIL PROTECTED] so that your
>message can get through to the mailing list cleanly
>
--
Keith C. Perry, MS E.E.
Director of Networks & Applications
VCSN, Inc.
http://vcsn.com
hrs_idx is defined as:
iprism=# \d hrs_idx
Index "public.hrs_idx"
Column | Type
+--
stamp | timestamp with time zone
btree, for table "public.report", predicate (thehour(stamp) >= 0::double
precision AND thehour(stamp) <= 23::do
Quoting Tom Lane <[EMAIL PROTECTED]>:
> "Keith C. Perry" <[EMAIL PROTECTED]> writes:
> > This might have been discussed before but I wanted to know if clustering
> tables
> > by partial indexes will be availble in a later release of pgSQL?
>
> What i
uild a bigger machine.
I'm not sure I heard any mention of filesystems but I've been moving all my EXT3
filesystems to XFS. Some other journaling filesystem that you might want to
look into are JFS and ReiserFS.
--
Keith C. Perry, MS E.E.
Director of Networks
; >
> > > >
> > > >
> > > >
> > > > ---(end of
> broadcast)---
> > > > TIP 9: the planner will ignore your desire to choose an index scan if
> your
> > > > joining
> ' LANGUAGE 'sql';
>
>
>
>
>
> How do I get these functions to import correctly if it
> fails due to this "current_transaction" table not
> being found? (only due to it being a temporarily table
> created by a different command)
I had
p exactly what I was trying to get out. We can put all the
material together that someone would use to be certified but there should not be
an emphasis on it. After reading/studying a training manual or guide, it should
be completely a personal choice.
--
Keith C. Perry, MS E.E.
Director of Ne
| http://candle.pha.pa.us
> [EMAIL PROTECTED] | (610) 359-1001
> + If your life is a hard drive, | 13 Roberts Road
> + Christ can be your backup.| Newtown Square, Pennsylvania 19073
>
> ---(end of broadcast)-
Quoting Peter Eisentraut <[EMAIL PROTECTED]>:
> Keith C. Perry wrote:
> > That situtation is a little different though since Linux comes is
> > various distributions. Eventually people with get that Linux = Red
> > Hat is NOT true. Heck, IBM is probably the best at pro
Quoting "Marc G. Fournier" <[EMAIL PROTECTED]>:
> On Thu, 11 Dec 2003, Peter Eisentraut wrote:
>
> > Keith C. Perry wrote:
> > > That situtation is a little different though since Linux comes is
> > > various distributions. Eventually people with ge
re how to mange them with oracle...
> http://www.engin.umich.edu/caen/wls/software/oracle/server.901/a88856/c04space.htm
>
> http://www.siue.edu/~dbock/cmis565/ch8-tablespaces.htm
> http://www-rohan.sdsu.edu/doc/oracle/server803/A54641_01/ch8.htm
>
>
> -Original
---
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
>
Just FYI...
Typically the "other" perl module is Pg.pm
(http://gborg.postgresql.org/project/pgperl/projdisplay.php).
--
Kei
purposes got zapped by lightning in August.
> --
> Mike Nolan
>
> ---(end of broadcast)---
> TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
>
I think that is what I was getting confused with before- schemas...
Quoting Greg Stark <[EMAIL PROTECTED]>:
> "Keith C. Perry" <[EMAIL PROTECTED]> writes:
>
> > Ok, thats for the response. I take it a PG namespace = Oracle table space
> (or
> > namespace is simply the generic term).
>
> Actually if you check
quickly have quite a
bit of "trainers" once we decide how to divide up the knowledge (i.e. training
levels). I think Bruce's said his materials are on his web site so perhaps we
should start there with the intention of repackaging that information for
community d
ql supports SSL natively but you can always tunnel the
connection with ssh if your ISP supports it. If you are using 7.4 you could
even use pg_dump with ssh in a similar manner.
--
Keith C. Perry, MS E.E.
Director of Networks & Applications
VCSN, Inc.
http://vcsn.com
ill switch to PG anywhere soon but sometimes it's
> hard to
> > > > > > > > find whatever information I need. Google is a great help but I
> would
> > > > > > > > expect it in the docs.
> > > > > > >
> > > >
t sure what that
meant but I looked for at the 3 inch doubled side binded of my 7.3.2 docs-
admin,user &,programmer- its as big as my J2EE binder.
Not very scientific I know :)
Seriously though, when people indicate PG is "hard", I hear, "if it was easy
everone would be doing it&
1 - 100 of 146 matches
Mail list logo
