I can't wait!
On 5/11/05, John Dean <[EMAIL PROTECTED]> wrote:
HiThis is my first post to this mailing list. I would like all list membersthat I am the same person who used to work for MySQL AB. Even though I
worked for MySQL AB, PostgreSQL has always been my RDBMS of choice. Thereason for telling
Sorry for short message, but I'm headed out for the weekend.
At my places of work we have use both a single table and one table for every table.
I personally liked the single table for every table approach. On 5/29/05, Zlatko Matic <[EMAIL PROTECTED]
> wrote:Hello.I must have audit trail of all i
I think it hits the press in June or July 2005???
On 6/3/05, Brad Nicholson <[EMAIL PROTECTED]> wrote:
Gevik babakhani wrote:> Dear All, Beside the documentation, which pg book would you recommend? Which one
> is your personal favorite pg book? Regards>> Gevik.>>>PostgreSQL by Korry Douglas
Well first off can you break those 700 lines out into more stored functions?
Maybe you have logic that would be best in its own function and than call one function from another. Makes testing many times easier. I always think in small chuncks when I write code.
Once code gets to be more than
Well first off can you break those 700 lines out into more stored functions?
Maybe you have logic that would be best in its own function and than call one function from another. Makes testing many times easier. I always think in small chuncks when I write code.
Once code gets to be more than
What are the opinions on a separate list just for pl/pgsql? Seems pl/pgsql deserves her own area. Just wondering if this would make sense, and if it did can we have a separate list?
an Oracle world where volumes of books have been written on PL/SQL on it's own.
Bob
On 6/7/05, Douglas McNaught <[EMAIL PROTECTED]> wrote:
Bob <[EMAIL PROTECTED]> writes:> What are the opinions on a separate list just for pl/pgsql? Seems
> pl/pgsql deserves her own a
Keep in mind there is no built in API to debug PL/pgSQL like there is for PL/SQL. You will have to use the old true and tried output statements to debug your stored procs.
On 6/21/05, Sean Davis <[EMAIL PROTECTED]> wrote:
You might want to look at pgEdit.Sean- Original Message -From: "Craig
PL/SQL is awesome just awesome no doubt about it.
But if you like to pay at a minium for 5 users 800 bucks then stick with PL/SQL. I personally can live with pl/psql and at a higher level postgresql to be honest. Not to mention the rate that things are being added and improved is mind numbing.
I have used PL/SQL for years. It's a great language that is easy to pick up and offers lots of ability/promise. The syntax seems very easy for new people to pick up who might know another language or are just starting out. Of course the same can be said of Ada code. It's just very easy to read.
Have you checked your pg_hba.conf file and add the correct entry to
allow the remote client ip address? Sorry don't have my file so I can't
show you an example. But I think the docs and/or a google will show
some examples.
Also you have to alter the postgresql.conf to allow tcp/ip connections.
I t
Doesn't that really only save you from having someone come in at the OS
level and copying your data files and than moutning them on a differet
server/database. A person could still come in to psql as a dba or
anyone for that matter with the proper select grants and query off that
data and see it i
Even though PostgreSQL is more like an Oracle which is a good thing.
It's like Oracle in function not in cost and adminstration. PostgreSQL
not only fits into the enterprice really well it also fits in the mom
and pop shops(dentist office,corner store, you name it that may not
have any IT folks. S
Here is the link in case your fingers are broken and it hurts to type;)
http://www.postgresql.org/docs/8.0/interactive/encryption-options.html
On 7/13/05, Matt McNeil <[EMAIL PROTECTED]> wrote:
Greetings,
I need to securely store lots of sensitive contact
information andnotes in a freely av
The first question is do you really need all the columns. Most times
you don't need them. There will be network overhead for sure in
returning all columns instead of just the few that you want. Also
select * is not very clear with what is going on in the statement.
Where I work we have standards t
any admin work and installing is as
hard as clicking next 3 or 4 times.
To me the only really nice thing Oracle has at this time is called
HTML DB that provides a semi easy development tool that hooks into
Oracle very easily. No need to write glue code such as connections and
state as the dev tool
# ROLLBACK TRANSACTION;ROLLBACKTime: 0.000 msdev=# select * from test_values; c1| c2-+ 2898364 | Autonomous Transaction
(1 row)Time: 0.000 msdev=#Regards,Bob Henkel
Is there any reason can't update to a newer version. Like 8.x?
Geoffrey wrote:
> We continue to have segmentation faults of the /usr/bin/postgres process
> as I mentioned in an earlier thread. In all cases, the core file
> always indicates a segmentation fault, but the backtraces don't seem to
>
Hi,
I have a very odd postgresql problem.
I have some subqueries contained within a function which are looking
for unrefernced data and then delete any rows that are found:
CREATE OR REPLACE FUNCTION housekeeping()
RETURNS TRIGGER AS '
BEGIN
DELETE FROM properties WHERE NOT EXISTS (SELECT
e data for every article.'
- Bob Futrelle
| grep lc_
s'il vous plaît. Also check if any code is setting client_encoding or any of
the lc_* options on the fly.
Bob Lunney
Senior Database Engineer
AWeber Communications, LLC
1100 Manor Drive
Chalfont, PA 18914 USA
> On Jul 8, 2015, at 12:48 PM, Daniel Verite wrote:
>
>
XFS absolutely does. Its well supported on Redhat and CentOS 6.x and 7.x.
Highly recommended.
Don’t know about OCFS2.
Bob Lunney
Lead Data Architect
MeetMe, Inc.
> On Apr 8, 2016, at 8:56 AM, Marllius wrote:
>
> Hi guys!
>
> The OCFS2 and XFS have compatibility with p
op
> http://www.stuartbishop.net/
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
+1
Bob Lunney
Lead Data Architect
MeetMe, Inc.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
pg_terminate_backend() didn’t work, as the signal queued behind the
kernel wait. We had to bounce the database to get rid of the problem.
Immediately afterwards we disabled the trigger.
HTH,
Bob Lunney
> On Apr 29, 2016, at 1:30 PM, Ciprian Grigoras
> wrote:
>
> Hi guys,
>
> I had
Hi All
Is there a fast and easy method of transferring information between MS Excel
and PostgreSQL??
Bob Pawley
Thanks
Does one version of ODBC work for all versions of Excel and Postgresql.
I am wanting to transfer one or two tables from Excel and manipulate the
information in Postgresql then transfer the results back to Excel as a
single table.
I am using Excel 2000 and PostgreSql 8.1.
Bob
Yes please send me a copy.
Bob
- Original Message -
From: "Harvey, Allan AC" <[EMAIL PROTECTED]>
To: "Joshua D. Drake" <[EMAIL PROTECTED]>; "Scott Marlowe"
<[EMAIL PROTECTED]>
Cc: "Csaba Nagy" <[EMAIL PROTECTED]>; &quo
I have numerous entries in a column of table 1, some of which are duplicated.
I need to transfer this information to table 2 so that I have column that can
be used as a primery key.
Any help is appreciated.
Bob Pawley
, are there any tools that may assist me in developing this graphic
interface?
Bob Pawley
<>
Can anyone tell me why a table developed through the PG Admin interface isn't
found by SQL when accessing it through the SQL interface??
Bob Pawley
I want to be able to convert a PostgreSQL database to other formats such as
Oracle, Access etc. - with, as well as without, the data.
Can this task be accomplished by employing pg_dump in SQL?
Bob Pawley
Is there a better method of transfering the database and data to between
DBs?
Bob
- Original Message -
From: "Joshua D. Drake" <[EMAIL PROTECTED]>
To: "Bob Pawley" <[EMAIL PROTECTED]>
Cc:
Sent: Tuesday, October 02, 2007 3:26 PM
Subject: Re: [GE
The documentation states that PostgreSQL does not support updating data via a
cursor.
Has that changed in the last little while.
Bob Pawley
nsure that rows are picked
up sequentially - lowest ID to highest ID or vice-versa?
3. Is there another mehod of accomplishing this task other than fetch?
Bob Pawley
That's marvelous - thanks.
Bob
- Original Message -
From: "brian" <[EMAIL PROTECTED]>
To:
Sent: Thursday, October 18, 2007 9:45 AM
Subject: Re: [GENERAL] ordering rows
Bob Pawley wrote:
Hi
I have a table 'import' which is an amalgam of two other tab
next From loop_set;
Bob Pawley
From loop_set;
Bob Pawley
I have a column with data structured as follows.
32TT - 0002
32LT- 0004
32PT-0005
Is there a way of selecting all of the rows containing LT in that column??
I have attempted variations of ' *LT* ' with out success.
Bob Pawley
Is there any way of converting text from an AutoCad (.dwg ot .dxf) file into a
PostgreSQL Database??
Bob Pawley
I would like to try PostgreSQL 8.3 without uninstalling version 8.1.
Is this possible??
Bob Pawley
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
-f output.
If the error message is correct how does pg_restore know what to put where?
I used the same command to successfully install the same pg_dump file into
PostgreSQL 8.1 running on the same computer.
Any thoughts would be much appreciated.
Bob Pawley
.
This is becoming quite frustrating.
Bob
- Original Message -
From: "Adrian Klaver" <[EMAIL PROTECTED]>
To:
Cc: "Bob Pawley" <[EMAIL PROTECTED]>
Sent: Sunday, October 28, 2007 11:45 AM
Subject: Re: [GENERAL] pg_restore
On Sunday 28 October 2007 11:
aurel.sql file which I just
successfully dumped a few minutes ago from the 8.1 on my other computer.
Could pg_restore in my 8.2 be corrupted??
Bob
- Original Message -
From: "Tom Lane" <[EMAIL PROTECTED]>
To: "Bob Pawley" <[EMAIL PROTECTED]>
Cc: &
This is the dump command
pg_dump -h localhost -d Aurel -U postgres
Could you suggest a dump command that will match the restore command -
pg_restore -h localhost -d PDW -U postgres aurel.sql
Thanks
Bob
- Original Message -
From: "Adrian Klaver" <[EMAIL PROTECT
utting the password.
I keep getting authentication failure.
When I attempt to do a new pg_dump with -Fc I also get a request for
password with identical results.
Bob
- Original Message -
From: "Adrian Klaver" <[EMAIL PROTECTED]>
To:
Cc: "Bob Pawley" <
properly and knowedge will result.
- We would begin to realize the full potential of computing power.
Is that what you were saying??
Bob
- Original Message -
From: "Richard Broersma Jr" <[EMAIL PROTECTED]>
To: ; "Andy" <[EMAIL PROTECTED]>
Sent: Monday,
Thanks Ilan this looks promising.
Bob
- Original Message -
From: Ilan Volow
To: pgsql-general@postgresql.org
Sent: Tuesday, October 30, 2007 3:01 PM
Subject: Re: [GENERAL] PostgreSQL and AutoCad
As I have a vested interest in storing AutoCad stuff in PostgreSQL, I
a good thing.
Bob
---(end of broadcast)---
TIP 6: explain analyze is your friend
n database, at one
time??
If you see any other challenges to this plan, I would appreciate it if you
would please let me know.
Bob Pawley
At the moment the database dump is 4.1 meg.
I suspect the end result will be less than 10 meg including the user's
information.
Is there other size information you need?
Bob
- Original Message -
From: "Richard Huxton" <[EMAIL PROTECTED]>
To: "Bob Pawl
ms.
The database will also be used to transfer information to other engineering
databases yet to be completed.
Bob
- Original Message -
From: "Scott Marlowe" <[EMAIL PROTECTED]>
To: "Bob Pawley" <[EMAIL PROTECTED]>
Cc: "PostgreSQL"
Sent: Mond
Thanks Erik. In between those attempts I did try what you suggest.
It failed, apparently due to not making a connection with the server.
Bob
- Original Message -
From: "Erik Jones" <[EMAIL PROTECTED]>
To: "Bob Pawley" <[EMAIL PROTECTED]>
Cc: "P
for each successful dump???
If not, does anyone have thoughts on where the problem could be??
Bob Pawley
---(end of broadcast)---
TIP 6: explain analyze is your friend
pg_dump
Bob
---(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
ore.
If anyone has any thoughts it would be much appreciated.
Bob
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message ca
Hi Dimitriy
Did you ever get an answer to your query regarding connection security.
I`m not only interested in this aspect, I am also interested in how to detect
any unauthorized connection attempt whether through the front door or the back
door.
Bob
From: Dmitriy Igrishin
Sent: Wednesday
Hi
I am attempting to see if my Postgresql installation is running.
I’ve found this -
[root user only] ./database_service.pl status
I don’t understand what is meant by root user.
I also don’t know how “./database_service.pl status” is used.
Bob
or the password of my computer -
which doesn’t exist.
How can I get around this??
Bob
Thanks Adrian but
psql –U postgres -d PDW -f PDW_June_10.sql
asks - "Password for user postgres:"
When I type the password the cursor doesn't respond and on enter I get
password failed.
Bob
-Original Message-
From: Adrian Klaver
Sent: Friday, December 24, 2010 2:
ntered the password it either said password failed or it simply went
back to the root command.
No database information was sent.
pg_hba.conf sets method as md5
I don't know what is meant by your reference to \1.
Bob
-Original Message-
From: bricklen
Sent: Friday, December 2
postgres user other than what PG Admin uses.
Bob
-Original Message-
From: Adrian Klaver
Sent: Friday, December 24, 2010 4:09 PM
To: pgsql-general@postgresql.org
Cc: Bob Pawley ; bricklen
Subject: Re: [GENERAL] Restore
On Friday 24 December 2010 4:03:52 pm Bob Pawley wrote:
I have tried
.
Maybe I need to delete the postgres database.
Bob
-Original Message-
From: Adrian Klaver
Sent: Friday, December 24, 2010 4:27 PM
To: Bob Pawley
Cc: pgsql-general@postgresql.org ; bricklen
Subject: Re: [GENERAL] Restore
On Friday 24 December 2010 4:20:13 pm Bob Pawley wrote:
Version
I just stopped the server after changing config to trust and I got the
message `System error 5 has occurred. Access is denied`
Perhaps this is a clue.
Bob
-Original Message-
From: Adrian Klaver
Sent: Friday, December 24, 2010 5:15 PM
To: Bob Pawley
Cc: pgsql-general@postgresql.org
I didn't copy or paste anything. I just clicked Stop.
Bob
-Original Message-
From: Scott Marlowe
Sent: Friday, December 24, 2010 5:41 PM
To: Bob Pawley
Cc: adrian.kla...@gmail.com ; pgsql-general@postgresql.org ; bricklen
Subject: Re: [GENERAL] Restore
On Fri, Dec 24, 2010 at 6:
When I type psql I am asked for a password. When I attempt to enter a
password the cursor doesn't move.
When I click enter I get failed password for - my computer name.
When I type psql \I - I get the same as above.
Bob
-Original Message-
From: Scott Marlowe
Sent: Friday, Dec
-Original Message-
From: Scott Marlowe
Sent: Friday, December 24, 2010 6:23 PM
To: Bob Pawley
Cc: bricklen ; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Restore
On Fri, Dec 24, 2010 at 7:20 PM, Bob Pawley wrote:
When I type psql I am asked for a password. When I attempt to
-Original Message-
From: Scott Marlowe
Sent: Friday, December 24, 2010 6:49 PM
To: Bob Pawley
Cc: bricklen ; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Restore
On Fri, Dec 24, 2010 at 7:36 PM, Bob Pawley wrote:
-Original Message- From: Scott Marlowe
Sent: Friday
-Original Message-
From: Adrian Klaver
Sent: Friday, December 24, 2010 7:17 PM
To: Bob Pawley
Cc: Scott Marlowe ; bricklen ; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Restore
On 12/24/2010 07:09 PM, Bob Pawley wrote:
-Original Message- From: Scott Marlowe
Sent
-Original Message-
From: Adrian Klaver
Sent: Friday, December 24, 2010 7:17 PM
To: Bob Pawley
Cc: Scott Marlowe ; bricklen ; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Restore
On 12/24/2010 07:09 PM, Bob Pawley wrote:
-Original Message- From: Scott Marlowe
Sent
I tried PDW# \i PDW_June_2_2010.sql (\i FILE as per help)
My guess didn't work.
Bob
-Original Message-
From: Adrian Klaver
Sent: Friday, December 24, 2010 7:33 PM
To: Bob Pawley
Cc: Scott Marlowe ; bricklen ; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Restore
On
No error it just went back to PDW#
Bob
-Original Message-
From: Scott Marlowe
Sent: Friday, December 24, 2010 7:51 PM
To: Bob Pawley
Cc: Adrian Klaver ; bricklen ; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Restore
On Fri, Dec 24, 2010 at 8:46 PM, Bob Pawley wrote:
I
Yes the file is in the postgresql bin and that is where I changed directory
to begin this saga.
Bob
-Original Message-
From: Adrian Klaver
Sent: Friday, December 24, 2010 7:49 PM
To: Bob Pawley
Cc: Scott Marlowe ; bricklen ; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Restore
The file is an .sql file from a database dump - same procedure I have used a
number of times previous to this upgrade.
Bob
-Original Message-
From: Adrian Klaver
Sent: Friday, December 24, 2010 7:53 PM
To: Scott Marlowe
Cc: Bob Pawley ; bricklen ; pgsql-general@postgresql.org
Subject
I am installing 8.4 as I had problems with 8.3.
Bob
-Original Message-
From: Adrian Klaver
Sent: Friday, December 24, 2010 7:59 PM
To: Bob Pawley
Cc: Scott Marlowe ; bricklen ; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Restore
On 12/24/2010 07:57 PM, Bob Pawley wrote
-Original Message-
From: Adrian Klaver
Sent: Friday, December 24, 2010 8:08 PM
To: Bob Pawley
Cc: Scott Marlowe ; bricklen ; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Restore
On 12/24/2010 08:03 PM, Bob Pawley wrote:
I am installing 8.4 as I had problems with 8.3.
Bob
Thanks for hanging in there.
Merry Christmas to all.
Bob
-Original Message-
From: Adrian Klaver
Sent: Friday, December 24, 2010 8:21 PM
To: Bob Pawley
Cc: Scott Marlowe ; bricklen ; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Restore
On 12/24/2010 08:15 PM, Bob Pawley wrote
I attempted loading earlier version of my backup database, using PDW# \I
PDW_May_2010 and it worked.
Looks as tho the June version may have been corrupt.
Thanks again for all of the help.
Bob
-Original Message-
From: Adrian Klaver
Sent: Friday, December 24, 2010 8:21 PM
To: Bob
there some way of correcting this – or re restoring the database, so that I
don’t have to go through the whole code line by line?
Bob
-Original Message-
From: Adrian Klaver
Sent: Tuesday, December 28, 2010 4:21 PM
To: pgsql-general@postgresql.org
Cc: Bob Pawley
Subject: Re: [GENERAL] Restore problem
On Tuesday 28 December 2010 3:06:40 pm Bob Pawley wrote:
Hi
I have restored a database using psql to windows version
Yes I was just looking at it.
It seems that it was dumped in that form.
Any thoughts on how that could happen?? Not that it will help in this
instance.
Bob
-Original Message-
From: Adrian Klaver
Sent: Tuesday, December 28, 2010 6:09 PM
To: Bob Pawley
Cc: pgsql-general
-Original Message-
From: Adrian Klaver
Sent: Tuesday, December 28, 2010 6:09 PM
To: Bob Pawley
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Restore problem
On Tuesday 28 December 2010 5:58:51 pm Bob Pawley wrote:
-Original Message-
From: Adrian Klaver
Sent
-Original Message-
From: Adrian Klaver
Sent: Tuesday, December 28, 2010 6:51 PM
To: Bob Pawley
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Restore problem
On Tuesday 28 December 2010 6:41:51 pm Bob Pawley wrote:
> > Bob
>
> --
> Adrian Klaver
> adria
-Original Message-
From: Adrian Klaver
Sent: Tuesday, December 28, 2010 7:06 PM
To: Bob Pawley
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Restore problem
On 12/28/2010 07:05 PM, Bob Pawley wrote:
-Original Message- From: Adrian Klaver
Sent: Tuesday, December
-Original Message-
From: Adrian Klaver
Sent: Tuesday, December 28, 2010 7:06 PM
To: Bob Pawley
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Restore problem
On 12/28/2010 07:05 PM, Bob Pawley wrote:
-Original Message- From: Adrian Klaver
Sent: Tuesday, December
-Original Message-
From: Adrian Klaver
Sent: Tuesday, December 28, 2010 7:33 PM
To: Bob Pawley
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Restore problem
On 12/28/2010 07:27 PM, Bob Pawley wrote:
-Original Message- From: Adrian Klaver
Sent: Tuesday, December
-Original Message-
From: Alan Hodgson
Sent: Tuesday, December 28, 2010 8:12 PM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Restore problem
On December 28, 2010, Adrian Klaver wrote:
On 12/28/2010 07:40 PM, Bob Pawley wrote:
>> Open the file in Wordpad and see
-Original Message-
From: Alban Hertroys
Sent: Wednesday, December 29, 2010 4:03 AM
To: Bob Pawley
Cc: Adrian Klaver ; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Restore problem
On 29 Dec 2010, at 4:40, Bob Pawley wrote:
It seems that this has affected just the triggers
know I have been having problems with firewall permissions in Win 7 during
install and uninstall of PostgreSQL.
Bob
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpr
opening.
The postgresql log follows. Can someone please interpret it for me?
Bob
2011-01-07 09:03:55 PSTERROR: unrecognized configuration parameter
"ssl_renegotiation_limit"
2011-01-07 09:03:55 PSTSTATEMENT: SET ssl_renegotiation_limit=0
2011-01-07 09:04:08 PSTLOG: could not receive
Hi Bill
Thanks for answering.
The problem turned out to be the excessive permissions required in Windows 7
Firewall.
It appears to be working now.
Bob
-Original Message-
From: Bill Moran
Sent: Monday, January 10, 2011 5:55 AM
To: Bob Pawley
Cc: Postgresql
Subject: Re: [GENERAL
FROM mytable
WHERE id LIKE '%z%' AND (tmp1 = expensivefunc(value)) > 0.5;
Any ideas anyone!
Thanks in advance!
Bob
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
FROM mytable
WHERE id LIKE '%z%' AND (tmp1 = expensivefunc(value)) > 0.5;
Any ideas anyone!
Thanks in advance!
Bob
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ime use function that declared
a variable with this 'constantdata...'::X value, and then pass this variable in
both calls.
Would this work?
Thanks again!
Bob
--- On Thu, 2/3/11, Bill Moran wrote:
> From: Bill Moran
> Subject: Re: [GENERAL] how to avoid repeating expensive com
enable only a single computation of the data for any given
row as long as the same args are used as parameters.
But, is this safe, or have any pitfalls I would need to look out for?
Thanks!
Bob
--- On Thu, 2/3/11, Tom Lane wrote:
> From: Tom Lane
> Subject: Re: [GENERAL] how to
I have this table:
CREATE TABLE REPORT_STYLE (
REPORT_STYLE_NAME VARCHAR(75) NOT NULL,
REPORT_STYLE_VERSION NUMERIC(8,0) NOT NULL,
UPDATE_TS TIMESTAMP NOT NULL,
UPDATE_USER_NAME VARCHAR(30) NOT NULL,
STYLE_DESCR VARCHAR(200),
JASPER_STYLE XML
);
ALTER TABLE REPORT_STYLE ADD
I would like to
use a more incremental approach to replication. This does not have to be a
"live" replication .. asynchronously triggering once every 24 hours is
sufficient. Also there are only a subset of tables which are required (the
rest consist of data which is generated).
Appreciate any advice.
Regards
Bob
to
it. Fortunately this days are mostly behind us :-)
On 30 June 2014 13:05, Francisco Olarte wrote:
> Hi Bob.
>
> On Mon, Jun 30, 2014 at 10:05 AM, Bob Jolliffe
> wrote:
> > What are people's thoughts about a more optimal solution? I would like
> to
> > use a
Thanks Stuart. I'll do some measurements on plaintext dump to git.
On 2 July 2014 09:46, Stuart Bishop wrote:
> On 30 June 2014 15:05, Bob Jolliffe wrote:
>
> > What are people's thoughts about a more optimal solution? I would like
> to
> > use a more incr
You should be able to find a cloud provider that could give you many TB.
Or so they like to claim.
- Bob
Many worthwhile things cost money.
I never suggested you wouldn't have to pay.
- Bob
On Tue, Jan 13, 2015 at 12:27 AM, Michael Nolan wrote:
>
>
> On Mon, Jan 12, 2015 at 7:46 PM, Bob Futrelle
> wrote:
>
>> You should be able to find a cloud provider that could give
1 - 100 of 502 matches
Mail list logo
