create a
list of the tables -remove the link, edit the code, restore the link. This
is not working very well.
TIA
John
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
dexes will be needed.
In the past I just started playing with explain using a hit and miss way of
doing it.
If there is nothing in Postgres does anyone have any suggestions?
John
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
On Friday 17 July 2009 12:29:59 am Richard Huxton wrote:
> John wrote:
> > Hi,
> >
> > Is there something built-in to Postgres that would suggest what indexes I
> > might add to improve performance? I created my required tables (they
> > only contain sm
On Friday 17 July 2009 07:17:15 am Sharma, Sid wrote:
> Sorry. Forgot to mention the postgres version
>
> PostgreSQL 8.1.3 on i686-pc-linux-gnu, compiled by GCC 2.96
>
>
>
>
>
> From: Sharma, Sid
> Sent: Friday, July 17, 2009 10:05 AM
> To: pgsql-general@postgresql.
On Friday 31 July 2009 05:47:39 am Thom Brown wrote:
> Hi all,
>
> We're migrating the contents of an old MSSQL server to PostgreSQL 8.3.7, so
> a full conversion is required. Does anyone know of any guides which
> highlight common gotchas and other userful information?
>
> Thanks
>
> Thom
You mi
Hi,
There is an accounting system called postbooks that uses Postgres for the
backend. I just downloaded the program yesterday. What is interesting is
within one database there are two schemas (api and public). The 'api' schema
is a bunch of views. The interesting part is if you update a vie
On Friday 07 August 2009 06:56:22 am Scott Mead wrote:
> On Fri, Aug 7, 2009 at 9:52 AM, Adrian Klaver wrote:
> > On Friday 07 August 2009 6:42:07 am John wrote:
> > > Hi,
> > > There is an accounting system called postbooks that uses Postgres for
> > > the bac
On Friday 07 August 2009 07:27:28 am John wrote:
> On Friday 07 August 2009 06:56:22 am Scott Mead wrote:
> > On Fri, Aug 7, 2009 at 9:52 AM, Adrian Klaver wrote:
> > > On Friday 07 August 2009 6:42:07 am John wrote:
> > > > Hi,
> > > > There is an ac
Hi,
I have a development DB and a production DB. I need a way to sync the changes
I make to the stucture in the devel DB to the production DB. I found pgdiff
but can't get it to work. I would like a solution that would work on windows
and linux. But I'll take either alone.
postgres 8.3
o
On Monday 28 September 2009 09:06:25 am Filip Rembiałkowski wrote:
> 2009/9/28 John
>
> > Hi,
> > I have a development DB and a production DB. I need a way to sync the
> > changes
> > I make to the stucture in the devel DB to the production DB. I found
> >
On Monday 28 September 2009 09:31:30 am Adrian Klaver wrote:
> - "John" wrote:
> > On Monday 28 September 2009 09:06:25 am Filip Rembiałkowski wrote:
> > > 2009/9/28 John
> > >
> > > > Hi,
> > > > I have a developm
On Monday 28 September 2009 09:56:33 am Filip Rembiałkowski wrote:
> 2009/9/28 John
>
> > After all this time I'm surprized that someone hasn't
> > provide an easy way to get this done. It's has to be every developers
> > problem.
>
> hmm, maybe b
Hi,
Is it better to create multi databases or create multi schemas?
I am writing a program that can have multi instances. Sort like a finanical
accounting system that can have multiable companies. Where each company has a
different name but the tables are an exact match to each other. IOW the
On Tuesday 20 October 2009 10:11:53 am Wolfgang Keller wrote:
> > Is it better to create multi databases or create multi schemas?
>
> You're missing one option imho: One database, one schema.
>
> > I am writing a program that can have multi instances. Sort like a
> > finanical accounting system th
On Tuesday 20 October 2009 11:59:54 am Rich Shepard wrote:
> On Tue, 20 Oct 2009, John wrote:
> > I never even considered using the one database with added company
> > field/column. On the surface is sounds OK but I'm not to sure. Each SQL
> > statement would
On Tuesday 20 October 2009 10:05:34 pm Roderick A. Anderson wrote:
> John wrote:
> > Hi,
> >
> > Is it better to create multi databases or create multi schemas?
>
> John, I just gave a talk on multi-tenant Pg clusters at PgConf West
> 2009 that may help you but ran
On Wednesday 21 October 2009 01:23:18 am Ivano Luberti wrote:
> The problem is how you use those data ?
> I have used schemas to split data when I had to manage large amount of
> data (hundred of thousand records) that are (almost) never going to be
> used together, if not for statistic purposes an
http://teenwag.com/search
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
- Mike
It can be done (see other posts), but I suspect that your programmer has
a good reason to be reluctant.
Let your programmer start from scratch on a new server. Once he has it
set up how he wants it, and has tested it against the other
applications, make the switch. If it doesn't wo
Christopher Browne wrote:
Quoth John <[EMAIL PROTECTED]>:
As per subject, i'm considering migrating a database (still in
development) from MaxDB to postgresql. The main reason for this is
that the stored procedures (functions) in MaxDB are unreliable and
hard to debug, and that the JDB
re to find out how well functions and JDBC are
supported in postgresql.
If anyone has info or experience on these two things, I'd be interested
to see what your opinion is.
John
---(end of broadcast)---
TIP 2: you can get off all lists a
Mike Richardson and John Dean are pleased to announce the 2.0 release of
Rekall, a personal, programmable DBMS system for Linux and Windows. If you
want to distribute your Rekall application commercially then there is a
run-time version of Rekall V2.0.0 available too. There are also versions
> > By the way, I keep receiving mails from the 'pgsql-hackers'
> > list, to which
> > I'm not subscribed.
> >
>
> as am I.
>
> -Jim
I think just about everyone in general is. (at least i know i am) It's
only been the past few days though. Same time frame of which everyone is
complaining
elled it. I also tried to "include" Pg.pm and
it says it cant find the module. I did a manual find and it is there.
Can any tell me what I am doing wrong or what I need to do to get postgres
working with perl?
Thanks,
-John
---(e
1 root root18124 May 23 21:32 Pg.pm
If this is not enough information please tell me what else to post. Thanks
for helping me as I am struggling.
-John
"Neil Conway" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> On Sun, May
.
-John
"Jason Earl" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> The types of problems that John is having are quite
> likely to persist with PHP, as his problems aren't so
> much in programming with Perl, as it seems to
l-general
--
He's about as useful as a wax frying pan.
10 to the 12th power microphones = 1 Megaphone
Maranatha! <><
John McKown
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
y
> if we combine their name column with their salary column. Unfortunately, the
> format of the data we have makes it more difficult than that (of course!)
> because some employees can hold multiple paying positions.
>
> Here's some example data:
>
> Name, Position, Salar
On Mon, Mar 9, 2015 at 10:12 AM, Eli Murray wrote:
> Thank you all for your help. I'm following along with John McKown's
> suggestion but when I run the update query I get "UPDATE 32956" but the
> personid column in my rawdata table has null values for every record.
s useful as a wax frying pan.
10 to the 12th power microphones = 1 Megaphone
Maranatha! <><
John McKown
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
postgresql/postgresql-9.3.4-3-windows-x64.exe
clicking on the second of those downloaded an exe, which I have not
tried to run because I'd catch hell from our security people for doing
it.
On Wed, Mar 18, 2015 at 6:46 AM, John McKown
wrote:
> Interesting. I can bring that page up on
anything permanently . Also, doing a simple
ANALYZE on the table might help some. I'm not sure.
ANALYZE master_items;
--
If you sent twitter messages while exploring, are you on a textpedition?
He's about as useful as a wax frying pan.
10 to the 12th power microphones = 1 Megaphone
ut as useful as a wax frying pan.
10 to the 12th power microphones = 1 Megaphone
Maranatha! <><
John McKown
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
re you on a textpedition?
He's about as useful as a wax frying pan.
10 to the 12th power microphones = 1 Megaphone
Maranatha! <><
John McKown
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
o restorecon -R /var/lib/pgsql/data # update SELinux attributes
The restorecon is only needed if you run SELinux
>
>
> Thanks so much in advance,
>
> --
> Octavi Fors
>
--
If you sent twitter messages while exploring, are you on a textpedition?
He's abou
On Thu, Apr 2, 2015 at 7:09 PM, Octavi Fors wrote:
> Thanks John for your extensive and helpful response.
>
> You see that I used the ALTER from David in last message, instead your
> suggestion of creating the whole database again.
Looks good!
>
> Two only questions re
On Fri, Apr 3, 2015 at 1:40 AM, Octavi Fors wrote:
> Hi David, John et al.,
> Oops, sorry yes I think I may "miss-spoke" when explaining my second reason
> why not choosing eSATA.
> My situation is the following:
>
> -Two computers (C1 & C2) and NAS (with no e
mailing list archive at Nabble.com.
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
If you sent twitter messages while exploring, are you on a textpedition?
He's about as useful as a wax frying pan.
10 to the 12th power microphones = 1 Megaphone
Maranatha! <><
John McKown
t; --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
If you sent twitter messages while exploring, are you on a textpedition?
He's about as useful as a wax frying pan.
10 to the 12th power microphones = 1 Megaphone
Maranatha! <><
John McKown
lue is an empty string, which results in all temporary
objects being created in the default tablespace of the current database.
I agree that is sounds like you're not using quality SSD drives.
--
If you sent twitter messages while exploring, are you on a textpedition?
He's about as useful as a wax frying pan.
10 to the 12th power microphones = 1 Megaphone
Maranatha! <><
John McKown
PostgreSQL.
Sorry about delay but: (1) I was on Jury duty yesterday & (2) I was hoping
a more experienced person would speak up.
--
If you sent twitter messages while exploring, are you on a textpedition?
He's about as useful as a wax frying pan.
10 to the 12th power microphones = 1 Megaphone
Maranatha! <><
John McKown
--
If you sent twitter messages while exploring, are you on a textpedition?
He's about as useful as a wax frying pan.
10 to the 12th power microphones = 1 Megaphone
Maranatha! <><
John McKown
ght to fantasize. Whether or not you
> wish to share my fantasy is entirely up to you.
>
--
If you sent twitter messages while exploring, are you on a textpedition?
He's about as useful as a wax frying pan.
10 to the 12th power microphones = 1 Megaphone
Maranatha! <><
John McKown
start an
>> undelete process before Windows overwrites that part of hard disk with new
>> files. You can set that flag back to "on" and get your file using
>> > >
>>
>
--
If someone tell you that nothing is impossible:
Ask him to dribble a football.
He's about as useful as a wax frying pan.
10 to the 12th power microphones = 1 Megaphone
Maranatha! <><
John McKown
you that nothing is impossible:
Ask him to dribble a football.
He's about as useful as a wax frying pan.
10 to the 12th power microphones = 1 Megaphone
Maranatha! <><
John McKown
>> >
>> >and the FULL JOIN will add a row for b_val=2 with NULL a_val.
>> >
>> >The second query will first produce
>> >
>> > a_val | b_val
>> >---+---
>> > 1 | 1
>> > 2 | 2
>> > 3 |
>> >
>> >an since none but the first row matches a_val=1, you'll get only that
>> row in the result.
>> >
>> >Yours,
>> >Laurenz Albe
>>
>>
>> Thank you!
>>
>> Sorry for not finding it myself, but now I understand why it behaves
>> like this :-)
>>
>> Thanks
>>
>> Nicklas
>>
>
>
>
> --
> Tim Rowe
>
--
My sister opened a computer store in Hawaii. She sells C shells down by the
seashore.
If someone tell you that nothing is impossible:
Ask him to dribble a football.
He's about as useful as a wax frying pan.
10 to the 12th power microphones = 1 Megaphone
Maranatha! <><
John McKown
-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
>
--
My sister opened a computer store in Hawaii. She sells C shells down by the
seashore.
If someone tell you that nothing is impossible:
Ask him to dribble a football.
He's about as useful as a wax frying pan.
10 to the 12th power microphones = 1 Megaphone
Maranatha! <><
John McKown
>
--
My sister opened a computer store in Hawaii. She sells C shells down by the
seashore.
If someone tell you that nothing is impossible:
Ask him to dribble a football.
He's about as useful as a wax frying pan.
10 to the 12th power microphones = 1 Megaphone
Maranatha! <><
John McKown
s processing of
workers marked as start_at = BgWorkerStart_RecoveryFinished
in 9.4.4?
Cheers, John
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Michael, thanks for checking,
I tried it again today and it is now working so I must have forgotten something.
John
> Date: Tue, 16 Jun 2015 08:33:09 +0900
> Subject: Re: [GENERAL] RegisterBackgroundWorker does not actually start a bg
> worke
tion. I am also interested in setting up an offsite hot standby
server for failover.
Suggestions for tools and/or further reading welcome!
Thanks in advance,
John
want.
Thanks!
John
n until a
restore is attempted.
Yoda of Borg, we are. Futile, resistance is, yes. Assimilated, you will be.
My sister opened a computer store in Hawaii. She sells C shells down by the
seashore.
If someone tell you that nothing is impossible:
Ask him to dribble a football.
He's about as useful as a wax frying pan.
10 to the 12th power microphones = 1 Megaphone
Maranatha! <><
John McKown
On Tue, Jul 7, 2015 at 12:10 AM, John R Pierce wrote:
> On 7/6/2015 9:55 PM, c.bu...@posteo.jp wrote:
>
>> On 2015-07-05 22:16 John R Pierce wrote:
>>
>>> >at a bare minimum, a database administrator needs to create database
>>> >roles (users) and d
ondition of any backup is unknown until a
restore is attempted.
Yoda of Borg, we are. Futile, resistance is, yes. Assimilated, you will be.
He's about as useful as a wax frying pan.
10 to the 12th power microphones = 1 Megaphone
Maranatha! <><
John McKown
On Wed, Jul 8, 2015 at 3:55 AM, Karsten Hilbert
wrote:
> On Tue, Jul 07, 2015 at 06:57:45AM -0500, John McKown wrote:
>
> > >>> >at a bare minimum, a database administrator needs to create database
> > >>> >roles (users) and databases for an app like you
are. Futile, resistance is, yes. Assimilated, you will be.
He's about as useful as a wax frying pan.
10 to the 12th power microphones = 1 Megaphone
Maranatha! <><
John McKown
ckup: The condition of any backup is unknown until a
restore is attempted.
Yoda of Borg, we are. Futile, resistance is, yes. Assimilated, you will be.
He's about as useful as a wax frying pan.
10 to the 12th power microphones = 1 Megaphone
Maranatha! <><
John McKown
x frying pan.
10 to the 12th power microphones = 1 Megaphone
Maranatha! <><
John McKown
ore is attempted.
Yoda of Borg, we are. Futile, resistance is, yes. Assimilated, you will be.
He's about as useful as a wax frying pan.
10 to the 12th power microphones = 1 Megaphone
Maranatha! <><
John McKown
Seconding Peter on this one; it's a lot more important should one of those
locks be hanging around, say for hours or days, not how many have come and
gone.
--
Jay
On Thu, Jul 30, 2015 at 8:57 AM, Renato Oliveira <
renato.olive...@cantabcapital.com> wrote:
> Peter thank you much appreciated
>
> Se
l is ->> actually running at?
>
> Or am I missing something?
>
Looks correct to me. As I understand it the ::jsonb is NOT an operator! It
is a syntactic construct for a CAST(). An equivalent which might make more
sense is:
select CASE WHEN CAST('{"a":null}' AS JSONB)->>'a' IS NULL THEN 'yes' ELSE
'no' END;
Oh, an CAST() may look like a function call, but it is also a syntactic
element. I.e. there is not a function called "CAST".
> Cheers
>
> Geoff
>
--
Schrodinger's backup: The condition of any backup is unknown until a
restore is attempted.
Yoda of Borg, we are. Futile, resistance is, yes. Assimilated, you will be.
He's about as useful as a wax frying pan.
10 to the 12th power microphones = 1 Megaphone
Maranatha! <><
John McKown
On Wed, Aug 5, 2015 at 8:35 AM, John McKown
wrote:
>
>
> Looks correct to me. As I understand it the ::jsonb is NOT an operator!
> It is a syntactic construct for a CAST(). An equivalent which might make
> more sense is:
>
> select CASE WHEN CAST('{"a"
On Wed, Aug 5, 2015 at 8:42 AM, Geoff Winkless wrote:
> On 5 August 2015 at 14:35, John McKown
> wrote:
>>
>> Looks correct to me. As I understand it the ::jsonb is NOT an operator!
>> It is a syntactic construct for a CAST(). An equivalent which might make
>> m
d my own Postgresql rpm.
>
> Thanks.
>
--
Schrodinger's backup: The condition of any backup is unknown until a
restore is attempted.
Yoda of Borg, we are. Futile, resistance is, yes. Assimilated, you will be.
He's about as useful as a wax frying pan.
10 to the 12th power microphones = 1 Megaphone
Maranatha! <><
John McKown
is attempted.
Yoda of Borg, we are. Futile, resistance is, yes. Assimilated, you will be.
He's about as useful as a wax frying pan.
10 to the 12th power microphones = 1 Megaphone
Maranatha! <><
John McKown
r now,
but not even a novice really.
--
Schrodinger's backup: The condition of any backup is unknown until a
restore is attempted.
Yoda of Borg, we are. Futile, resistance is, yes. Assimilated, you will be.
He's about as useful as a wax frying pan.
10 to the 12th power microphones = 1 Megaphone
Maranatha! <><
John McKown
of any backup is unknown until a
restore is attempted.
Yoda of Borg, we are. Futile, resistance is, yes. Assimilated, you will be.
He's about as useful as a wax frying pan.
10 to the 12th power microphones = 1 Megaphone
Maranatha! <><
John McKown
On Thu, 13 Aug 2015 09:46:49 -0400, Melvin Davidson
wrote:
On Thu, Aug 13, 2015 at 9:21 AM, John McKown
wrote:
On Thu, Aug 13, 2015 at 8:03 AM, Melvin Davidson
wrote:
This should put a smile on all PostgreSQL DBA's faces.
The Best Overall Database
Very nice. Of course, I h
would be 2, not 12. Or do you really want the 12? I'm unsure.
--
Schrodinger's backup: The condition of any backup is unknown until a
restore is attempted.
Yoda of Borg, we are. Futile, resistance is, yes. Assimilated, you will be.
He's about as useful as a wax frying pan.
10 to the 12th power microphones = 1 Megaphone
Maranatha! <><
John McKown
le to ONLY and ALWAYS specify the variable names. The only
exception is if your program actually examines the schema of the table
before doing a SELECT and dynamically constructs it.
--
Schrodinger's backup: The condition of any backup is unknown until a
restore is attempted.
Yoda of Borg, we are. Futile, resistance is, yes. Assimilated, you will be.
He's about as useful as a wax frying pan.
10 to the 12th power microphones = 1 Megaphone
Maranatha! <><
John McKown
Melvin's use of DISTINCT ON (...) is superior to my use of DISTINCT(...)
because it doesn't return the value to your program. I keep forgetting this
way. I learned it the other way. Old dog + new trick == problem.
On Sun, Aug 23, 2015 at 5:04 PM, John McKown
wrote:
> On Sun, Aug
ry, they must be accompanied by a legitimate Unique natural key.
- John
to
good enough.
JD
I'm all for development via ORMs, but alas, the ORMs would've done well to
have given more consideration to key conventions...
I would only add that if the app is of any significance for an LOB, then
at some point the schema would need to be validated against re
's backup: The condition of any backup is unknown until a
restore is attempted.
Yoda of Borg, we are. Futile, resistance is, yes. Assimilated, you will be.
He's about as useful as a wax frying pan.
10 to the 12th power microphones = 1 Megaphone
Maranatha! <><
John McKown
h are
typically scaffolded with boilerplate, but almost invariably need to be
tweaked in order to effect the desired changes in the database..
- John
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/
e local host are
automatically logged in as their Linux (in my case) id.
Your code is connecting via TCPIP because you have the host= & port=
parameters. This is not normally needed for users running on the same
physical machine as the PostgreSQL data base server. So I'm too lazy to do
it [
On Thu, Aug 27, 2015 at 4:19 PM, Abraham Mathew
wrote:
"test" is not in the postgres database. In fact, there is no table or
column named "test"
The user is "postgres" and the dbname is also "postgres"
On Thu, Aug 27, 2015 at 4:13 PM, John McKown
w
x frying pan.
10 to the 12th power microphones = 1 Megaphone
Maranatha! <><
John McKown
memory that is returned to the
caller?
Regards,
John
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
is:
"What makes palloc() special is that it allocates the memory in the current
context and the whole memory is freed in one go when the context is destroyed."
What "context"? The connection? The transaction? A SQL statement? The function
call?
John
--
Sent via pgsql-genera
On Mon, Sep 21, 2015 at 10:46 AM, John R Pierce wrote:
> On 9/21/2015 12:31 AM, Etienne Champetier wrote:
>
>> I'm looking for old postgres rpm, like
>> postgresql93-server-9.3.6-1PGDG.rhel6.x86_64.rpm
>>
>> (one of our software is "certified" with t
memory that is returned to the
caller?
Regards,
John
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
> http://www.postgresql.org/mailpref/pgsql-general
>
--
Schrodinger's backup: The condition of any backup is unknown until a
restore is attempted.
Yoda of Borg, we are. Futile, resistance is, yes. Assimilated, you will be.
He's about as useful as a wax frying pan.
10 to the 12th power microphones = 1 Megaphone
Maranatha! <><
John McKown
l be a
"leaning experience" (with associated scars, I'm sure).
--
Schrodinger's backup: The condition of any backup is unknown until a
restore is attempted.
Yoda of Borg, we are. Futile, resistance is, yes. Assimilated, you will be.
He's about as useful as a wax frying pan.
10 to the 12th power microphones = 1 Megaphone
Maranatha! <><
John McKown
On Tue, Oct 6, 2015 at 9:25 AM, Reid Thompson
wrote:
> On Tue, 2015-10-06 at 09:04 -0500, John McKown wrote:
>
> > I'm wanting to do some reporting on data which I have an a PostgreSQL
> table.
> > For lack of anything better, I've decided to see if I can do
;
> bobb
>
>
--
Schrodinger's backup: The condition of any backup is unknown until a
restore is attempted.
Yoda of Borg, we are. Futile, resistance is, yes. Assimilated, you will be.
He's about as useful as a wax frying pan.
10 to the 12th power microphones = 1 Megaphone
Maranatha! <><
John McKown
I would like to get the session_user into a C char[] in a C language UDF. I
have found what appears to be a function returning a Datum type called
session_user, but I'm having trouble working out how to call it from within my
C function. Can anyone provide some advice on how to do this?
ted, you will be.
He's about as useful as a wax frying pan.
10 to the 12th power microphones = 1 Megaphone
Maranatha! <><
John McKown
know why the OP wants to put
the database files on an NFS.
--
Schrodinger's backup: The condition of any backup is unknown until a
restore is attempted.
Yoda of Borg, we are. Futile, resistance is, yes. Assimilated, you will be.
He's about as useful as a wax frying pan.
10 to the 12th power microphones = 1 Megaphone
Maranatha! <><
John McKown
" and got a lot of
hits. Are you asking for a "canonical" and "official" list?
--
The unfacts, did we have them, are too imprecisely few to warrant our
certitude.
Maranatha! <><
John McKown
Hello, I have a few questions regarding the use of PostgreSQL and HIPAA
compliance. I work for a company that plans on storing protected health
information (PHI) on our servers. We have looked at various solutions for doing
so, and RDS is a prime candidate except for the fact that they have explici
ineer. Pessimistic people check
their work three times, because they're sure that something won't be right.
Optimistic people check once, trust in Solis-de to keep the ship safe, then
blow everyone up."
"I think you're mistaking the word optimistic for inept."
"They've got a similar ring to my ear."
>From "Star Nomad" by Lindsay Buroker:
Maranatha! <><
John McKown
ed between session.
--
"Pessimism is a admirable quality in an engineer. Pessimistic people check
their work three times, because they're sure that something won't be right.
Optimistic people check once, trust in Solis-de to keep the ship safe, then
blow everyone up."
"I think you're mistaking the word optimistic for inept."
"They've got a similar ring to my ear."
>From "Star Nomad" by Lindsay Buroker:
Maranatha! <><
John McKown
ot;Worry was nothing more than paying interest on a loan that a man may never
borrow"
From: "Quest for the White Wind" by Alan Black
Maranatha! <><
John McKown
> On Jul 18, 2016, at 11:47 PM, John R Pierce wrote:
>
> Drupal even tried to offer a database API so plugin developers wouldn't touch
> SQL directly, but too many ignored it.
I have been using Drupal with PostgreSQL for more than 10 years without too
many problems. Since
n, will do some
> more digging later.
See
https://github.com/dimitri/pgloader/issues/296
John DeSoi, Ph.D.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
; type policy. Or I'd "sandbox" the PostgreSQL server code using
something like docker, or under in a virtual machine with little access to
other services.
>
>
> --
> *Melvin Davidson*
> I reserve the right to fantasize. Whether or not you
> wish to share my fantasy is entirely up to you.
>
--
Klein bottle for rent -- inquire within.
Maranatha! <><
John McKown
prefix which, if used, runs the given SQL
statement as a PG superuser. You then GRANT(?) authority to that facility
like you would to a table or database or ... . E.g. GRANT SUDO TO SOMEBODY;
who could then do SUDO some other SQL statement; and that SQL statement
would be done as if the PG user was a superuser.
--
Klein bottle for rent -- inquire within.
Maranatha! <><
John McKown
an event trigger that updates a simple table with the last
modification time or sends a notification?
https://www.postgresql.org/docs/current/static/sql-createeventtrigger.html
John DeSoi, Ph.D.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subs
1 - 100 of 2768 matches
Mail list logo
