Hi,
I'm updating my database from 9.4 to 9.6 (Debian Jessie to Stretch). I
think that it is a good opportunity to turn on data checksum.
I don't have experience with cluster creation or moving a DB to a new cluster.
I'll use pg_upgradecluster, but I don't see any option to turn of data checksum.
On Sun, Aug 6, 2017 at 2:43 PM, Karsten Hilbert wrote:
>
> Yes. Been there done that.
>
> Karsten
>
Thanks Karsten, it worked!
Daniel
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hi,
When I do a DELETE FROM table WHERE ...;
I get the number of rows deleted in that table.
How do I get the total number of rows deleted in the database by
foreign keys with the ON CASCADE option?
Thanks,
Daniel
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
d, and may have to deal with a handle randomly going away on
me, I can handle that -- I'm more worried about data corruption and
deadlock problems here, stuff I can't reasonably catch at the application
level)
-Dan
---(end of broadcast)
sures that child processes won't be able to mess up
> the parent's database connection. However it sounded like Dan might be
> doing fork without exec, in which case he's definitely at risk ...
Yep, this is a fork without exec. And the child processes often aren't
even do
an the
children all do get their own handles, just that they're supposed to.
Regardless, at this point I'm sufficiently convinced that things will
potentially be bad (or at least annoying) enough that it warrants fixing
it now, rather than just putting it off and relying on error traps.
-Dan
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
the terminal? I've had
cases in the past where Postgres got unhappy and froze when it couldn't
write logging information to stderr. (Though, granted, in the cases I hit
the server's stderr was redirected to a pipe that was full, so it's not
100% analogous)
-Dan
--
Sent via
column "CREATE USER " does not exist
CONTEXT: SQL statement "SELECT "CREATE USER " || $1 || " WITH PASSWORD
" || $2 "
PL/pgSQL function "user_create" line 2 at execute statement
Directly executing CREATE USER in this function also fails.
thanks!
I actually came to a similar solution after Roman's post.
Thanks all for the replies!
> Dan <[EMAIL PROTECTED]> schrieb:
>
>> Hey,
>>
>> I am running PostgreSQL 8.1.4 and I want to create a user from inside a
>> function. Is this possible in 8.
l function was also handy for this.
Thanks again!
Regards,
Dan
> Double quotes can be used only for identifiers (table, column
> names, etc), you want to use single quotes for strings. Now, since
> you already are in a string (the function body), you need to escape
>
Hi guys,
I am trying to put together a web database for a series of pages that
will be in the format of a journal or magazine. I was wondering if you
knew of any urls that discuss the pros and cons of different structures
of implementation. I have an idea, I just want to see if someone has a
bett
Same version of DB for dump & restore? If not, was the dump done via the
pg_dump from the newer version. If not, please do that.
--
Dan Langille
http://langille.org/
On Aug 28, 2013, at 2:56 AM, Torello Querci wrote:
> Interesting .
>
> while trying to restore the databas
h anything so far
to shed some light on this. Any help someone could provide on how to figure
out where this substantial amount of extra disk space is being used would be
greatly appreciated!
Thanks!
Dan
--
Syzygy Research & Technology
Box 83, Legal, AB T0G 1L0 Canada
P
first place.
Until a few days ago, I hadn't even heard of TOAST tables, and just presumed
all the data was stuffed into the database I created directly. From what I've
read about them since, they sound like a great idea - but I never anticipated
them, or their effect on trying to sor
On 2012-Jan-21, at 6:39 PM, Scott Marlowe wrote:
> On Sat, Jan 21, 2012 at 1:37 AM, Dan Charrois wrote:
>> Hi everyone. I'm currently in the situation of administering a rather large
>> PostgreSQL database which for some reason seems to be even much larger than
>>
ast on this list about the
efficiency of "NOT IN (SELECT DISTINCT ...)", but I haven't yet found any bug
reports about incorrect results. I'm sorry I haven't been able to create
reproducible test case yet.
Thanks,
Dan
1. Query pla
On 8/11/2012 2:21 PM, Raymond O'Donnell wrote:
On 11/08/2012 04:32, Dan Halbert wrote:
1. select count(t1_id) from t1 where t1_id not in (select distinct t1_id
from t2 limit 1103) ==> 13357 [CORRECT result]
2. select count(t1_id) from t1 where t1_id not in (select distinct t1_id
use more than a few gig of
shared buffers. If I do that, though, am I going to have to do a
database dump and reload, or will the disk files be compatible and it
just a matter of shutting down the 32 bit server and firing up the 64
bit one?
--
Dan
At 1:01 AM -0500 3/10/07, Tom Lane wrote:
Dan Sugalski <[EMAIL PROTECTED]> writes:
I assume I'll have to do a 64 bit build to use more than a few gig of
shared buffers. If I do that, though, am I going to have to do a
database dump and reload,
Yes, most likely, because you'
At 7:47 PM +0100 3/10/07, Martijn van Oosterhout wrote:
On Sat, Mar 10, 2007 at 08:30:20AM -0500, Dan Sugalski wrote:
Possibly it won't. The machine the DB is on sees heavy access to
large files, to the point where parts of the database may get flushed
out of the OS buffer cache.
Nevermind this question...
>
Where is the documentation on tsearch2?
Google first, ask second, I remind myself again... I knew I hadn't
seen it mentioned in the official postgresql manual.. didn't think
about it being an extension.
Dan
Dan Armbrust wrote:
Hmm, well, I don
also don't want to negatively affect the performance of the rest of
the DB just to accommodate this instance - hence the questions about
the implications of changing the BLCKSZ variable.
Dan
Bruno Wolff III wrote:
On Mon, Jul 18, 2005 at 14:44:26 -0500,
Dan Armbrust <[EMAIL PROTECTED]>
;anotherfoo' and propertyValue ILIKE 'valu%'
What indexe(s) would be recommended?
My current 3 column index (that works on other DB's) doesn't perform
well due to case sensitivity issues, and now fails, due to data length
issues.
Dan
Dan
Jaime Casanova wrote:
iable is set to 8192. What are the
performance/disk usage/other? implications of doubling this value, to 16384?
Any other suggestions in dealing with this problem?
Thanks,
Dan
---(end of broadcast)---
TIP 1: if posting/reading through Usenet,
er varying(50),
ispreferred boolean,
degreeoffidelity character varying(50),
matchifnocontext boolean,
representationalform character varying(50),
propertyvalue text NOT NULL
);
Primary Key:
ALTER TABLE ONLY conceptproperty
ADD CONSTRAINT conceptproper
Dan Armbrust wrote:
I'm trying to load some data into PostgreSQL 8.0.3, and I got the
error message "index row size 2904 exceeds btree maximum, 2713".
After a bunch of searching, I believe that I am getting this error
because a value that I am indexing is longer than ~ 1/3 of
8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
--
Dan
--it's like this---
Dan Sugalski even sam
Dan Armbrust wrote:
I have one particular insert query that is running orders of magnitude
slower than other insert queries, and I cannot understand why.
For example, Inserts into "conceptProperty" (detailed below) are at
least 5 times faster than inserts into "conceptProperty
utes.
If thats not bad and buggy behavior, I don't know what is
Dan
--
Daniel Armbrust
Biomedical Informatics
Mayo Clinic Rochester
daniel.armbrust(at)mayo.edu
http://informatics.mayo.edu/
---(end of broadcast)-
just disabled that "feature". And it works
fine with sequential scans disabled - I have no problem with it in this
respect, since I can turn it off.
Is there any way that I can disable sequential scans for foreign key checks?
Dan
--
Daniel Armbrust
Bio
ng the indexes. The time savings of using
indexes when things are big is FAR bigger than the time savings of not
using indexes when things are small.
Dan
--
Daniel Armbrust
Biomedical Informatics
Mayo Clinic Rochester
daniel.armbrust(at)mayo.edu
ht
Alvaro Herrera wrote:
On Tue, Aug 02, 2005 at 10:01:50AM -0500, Dan Armbrust wrote:
I shouldn't have to manually run Analyze to make the DB be capable of
handling inserts involving tables with foreign keys correctly. My code
that is doing the inserts is a java application
maybe the fix didn't fix the issue.
Dan
--
Daniel Armbrust
Biomedical Informatics
Mayo Clinic Rochester
daniel.armbrust(at)mayo.edu
http://informatics.mayo.edu/
---(end of broadcast)---
TIP 2: Don't
Jaime Casanova wrote:
On 8/2/05, Dan Armbrust <[EMAIL PROTECTED]> wrote:
I've been trying to track down some performance problems that I am
having doing large inserts on tables with foreign keys.
I'm 99% sure that the issue I am having is BUG 1552 -
http://archive
[EMAIL PROTECTED] wrote:
First, makes sure the PostgreSQL database is listening for TCP/IP
connections on the computer you're trying to connect to. On Mac OS X, run
this command in the a terminal, i.e. Terminal.app:
netstat -l
You should see a line like this somewhere in the output:
tcp6 0 0
n the encounter the issue -
they are going to put in the error message)
Dan
--
Daniel Armbrust
Biomedical Informatics
Mayo Clinic Rochester
daniel.armbrust(at)mayo.edu
http://informatics.mayo.edu/
work good in what Linux
SO ?
This
language have developmente
ambient IDE (like Delphi 2005) ?
Where may
download this compiler to
test ?
Tks for help.
Gerson
Java... And Eclipse for your IDE.
And using SWT rather than Swing for your GUI.
Dan
- supports PostgreSQL:
http://www.azzurri.jp/en/software/clay/index.jsp
Another database plugin for Eclipse that lets you work with a
PostgreSQL database.
http://quantum.sourceforge.net/screen_shots.html
Dan
Daniel Armbrust
Biomedical Informatics
Mayo Clinic Rochester
daniel.armbrust(at)mayo.edu
http://informatics.mayo.edu/
.org/derby/
Suddenly, Hypersonic SQL http://www.hsqldb.org/ (which also works
wonderfully for small databases - nobody would claim that these can
scale like PostgreSQL)
has a bunch of competition.
Dan
--
Daniel Armbrust
Biomedical Informatics
Mayo Clinic
code bases) that can be used by both
opensource and corporate types alike.
So keep up the good work!
Dan
--
Daniel Armbrust
Biomedical Informatics
Mayo Clinic Rochester
daniel.armbrust(at)mayo.edu
http://informatics.mayo.edu/
---(e
order - MySQL fails
on this front - but since it allows me to specify the tables to dump,
and it dumps them in that order, I can specify the correct order.
PostgreSQL's pg_dump command seems rather limited in its abilities.
Maybe I'm missing the command I'm looking
- but on my first reading of the description (and being and
annoying user who didn't try it first) it didn't appear that it would
allow me to specify more than one table.
But I tested it, and it does let me specify the -t command more than
once. So that gets me past that is
Dan Armbrust wrote:
Bricklen Anderson wrote:
pg_dump --help
...
-n, --schema=SCHEMA dump the named schema only
-s, --schema-onlydump only the schema, no data
-t, --table=TABLEdump the named table only
...
Just after I sent the e-mail, I realized that I forgot
ould specify a where condition would certainly be handy.
Thanks,
Dan
--
Daniel Armbrust
Biomedical Informatics
Mayo Clinic Rochester
daniel.armbrust(at)mayo.edu
http://informatics.mayo.edu/
---(end of broadcast)-
ys while I load the data.
Both ways are a pain - and it makes it overly difficult to export/import
chunks of data from a database.
Dan
--
Daniel Armbrust
Biomedical Informatics
Mayo Clinic Rochester
daniel.armbrust(at)mayo.edu
http://informatic
Jim C. Nasby wrote:
> pg_dump handles table ordering properly.
>
Maybe I missed something then, because it didn't last time I tried to
move some data. I had to drop my foreign keys before I could reload it.
Dan
--
Daniel Armbrust
Biomedical Infor
s own:
Just out of curiosity, is this something that constant SQL (or SQL
generated by code) with placeholder variables won't protect against?
--
Dan
--it's like this-------
Dan Sugalski
it that the planner has no access to the
data in the where clause, so it unconditionally rules out some paths.
(LIKE clauses with constant prefix text, like "FOO%", get hit hard by
this)
It's certainly not as simple as all-constant SQL text, but it's
definite
swers...
Thanks,
Dan
--
Daniel Armbrust
Biomedical Informatics
Mayo Clinic Rochester
daniel.armbrust(at)mayo.edu
http://informatics.mayo.edu/
---(end of broadcast)---
TIP 6: explain analyze is your friend
store it works well.
I have this table, data and query:
create table test
(
id int,
txt text,
txt_arr text[],
f float
);
insert into test
values
(1,'jkl','{abc,def,fgh}',3.14159),(2,'hij','{abc,def,fgh}',3.14159),(2,null,null,null),(3,'def',null,0);
select j, json_populate_record(null::test, j)
from
(
select to_json(t) as j from test t
) r
Best Regards
Dan S
Yes I meant equivalence in the roundtrip conversion sense.
And of course the "feature complete" solution which can handle deep
structures would be really nice to have.
Best Regards
Dan S
2016-02-23 21:11 GMT+01:00 David G. Johnston :
> On Tue, Feb 23, 2016 at 12:54 PM, To
uch higher than just building an ETL job. Are
you so certain your situation is so special that you can't use what the rest of
the industry uses?
-Dan
about how to do this, or where to search. (Maybe i'm just
looking in all the wrong places.)
dan
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
's an implicitly-created
index for the composite primary key.
Thanks,
Dan
Hi,
I'm using Pg for bioinformatic work and I want to be able to insert,
uniquely, biological sequences into a table returning the sequence id -
this part is fine. However, if the sequence already exists in the table
I want to return to id.
At the moment it seems to me that I should do a
SELECT
Thanks for that - yes very helpful. Good to know what is possible.
Dan
On Tue, 2010-11-23 at 10:27 +0100, Matthieu Huin wrote:
> A similar question was discussed here about 3 weeks ago :
> http://archives.postgresql.org/pgsql-general/2010-11/msg00110.php
>
> The "UPSERT&qu
Can anyone recommend a PostgreSQL compatible free tool that I can use
to generate some schema diagrams of an existing database?
Thanks
Dan
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql
ack in
the order that transactions return on the server, regardless of whether they
are asynchronous or synchronous?
Thanks,
Dan
I'm wrong.
-Dan
On Wed, Jan 12, 2011 at 12:32 PM, Vick Khera wrote:
> On Wed, Jan 12, 2011 at 12:03 AM, Dan Birken wrote:
> > If I commit asynchronously and then follow that with
> a synchronous commit,
> > does that flush the asynchronous commit as well?
>
> I'
cation> (which
I am assuming is the doc OP is referring to positively) is that it only
includes details about streaming replication, thus you don't have to
constantly be dodging information that doesn't apply to you.
-Dan
On Wed, Jan 26, 2011 at 7:04 AM, Bruce Momjian wrote:
>
ines can fall behind while still being able to recover without
archiving.
-Dan
On Tue, Feb 8, 2011 at 6:51 PM, Ogden wrote:
>
> On Feb 8, 2011, at 8:47 PM, Ray Stell wrote:
>
> >
> > pg_controldata command is helpful.
> >
> > Archiving wal not required, b
Hi !
Is there a way to use plpgsql copy type to get an array of a certain type ?
For example if I have a type sample%TYPE
How can I declare a variable that is an array of sample%TYPE
I can't get it to work, is there a way to do it ?
Best Regards
Dan S
way then.
Thank you Merlin and Pavel for your quick answers
Dan S
2011/3/18 Merlin Moncure
> On Fri, Mar 18, 2011 at 2:20 PM, Dan S wrote:
> > Hi !
> >
> > Is there a way to use plpgsql copy type to get an array of a certain type
> ?
> >
> > For example if I
ultiple times with the same tar
archive with the same results (on different systems).
Thanks,
Dan
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
AL
files to finish a particular transaction.
-Dan
On Fri, May 13, 2011 at 11:28 AM, bubba postgres
wrote:
> What I mean is if I do pg_dump on slave I get the " ERROR: canceling
> statement due to conflict with recovery".
> So I googled and tried the solution listed in the link
tmt := 'select * from tbl1 ';
IF (i IS NOT NULL) THEN cond := ' col1 < $1 '; END IF;
IF (cond IS NOT NULL) THEN stmt := stmt || 'where ' || cond; END IF;
RETURN QUERY EXECUTE stmt USING i;
RETURN;
END;
$$ language plpgsql;
select * from dynamic_query(4);
Best Regards
Dan S
Yes throwing an error would probably be good to catch these kind of mistakes
which silently gives you the wrong answer otherwise.
Best Regards
Dan S
2011/5/21 Tom Lane
> Dan S writes:
> > And yes I do know that I can fix the problem by renaming the output
> column
> > to s
on_schema.parameters p
where r.routine_name = 'test'
and p.specific_name = r.specific_name
and p.specific_catalog=r.specific_catalog
and p.specific_schema=r.specific_schema
Best Regards
Dan S
So is there always an underscore prepended to the type name of an array ?
for example float[] would then be _float right ?
Best Regards
Dan S
2011/5/21 Pavel Stehule
> Hello
>
> type "array of text" has name "_text"
>
> Regards
>
> Pavel Stehule
&
Is there any examples of how to join the system tables to get the same
information as I was trying to get from the function ?
Best Regards
Dan S
2011/5/21 Pavel Stehule
> 2011/5/21 Dan S :
> > So is there always an underscore prepended to the type name of an array ?
> > fo
I'll try that .
Thank you very much for your help.
Best Regards
Dan S
2011/5/21 Pavel Stehule
> 2011/5/21 Dan S :
> >
> > Is there any examples of how to join the system tables to get the same
> > information as I was trying to get from the function ?
>
> you c
clause expression is volatile ?
Best Regards
Dan S
P.S.
I've since rewritten the query like below to get the expected results but I
still thought I should ask if it is a bug.
with
cte as
(
select generate_series,(random()*999.0)::int + 1 as id from
generate_series(1,1000)
)
select (select
Ahh yes, I understand now.
Thanks !
Best Regards
Dan S
2014-07-28 18:28 GMT+02:00 Tom Lane :
> Dan S writes:
> > I've run into a strange problem with a query.
> > I wonder if it might be a bug or a misunderstanding from my side.
>
> > Steps to recreate th
al to require such a workaround for what seems like a common need.
Thanks for any insight you might have!
Sincerely,
Dan
Hi,
I encountered a deadlock while running 'reindex table TABLE1' in
postgresql version 9.2.4
The postgresql logs shows the two offending processes.
1st process was running reindex table TABLE1
waiting for AccessExclusiveLock on primary key index of TABLE1
2nd process was running stored procedur
n is, how do I shut down the tuplesort properly after the last
call to my window function ?
I'm running "PostgreSQL 9.3.5 on i686-pc-linux-gnu, compiled by
gcc-4.4.real (Debian 4.4.5-8) 4.4.5, 32-bit"
Best Regards
Dan S
an be used to answer questions like what are the maximum
number of simultaneously overlapping ranges and at which ranges the maximum
occurs)
Best Regards
Dan S
2014-12-26 18:57 GMT+01:00 Tom Lane :
> Dan S writes:
> > I'm trying to write a window function in C .
> > In the fu
2014-12-27 6:43 GMT+01:00 Merlin Moncure :
> On Fri, Dec 26, 2014 at 11:41 PM, Merlin Moncure
> wrote:
> > On Fri, Dec 26, 2014 at 1:19 PM, Dan S wrote:
> >> Well I'm trying to implement a window-function that works on
> range_types and
> >> produce
I'd like to ensure that the DB stops whatever else it's doing so that
the insert can occur. What is the best way of doing this?
Thanks,
Dan Scott
http://danieljamesscott.org
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Tue, Aug 30, 2011 at 13:52, Daniel Verite wrote:
> Dan Scott wrote:
>
>> the insert process is unable to insert new rows into the database
>
> You should probably provide the error message on insert or otherwise describe
> how it's not working. Normally readin
On Tue, Aug 30, 2011 at 13:21, Scott Ribe wrote:
> On Aug 30, 2011, at 8:22 AM, Dan Scott wrote:
>
>> Perhaps because I'm locking the table with my query?
>
> Do you mean you're explicitly locking the table? If so, why???
No, not explicitly. I just thought of it a
Hi,
Sorry for the late response on this.
On Wed, Aug 31, 2011 at 09:40, Tomas Vondra wrote:
> On 31 Srpen 2011, 1:07, Dan Scott wrote:
>> On Tue, Aug 30, 2011 at 13:52, Daniel Verite
>> wrote:
>>> Dan Scott wrote:
>>>
>>>> the insert
It would be nice with a consistent behaviour, with the callstack always
looking the same despite different causes of the exception.
I think it is violating the 'Principle of least astonishment' .
Best Regards
Dan S
2012/12/11 Pavel Stehule
> Hello
>
> 2012/12/10 Dan S :
&
I got another unexpected behaviour of the call stack by this invocation :
select testfunc2(true) from generate_series(1,10);
The first call stack is different from the nine folllowing.
Shouldn't it be identical to the others ?
Best Regards
Dan S
2012/12/11 Pavel Stehule
> Hello
>
> ll /usr/local/pgsql/data/pg_xlog
lrwxr-xr-x 25B Oct 19 10:48 pg_xlog -> /usr/local/pglog/pg_xlog/
I've exhausted everything I can think of to try to solve this one. Has
anyone got any ideas on how to go about debugging this?
Thanks,
Dan
anything up. However, next reboot I'll certainly do that.
> That said, i think you might consider posting on freebsd-[questions|stable]
> as well.
Yes I think that might be a good plan :)
Dan
On 20 March 2013 12:30, Achilleas Mantzios wrote:
> Did you do a detailed du during the suppo
behaviour. There's
nothing obvious in the differences in usage patterns that we can see
(we're not using any exotic features or anything), but it certainly
suggests that it's *something* related to PG or our usage of it.
On 20 March 2013 14:11, Vick Khera wrote:
>
> On Wed, M
Achilleas Mantzios wrote:
> On Ôåô 20 Ìáñ 2013 15:15:23 Dan Thomas wrote:
>
>>
>> We actually have another FreeBSD8.3/PG9.1 machine under different (but
>> similar) load that *doesn't* demonstrate this behaviour. There's
>> nothing obvious in the difference
sure be aware of, or some other incompatibility that makes this setup not
work.
The goal is to have PITR using a combination of pg_basebackup (which is
part of 9.1) and pg_receivexlog.
Thanks,
Dan
s per WAL segment:16777216
Maximum length of identifiers:64
Maximum columns in an index: 32
Maximum size of a TOAST chunk:1996
Date/time type storage: 64-bit integers
Float4 argument passing: by value
Float8 argument passing: by value
root@ip-10-148-131-236:~#
Thanks again.
Dan
I am in the process of doing that now. I'll reply again with results once that
is done.
-Original Message-
From: Lonni J Friedman [mailto:netll...@gmail.com]
Sent: Saturday, June 22, 2013 4:11 PM
To: Dan Kogan
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Standby st
Message-
From: Lonni J Friedman [mailto:netll...@gmail.com]
Sent: Saturday, June 22, 2013 4:11 PM
To: Dan Kogan
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Standby stopped working after PANIC: WAL contains
references to invalid pages
Looks like some kind of data corruption
We have backed up $PGDATA, but had to re-initialize the slave.
We also have the WALs from the day this happened.
Thanks,
Dan
-Original Message-
From: Lonni J Friedman [mailto:netll...@gmail.com]
Sent: Saturday, June 22, 2013 10:09 PM
To: Dan Kogan
Cc: pgsql-general@postgresql.org
Update: I have successfully used this configuration with a month's worth of
WALs (tens of thousands), run a test restore, and everything appears to
have worked as expected. So at least based on that test, this
configuration seems fine.
-Dan
On Fri, May 24, 2013 at 4:42 PM, Dan Birken
fetch) Do I have to?
--
Dan
--it's like this---
Dan Sugalski even samurai
[EMAIL PROTECTED] have teddy bears and even
teddy bears get drunk
-
At 12:50 PM -0700 2/15/05, Michael Fuhr wrote:
On Tue, Feb 15, 2005 at 02:32:56PM -0500, Dan Sugalski wrote:
I've got some code that uses PQexecParams and does the equivalent of:
DECLARE a_cursor CURSOR FOR SELECT foo, bar FROM baz WHERE field = $1
FETCH NEXT a_cursor
but when I g
erl's using its own memory allocator you'll want to
rebuild it to not do that.
--
Dan
--it's like this---
Dan Sugalski even samurai
[EMAIL PROTECTED]
At 3:14 PM -0500 3/24/05, Tom Lane wrote:
Dan Sugalski <[EMAIL PROTECTED]> writes:
... I'm pretty sure for embedding use it uses whatever routines
the embedder defines, but it's been a while since I've poked around
in there.
Hmm. plperl is definitely not doing anything
At 6:58 PM -0500 3/24/05, Greg Stark wrote:
Dan Sugalski <[EMAIL PROTECTED]> writes:
Anyway, if perl's using its own memory allocator you'll want to rebuild it
to not do that.
You would need to do that if you wanted to use a debugging malloc. But
there's
no particular rea
in my program. I realize I can turn off AutoCommit when I
connect to the database but in this case that is not what I want to
do. This is a one-off task.
Set the AutoCommit attribute of the database handle. Pull up the docs
for DBI and search for the "Database Handle Attributes" sect
1 - 100 of 336 matches
Mail list logo