Does anyone have experience accessing a datomic database using a foreign
data wrapper?
I'd be quite content with read-only and discarding the transaction data.
The real goal is to explore data in datomic using SQL.
Thanks,
Reece
Does anyone know if there are plans to support plpython in Amazon's RDS? I
(approximately) understand the issue, but I don't know if there's any
effort to remedy the problem or, rather, I shouldn't bother hoping.
Thanks,
Reece
On Fri, Feb 14, 2014 at 10:15 AM, Merlin Moncure wrote:
> yeah -- you could do this with some gymnastics and some dynamic SQL.
> If I were lazy (check), I would just encode the order in the name of
> the view somehow.
>
Thanks. That's exactly what I do already. Apparently, I'm even lazier than
y
Is there a way to automatically refresh all materialized views, preferably
in order of dependendency?
I should be able to chase pg_depends entries to create this ordering, right?
Thanks,
Reece
On Fri, Feb 7, 2014 at 8:27 AM, Steve Crawford <
scrawf...@pinpointresearch.com> wrote:
> Ignoring the scary security issues
>
One of the niceties of an RDS deployment is that I don't care much about
the security issues: The machine is not in our VPC, there's only public
data on it, and I pre
On Thu, Feb 6, 2014 at 6:37 PM, David Johnston wrote:
> Doubtful.
>
Yeah, that's what I had assumed too.
The question is motivated entirely by what I think would make it easier for
users. In principle it's not difficult to give people a password (as I do
now), but in practice it's a barrier tha
I'd like to provide public access, without a password, to a database hosted
on Amazon RDS.
I'm familiar with using pg_hba.conf to enable trust (no) authentication for
a user. pg_hba.conf is not available to DBAs on RDS.
Is there any other way to achieve password-less login in postgresql? I
tried
On Wed, Mar 9, 2011 at 9:16 AM, Merlin Moncure wrote:
> create type validation_flags as
> (
> cluster bool,
> freq bool
> );
>
Wow. That solution is nearly sexy, and far and away better than any solution
that I would have come up with. Thanks, Merlin!
-Reece
On Tue, Mar 8, 2011 at 9:41 PM, John R Pierce wrote:
> why not just have a set of booleans in the table for these individual
> on/off attributes? wouldn't that be simplest?
I like that approach, but I think it's unlikely to fly in this specific case
for a couple reasons.
First, there are act
On Tue, Mar 8, 2011 at 5:51 PM, Steve Atkins wrote:
> tsvector or intarray might be other options, depending on how you're going
> to query it and whether those are really strings or more enum-ish.
>
> The more SQLy way of doing it would be to have that stored in a separate
> table, with a foreig
On Tue, Mar 8, 2011 at 5:52 PM, Darren Duncan wrote:
> Try starting with an enum type to define the possible values:
>
> CREATE TYPE Consequence_Type
>AS ENUM ('ESSENTIAL_SPLICE_SITE','STOP_GAINED',
> 'STOP_LOST','COMPLEX_INDEL','SPLICE_SITE');
>
> ... and then you could try using "ARRAY
I'm considering porting a MySQL database to PostgreSQL. That database uses
MySQL's SET type. Does anyone have advice about representing this type in
PostgreSQL?
MySQL DDL excerpt:
CREATE TABLE `transcript_variation` (
`transcript_variation_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`transcr
On 02/02/2010 03:41 PM, DM wrote:
You were right, after zipping the dump file it came out to 6.9G
Also check out the "custom" pg_dump format (pg_dump -Fc ...), which is
compressed. There are caveats regarding portability across PG versions
with the custom format, which you may want to resear
On Wed, 2009-12-30 at 09:11 -0800, shulkae wrote:
> I want to delete all rows exceeding 400 hours (10 days) and I want to
> limit deletion of only 100 records at a time.
If your table has a primary key or you can contrive one, then the
DELETE FROM tbl WHERE pk in (SELECT pk FROM tbl WHERE hours>4
On Fri, 2009-07-03 at 11:29 -0700, David Fetter wrote:
> I'm missing what you're doing here that foreign keys don't cover.
> Could you send along your DDL?
No DDL yet... I'm just in the thinking stages. FKs technically would do
it, but would become unwieldy. The intention was to have subclasses o
On Thu, 2009-07-02 at 19:19 -0700, Nathan Boley wrote:
> Is an association, for example, an experiment that establishes a
> dependent relationship? So could there be multiple associations
> between variant and phenotype?
Exactly. You might have one group say that allele X "causes" some trait,
whe
This is a question about data modeling with inheritance and a way to
circumvent the limitation that primary keys are not inherited.
I'm considering a project to model genomic variants and their associated
phenotypes. (Phenotype is a description of the observable trait, such as
disease or hair colo
On Mon, 2009-05-18 at 15:13 -0400, Joshua Berry wrote:
> Is there an easy and efficient way to return a boolean false for a
> query that returns no result, and true for one that does return a
> result?
Presuming that you're not using the values in temp_table, I think you
should be using PERFORM
gexp) won't work because extended
regexps might contain character classes (e.g., \S != \s). And, I guess
that alias ~* regexp requires a seqscan because the index isn't ordered
over ~* (right?). How about lower(alias) ~* regexp ? Is PG smart enough
to know that that ordering is wel
Index Scan using a_t on a (cost=0.00..8.27 rows=1 width=4) (actual
time=0.061..0.062 rows=1 loops=1)
Index Cond: (t = 'foo'::text)
Total runtime: 0.099 ms
(3 rows)
script at http://harts.net/reece/tpo-test.s
---
indexname | pannotation_alias
indexdef | CREATE INDEX pannotation_alias ON pannotation USING btree (alias)
-[ RECORD 4 ]-
indexname | pannotation_alias_cf
indexdef | CREATE INDEX pannotation_alias_cf ON pannotation USING btree
(lower(a
My two:
* lack of PK/unique indexes on inherited tables (workarounds possible
but annoying)
* lack of auto-tuning or tuning tools (or perhaps my lack of awareness
of them?)
-Reece
--
Reece Hart, http://harts.net/reece/, GPG:0x25EC91A0
conference site
I'm open to all feedback and problem reports.
Cheers,
Reece
--
Reece Hart, http://harts.net/reece/, GPG:0x25EC91A0
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
B,textarea1,enter your long comment here
You could easily extend this to , or normalize it
as you see fit.
Another possibility is to use hstore hashes for form fields/values. See
http://www.postgresql.org/docs/8.3/static/hstore.html
Do either of those suffice?
-Reece
--
Reece Hart, http://hart
lel query optimization -- presumably
contention for memory (for parallel sorts, say) becomes critical.
-Reece
--
Reece Hart, http://harts.net/reece/, GPG:0x25EC91A0
lease, you will be able to use a better way:
> EXECUTE 'INSERT INTO ' || ctable || ' VALUES( ($1).* )' USING new;
Domo arigato, Itagaki-san. (I think I got that right.)
The 8.3 method works like a charm.
-Reece
--
Reece Hart, http://harts.net/reece/, GPG:0x25EC91A0
I didn't know what else to try.
Now that my only idea is gone, the question for y'all is: how?
(Okay, I actually do have one more idea: construct the insert values
list with quote_literal. I'm hoping there's a better way.)
Thanks,
Reece
--
Reece Hart, http://harts.net/ree
ql can see the same files (i.e., are running on the same machine or
you're saving to a network fs), it's more reliable to save the file and
read it in psql with \i or with psql -f. (\i and -f won't try to do tab
completion, of course.)
-Reece
--
Reece Hart, http://harts.net/reece/, GPG:0x25EC91A0
dtable in the new db
(perhaps using the COPY method above). This won't work if there are
intentional identical rows in your table.
The pipe assumes a Unix-ish box.
-Reece
--
Reece Hart, http://harts.net/reece/, GPG:0x25EC91A0
On Tue, May 20, 2008 at 02:25:15PM -0400, Decibel! wrote:
> I need to add a field to a fairly large table. In the same alter statement
> I'd like to add a FK constraint on that new field. Is there any way to
> avoid the check of the table that the database is doing right now? The
> check is poin
names like _someview_v_20080520.) When you rename a
table or view, the definition of any views which depend on them will be
updated appropriately. This is particularly handy when you have several
layers of views and don't want to break current behavior.
-Reece
--
Reece Hart, http://harts
robably want dblink, a stiff drink, and a long-hard
think about the prudence of such a design.
-Reece
--
Reece Hart, http://harts.net/reece/, GPG:0x25EC91A0
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
e care to comment about whether a table partition might be better
here? Could an insert rule on a table partition automatically create the
inherited table, if needed, and insert there?
Thanks,
Reece
--
Reece Hart, http://harts.net/reece/, GPG:0x25EC91A0
mydb.toc >mydb-fx.toc
$ pg_restore -L mydb-fx.toc mydb.pgdfc
The output of pg_restore is sql.
This technique is extremely useful for other kinds of schema elements as
well.
-Reece
--
Reece Hart, http://harts.net/reece/, GPG:0x25EC91A0
--
Sent via pgsql-general mailing list (pgsql-general
general regexp like
the one I initially tried. Do you have any suggestions?
Thanks again. I'm very impressed with tsearch2.
-Reece
--
Reece Hart, http://harts.net/reece/, GPG:0x25EC91A0
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
1 or 2 chars from
[a-zA-Z0-9]. Does that require a custom parser?
Thanks,
Reece
--
Reece Hart, http://harts.net/reece/, GPG:0x25EC91A0
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
change)
2. a (multiple times daily)
3. consistent with 1
4. c
Blue. No, red. Aaah...
--
Reece Hart, http://harts.net/reece/, GPG:0x25EC91A0
en the partition criterion changes into
the database. I've not done this myself, so I'm, um, not speaking from
experience.
-Reece
--
Reece Hart, http://harts.net/reece/, GPG:0x25EC91A0
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes
is was true for all engines or whether it
might have been fixed. Having to shutdown a database to make a backup is
a non-starter for anything that other than a toy (or read-only)
databases.
-Reece
--
Reece Hart, http://harts.net/reece/, GPG:0x25EC91A0
e \g file, then \i file
* within psql, use \g |psql
I like the \g + \i option most for consistency and robustness (don't
have to specify the db connection or worry about connecting to the wrong
db), but what I really want is a hypothetical \eval to execute the query
and then execute the result
CSV formatting isn't being done in the database
but rather by psql.
-Reece
--
Reece Hart, http://harts.net/reece/, GPG:0x25EC91A0
---(end of broadcast)---
TIP 6: explain analyze is your friend
code.
Thanks,
Reece
--
Reece Hart, http://harts.net/reece/, GPG:0x25EC91A0
| 2007-05-01 12:03:00 | 00:05:00
(4 rows)
-Reece
--
Reece Hart, http://harts.net/reece/, GPG:0x25EC91A0
create table data (
client_id integer,
datetime timestamp not null
);
create index data_client_id on data(client_id);
copy data from STDIN DELIMITER ',';
122,2007-05-01
eally sure where that is.
--
Reece Hart, http://harts.net/reece/, GPG:0x25EC91A0
ctable issues that will happen".
If uid is unique then something like
=> select uid,somevalue,somevalue||'-'||uid from mytable
is much better.
-Reece
--
Reece Hart, http://harts.net/reece/, GPG:0x25EC91A0
---(end of broadcast)---
TIP 6: explain analyze is your friend
e;' .
Although DISTINCT is standard, the DISTINCT ON (cols) variant is a
PostgreSQL-ism.
See
http://www.postgresql.org/docs/8.2/static/queries-select-lists.html#QUERIES-DISTINCT
.
-Reece, your heterographic brother
--
Reece Hart, http://harts.net/reece/, GPG:0x25EC91A0
AccessShareLock | RUN | rkh | select * from pgutils.locks ; | 00:00:00
15716 | csb-dev | pg_catalog | pg_class_oid_index | relation |
AccessShareLock | RUN | rkh | select * from pgutils.locks ; | 00:00:00
15716 | csb-dev | pg_catalog | pg_class_relname_nsp_index | relati
er that I saw a log of these in /var/log/messages (assuming
you're logging locally). Consider looking there to see if you have other
instances of this bug with other applications.
-Reece
--
Reece Hart, http://harts.net/reece/, GPG:0x25EC91A0
a from ( ) X;
This will get you only the timestamps of adjacent rows with large
deltas. The easiest way to get the associated data is to join on the
original data table where ts1=ts or ts2=ts.
-Reece
--
Reece Hart, http://harts.net/reece/, GPG:0x25EC91A0
99.)
Bear in mind that the ordering of rows with the same value (incl. NULL)
of foo is arbitrary. And, I guess that the equivalence of this query on
two systems will depend on the collating locale also (but I'm a neophyte
in this area).
-Reece
--
Reece Hart, http://harts.net/
n_schema.tables"
-Reece
--
Reece Hart, http://harts.net/reece/, GPG:0x25EC91A0
---(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
ll path) and I unsetl PG* variables.
-Reece
--
Reece Hart, http://harts.net/reece/, GPG:0x25EC91A0
imary
keys routinely.
-Reece
--
Reece Hart, http://harts.net/reece/, GPG:0x25EC91A0
particular range of m1.
begin;
update master set m1=-m1;
update master set m1=-m1+1;
commit;
You could just as easily add N to m1, then subtract (N-1) from m1.
You'll need N>max(m1).
Good luck,
Reece
--
Reece Hart, http://harts.net/reece/, GPG:0x25EC91A0
e rows than to incur the index overhead. These
decisions are not always correct, but they're usually quite good.
If you don't believe it, try:
# set enable_seqscan=off;
# explain analyze ...
# set enable_seqscan=on;
# explain analyze ...
-Reece
--
Reece Hart, http://harts.net/reece/, GPG:0x25EC91A0
to
me that it wouldn't be hard to move your dependency encoding into the
SQL itself, such as
-- requires: utils.sql common.sql
create or replace function ...
Then you'd automatically generate a file of sql dependencies using a
perl one-liner (or whatever).
-Reece
--
Reece
en, I generate a table of contents with pg_restore -l,
edit the TOC to include only the entries I want, and then rerun
pg_restore with -L.
Good luck,
Reece
--
Reece Hart, http://harts.net/reece/, GPG:0x25EC91A0
---(end of broadcast)---
TIP 9:
sive, but get you exactly 100 (if your table has >= 100
rows, of course).
-Reece
--
Reece Hart, http://harts.net/reece/, GPG:0x25EC91A0
---(end of broadcast)---
TIP 6: explain analyze is your friend
cuum_cmd from view' | psql -aX
which uses one connection to select the script, and another to execute
it.
Good luck,
Reece
--
Reece Hart, http://harts.net/reece/, GPG:0x25EC91A0
---(end of broadcast)---
TIP 1: if posting/reading through
d_idx
(cost=0.00..33385.65 rows=1692012 width=0)
Index Cond: (tax_id = 9606)
(9 rows)
Long ago I compared a few views with their inlined counterparts and the
upshot is that there is exactly or practically zero difference.
-Reece
--
Reece Hart,
x27;);
iif
--
nope
(1 row)
[EMAIL PROTECTED]> select $$It's$$ || iif(true,'',' not') || ' true';
?column?
---
It's true
(1 row)
The fu
tiple years. You
wouldn't be able to do that (easily*) if you archived the full database.
-Reece
* This is where David Fetter will mention dblink.
--
Reece Hart, http://harts.net/reece/, GPG:0x25EC91A0
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
t the space saved by storing digests as
binary (1/2 size of hex) will substantially impact index ins/upd/del
performance or when the digest itself is a large fraction of the rest of
the row size?
Thanks,
Reece
--
Reece Hart, http://harts.net/reece/, GPG:0x25EC91A0
t the space saved by storing digests as
binary (1/2 size of hex) will substantially impact index ins/upd/del
performance or when the digest itself is a large fraction of the rest of
the row size?
Thanks,
Reece
--
Reece Hart, http://harts.net/reece/, GPG:0x25EC91A0
data types that provide these
conversions? If not, I'll do it myself... but I'd rather steal of
course.
Thanks,
Reece
--
Reece Hart, http://harts.net/reece/, GPG:0x25EC91A0
./universe -G 6.672e-11 -e 1.602e-19 -protonmass 1.673e-27 -uspres bush
kernel warning: universe consuming too many res
[EMAIL PROTECTED]> select 'pseq'::regclass::oid::FQregclass;
regclass
--
unison.pseq
(1 row)
-Reece
--
Reece Hart, http://harts.net/reece/, GPG:0x25EC91A0
./universe -G 6.672e-11 -e 1.602e-19 -protonmass 1.673e-27 -uspres bush
kernel w
On Mon, 2007-03-19 at 13:03 -0700, Reece Hart wrote:
> The harder and more general case is to build such a query dynamically
> from pg_depends
...
> See the pg_depends documentation at
Apologies. I intended to write pg_constraint and the documentation at
http://www.postgresql.org
ot be too painful to generate the query within the
trigger itself. Otherwise, you might have to store/update these queries
in a separate table after every DDL change.
See the pg_depends documentation at
http://www.postgresql.org/docs/8.2/interactive/catalog-pg-depend.html
-Reece
--
Reece Hart,
postgres| 3905 kB
csb | 113 GB
template0 | 3840 kB
csb-dev | 124 GB
csb-dev-snapshot-2007-03-08 | 123 GB
csb_02_02_2007 | 121 GB
template1 | 3840 kB
--
Reece Hart, http://harts.
l never happen (and,
sniffle, I'll be inextricably bound to Oracle forever).
-Reece
--
Reece Hart, http://harts.net/reece/, GPG:0x25EC91A0
./universe -G 6.672e-11 -e 1.602e-19 -protonmass 1.673e-27 -uspres bush
kernel warning: universe consuming too many resources. Killing.
universe killed due to catastrophic leadership. Try -uspres carter.
iscourage cross-database joins. Can
someone out there enlighten me? What's the intent for HSODBC and what
are its limitations? Can one access remote server side functions via
HSODBC (eg, sqlplus> select col1,plpgsqlfx(col1) from remotetable)?
Thanks,
Reece
--
Reece Hart, http://harts.n
ards, I can watch 5 monitors at the same
time, and I can respond to 15 emails while coding on 3 branches and
running regression tests... this is great!
-Reece
--
Reece Hart, http://harts.net/reece/, GPG:0x25EC91A0
./universe -G 6.672e-11 -e 1.602e-19 -protonmass 1.673e-27 -uspres bush
kernel w
t I was being
ignored and was about to restart the cluster anyway, for which I'd
expect remnants. However, I'm certain of the observation that disk full
led to remnants of a partial copy. That job was running in the
background when I wasn't logged in.
Thanks,
Reece
--
Reece H
tly had the disk full
error. My best guess is that these orphaned directories result from
those interruptions and failure.
Thanks,
Reece
--
Reece Hart, http://harts.net/reece/, GPG:0x25EC91A0
./universe -G 6.672e-11 -e 1.602e-19 -protonmass 1.673e-27 -uspres bush
kernel warning: universe consum
sot a database? createdb -T db db-snapshot
seemed like a good idea, but that requires the template db to not be in
use (ie, no logged in users).
I'm running 8.1.8 and will move to 8.2.3 shortly.
Thanks,
Reece
--
Reece Hart, http://harts.net/reece/, GPG:0x25EC91A0
./universe -G 6.672e-11 -e
kh | | 00:00:21
28434 | csb-dev | pg_catalog | pg_stat_activity | relation |
AccessShareLock | RUN | rkh | | 00:00:21
28434 | csb-dev | pgutils | locks | relation |
AccessShareLock | RUN | rkh | | 00:00:21
(6 rows)
-Reece
--
Reece Hart, htt
onsistency of child
tables and an implied UNION ALL of children when one selects on the
parent.
-Reece
--
Reece Hart, http://harts.net/reece/, GPG:0x25EC91A0
./universe -G 6.672e-11 -e 1.602e-19 -protonmass 1.673e-27 -uspres bush
kernel warning: universe consuming too many resources. Killing.
universe killed due to catastrophic leadership. Try -uspres carter.
similar. I wrote some views to do this and
packaged 'em up as something I call pgutils. See:
http://archives.postgresql.org/pgsql-general/2006-11/msg00752.php
http://harts.net/reece/pgutils/
-Reece
--
Reece Hart, http://harts.net/reece/, GPG:0x25EC91A0
./universe -G 6.672e-11 -e 1.60
27; blue
> 'bubu'blue
> 'haha'red
> 'kkk' red
>
> Could I?
select name,'blue' as "table_name" from blue union all select name,'red'
as "table_name" from red;
Note the 'all' after uni
to is
> configured as stop word. Same with most other functions.
That would be useful and almost certainly result in better specificity.
A counter example is searching for "information schema", for which you'd
probably want hits to "information_schema" as well.
-Reece
tp://chrisp.de/en/rsrc/kerberos.html
http://www.windowsnetworking.com/articles_tutorials/Authenticating-Linux-Active-Directory.html
If you can make that work, the community might appreciate a summary of
how you did it.
-Reece
--
Reece Hart, http://harts.net/reece/, GPG:0x25EC91A0
./universe -G 6.672e-11 -e
urned meaningful links. Is that a stemmer
problem?
-Reece
--
Reece Hart, http://harts.net/reece/, GPG:0x25EC91A0
./universe -G 6.672e-11 -e 1.602e-19 -protonmass 1.673e-27 -uspres bush
kernel warning: universe consuming too many resources. Killing.
universe killed due to catastrophic leadership. Try -uspres carter.
liable, cost-effective, and empowering
alternative to proprietary databases and therefore decrease the risk
concerns.
The only reason I spent this much time weighing in is because I'm
thrilled with PostgreSQL (er, sorry Tom, Postgres) and appreciate and
respect the terrific work done in this
e the next character
verbatim". In effect, you're typing ASCII char 5 (a single character)
literally into the single quotes rather than \x05 or any other
representation of it (e.g., \x05). I'm pretty sure that readline is
responsible for this interaction, and therefore this probably doesn't
work on readline-less installations.
-Reece
--
Reece Hart, http://harts.net/reece/, GPG:0x25EC91A0
almost sent you an off-list email before I posted because I just knew you'd know the answer.
Thank you.
-Reece
--
Reece Hart, http://harts.net/reece/, GPG:0x25EC91A0
Woody and Albe-
I wasn't aware of pg_service -- that does solve my original problem.
Thanks for the replies.
-Reece
--
Reece Hart, http://harts.net/reece/, GPG:0x25EC91A0
e that db aliases would affect only new connections.
Thanks,
Reece
--
Reece Hart, http://harts.net/reece/, GPG:0x25EC91A0
, histogram, etc). I appreciate that I could expose this through postgres, but that's a little awkward for prototyping and I'm not keen to add load to my postgres box.
-Reece
--
Reece Hart, http://harts.net/reece/, GPG:0x25EC91A0
the Right Thing for a guy who wants R to talk to postgresql?
Thanks, and send aspirin,
Reece
--
Reece Hart, http://harts.net/reece/, GPG:0x25EC91A0
abase itself to ensure consistency.
-Reece
--
Reece Hart, http://harts.net/reece/, GPG:0x25EC91A0
s,
Reece
--
Reece Hart, http://harts.net/reece/, GPG:0x25EC91A0
name text,
email text,
constraint valid_name_or_email
check (name is not null or email is not null)
);
Cheers,
Reece
--
Reece Hart, http://harts.net/reece/, GPG:0x25EC91A0
---(end of broadcast)-
is in http://harts.net/reece/pgutils/ .
-Reece
--
Reece Hart, http://harts.net/reece/, GPG:0x25EC91A0
, if you expect that the constraints are consistent at the end of the transaction, perhaps the problem is merely the order in which constraints are checked. See
http://www.postgresql.org/docs/8.1/interactive/sql-set-constraints.html
and consider something like SET CONSTRAINTS ALL DEFERRED .
-Reece
w and dump that.
A similar effect could be obtained by synthesizing a create table statement appropriate for the psql data export as above and using the copy command to load data. That could all be wrapped into a single file to be passed to psql for loading.
-Reece
--
Reece Hart, http://harts.net/reece/, GPG:0x25EC91A0
l send it via parcel post with two 13 cent stamps as soon as I finish watching War Games on my betamax.
Is Carter still president?
-Reece
--
Reece Hart, http://harts.net/reece/, GPG:0x25EC91A0
ably improves the consistency of your
security policy (over having the policy in functions).
On the other hand, I could be blowing smoke -- it seems like this outta
work, but I haven't actually done this myself. I don't actually do any
real work myself.
-Reece
--
Reec
coding for specific numbers of args or encoding args them within in a single string... ick!
Is there a way to get more flexible formatting as in these examples within a backend query, even if not with sprintf per se?
Thanks,
Reece
--
Reece Hart, http://harts.net/reece/, GPG:0x25EC91A0
emory.
Okay. Thanks for the advice, Tom.
-Reece
--
Reece Hart, http://harts.net/reece/, GPG:0x25EC91A0
|| ((c)=='*') )
char* clean_sequence(const char* in, int32 n) {
char* out;
char* oi;
int32 i;
out = palloc( n + 1 );/* w/null */
if (!out)
{ elog( ERROR, "couldn't palloc (%d bytes)", n+1 ); }
for( i=0, oi=out; i<=n-1; i++
1 - 100 of 125 matches
Mail list logo
