On 09/10/2015 03:03 PM, Andrew Sullivan wrote:
> On Thu, Sep 10, 2015 at 02:54:31PM -0700, Ken Tanzer wrote:
>> Thanks, but I guess I should have been clearer. Thanks to y'all wonderful
>> mailing list folks, I get it now as to why the two sorts are not the same.
>> I'm hoping for practical sugges
On 10/15/2015 07:05 AM, Ramesh T wrote:
> '123-987-123' it is not fixed some times it may be '1233-9873-123-098'
> as you said it's fixed,
>
> changes the values in middle of the -
>
> sometimes times i need 1233 and 098 or 9873,first position i'll find
> direct for second variable we don't know
On 10/21/2015 07:31 AM, Michael Hartung wrote:
> being on OS X 10.11 (El Capitain) and trying a VPATH build with plain
> "configure" and "make" works fine.
>
> /Users/me/Documents/workspace/postgres/configure --with-openssl
> --with-includes=/usr/local/ssl/include/openssl
> --with-libraries=/usr/l
On 10/30/2015 10:27 AM, rajan wrote:
> The function is created as postgres user.
>
> And I get a permission denied error.
If you want help solving this, I suggest you post a minimal, self
contained test case (i.e. SQL statements) which anyone can run to
reproduce your issue.
HTH,
Joe
--
Crunc
On 07/28/2016 03:16 PM, Bruce Momjian wrote:
> On Thu, Jul 28, 2016 at 12:35:23AM -0700, Jeff Janes wrote:
>> On Wed, Jul 27, 2016 at 9:48 PM, John R Pierce wrote:
>>> On 7/27/2016 9:39 PM, Jeff Janes wrote:
That depends on how how many objects there are consuming that 1 TB.
With mi
On 11/23/2016 02:50 PM, Israel Brewster wrote:
> On Nov 23, 2016, at 10:31 AM, John R Pierce > there's a tool, barman, I've never used but its supposed to greatly
>> simplify this whole process...
>>
>> http://www.pgbarman.org/
>
> Definitely looks like something to try. Thanks!
I'd recommend you
On 12/16/2016 01:02 AM, Simon Charette wrote:
> Unfortunately this will only return accounts matching the current_user's name.
>
> I would expect "SET ROLE foo; SELECT name FROM accounts" to return "foo" and
> "bar" and not only "foo" like your proposed solution would do.
Perhaps:
8<
On 12/17/2016 01:01 PM, Simon Charette wrote:
> Thanks a lot Joe, that seems to work!
Good to hear.
> I suppose this works because PostgreSQL cannot introspect the
> get_owner_id procedure to detect it's querying the "accounts" table
> and thus doesn't warn about possible infinite recursion?
Not
On 12/17/2016 02:04 PM, Stephen Frost wrote:
> Note that RLS won't be applied for the table owner either (unless the
> relation has 'FORCE RLS' enabled for it), so you don't have to have
> functions which are run as superuser to use the approach Joe
> recommended.
Good point, thanks, I should have
On 12/15/2015 06:24 PM, James Sewell wrote:
> I have a Windows PostgreSQL server where dblink_connect fails to pick up
> the current user as follows:
> ffm=# SELECT dblink_connect('master', 'dbname=ffm');
> ERROR: could not establish connection
> DETAIL: FATAL: role "PRDSWIDEGRID01$
On 12/16/2015 04:53 PM, James Sewell wrote:
> No it is not.
>
> Just in case I tried setting it to 'postgres', logged in without -U
> (doesn't work without PGUSER set) and tried the operation again.
> > DETAIL: FATAL: role "PRDSWIDEGRID01$" does not exist
That "PRDSWIDEGRID01$" is comi
On 12/16/2015 06:10 PM, James Sewell wrote:
> Oops left off the list.
Me too -- response repeated below...
> -- Forwarded message --
> From: *James Sewell* <mailto:james.sew...@lisasoft.com>>
> Date: Thursday, 17 December 2015
> Subject: dblink_connec
On 12/30/2015 11:09 AM, Cory Tucker wrote:
> We have a performance problem accessing one of our tables, I think
> because the statistics are out of date. The table is fairly large, on
> the order of 100M rows or so.
> The fix I have employed to restore the speed of the query after I notice
> it
On 01/05/2016 04:32 PM, John R Pierce wrote:
> On 1/5/2016 4:12 PM, oleg yusim wrote:
>> I meant a scenario, when user is trying to connect to database
>> (doesn't matter what interface) and database fails at this moment. If
>> all authentication/authorization/validation functions are written to
>>
On 02/25/2016 03:42 PM, Bryan Ellerbrock wrote:
> Hi, I'm first time mailing-list user with a problem. I'm working on a
> UTF8 encoded database using psql (9.5.1, server 9.4.6)
>
> I've implemented a very large materialized view to speed up certain
> search queries. I need to give users the abilit
On 02/26/2016 07:12 AM, David G. Johnston wrote:
> pg_dump emits a "CREATE EXTENSION" statement to the dump file and then
> pg_restore executes the "CREATE EXTENSION". None of the actual schema
> objects are dumped and thus any changes to those objects in the current
> database, including their pe
On 03/02/2016 11:29 AM, Alan Droege wrote:
> I have removed SELECT rights from the pg_proc.prosrc column so that
> I can hide the source code of stored functions. This is working OK,
> however I would really like to just hide certain functions via RLS.
> I understand that great damage could be don
On 03/02/2016 11:53 AM, Joshua D. Drake wrote:
> On 03/02/2016 11:37 AM, Joe Conway wrote:
>
>> http://www.postgresql.org/message-id/flat/CA+Tgmoa=4vti1hb1hta0+qbzlojkpjbd5dkvw3zmp-kdwje...@mail.gmail.com#CA+Tgmoa=4vti1hb1hta0+qbzlojkpjbd5dkvw3zmp-kdwje...@mail.gmail.com
>>
&
On 03/02/2016 12:14 PM, Julien Rouhaud wrote:
> On 02/03/2016 20:56, Joe Conway wrote:
>> I thought there was once a link somewhere on the mail archives to get a
>> specific email resent, but for the life of me I cannot find it today :-/
>>
>
> It's only available
(please do not post HTML to these lists; see:
https://wiki.postgresql.org/wiki/Mailing_Lists)
On 03/02/2016 03:06 PM, da...@andl.org wrote:
> Writing a language handler: pl_language_handler. Need to do a variety of
> data conversions. One of them is char* C-string to and from Text/Varchar.
>
> Th
On 03/02/2016 04:20 PM, da...@andl.org wrote:
> (please do not post HTML to these lists; see:
> https://wiki.postgresql.org/wiki/Mailing_Lists)
> [dmb>] I checked the list first: it looks like about 25-50% HTML.
> Happy to oblige, but I think you've got your work cut out.
Understood, but you shou
Islam Hegazy wrote:
I wrote a C function to call from PostgreSQL8.2.4 under Linux. The
functions returns unexpected results. I did an extensive analysis to the
function and it seems correct. I want to know if there is a way to debug
C functions that are passed to PostgreSQL.
Yes. Something al
Marko Kreen wrote:
On 6/5/07, Brian Mathis <[EMAIL PROTECTED]> wrote:
pgcrypto also supports md5, so I'm not sure what you're referring to
here.
digest(psw, 'md5') vs. crypt(psw, gen_salt('md5'))
As I already mentioned, *salting* before you hash is a very
important step. I'm not sure if you
Bill Moran wrote:
Tom Allison <[EMAIL PROTECTED]> wrote:
If the user base gets to 100 or more, I'll be hitting a billion rows before too
long. I add about 70,000 rows per user per day. At 100 users this is 7 million
rows per day. I'll hit a billion in 142 days, call it six months for simpl
Gustavo Tonini wrote:
Someone have a function that converts a string literal (a varchar
argument) to an integer array?
It isn't clear from your question if you want this:
select string_to_array('1,2,3'::varchar,',')::int[];
string_to_array
-
{1,2,3}
(1 row)
or this:
select
Ow Mun Heng wrote:
=> select code, subset, avg(value) from foo group by subset, code;
code | subset | avg
--++-
A| 3 | 98.
A| 1 | 20.
A| 4 | 98.
A| 0 | 98.000
Ow Mun Heng wrote:
On Thu, 2007-09-06 at 20:19 -0700, Joe Conway wrote:
An alternative way to get the output below, would be to feed your
aggregate query above to the crosstab() function in contrib/tablefunc.
I just looked at it and seems like the
...
row_name and value must be of type
Tom Lane wrote:
so it's trying to pstrdup a null result from SPI_getvalue.
Obviously it shouldn't crash, but I'm not sure what it *should* do in
this case. Joe?
The row is pretty useless without a rowid in this context -- it seems
like the best thing to do would be to skip those rows entirel
Tom Lane wrote:
Jorge Godoy <[EMAIL PROTECTED]> writes:
Em Thursday 18 October 2007 16:37:59 Joe Conway escreveu:
The row is pretty useless without a rowid in this context -- it seems
like the best thing to do would be to skip those rows entirely. Of
course you could argue I suppose t
Tom Lane wrote:
Jorge Godoy <[EMAIL PROTECTED]> writes:
Em Thursday 18 October 2007 16:37:59 Joe Conway escreveu:
The row is pretty useless without a rowid in this context -- it seems
like the best thing to do would be to skip those rows entirely. Of
course you could argue I suppose t
Reg Me Please wrote:
The meaning is that an entity called by the value of "item" has a number
of properties called by "property" with value "prop_value".
So, for a single "item" there can be many different "property" each with its
own value.
A filter is a list of property values needed to qua
Reg Me Please wrote:
Il Wednesday 21 November 2007 20:22:46 Joe Conway ha scritto:
Reg Me Please wrote:
The meaning is that an entity called by the value of "item" has a number
of properties called by "property" with value "prop_value".
So, for a single &quo
list of the
> categories corresponding to the output columns.
HTH,
Joe
--
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
Training, Service, Consulting, & 24x7 Support
signature.asc
Description: OpenPGP digital signature
"object graph" not
> "image representation of data".
Analysis of graphs is available via PL/R as well. See:
http://cran.r-project.org/web/views/gR.html
Joe
--
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
Training, Service, Consulting, & 24x7 Support
signature.asc
Description: OpenPGP digital signature
++
a || 1.23
b| 2.34 |
(2 rows)
HTH,
Joe
--
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
Training, Service, Consulting, & 24x7 Support
signature.asc
Description: OpenPGP digital signature
in the app code.
>
> Any advice or clues? I need the app to work on both platforms.
Just a guess, but maybe DNS lookup time? Try using IP address instead of
FQDN.
HTH,
Joe
--
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
Training, Service, Con
bit overcomplex for a back-patch. Joe, any thoughts?
Sorry for the slow response.
I think this issue was fixed by that patch only as a side effect of
significant restructuring. The attached one liner against 8.4 seems to
fix it. Objections?
Joe
--
Joe Conway
credativ LLC: http://www.credativ.u
.org/index.php -- is
bidirectionally linked with sipx-us...@list.sipfoundry.org
Joe
--
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
Training, Service, Consulting, & 24x7 Support
signature.asc
Description: OpenPGP digital signature
owdt::date, temperature FROM mytable ORDER BY 1$$,
$$VALUES('2003-03-01'),('2003-03-02'),('2003-03-03')$$
)
AS
(
rowid text,
"2003-03-01" int,
"2003-03-02" int,
"2003-03-03" int
);
rowid | 2003-03-01 | 2003-03-02 | 2003-03-03
--
mperature FROM
mytable WHERE 1 = 1 ORDER BY
1,2','VALUES($v$2003-03-01$v$),($v$2003-03-02$v$),($v$2003-03-03$v$)')
AS (rowid
contrib_regression(# text,"2003-03-01" int,"2003-03-02" int,"2003-03-03"
int);
rowid | 2003-03-01 | 2003-03-02 | 2003-03-03
---+--
27; quote '"';
select * from testcsv;
id | f1| f2 | f3
+-----+-+
1 | testing 123,456 | hello world | 42
(1 row)
HTH,
Joe
--
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
Training, Service, Consulting, & 24x7 Support
signature.asc
Description: OpenPGP digital signature
e = int[]
);
select grp, pairwise_sum(a) from regres group by grp;
grp | pairwise_sum
- -+--
1 | {14,16,19}
2 | {11,13,15}
(2 rows)
HTH,
Joe
- --
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
Training, Service, Consu
pful"
http://no0p.github.io/postgresql/2014/09/06/benchmarking-postgresql-btrfs-zlib.html
Joe
- --
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
Training, Service, Consulting, & 24x7 Support
-BEGIN PGP SIGNATURE---
hibit hall, all Saturday/Sunday speaker tracks, and evening events
(excludes the Linux Training Class).
Schedule:
http://www.socallinuxexpo.org/scale11x/schedule/friday
Register:
https://reg.socallinuxexpo.org/reg6/
--
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general
nting the paging transparently beneath the
dataframe object, but have not gotten around to it. Apparently the
Oracle connector to R is able to do that, so I'm sure it is a SMOP.
Joe
- --
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
Training, Servi
i.e. work on one
group at a time) or use the SPI cursor functionality within the PL/R
function and page your data using a cursor. Not all forms of analysis
lend themselves to these approaches, but perhaps yours does.
Ultimately I would like to implement a form of R data.frame that does
the pa
ontrib_regression set search_path to foobar;
select * from pg_db_role_setting ;
setdatabase | setrole | setconfig
- -+-+--
0 | 16401 | {search_path=bar}
16384 | 0 | {search_path=foobar}
(2 rows)
Is that what you are looking for?
HTH
On 02/27/2017 03:25 PM, Nathan Stocks wrote:
> What worthwhile conferences should a PostgreSQL DBA consider going to?
>
> There have been some good sessions at OSCON in the past, but I was
> wondering about more DBA-specific events.
In North America the bigger ones are:
--
On 03/31/2017 01:58 AM, Moreno Andreo wrote:
> Il 30/03/2017 14:38, Vick Khera ha scritto:
>>
>> On Thu, Mar 30, 2017 at 6:10 AM, Moreno Andreo
>> mailto:moreno.and...@evolu-s.it>> wrote:
>>
>> Since I'm on Google Cloud Platform, I thought it would be a good
>> idea to see what it offers.
On 04/07/2017 05:35 PM, Adrian Klaver wrote:
> On 04/07/2017 05:03 PM, John Iliffe wrote:
Running on Fedora 25 with SELinux in PERMISSIVE mode. The audit log
shows no hits on Postgresql.
>> My going in position was/still is, that this is a SELinux security
>> problem
>> but I am findin
On 04/08/2017 06:31 AM, John Iliffe wrote:
> On Saturday 08 April 2017 00:10:14 Adrian Klaver wrote:
>> On 04/07/2017 07:45 PM, Joe Conway wrote:
>> > On 04/07/2017 05:35 PM, Adrian Klaver wrote:
>> >> On 04/07/2017 05:03 PM, John Iliffe wrote:
>> >&g
On 04/08/2017 01:23 PM, John Iliffe wrote:
> On Saturday 08 April 2017 09:38:07 Adrian Klaver wrote:
>> So what if you change the connection to use -h localhost?
>
> Can you please expand on that request? I'm not sure where you want me to
> put that directive. I'm using the mod_php module in Ap
On 04/09/2017 11:33 AM, John Iliffe wrote:
> On Saturday 08 April 2017 18:10:35 Joe Conway wrote:
>> On 04/08/2017 01:23 PM, John Iliffe wrote:
>> > On Saturday 08 April 2017 09:38:07 Adrian Klaver wrote:
>> >> So what if you change the connection to use -h localh
On 04/09/2017 12:37 PM, John Iliffe wrote:
>> > Thanks Joe. I Changed the pg_connect line in the script to:
>> > $db_handle = pg_connect('dbname=yrarc host=192.168.1.6 port=5432
>> > user= password=xx');
> If I may be permitted a rant at this point, the Fedora documentation is
> almost
On 06/08/2017 10:37 PM, Ken Tanzer wrote:
> My approach was to have the initial connection made by the owner, and
> then after successfully authenticating the user, to switch to the role
> of the site they belong to. After investigation, this still seems
> feasible but imperfect. Specifically, I
On 06/09/2017 08:56 AM, Ken Tanzer wrote:
> On Fri, Jun 9, 2017 at 6:42 AM, Joe Conway wrote:
> See set_user for a possible solution: https://github.com/pgaudit/
>
> Thanks! Looking at the README, it seems like the intended use case is
> the opposite (escalating privil
On 06/09/2017 02:16 PM, Ken Tanzer wrote:
> FWIW, it would be clearer at least to me if you took the two statements
> in the description:
>
> * log_statement setting is set to "all", meaning every SQL statement
> executed while in this state will also get logged.
> * If set_user.block_log_
On 08/07/2017 04:47 PM, anand086 wrote:
> Only Insert/Update/Delete sqls are to be audited.
You could get close to what you want, I think, by setting log_statement
= mod for the users of interest, e.g. by doing:
ALTER USER whomever SET log_statement = mod;
See:
https://www.postgresql.org/docs
e (see the VIEW roletree):
https://github.com/pgaudit/set_user
Then you can do something like:
SELECT
ro.rolname,
ro.rolcanlogin,
ro.rolparents
FROM roletree ro
WHERE 'module_dml' = ANY (rolparents);
rolname | rolcanlogin |rolparents
-+-+--
bob
On 10/20/2017 02:10 PM, Tom Lane wrote:
> "David G. Johnston" writes:
>> On Fri, Oct 20, 2017 at 1:12 PM, rakeshkumar464
>> wrote:
>>> How do I know beforehand where the dir path is ?
>
>> I think pg_config (
>> https://www.postgresql.org/docs/current/static/app-pgconfig.html ) is what
>> you ar
On 11/09/2017 01:59 PM, chiru r wrote:
> I am using PostgreSQL version *9.5.7* on Red hat enterprise Linux *7.2.*
>
> *OpenSSL version : * OpenSSL 1.0.1e-fips 11 Feb 2013.
>
> I have a requirement to enable the SSL in my environment with specific
> cipher suites,we want to restrict weak cipher su
On 11/09/2017 05:52 PM, chiru r wrote:
> If OpenSSL apply any patches at OS level, Is there any
> changes/maintenance we need to perform at PostgreSQL end?
>
> On Thu, Nov 9, 2017 at 5:46 PM, Joe Conway wrote:
>> Assuming you mean that you need only FIPS 140-2 compliant ciphers,
On 11/10/2017 01:01 PM, Adam Brusselback wrote:
>> You might want to increase pg_ctl's wait timeout for this situation,
>> since the default's evidently too little. However ...
> Got it, thanks.
>
>> ... pg_ctl itself wouldn't decide to forcibly shut down the server
>> if the timeout expired. It
Enrico Sirola wrote:
typically, arrays contain 1000 elements, and an operation is either
multiply it by a scalar or multiply it element-by-element with another
array. The time to rescale 1000 arrays, multiply it for another array
and at the end sum all the 1000 resulting arrays should be enough
Erik Jones wrote:
See how postgres handles filling the NULLs for you? What you'd really
want to do with this would be to define some functions for setting and
getting a person's answers to a given question or set of questions so
that you could implement some kind of data integrity with regards
Balázs Klein wrote:
I was hoping that now with PG supporting plan invalidation it would
be possible to return a recordset.
Plan invalidation has nothing to do with it. In Postgres a returned
recordset can be used as a row source in the FROM clause -- this
requires data type information to be
Alvaro Herrera wrote:
Joe Conway wrote:
It occurs to me that it shouldn't be terribly difficult to make an
alternate version of crosstab() that returns an array rather than tuples
(back when crosstab() was first written, Postgres didn't support NULL
array elements). Is
Kelly Jones wrote:
I have a directed graph (nodes and edges) that I want to store
"efficiently": given two nodes, I want to quickly find the shortest
path between them. The graph is NOT acyclic (it's not a tree), is
fairly "sparse" (about 1 edges for 2500 nodes), and changes
occasionally.
I
Kevin Kempter wrote:
Anyone know of any MOLAP/MDDB/MDX Business Intelligence reporting solutions
tahat work on top of PostgreSQL ?
I haven't used it myself, but you could check out Mondrian:
http://sourceforge.net/projects/mondrian/
HTH
Joe
--
Sent via pgsql-general mailing list (pgsql-g
> Joe Conway <[EMAIL PROTECTED]> wrote:
>> Sorry, my bad. Fixed
Ivan Zolotukhin wrote:
Still does not work for me, HTTP timeout
Yeah, my words above were so called "famous last words".
Shortly after fixing the problem and writing that email, my ISP decided
to m
Scott Marlowe wrote:
On Sat, Jun 27, 2009 at 1:45 PM, Michal Szymanski wrote:
Hi,
I'm looking for free software that provide OLAP functionality (or more
general BI) for data that are stored in Postgres database. I've found
Pentaho and Jasper but both sollution are configured for MySQL. Can
you
Adam Rich wrote:
Hello,
I have a table with a DATE field "birth_date". The data obviously
contains various dates in the past, such as 07/04/1970. In my query, I
need to retrieve the person's "next" birthday. In other words, for the
example date 07/04/1970, the query should return 07/04/2009
latest code from github, which works fine with 9.3:
https://github.com/jconway/plr
Joe
- --
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
Training, Service, Consulting, & 24x7 Support
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.12 (GNU
hat it didn't need the column definition list until query
execution time, which I also doubt is possible.
Joe
--
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
Training, Service, Consulting, & 24x7 Support
--
Sent via pgsql-general mailing li
On 12/18/2013 05:14 PM, John Abraham wrote:
On Dec 18, 2013, at 3:52 PM, Joe Conway wrote:
3) Not possible -- reason was given down thread. Column definition
must be known/determinable by the parser prior to query execution.
No, wait, I think you misunderstood my idea. Can’t we have a
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 01/24/2014 12:50 PM, alexandros_e wrote:
> For some reason levenshtein_less_equal does not work,
Define "does not work", i.e. cut and paste exact SQL and output so we
can see and reproduce your issue.
Joe
- --
Joe Conway
creda
3
(1 row)
8<-
We need more specific info about how you obtained and installed the
extension.
Joe
- --
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
Training, Service, Consulting, & 24x7
4-bit"
>
> routing_nw2=# \df levenshtein_less_equal List of functions Schema
> | Name | Result data type | Argument data types | Type
> +--+--+-+-- (0
> rows)
>
> routing_nw2=#
Hmm, can we see:
\dx
and
\df
fuzzystrmatch | 1.0 | public | determine similarities and
distance between strings
plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language
(2 rows)
Joe
- --
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
theory,
can't say I have tried it extensively). But your method works too ;-)
Joe
- --
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
Training, Service, Consulting, & 24x7 Support
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.14 (GNU/Linux)
C
the examples about 2/3rds down the page.
HTH,
Joe
- --
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
Training, Service, Consulting, & 24x7 Support
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.14 (GNU/Linux)
Comment: Using GnuP
s is, do you see any
> optimizations?
Not exactly what you asked, but you might try PL/R with the R
"classInt" package:
http://cran.at.r-project.org/web/packages/classInt/classInt.pdf
HTH,
Joe
- --
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Sou
e the issue.
In other words, help us help you.
Joe
- --
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
Training, Service, Consulting, & 24x7 Support
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.14 (GNU/Linux)
Comment: Using GnuPG with Thu
e,produkid, onhand
from test order by 1,2',
'values (279140414),(279140421)'
)
as ct (warehousename text, p_279140414 int, p_279140421 int);
warehousename | p_279140414 | p_279140421
- ---+-----+-
OFFICE
RE? )
select * from dblink('dbname=test',$$select array_agg(r) from (values
(1::int, 'today'::timestamp, 'a'::text), (2, 'yesterday', 'b'))
r(a,b,c)$$) as d(f text[]);
f
- --
| text| not null
Indexes:
"like_twserid_pkey" PRIMARY KEY, btree (id)
Then something like:
insert into like_twserid select * from twserid;
SELECT setval('twserid_id_seq', (select max(id) from like_twserid));
HTH,
Joe
--
Joe Conway
credativ LLC: http://www.credativ
'shared_buffers';
setting
-
4096
(1 row)
postgres=# select 4096 * 8 / 1024 as MB;
mb
32
(1 row)
HTH,
Joe
--
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
Training, Service, Consulting, & 24x7 Support
--
Sent via pgsq
e:
*Speaker Full Name
*Speaker Bio
*E-mail
*Cell Phone
*Title of Talk
*Description of Talk
*Notes for Committee
For more information visit:
https://sites.google.com/site/pgdayla/
--
Regards,
Joe Conway
Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql
ot;.
select array_to_string
(
(
string_to_array
(
'aaa,bbb,ccc,ddd,eee,fff,ggg',','
)
)[1:3],','
);
array_to_string
-----
aaa,bbb,ccc
(1 row)
HTH,
Joe
--
Joe Conway
credativ LLC: http://www.creda
PL/R, or some hand-coded SQL statement to
build your crosstab.
But certainly if you can do all your work on the reshaped table within
the R environment, PL/R will be easier to use.
Joe
--
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
Training, Serv
es will be applied. Postgres must be able to resolve data
types for the columns in the result, and therefore it needs you to
provide a column definition either at function creation time (via OUT
params or by explicit composite return type) or at execution time via
AS(...) clause.
Joe
--
Joe Con
faster, but it may well be more convenient if your goal is to get a
CSV file in the end anyway.
Joe
--
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
Training, Service, Consulting, & 24x7 Support
--
Sent via pgsql-general mailing list (pgsql-g
form as bytea from a PL/R function and store it in a table along with
the basic experimental info. Then later if you pass the serialized
object back into another PL/R function as a bytea argument, it gets
reconstituted as the original R object.
Joe
--
Joe Conway
credativ LLC: http://www.credat
ed into your R interpreter
when R is first initialized.
http://www.joeconway.com/plr/doc/plr-module-funcs.html
Joe
--
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
Training, Service, Consulting, & 24x7 Support
--
Sent via pgsql-general mai
e slide 19 here:
http://www.joeconway.com/presentations/LISA2012-PredSrvAnalytics.pdf
> beware sql injection.
good point!
Joe
--
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
Training, Service, Consulting, & 24x7 Support
--
Sent via pgsq
On 07/02/2010 08:13 AM, saitenhe...@web.de wrote:
> Thanks for reply Tom!
>
> I've tried several version:
>
> #define _USE_32BIT_TIME_T
>
> #include "postgres.h"
> #include "fmgr.h"
> #include "executor\spi.h"
>
> /*
> #ifdef PG_MODULE_MAGIC
> PG_MODULE_MAGIC;
> #endif
> */
> but still the sam
On 07/02/2010 08:36 AM, saitenhe...@web.de wrote:
> Thanks, I've already tried that. I doesn't make any difference. Still the
> same error.
>
> in Visual C++ I can't even compile it, although I set all links and
> compiler directories like it was told in this post:
> http://www.postgresql.org/
ian 4.3.2-1.1) 4.3.2 "
>
> Is there an effective way to identify these objects using the stats
> tables? Something like a last accessed/used or some such column?
Maybe pg_statio* views?
http://www.postgresql.org/docs/8.3/interactive/monitoring-stats.html
Joe
--
Joe Conway
cr
ary of the performance hit
and rapidly growing log though. Another idea would be to modify a copy
of 8.3.x source code (I think that's what you said you were on in an
earlier post) to emit a NOTICE with a name whenever a function is called
if it meets some criteria.
Joe
--
Joe Conway
credati
lot of PostgreSQL users in the San Diego metropolitan
area, and getting a PUG going here is long overdue. Please join up,
spread the word, and attend if you can!
Joe
--
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
Training, Service, Consulting
1 - 100 of 277 matches
Mail list logo
