Hi,
Is there any way to do this?
For context, I'm wanting to write a custom script in repeatable read isolation
level. If I hit a serializable error, I don't want the client to abort, I want
it to continue running transactions. Is that possible?
thanks,
Brad.
--
Sent via pgsql-general
statement will be seen.
Brad.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Thanks,
Brad.
814822
Is this a case of having work_mem set to low, or something else? I haven't
seen temp files on commit before.
Thanks,
Brad.
+ debug the
PostgreSQL.
Can someone please provide some guidance where I should make the changes to
preserve mixed case for identifiers?
Thank you
Brad.
between DB users and/or databases on
the instance? If the answer is yes to either, that is a fair bit better than
what we can achieve today.
Brad.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql
the line
td align=leftlt;a href=http://www.postgresql.orggt;Postgreslt;/agt;/td
To be
td align=lefta href=http://www.postgresql.orgPostgres/a/td
Thanks,
Brad
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
-Original Message-
From: Josh Kupershmidt [mailto:schmi...@gmail.com]
Sent: Wednesday, October 26, 2011 5:04 PM
To: Nicholson, Brad (Toronto, ON, CA)
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] psql HTML mode - quoting HTML characters
On Wed, Oct 26, 2011 at 3:51 PM
for some of my clusters. They may have fixed the query that was
causing that to happen though.
Brad.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
you actually need any of the new features and/or performance benefits in 9.1?
Postgres does have an excellent track record for quality and stability with new
releases, but a couple of months in the field isn't really considered stable in
most places.
Brad.
--
Sent via pgsql-general mailing list
believe, but very different from the way the pg_catalog queries
work - which will return you all objects back regardless of permissions on them.
Brad.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref
be a win.
Brad
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
that there are ways to get at some of this stuff or work around it
- but the barrier of entry is often pretty high, can involves high volume
logging and is often far more time consuming task than it could be.
Brad.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes
with each table.
pg_total_relation_size() will give you the size of the table and the indexes on
it.
Brad.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
approach, the instance can evict buffers cached for DB B
in order to load buffers needed for DB A. In the split instance, you can't.
Brad.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
-Original Message-
From: Ben Chobot [mailto:be...@silentmedia.com]
Sent: Friday, March 18, 2011 3:45 PM
To: Nicholson, Brad (Toronto, ON, CA)
Cc: pgsql-general General
Subject: Re: [GENERAL] multi-tenant vs. multi-cluster
On Mar 18, 2011, at 12:34 PM, Nicholson, Brad (Toronto
of such a change before deploying
it. Be very aware that just because something works in one fashion on another
database like Oracle, it does not mean that it will work in the same fashion
for Postgres (or any other DB for that matter).
Brad.
--
Sent via pgsql-general mailing list (pgsql-general
a degraded state or worrying
about STONITH. If you switch roles in a controlled manner, both nodes
remain in the cluster. Slony prevents writes against the replica.
I do agree that for most, Slony is overkill and streaming replication
and hot standby will be the better choice.
--
Brad
tuples -- a number we know in fact to be correct? How
could both statements be correct?
It found 45878 dead tuples in 396 pages for the index authors_archive_pkey.
It found 16558 dead tuples in 492 pages for the table authors_archive.
--
Brad Nicholson 416-673-4106
Database Administrator, Afilias
On 10-07-29 08:54 PM, Greg Smith wrote:
Brad Nicholson wrote:
Postgres also had a reputation of being slow compared to MySQL.
This was due to a lot of really poor MySQL vs Postgres benchmarks
floating around in the early 2000's.
I think more of those were fair than you're giving them credit
On 10-07-29 08:54 PM, Greg Smith wrote:
Brad Nicholson wrote:
Postgres also had a reputation of being slow compared to MySQL.
This was due to a lot of really poor MySQL vs Postgres benchmarks
floating around in the early 2000's.
I think more of those were fair than you're giving them credit
-generate statistics for the table for the query planner to use.
--
Brad Nicholson 416-673-4106
Database Administrator, Afilias Canada Corp.
protection
for your data that MySQL didn't worry about.
No one really tested it in a way that mattered, which was how the two
databases performed under concurrent load, where Postgres won hands down.
--
Brad Nicholson 416-673-4106
Database Administrator, Afilias Canada Corp.
--
Sent via
if their is no index on the updated column and there is enough
space in the physical page to keep the tuple on the same page. You can
adjust the fillfactor to try and favour this.
You can check if you are doing hot updates by looking at
pg_stat_user_tables for the number of hot updates.
--
Brad
are tied to that app.
--
Brad Nicholson 416-673-4106
Database Administrator, Afilias Canada Corp.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
I want to put the functions from pgcrypto into a separate schema, but
pgcrypto.sql is explicitly setting the search path to public. Is there
a reason it does this that I should be aware of? Is it fine to change
that and install the functions in a separate schema?
--
Brad Nicholson 416-673-4106
I am experiencing this error trying to set the connection time zone to
UTC on PostgreSQL 8.4.4:
postgres=# set time zone 'UTC';
ERROR: unrecognized time zone name: UTC
I have read the documentation for timezone_abbreviations, and
everything looked in order, at least as far as my limited
On Tue, May 18, 2010 at 8:15 PM, Brad Ediger b...@bradediger.com wrote:
I am experiencing this error trying to set the connection time zone to
UTC on PostgreSQL 8.4.4:
postgres=# set time zone 'UTC';
ERROR: unrecognized time zone name: UTC
Answered my own question -- it was my Prefix
Hi,
Is anyone using Lifekeeper for Linux availability with Postgres?
If so, what are your thoughts on it? Work as advertised? Any dangerous
gotchas?
--
Brad Nicholson 416-673-4106
Database Administrator, Afilias Canada Corp.
--
Sent via pgsql-general mailing list (pgsql-general
space costs.
Depends on the your vantange point I guess. I'm looking at these as
potential alternatives to some high end, expensive storage products, not
a cheap way to get really fast disk.
--
Brad Nicholson 416-673-4106
Database Administrator, Afilias Canada Corp.
--
Sent via pgsql
Could someone please point me towards the changes for 8.3.10 that was
mentioned on -announce this morning?
Also, any idea when this is going to be released?
--
Brad Nicholson 416-673-4106
Database Administrator, Afilias Canada Corp.
pgsql-general pgsql-general@postgresql.org
--
Sent via
allocate all 30MB, or just the 10MB I need?
--
Brad Nicholson 416-673-4106
Database Administrator, Afilias Canada Corp.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
,
Check_posgres:database_size will alert me if I go over X size, which is
useful but with Cacti, I get a graph of waht the size is over a 5 min
period of time, so I can watch growth ...
Check out Hyperic. We're currently evaluating it for profiling out
systems, and I'm pretty impressed with it so far.
--
Brad
initdb. If you want to do it after
the DB is created, move the contents of pg_xlog/ (when the DB is shut
down) and make a symlink to the new directory.
--
Brad Nicholson 416-673-4106
Database Administrator, Afilias Canada Corp.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org
.
Absolutely. The smoothing is supposed to alleviate that, but I'm not
sure how well it works with aggressive activity driven checkpoints like
you have. Keep up posted, I'm curious.
Thanks for any ideas.
--
Brad Nicholson 416-673-4106
Database Administrator, Afilias Canada Corp.
--
Sent
,
but after deleting one row, it shows dead_tuple_percent = 0.09?
5: on the missing stats - does this mean my query plans are potentially
bad until the stats are regenerated?
--
Brad Nicholson 416-673-4106
Database Administrator, Afilias Canada Corp.
--
Sent via pgsql-general mailing list
On Mon, 2009-10-19 at 12:07 -0400, Tom Lane wrote:
Brad Nicholson bnich...@ca.afilias.info writes:
If you issue an immediate shutdown to the database, autovacumm will not
process tables that should be vacuumed until manually re-analyzed.
AFAICS this is an unsurprising consequence
On Mon, 2009-10-19 at 10:53 -0600, Scott Marlowe wrote:
On Mon, Oct 19, 2009 at 10:44 AM, Tom Lane t...@sss.pgh.pa.us wrote:
Brad Nicholson bnich...@ca.afilias.info writes:
On Mon, 2009-10-19 at 12:07 -0400, Tom Lane wrote:
That seems like a fundamentally stupid idea, unless you
On Mon, 2009-10-19 at 11:16 -0600, Scott Marlowe wrote:
On Mon, Oct 19, 2009 at 11:06 AM, Brad Nicholson
bnich...@ca.afilias.info wrote:
On Mon, 2009-10-19 at 10:53 -0600, Scott Marlowe wrote:
On Mon, Oct 19, 2009 at 10:44 AM, Tom Lane t...@sss.pgh.pa.us wrote:
Brad Nicholson bnich
,
autovacuum will vacuum accordingly.
autoanalyze will automatically analyze new tables when they don't have
stats. It seems logical that it should handle this case where the table
also does not have stats.
--
Brad Nicholson 416-673-4106
Database Administrator, Afilias Canada Corp.
--
Sent via
On Mon, 2009-10-19 at 15:01 -0400, Tom Lane wrote:
Brad Nicholson bnich...@ca.afilias.info writes:
autoanalyze will automatically analyze new tables when they don't have
stats. It seems logical that it should handle this case where the table
also does not have stats.
It will autoanalyze
On Mon, 2009-10-19 at 15:09 -0400, Brad Nicholson wrote:
On Mon, 2009-10-19 at 15:01 -0400, Tom Lane wrote:
Brad Nicholson bnich...@ca.afilias.info writes:
autoanalyze will automatically analyze new tables when they don't have
stats. It seems logical that it should handle this case where
On Wed, 2009-07-15 at 14:13 +0200, Rafael Martinez wrote:
Hello
Should not the execution of pg_stat_reset() reset *all* statistics
counters everywhere in the database?
It only resets the stats for the current database, not the cluster wide
stats - pg_database is cluster wide.
--
Brad
LC_IDENTIFICATION=en_US.UTF-8
LC_ALL=
-Brad
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
/XAJ43UGqlzv5gfzg1YgECbhvL2MaPzwCdEnt3
GfewITsorV/t7cfpq3WxVqM=
=84cI
-END PGP SIGNATURE-
--
Brad Nicholson 416-673-4106
Database Administrator, Afilias Canada Corp.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
estimating, or is it flat our
wrong?
Co-workers that were PGCon are saying that this is becoming a
popular/accepted way to check for bloated tables.
--
Brad Nicholson 416-673-4106
Database Administrator, Afilias Canada Corp.
--
Sent via pgsql-general mailing list (pgsql-general
I'm having problems passing in variables into my execute statement. Any
ideas?
*
*
**
*Table:*
CREATE TABLE cat.case
(
vari character varying(50),--Contains Value
‘BDD1’
htnumeric(4,1) --Contains
Value 30.0
)
frustrated with this request as I figured
just the amount of bug-fixes alone would be adequate reasoning.
Unfortunately, what seems adequate to us technical folks is seldom is to
the business folks.
--
Brad Nicholson 416-673-4106
Database Administrator, Afilias Canada Corp.
--
Sent via
I'm wanting to optimize and improve a query to get the maximum number of
users over a period of time. What I'm trying to accomplish is to get
graphable data points of the maximum number of simultaneous users at a
specified interval over a period of time, preferably with only a single pass
through
for a function I could call, or maybe some variable I write
to, that would cause the contents to be invalidated.
Restart the database.
--
Brad Nicholson 416-673-4106
Database Administrator, Afilias Canada Corp.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
With XML similar to:
a
b
c 1 / c
c 2 / c
c 3 / c
/ b
I'm trying to create an xpath expression (for a postgresql query) that will
return if is a particular value and not that is all three values.
What I currently have (which does not work) is:
select * from someTable
Is there a reason that pg_stat_reset doesn't reset the stats in
pg_stat_bgwriter and pg_stat_database? PG 8.3 (obviously).
The call to pg_stat_reset works, as my other stats tables are clear.
--
Brad Nicholson 416-673-4106
Database Administrator, Afilias Canada Corp.
--
Sent via
on disk is greater). Is there a
way to do this?
Regular VACUUM is the correct operation to get rid of the dead tuples.
If you want to compact the the table, you either need to use CLUSTER or
VACUUM FULL + REINDEX.
--
Brad Nicholson 416-673-4106
Database Administrator, Afilias Canada Corp
on how to use it?
There are a series of functions in the database core that will tell you
this now.
http://www.postgresql.org/docs/8.3/interactive/functions-admin.html
--
Brad Nicholson 416-673-4106
Database Administrator, Afilias Canada Corp.
--
Sent via pgsql-general mailing list (pgsql
On Wed, 2008-03-26 at 15:31 -0400, Tom Lane wrote:
Brad Nicholson [EMAIL PROTECTED] writes:
We just took a test database down (PG 8.1.11) fairly hard (pulled a SAN
It could be that but not necessarily. These could be pages that were
allocated to put new tuples into, but the crash happened
On Thu, 2008-03-27 at 10:29 -0300, Alvaro Herrera wrote:
Brad Nicholson wrote:
On Wed, 2008-03-26 at 15:31 -0400, Tom Lane wrote:
Brad Nicholson [EMAIL PROTECTED] writes:
We just took a test database down (PG 8.1.11) fairly hard (pulled a SAN
It would be easier to believe
On Thu, 2008-03-27 at 10:37 -0400, Tom Lane wrote:
What do you mean by two separate SAN switches pulled out --- is the
DB spread across multiple SAN controllers?
It's using IO mutilpath through 2 HBAs. Both of those were taken down.
Brad.
--
Sent via pgsql-general mailing list (pgsql
: relation my_table page 652140 is uninitialized --- fixing
WARNING: relation my_table page 652940 is uninitialized --- fixing
WARNING: relation my_table page 652941 is uninitialized --- fixing
That sort of looks like it could be data loss, can someone explain what
happened?
Brad.
--
Sent via pgsql
On Tue, 2008-02-26 at 15:19 -0500, Kynn Jones wrote:
Is there a simple way to copy a table from one database to another
without generating an intermediate dump file?
pg_dump -t table name source DB | psql -d target DB
--
Brad Nicholson 416-673-4106
Database Administrator, Afilias Canada
with 8.3 and Slony 2.0.
Brad.
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
) (we had set postgres' db block size as
8 and oracle's is 16kb...)
Do you have any comments on this?
8k is the defualt. You can change the block size if you need to. You
need to modify src/include/pg_config_manual.h recompile and re-initdb.
--
Brad Nicholson 416-673-4106
Database
On Tue, 2007-11-20 at 13:04 -0500, Josh Harrison wrote:
On Nov 20, 2007 11:13 AM, Brad Nicholson [EMAIL PROTECTED] wrote:
On Tue, 2007-11-20 at 07:22 -0500, Josh Harrison wrote:
There were a couple of things we noted.
1. Tablesize twice as much than oracle-- Im not sure if postgres null
no part in this :-))
was a cron job was that restarted the MySQL server every night.
--
Brad Nicholson 416-673-4106
Database Administrator, Afilias Canada Corp.
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http
what the differences are.
We have a script that runs nightly that dumps tables / functions to file,
and
then checks it in automagically to svn, which sends an email of the diffs.
Perhaps that would work for you?
--
Brad Lhotsky[EMAIL PROTECTED]
NCTS Computer
is lying about fsync
operations.
What filesystem are you using? I've seen similar problems on JFS2, it
was something with logredo or fsck being busted on a Big Blue OS.
--
Brad Nicholson 416-673-4106
Database Administrator, Afilias Canada Corp.
---(end of broadcast
on what is going on, as it is
possible that you can make things worse.
I would start with something like 2% for bgwriter_all_maxpages and see
if that helps things out.
--
Brad Nicholson 416-673-4106
Database Administrator, Afilias Canada Corp.
---(end of broadcast
:::::::trust
can you please guide me on what the problem might be.
Regards
Rajaram
--
Brad Nicholson 416-673-4106
Database Administrator, Afilias Canada Corp.
---(end of broadcast)---
TIP 1: if posting/reading
I just want to confirm that the cluster/MVCC issues are due to
transaction visibility. Assuming that no concurrent access is happening
to a given table when the cluster command is issued (when takes it
visibility snapshot), it is safe to cluster that table. Correct?
--
Brad Nicholson 416-673
I have a couple of database clusters that need a vacuum full, and I
would like to estimate how long it will take, as it will need to be in a
maintenance window. I have the times that it takes to to do a regular
vacuum on the clusters, will vacuum full take longer?
--
Brad Nicholson 416-673-4106
in main (argc=1, argv=0x2ff22c40) at main.c:222
#21 0x1204 in __start ()
Ideas?
--
Brad Nicholson 416-673-4106
Database Administrator, Afilias Canada Corp.
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ
for 7.4? I bumped it up to ~ 245mbs
--
Brad Nicholson 416-673-4106
Database Administrator, Afilias Canada Corp.
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
On Tue, 2007-07-10 at 11:31 -0400, Tom Lane wrote:
Brad Nicholson [EMAIL PROTECTED] writes:
On Tue, 2007-07-10 at 11:19 -0400, Tom Lane wrote:
Oh, I forgot to mention --- you did check that vacuum_mem is set to
a pretty high value, no? Else you might be doing a lot more
btbulkdelete
that there is a
worthwhile performance benefit from turning it off (which there may not
be), and you gotten your boss/clients/stakeholders to sign off
(preferably in writing) that data loss is acceptable if the db crashes,
then go ahead and turn it off.
--
Brad Nicholson 416-673-4106
Database Administrator, Afilias
Running PG8.1 - will it recognize CPU and memory that are added
dynamically to the server when the postmaster is running?
--
Brad Nicholson 416-673-4106
Database Administrator, Afilias Canada Corp.
---(end of broadcast)---
TIP 1: if posting
the connection between the two sites is.
--
Brad Nicholson 416-673-4106
Database Administrator, Afilias Canada Corp.
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
On Tue, 2007-04-24 at 09:02 +0530, Mageshwaran wrote:
Hi ,
I want to do replication using WAL , please tell the methods by which
log shipping is done ie moving the wal files to slaves and executing it.
http://www.postgresql.org/docs/8.2/interactive/continuous-archiving.html
--
Brad
Hi Martijn,
Thank you very much for the suggestion:
CREATE FUNCTION add_one(IN int)
RETURNS int
AS 'add_one'
LANGUAGE C;
I corrected this to say:
AS 'Project1', 'add_one'
And restarted psql (rebooted for that matter as well) and am still getting
the same error.
int
add_one(int arg)
{
return arg + 1;
}
And the sql statement I am using is:
CREATE FUNCTION add_one(IN int)
RETURNS int
AS 'add_one'
LANGUAGE C;
Any feedback as to how to correct it is appreciated!
Thanks,
Brad
---(end of broadcast
Question about pg_dump and Postgres 8.1.
Assuming you've let you buffers settle, and then you dump your
database. Will this clobber your shared buffers like a seq scan against
a large table will?
--
Brad Nicholson 416-673-4106[EMAIL PROTECTED]
Database Administrator, Afilias Canada
On Wed, 2007-01-10 at 16:51 +0100, Andy Dale wrote:
If anyone can help or offer advice on how to achieve my objective it
would be greatly appreciated.
Slony log shipping will do this
--
Brad Nicholson 416-673-4106
Database Administrator, Afilias Canada Corp
on powerpc-ibm-aix5.3.0.0, compiled by GCC gcc (GCC)
3.3.2
(1 row)
--
Brad Nicholson 416-673-4106
Database Administrator, Afilias Canada Corp.
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
On Tue, 2006-12-12 at 11:13 -0500, Tom Lane wrote:
Brad Nicholson [EMAIL PROTECTED] writes:
This seems odd. Any idea what's going on here?
template1=# SET TimeZone TO 'GMT';
ERROR: unrecognized time zone name: GMT
Worksforme. Perhaps you are missing the /usr/share/pgsql/timezone
version that causes log shipping to fall over if you have more than 2
nodes in your config (not just log shipped nodes).
If you have more questions, please sign up for the Slony list.
--
Brad Nicholson 416-673-4106
Database Administrator, Afilias Canada Corp.
---(end
rate = higher
latency), and not easy to put a bound on pre-8.2.
I'm not entirely sure how battle tested the Slony log shipping stuff
actually is.
--
Brad Nicholson 416-673-4106
Database Administrator, Afilias Canada Corp.
---(end of broadcast
On Fri, 2006-11-10 at 15:16 -0500, Tom Lane wrote:
Brad Nicholson [EMAIL PROTECTED] writes:
On Fri, 2006-11-10 at 15:07 -0500, Tom Lane wrote:
Those are two different methods: you'd use one or the other, not both.
Slony has its own log shipping, I think that was what he was referring
I'm wondering what that status of the fix for this is. Looking at the
archives, it looks like Bruce had a patch
http://beta.linuxports.com/pgsql-jdbc/2006-08/msg00036.php
I don't see anything in the release notes though. What's the status on
this?
--
Brad Nicholson 416-673-4106
Database
On Mon, 2006-10-30 at 10:14 -0500, Tom Lane wrote:
Brad Nicholson [EMAIL PROTECTED] writes:
I'm wondering what that status of the fix for this is.
AFAIK it all works ... grab beta2 and try it.
Will do. Is this strictly an 8.2 patch, or will it be back-ported to
8.1 and 7.4?
--
Brad
On Mon, 2006-10-30 at 10:27 -0500, Tom Lane wrote:
Brad Nicholson [EMAIL PROTECTED] writes:
Will do. Is this strictly an 8.2 patch, or will it be back-ported to
8.1 and 7.4?
We aren't going to change the behavior of logging that much in existing
releases --- or were you just thinking
appropriate permissions to?
--
Brad Nicholson 416-673-4106
Database Administrator, Afilias Canada Corp.
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
On Wed, 2006-10-18 at 13:00 -0400, Tom Lane wrote:
Brad Nicholson [EMAIL PROTECTED] writes:
Can someone please provide a bit of information where the following
error is coming from? This is PG 8.1.3 on AIX 5.3
LOG: could not bind socket for statistics collector: Permission denied
On Wed, 2006-10-18 at 14:31 -0400, Tom Lane wrote:
Brad Nicholson [EMAIL PROTECTED] writes:
On Wed, 2006-10-18 at 13:00 -0400, Tom Lane wrote:
That's bizarre. What error conditions does your man page for bind(2)
document as yielding EACCES? The only one mentioned on my systems
On Wed, 2006-10-18 at 15:59 -0400, Tom Lane wrote:
Brad Nicholson [EMAIL PROTECTED] writes:
On Wed, 2006-10-18 at 14:31 -0400, Tom Lane wrote:
Would you try strace'ing postmaster start to see what gets passed to the
socket() and bind() calls just before this message comes out?
Here
Is it by file name or by inode?
Brad.
---(end of broadcast)---
TIP 6: explain analyze is your friend
to evaluate something is on
the basis of
- if there is someone they can sue.
Good luck attempting to sue Microsoft, Oracle or IBM for deficiencies in
their database products.
Brad.
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner
I have a field that is varchar(15) type and an example of data I'm working with is (PROJ-0001-06)
I can make these two select statements work but not together.
select cast((max(substring(test.test from 6 for 4))) AS INTEGER) + 1 FROM test;select max(substring(test.test from 11 for 2)) FROM
On Thu, 2006-08-17 at 16:07 -0400, Merlin Moncure wrote:
On 8/17/06, Brad Nicholson [EMAIL PROTECTED] wrote:
Hmm, I think you are wrong. There is a SELECT ... FOR UPDATE;
The first-to-obtain the gapless sequence transaction will establish
a lock onthe tax_id row. The other
On Thu, 2006-08-17 at 15:13 -0500, Scott Marlowe wrote:
On Thu, 2006-08-17 at 15:07, Merlin Moncure wrote:
On 8/17/06, Brad Nicholson [EMAIL PROTECTED] wrote:
Hmm, I think you are wrong. There is a SELECT ... FOR UPDATE;
The first-to-obtain the gapless sequence transaction
the max id of x
t2 tries to insert a value of x+1, insert fails (if it doesn't, you
really want to have a close look at your constraints :-)
Brad Nicholson 416-673-4106
Database Administrator, Afilias Canada Corp.
---(end of broadcast)---
TIP 1
On Tue, 2006-07-25 at 10:45 -0700, Redefined Horizons wrote:
I'm having trouble figuring out how to use the currval() function for
sequences in an INSERT statement. I did some searching online, but
couldn't find what I was looking for.
I have two Schemas in my Database:
metadata
geometry
SERIALIZABLE;
-- SELECT * from foo;
INSERT INTO foo (id) --
VALUES (1); --
-- SELECT * from foo;
The select in t2 (the last one, obviously) does not see the insert from t1.
What's up?
--
Brad Nicholson 416-673-4106[EMAIL
1 - 100 of 118 matches
Mail list logo
