Basically, you can get away with cheaper hardware, but it usually
doesn't have the reliability/performance of more expensive options.
You want an in-depth comparison of how a server disk drive is internally
better than a desktop drive:
http://www.seagate.com/content/docs/
Robert Treat wrote:
> On Thursday 27 April 2006 11:59, Bruce Momjian wrote:
> > Well, one problem now is that everytime pg_autovacuum opens a database,
> > a message is placed in the logs:
> >
> > LOG: autovacuum: processing database "test"
> >
llow previous
> patterns.
The schedule is for feature freeze of August 1, so right, no _release_
in the summer (assuming northern hemisphere).
--
Bruce Momjian http://candle.pha.pa.us
EnterpriseDBhttp://www.enterprisedb.com
+ If your life is a hard drive, Christ can b
t; >>> Will Reese -- http://blog.rezra.com
> >>>
> >>> ---(end of broadcast)---
> >>> TIP 6: explain analyze is your friend
> >>>
> >>
> >> --Jim C. Nasby, Sr. Engineering Consultant [EM
or MySQL when it comes to support
> for their products. Plus the support on these mailing lists is
> absulutely top-notch.
--
But the spelling isn't. :-) {Couldn't resist.}
--
Bruce Momjian http://candle.pha.pa.us
EnterpriseDBhttp://www.enterprisedb.com
+
gt; COMMIT;
>
> It won't let me. Any ideas solutions?
What error does it show?
--
Bruce Momjian http://candle.pha.pa.us
EnterpriseDBhttp://www.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
---(end of broadcast)--
http://www.postgresql.org/docs/8.1/interactive/sql-copy.html
>
> http://www.postgresql.org/docs/8.0/interactive/sql-copy.html
>
> Now happily using COPY,
> Oisin
>
>
>
> ---(end of broadcast)---
> TIP 2: Don
ast were:
query via XML
results via XML
retrive/update parts of the XML document
--
Bruce Momjian http://candle.pha.pa.us
EnterpriseDBhttp://www.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
---(end of broadcast)---
TIP 6: explain analyze is your friend
hat will also clutter your log with a ton of
> extraneous info...)
Added to TODO:
* Allow log_min_messages to be specified on a per-module basis
This would allow administrators to see more detailed information from
specific sections of the backend, e.g. checkpo
, not steps)
AIX FAQ updated for clarity that these are options.
--
Bruce Momjian http://candle.pha.pa.us
+ If your life is a hard drive, Christ can be your backup. +
---(end of broadcast)---
TIP 4: Have you searched our list archives?
rred to as just Postgres.
Is that unclear?
--
Bruce Momjian http://candle.pha.pa.us
SRA OSS, Inc. http://www.sraoss.com
+ If your life is a hard drive, Christ can be your backup. +
---(end of broadcast)---
TIP 3: Have you checked our e
7;''
>
> legal way to set password to ' character ?
>
> Andrus.
>
>
>
> ---(end of broadcast)---
> TIP 3: Have you checked our extensive FAQ?
>
>http://www.postgresql.org/docs/faq
>
--
Bruc
transaction, and gettimeofday() returns the wallclock time. This will
make time reporting more consistent and will allow reporting of
the statement start time.
--
Bruce Momjian http://candle.pha.pa.us
SRA OSS, Inc. http://www.sraoss.com
+ If your life
it. :-)
Added for ecpg TODO:
o Add COPY TO STDIN / STDOUT handling
I think we should document _every_ thing that ecpg needs because it
helps existing users know what is missing, and encourages patches.
Would you please supply a list?
--
Bruce Momjian http://candle.pha.pa.us
SRA OSS,
Bruce Momjian wrote:
> CSN wrote:
> > I was playing around with negative offsets:
> >
> > select * from table1 order by col1 offset -5 limit 25;
> > select * from table1 order by col1 offset -25 limit
> > 25;
> > select * from table1 order by col1 offs
with "pg_upgrade" ?
> Does it still exist ? If not, is there another tool to replace it ?
pg_upgrade has not worked for several releases, and was moved to
pgfoundry or gborg.
--
Bruce Momjian http://candle.pha.pa.us
SRA OSS, Inc. http://www.sraoss.com
+ I
Tom Lane wrote:
> Bruce Momjian writes:
> > Currently we output the ctid as a string:
> > snprintf(buf, sizeof(buf), "(%u,%u)", blockNumber, offsetNumber);
> > Perhaps someday we should consider outputting that as an array or a
> > result set:
&g
d work on NT, but it will
not install on NT. See the FAQ:
http://pginstaller.projects.postgresql.org/faq/FAQ_windows.html
--
Bruce Momjian http://candle.pha.pa.us
SRA OSS, Inc. http://www.sraoss.com
+ If your life is a hard drive, Christ can be yo
OK, added to TODO.
---
Michael Glaesemann wrote:
>
> On Feb 25, 2006, at 12:09 , Bruce Momjian wrote:
>
> > We have this TODO:
> >
> > o Allow infinite dates just like infinite timestamp
o not have the time at the moment to even
> reproduce bugs. Hopefully this will become better in the near future.
Should we add this to TODO? Anything else?
--
Bruce Momjian http://candle.pha.pa.us
SRA OSS, Inc. http://www.sraoss.com
+ If your life is a har
lace. But if
> a believer demands that I, as a nonbeliever, observe his taboos in the
> public domain, he is not asking for my respect, but for my submission. And
> that is incompatible with a secular democracy.
>
--
Bruce Momjian http://candle.pha.pa.us
SRA O
t will not. I see way to do that anymore using a single statement.
--
Bruce Momjian http://candle.pha.pa.us
SRA OSS, Inc. http://www.sraoss.com
+ If your life is a hard drive, Christ can be your backup. +
---(end of broadcast)---
TI
nnot do that anymore since it causes shift/reduce conflicts. */
ECPGRelease: TransactionStmt RELEASE
and we commented out the ECPGRelease state. You can only use:
| RELEASE SAVEPOINT ColId
| RELEASE ColId
| ROLLBACK opt_transaction TO SAVEPOINT ColId
ates just like infinite timestamps
Do we need to add intervals to this?
--
Bruce Momjian http://candle.pha.pa.us
SRA OSS, Inc. http://www.sraoss.com
+ If your life is a hard drive, Christ can be your backup. +
---(end of broadcast)---
TI
Joshua D. Drake wrote:
> Hello,
>
> We need booth staffers for Linux World east. Please step up.
I think I am going.
--
Bruce Momjian http://candle.pha.pa.us
SRA OSS, Inc. http://www.sraoss.com
+ If your life is a hard drive, Christ can be yo
printf(buf, sizeof(buf), "(%u,%u)", blockNumber, offsetNumber);
Perhaps someday we should consider outputting that as an array or a
result set:
test=> select x from (select 1, 2) as x;
x
---
(1,2)
(1 row)
--
Bruce Momjian http://candle.ph
Bruno Wolff III wrote:
> On Fri, Feb 24, 2006 at 10:52:53 -0400,
> "Marc G. Fournier" <[EMAIL PROTECTED]> wrote:
> > On Fri, 24 Feb 2006, Bruce Momjian wrote:
> >
> > Greatbridge had "major funding", and succeeded in burning it off in, what,
sitive that the
> base backup I just made will be valid when I try to restore from it.
>
> This lessens my need for the "get current WAL file" functionality in
> this context. It will still be nice to have in the context of
> backing it up every five minutes or so in
nk. Anyway, now that we have the tz database in PostgreSQL, we can
use the long names, so the abbreviations are only for convenience. We do
have a TODO item on this:
o Allow customization of the known set of TZ names (generalize the
present australian_timezones hack)
--
Bruc
ySQL as the low-end alternative to their own database to
> give a full solution to the customer. And this would slow down the take up
> rate for other database competitor.
MySQL already has major funding. I don't see how it could get worse for
us if Oracle bought them.
--
Bruce Mo
Joachim Wieland wrote:
> On Wed, Feb 08, 2006 at 09:03:54AM -0500, Bruce Momjian wrote:
> > Joachim Wieland wrote:
> > > On Tue, Feb 07, 2006 at 09:49:02AM -0500, Bruce Momjian wrote:
> > > > > The correct solution to this is to forbid ALTER COLUMN SET DEFAULT on
Joachim Wieland wrote:
> On Tue, Feb 07, 2006 at 09:49:02AM -0500, Bruce Momjian wrote:
> > > The correct solution to this is to forbid ALTER COLUMN SET DEFAULT on
> > > a serial column, but we haven't gotten around to enforcing that yet.
>
> > TODO has:
>
TER TABLE test5 ALTER COLUMN id SET DEFAULT
nextval('test_id_seq') * 10;
ALTER TABLE
pg_dump has:
CREATE TABLE test2 (
id integer DEFAULT (nextval('test_id_seq'::regclass) * 10),
data text
);
--
Bruce Momjian
of broadcast)---
> TIP 3: Have you checked our extensive FAQ?
>
>http://www.postgresql.org/docs/faq
>
--
Bruce Momjian| http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13
; > ***
> > ALTER TABLE test ALTER COLUMN id SET DEFAULT nextval('test_id_seq') * 10;
>
> The correct solution to this is to forbid ALTER COLUMN SET DEFAULT on
> a serial column, but we haven't gotten around to enforcing that yet.
TODO has:
og/
> > Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> > tool for doing 5% of the work and then sitting around waiting for someone
> > else to do the other 95% so you can sue them.
-- End of PGP section, PGP failed!
--
Bruce Momjian
4087408-733-2737(fax)
>
> http://www.zeemaps.com
>
>
>
> ---(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 da
ur extensive FAQ?
>
>http://www.postgresql.org/docs/faq
>
--
Bruce Momjian| http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup.
> ---(end of broadcast)-------
> TIP 4: Have you searched our list archives?
>
>http://archives.postgresql.org
>
--
Bruce Momjian| http://candle.pha.pa.us
pgman@candle.pha.pa.us
t;>>or the socket filename extension<<< for Unix-domain
> connections.
>
> How is it possible to specify full unix domain socket
> path and name, not only path and extension?
>
> Thanks
> Ervin
>
> -------(end of broadcast)--
ort of textproc/docbook-dsssl seems to be broken ...
This is all we have:
http://www.postgresql.org/docs/8.1/static/docguide-toolsets.html
--
Bruce Momjian| http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard
p or pg_dumpall.
--
Bruce Momjian| http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup.| Newtown Square, Pennsylvania 19073
---
r/role?
pg_dumpall should transfer your passwords too.
--
Bruce Momjian| http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup.| Newtown
s message has been scanned for viruses and
> dangerous content by MailScanner, and is
> believed to be clean.
>
>
> -------(end of broadcast)---
> TIP 6: explain analyze is your friend
>
--
Bruce Momjian| http://ca
gfnobrega wrote:
> Hi, list!
>
>
>
> Exist some negative performance impact in compiling postgresql without libs
> readline and zlib? I was compiling in a HP PA-RISC with HP AnsiC compiler.
No performance impact in having or not having these features.
-
tmaster after the log rotation resolve
> this?
>
> I also was not able to get it to log to syslog. Maybe I missed something
> here. Any help would be kindly appreciated
Have you read our documenation on this issue?
http://www.postgresql.org/docs/8.1/static/logfile-maint
hink I
> found one on the list from Simon Riggs) then I can do what I need to
> do before those todo items get done? Or will I need to wait till
> postgres gives me the ability to safely copy the file?
>
>
>
> On Jan 30, 2006, at 11:13 AM, Bruce Momjian wrote:
>
Ted Powell wrote:
> On Mon, Jan 30, 2006 at 04:31:29PM -0500, Bruce Momjian wrote:
> >
> > I assume it is this TODO:
> >
> > * Allow protocol-level BIND parameter values to be logged
> >
> >
> > --
7;s the difference between
> owning your own home and just renting. --PJ
>
> ---(end of broadcast)---
> TIP 1: if posting/reading through Usenet, please send an appropriate
>subscribe-nomail command to [EMAIL PROTECTED] so t
an
> > then only restore from that point in time forward.
> >
> > There is no "last one" in the WAL set unless you know the time you
> > want to restore to. Indeed, the "last one" might not be "full" yet
> > and therefore arch
Tom Lane wrote:
> Bruce Momjian writes:
> > I am not sure what to do on this. Right now we have a one-line test:
> > AC_REPLACE_FUNCS([getaddrinfo])
> > To test for a macro we are going to need to add include netdb.h, and the
> > LINK test below is overkill. I
normally a macro.
>
> We're still missing some necessary understanding here...
>
> Have a nice day,
> --
> Martijn van Oosterhout http://svana.org/kleptog/
> > Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is
> > a tool for doing 5% of the
page>.
>
> I don't see that as being detrimental to anyone and would certainly be
> in fair play.
>
> --
> Tony Caduto
> AM Software Design
> Home of PG Lightning Admin for Postgresql
> http://www.amsoftwaredesign.com
>
> ---(end of
erpret but if you watch the numbers
> for a while you can tell if a drive is going bad and continually remapping bad
> blocks. badblocks is useful still as a way of ensuring that every block is
> read and written to, but then you have to look at the SMART data to see
Joshua D. Drake wrote:
> Bruce Momjian wrote:
> > Tony Caduto wrote:
> >
> >> I was doing a search on Google and found this link on Navicat's web page
> >>
> >> http://pgsql.navicat.com/PG_Lightning_Admin/index.php
> >>
> >> I a
elated but I was just wondering what
> others thought about this.
I don't have a problem with it, especially since they mention it is
their version of PostgreSQL (they use our name).
--
Bruce Momjian| http://candle.pha.pa.us
pgman@candle.pha.pa.us
tions that can do that? It seems that PgSQL
> COPY expects the NULL to be always unquoted. There is an option (FORCE
> NOT NULL) for doing the opposite. How do I specify that the NULLs are
> quoted? I am on 8.0.5.
Did you try NULL AS ''?
--
Bruce Momjian
are crypto devices, which most systems don't
> have (though they're certainly available). If you don't have one of
> those, then the key has to be stored in system memory.
FYI, we do have a general encryption documentation section:
http://www.postgresql.org/docs/8.1/st
"I thought this might
> improve things" doesn't qualify. Exactly what problem are you trying to
> solve and why is a run-time test necessary? Why doesn't the existing
> coding work for you?
>
> regards, tom lane <>
there is still data to be dumped, as a result PQendcopy() throws
> error. THROTTLE comments in pg_dump were helpful. Any thoughts.
What operating system is this? It sounds broken.
--
Bruce Momjian| http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610
s about that ...
>
> That's GREAT news! Is that the "Bitmap Scan" item in the what's new
> list (http://www.postgresql.org/docs/whatsnew)? I didn't even notice it
Yes.
--
Bruce Momjian| http://candle.pha.pa.us
pgman@cand
restore
to the same architecture you used to create the files.
--
Bruce Momjian| http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup.| New
Scott Marlowe wrote:
> On Wed, 2006-01-18 at 11:51, Bruce Momjian wrote:
> > Scott Marlowe wrote:
> > > Used to be the HISTORY file was in cvs, but now it's created by the
> > > tarball creation process.
> > >
> > > Is there a web link some
Scott Marlowe wrote:
> Used to be the HISTORY file was in cvs, but now it's created by the
> tarball creation process.
>
> Is there a web link somewhere to the latest HISTORY file(s)?
Sure:
http://www.postgresql.org/docs/current/static/release.html
--
any suspicious write activity.
>
> Thanks for suggestion,
> --
> Marcin
>
> -------(end of broadcast)---
> TIP 5: don't forget to increase your free space map settings
>
--
Bruce Momjian| http://candle.ph
with one command
The proposed syntax is:
GRANT SELECT ON ALL TABLES IN public TO phpuser;
GRANT SELECT ON NEW TABLES IN public TO phpuser;
--
Bruce Momjian| http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 35
on the locale behaviour, IIRC...
>
> Maybe if you are using a locale different than C and have indexes on
> strings then is better to REINDEX just to be sure...
Read the specific REINDEX mentioned in the release notes and if any
apply to you, you should reindex. Were they not clear?
Marcelo Lima wrote:
> Help me please!
>
> I need change autocommit to off in fedora core 3 in postgresql.conf i don?t
> know.
>
> How can i do?
No, only in psql using AUTOCOMMIT.
--
Bruce Momjian| http://candle.pha.pa.us
pgma
got it that way.
> Any comments? If it is the first option above, then it feels like
> by definition there is absolutely nothing that can be done, now
> or ever :-(
Yes, I came to that conclusion long ago.
--
Bruce Momjian| http://candle.pha.pa.us
pgman@
Note that our software is a non Open Sorce software. The availability of
> POSTGRESQL for Windows/Linux and other platforms is the main reason we are
> planning to choose POSTGRESQL
>
> - Rajendra Talekar
> Chief Developer and Managing Director
> Codexpert Systems
--
Bruce Mom
match. Actually adding a column to a system table is quite complex
and you might be better off creating a new table that refernces
pg_database and linking to it.
--
Bruce Momjian| http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ I
INES
> TERMINATED BY '\r\n';
>
> ENCLOSED BY '"' helps in mysql
>
>
> 1.in postgresql I can't do COPY WITH CSV, it says superuser needed
Right.
> 2. i can use is [\copy] but it wont help me, I get syntax error
> 3. i can't convert
t; > regards, tom lane
> >
> >
>
> --
> *Benjamin Arai*
> [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]>
> http://www.benjaminarai.com
--
Bruce Momjian| http://candle.pha.pa.us
pgman@candle.pha.pa.us |
cally rolled back
on abort, meaning we don't re-run the triggers on abort, the changes
the trigger made are ignored by other backends.
--
Bruce Momjian| http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard d
ps to reference
that bitmap to avoid heap lookups, perhaps the same bitmap we might
add someday to determine which heap pages need vacuuming. Frequently
accessed bitmaps would have to be stored in shared memory. One 8k
page of bitmaps could track 512MB of heap pages.
--
#x27;, 'blah', DEFAULT);
> SELECT currval('lm_id_seq');
>
> I perform this back to back in the db, and the currval works fine.
>
> What gives? It used to work in the java code, but now it doesn't!
> Also, please comment on your thoughts abo
oblem, but in
> the user's point of view it's a weird and serious bug which shouldn't be
> there. Using hu_HU with latin2 is a normal marrying.
>
> Some users (including me) don't always read the "known issues" chapter,
> even for a good quality softw
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
>
--
Bruce Momjian| http://candle.pha.pa.
xample
* SELECT * FROM wide_table ORDER BY foo, bar, baz.
* In any case, depending on column data types you will likely be running
* into the disk-block-based limit on overall tuple size if you have more
* than a thousand or so columns. TOAST won't help.
*--
*/
#define MaxHeapAttributeNu
type. It is sort of like a macro for
types.
CREATE TYPE creates a new data type, independent of existing data types,
and usually requires C code and a shared object file to load into the
database.
--
Bruce Momjian| http://candle.pha.pa.us
pgman@candle.pha.pa.us
Joseph Shraibman wrote:
> Is there any performance impact of releasing savepoints?
Releasing savepoints does release a little memory associated with each
subtransaction, but I doubt you would be able to measure the difference
unless you had thousands of subtransactions.
--
Bruce Momj
files when I was modifying dblink. I
had to grope around in the regression tests to see how the functions
worked.
--
Bruce Momjian| http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, |
the only official PGDG release is the source?
Yes, I think the only official PGDG stuff is source. The binaries are
done by port-specific teams. PGDG doesn't deal with MSI installer
issues, or RPM issues, only the port-specific teams do. I know I don't
read any RPM emails and any MSI is
though one is
> contrib)?
The distinction is that RPMs and pginstaller are port-specific, binary
distributions.
--
Bruce Momjian| http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive
roup has official RPMs? I didn't
> >know. When Lamar did it it was always unofficial.
> >
> >
> Well they are kept on PostgreSQL.Org servers, they are called PGDG
> rpms... I don't
> think you can get much more official then that.
I think they are official li
Joshua D. Drake wrote:
> Bruce Momjian wrote:
>
> >This patch should be sent to SuSE, not PostgreSQL.
> >
> >
>
> Actually, I think this should be incoporated into a spec file
> specifically for suse within the PGDG rpms.
The PostgreSQL Global Development G
something like smash('ab') = smash('??b') rather than making the
> strings equal in all contexts.
>
> Of course, not being a native speaker of any of the affected languages,
> my opinion shouldn't be taken too seriously ...
>
>
---(end of broadcast)---
> > TIP 1: if posting/reading through Usenet, please send an appropriate
> > subscribe-nomail command to [EMAIL PROTECTED] so that your
> > message can get through to the mailing list cleanly
&g
fer
> | information technologies, Austria
> |
> | phone : +43 (0)1 5454421 0| email: [EMAIL PROTECTED]
> | fax : +43 (0)1 5454421 19 | web : http://weberhofer.at
> | mobile: +43 (0)699 11998315
> |--->>
>
>
>
7;t know how to tell which
are available as client encodiings. I hope that helps.
--
Bruce Momjian| http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your ba
me resultset (offset 0). Is
> there even any point in allowing negative offsets -
> such as maybe someday they'll offset backwards?
Actually we allow negative offsets and limits. Seems we should disallow
them. Yes, it would be interesting if they did offsets relative to the
end o
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>
--
Bruce Momjian| http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Ro
does that help explain its complexity?
;-)
--
Bruce Momjian| http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup.| Newtown
at operations cannot be rolled back with Rollback ?
>
> Thanks in advance,
> Otto
>
>
>
> ---(end of broadcast)---
> TIP 6: explain analyze is your friend
>
--
Bruce Momjian| http://candle.ph
ot;no" refers to...
> I think Andreas Pflug now commited a patch that manually adds
> "role" to the list of per-user variables in pgadmin3 - but in the
> long run, there should be a better solution...
>
> greetings, Florian Pflug
>
>
uot; via psql.
>
> That's a great idea, Richard - thanks, I'll give this a shot --
createuser was converted from a shell script to a C program in 7.4, so I
guess something changed at that point.
--
Bruce Momjian| http://candle.pha.pa.us
pgman@candle.pha
ptimization to be done
> on Numeric comparison, and also on other areas such as aggregation. I've
> not done this yet.
>
> Best Regards, Simon Riggs
[ Attachment, skipping... ]
>
> -------(end of broadcast)---
> TIP 2: Don&
Tom Lane wrote:
> Greg Stark <[EMAIL PROTECTED]> writes:
> > Where is Postgres at with psql using savepoints implicitly to wrap every
> > client command btw?
>
> I think that 8.1 psql can be told to do that.
Right:
\set ON_ERROR_ROLLBACK inter
be changed?
All are the same, on all platforms.
--
Bruce Momjian| http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup.| Newtown Sq
\d" report ?
>
> Thank you,
> Peter Futaro
>
>
>
> -
> Yahoo! Music Unlimited - Access over 1 million songs. Try it free.
--
Bruce Momjian| http://candle.pha.pa.us
pgman@candle.pha.pa.us
901 - 1000 of 2011 matches
Mail list logo