On Apr 21, 2008, at 8:51 AM, Pau Marc Munoz Torres wrote:
psql:/usr/local/Make2D-DB_II
/pgsql/make2db_functions.pgsql:85: ERROR: language "plpgsql" does
not exist
HINT: Use CREATE LANGUAGE to load the language into the database.
and then when I try to create the language, i get
geldb=# C
Does anything like this exist? If not, I might have a new project...
Thanks!
-- Christophe
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Apr 22, 2008, at 1:45 PM, D. Dante Lorenso wrote:
So, the advice here is "don't use ENUM"?
I think it's more "Don't use ENUM for a type that you are planning to
extend."
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www
For a database that big, you might consider using the WAL archiving
strategy and shipping the WAL files offsite:
http://www.postgresql.org/docs/8.3/interactive/continuous-
archiving.html
On Apr 23, 2008, at 8:14 AM, Gabor Siklos wrote:
I need to back up our database off-site for disaster r
Hi,
I will have a log table which, once a day or so, is copied to a file
(for movement to a data warehouse), and the log table emptied. For
performance, the log table on the production system has no indexes,
and is write-only. (The unload process is the only reader.)
To unload it, I wil
On May 3, 2008, at 9:56 AM, Tom Lane wrote:
This is
a great deal less efficient than TRUNCATE, but it's secure for
concurrent insertions, which TRUNCATE is definitely not.
Exactly my question; thank you!
-- Xof
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make chan
On May 3, 2008, at 9:29 PM, Patrick TJ McPhee wrote:
How about something along the lines of
BEGIN;
ALTER TABLE log RENAME to log_old;
CREATE TABLE log(...);
COMMIT;
BEGIN;
LOCK table log_old;
COPY log_old TO 'filename-path';
DROP TABLE log_old;
COMMIT;
I believe this will keep the writers writ
Yet another option, of course, is to simply not do any calculations
in PostgreSQL, and accept the results from Excel as definitive...
which seems to be what is desired, anyway.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://w
You'll need to get a particular revision of MediaWiki that is PG 8.3
compatible:
http://people.planetpostgresql.org/greg/index.php?/archives/123-
MediaWiki-is-Postgres-8.3-compatible.html
Once that's done, it works fine (at least for me).
--
Sent via pgsql-general mailing list (pgsql-genera
Greetings,
The video from the June 9, 2009 SFPUG meeting, "PostgreSQL as a secret
weapon for high-performance Ruby on Rails applications," is now
available for viewing or download from the media.postgresql.org server:
http://media.postgresql.org/sfpug/sfpug-rails-20090609.mov
Thanks,
-- X
On Jun 10, 2009, at 6:27 PM, Chris wrote:
Can you list the filesizes on http://media.postgresql.org/sfpug/
please?
Josh Berkus handles that page, but I think that's a splendid idea.
This particular video file is about 403MB.
--
Sent via pgsql-general mailing list (pgsql-general@postgresq
On Jun 11, 2009, at 1:23 PM, James B. Byrne wrote:
Given a datetime column, not null, is there a single syntax that
permits searching for all dates in a given year, year+month, and
year+month+day such that a single parameterised query can handle all
three circumstances?
Well, of course, in a
On Jul 20, 2009, at 6:56 PM, Dennis Gearon wrote:
I once talked to a company that made a custome version of Postgres.
It split tables up on columns and also by rows, had some other
custome features. It was enormously faster from what I gathered.
I could of sworn it began with the letter
On Jul 23, 2009, at 12:11 PM, Steve Atkins wrote:
They asked me to open up my firewall to them, pointing at a fake
server, just so they'd have something to audit, after failing our
audit "because we only allowed access to the application from inside
our firewall."
I'm glad it wasn't just
On Jul 7, 2008, at 12:22 PM, aravind chandu wrote:
I need to store an image in postgresql database and after
that i need to retrive the image back.Can you please help me how to
do this?
Assuming you mean an image as in a binary visual image (like a JPEG),
the data type you want is
On Jul 9, 2008, at 6:38 AM, Adrian Moisey wrote:
I would like to be able to "mark" a point in my postgres database.
After that I want to change a few things and "rollback" to that
point. Does postgres support such a thing? Is it possible for me
to do this?
This seems to be exactly what tr
On Jul 9, 2008, at 4:32 PM, Swaminathan Saikumar wrote:
Hello,
I created a Postgres table with a UUID. I want the UUID to be
populated by default.
PostgreSQL doesn't have built-in functions for generating UUIDs, but
there is a module in contrib that will do so:
http://www.postg
On Jul 25, 2008, at 11:20 AM, Andrew Sullivan wrote:
On Fri, Jul 25, 2008 at 01:41:50PM -0400, Jonathan Bond-Caron wrote:
I'd say "the Web is just and always was a hack"
I have to object to this pretty strongly.
He has a point, though. If you were starting out to build a user
interface
On Jul 28, 2008, at 9:16 AM, Bob Pawley wrote:
I haven't been able to find much information on Fetch for Update.
Does 8.3 support this command??
Postgres doesn't have an explicit FETCH FOR UDPATE. You can either
create the cursor with SELECT FOR UPDATE, or UPDATE the row in the
cursor us
On Jul 29, 2008, at 1:24 PM, Rob Richardson wrote:
I was asked how to automate the procedure,
and I couldn't answer.
The options are manifold!
http://www.postgresql.org/docs/8.3/interactive/backup.html
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make chang
On Jul 29, 2008, at 2:35 PM, Tom Lane wrote:
No, he does need an OPEN.
Really? I thought that PG didn't use OPEN:
"The PostgreSQL server does not implement an OPEN statement for
cursors; a cursor is considered to be open when it is declared."
http://www.postgresql.org/docs/8.3/int
On Jul 29, 2008, at 4:51 PM, Klint Gore wrote:
It's different in PL/pgSQL.
Ah, yes, sorry, didn't catch that it was a PL/pgSQL function.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
My apologies if this is in the docs and I missed it, but is there a
PL/pgSQL function equivalent for the pglib function
PQtransactionStatus (i.e., a way to find out if we're in an open
transaction block, and if that transaction is in an error status)?
--
Sent via pgsql-general mailing list
On Jul 31, 2008, at 11:12 AM, Richard Huxton wrote:
A pl/pgsql function *always* executes within a transaction.
Indeed so. What I'm looking for is a way of detecting if a
transaction block has been opened (i.e., we're within a BEGIN).
--
Sent via pgsql-general mailing list (pgsql-general@
On Jul 31, 2008, at 11:49 AM, Alvaro Herrera wrote:
Why does it matter?
I'm attempting to "clean out" a connection that is in an unknown
state (along the lines of what pgpool does when reusing an open
connection). Of course, I could just fire an ABORT down, but it
seems nicer to avoid d
On Jul 31, 2008, at 11:49 AM, Alvaro Herrera wrote:
Why does it matter?
Ah, I see, deep confusing on my part regarding PL/pgSQL and
tranasctions! Ignore question. :)
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.post
On Aug 3, 2008, at 1:18 PM, [EMAIL PROTECTED] wrote:
ERROR: function uuid_ns_url() does not exist
Remember to install the functions in your database using the SQL file
in the contrib/uuid-ossp directory, uuid-ossp.sql.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
T
I'm startled that I've never done this before, but... I have a PL/
pgSQL function that takes no arguments, returns VOID, and has a bunch
of side effects on the database. The correct way of invoking this
function is:
SELECT my_func();
... yes? Thanks; it seems to work fine, but us
On Aug 15, 2008, at 1:47 PM, Raymond O'Donnell wrote:
For functions return SETOF any type, you need to use the following
idiom:
Or, you can use,
RETURN QUERY
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgr
On Aug 26, 2008, at 7:10 PM, Anderson dos Santos Donda wrote:
How I can connect a postgre database on another postgre database,
and manipulate the datas on both database?
There is a module in contrib just for such a purpose:
http://www.postgresql.org/docs/8.3/interactive/dblink.html
On Aug 28, 2008, at 3:23 PM, D. Dante Lorenso wrote:
I use RETURNING for all my insert and UPDATE statements now.
Usually I'll return the primary key for the table, but sometimes I
return a column that is created by one of my triggers. It's
awesome to be able to do this in one query.
On Aug 28, 2008, at 3:21 PM, Matthew Dennis wrote:
I have no doubt that someone would complain about it, but I think
it's better than the alternative.
Determining if changing any function will cause an index to break is
not a straight-forward problem. I don't believe that PG right now
kee
On Aug 28, 2008, at 5:49 PM, Matthew Dennis wrote:
Yes, I can see that would indeed be a problem. Are there future
plans to start tracking such dependencies? It seems like it would
be a good idea in general.
I believe the EXECUTE statement would thwart such plans.
--
Sent via pgsql-gener
On Aug 28, 2008, at 6:10 PM, Matthew Dennis wrote:
I'm not sure I follow. Couldn't you track which statements were
prepared that called a function and either reprepare (just like
reindex, recheck, etc) or in the case of dropping a function,
refuse to drop it because something depends on it
On Aug 28, 2008, at 6:51 PM, Alvaro Herrera wrote:
Also, you have to keep in mind that we support pluggable
languages. The
function's source code is just an opaque string.
Oh, ouch, right.
I think that this is one of those cases where it's better that we
simply advertise: BE AWARE OF THI
On Aug 28, 2008, at 7:04 PM, Matthew Dennis wrote:
The plpgsql execute statement, as I understand it, means "take this
string and execute like a client sent it to you".
Of course, the string could come from anywhere. There's no inherent
reason that I can think of (except good taste) that yo
On Aug 28, 2008, at 7:22 PM, Matthew Dennis wrote:
Yes, but in the case of pluggable languages, you still load
something that constitutes the "source". In the case of PL/Java,
the jar for example.
This would mean that, for example, if you changed any single function
(no matter how distan
On Aug 30, 2008, at 6:26 AM, Albretch Mueller wrote:
Well, then obviously there is the need for it and you were not
successful enough at convincing these developers that they were
"confusing postgresql with a spreadsheet program"
The behavior you are looking for is typical of a spreadsheet, b
On Aug 30, 2008, at 10:33 AM, Albretch Mueller wrote:
well, yeah! I would totally agree with you, but since I doubt very
much "COPY FROM CSV" is part of the SQL standard to beging with, why
not spice it up a little more?
I'd guess that coming up with a general algorithm to guess the type
fr
You have made clear to me why my attempt for a RFE for COPY FROM CVS
has found some technical resistance/disagreement, but I still think my
idea even if not so popular for concrete and cultural reasons makes at
least sense to some people
It's a perfectly reasonable problem to want to solve; th
On Aug 31, 2008, at 7:44 PM, Guy Rouillier wrote:
CTOs/CIOs like to sleep at night.
If you buy Oracle, and there's a problem, the conversation with the
CEO is that "Oracle broke." With PG, even if you have exactly the
same level of support, "that database you selected broke."
The sad rea
On Sep 4, 2008, at 11:34 AM, Akhtar Yasmin-B05532 wrote:
I am really stuck here. And need to get a way thru all of this.
Any suggestions will be really appreciated.
Have you confirmed that the user that you are logged in as when you
attempt to start Postgres has write access to /home/data/www
On Sep 25, 2008, at 1:05 PM, Casey Allen Shobe wrote:
As for the expectation above - could pl/pgsql be made compilable?
Without getting into the argument as to the level of security
provided, it strikes me that a reasonable approach would be a non-
core pluggable language which accepts encr
On Oct 28, 2008, at 4:03 PM, Steve Atkins wrote:
Installing from source means I can avoid the fragility of macports
or fink, and know that I've built it in much the same way as the
postgresql or solaris installation I'd be using for production.
+1
It means I can easily pick the contrib mod
On Oct 30, 2008, at 8:10 AM, Grzegorz Jaśkiewicz wrote:
up to 8.3 it was massively slower on raid1 (software raid on
linux), starting from 8.3 things got lot lot better (we speak 3x
speed improvement here), but it still isn't same as on 'plain' drive.
I'm a bit surprised to hear that; what
On Oct 30, 2008, at 2:54 PM, Gregory Stark wrote:
Wouldn't it be just as good to indicate to the archive command the
amount of
real data in the wal file and have it only bother copying up to
that point?
Hm! Interesting question: Can the WAL files be truncated, rather
than zeroed, safely?
On Nov 20, 2008, at 1:21 PM, Tom Lane wrote:
See the fine manual, for instance last para here:
http://developer.postgresql.org/pgdocs/postgres/queries-with.html
Fine manual indeed... this the best explanation of WITH RECURSIVE
I've ever read. Kudos to the documentation writer(s).
--
Sent v
Hi
Why don't use etckeeper ?
Regards,
http://joey.kitenet.net/code/etckeeper/
Le 03/11/09 23:41, JP Fletcher a écrit :
Hi,
We manage hundreds of clusters and a handful of distinct pg_hba.conf
files across several sites. We are mostly satisfied with our
automated method of management, but
Playing the straight man, I have to ask: Scalability issues with locks
in PG vs Oracle?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Feb 15, 2009, at 2:47 PM, Stuart McGraw wrote:
I just hoping for some confirmation that the permissions based
approach did not have some holes in it that I am
not seeing.
Another possibility is to create a set of functions that contain the
query operations you would like to allow, isol
On Mar 4, 2009, at 9:54 AM, Joshua D. Drake wrote:
Not sure what the complainer is talking about here. pgsql-announce is
moderated so spam should be almost nil.
I'm not 100% sure what "Twitter spam" *is*, for that matter.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
T
On Mar 11, 2009, at 5:51 PM, CaT wrote:
Will there be a saved version of this available for later viewing?
Don't
make me choose between steak and beer and postgres. 8(
Yes! I'll announce it here when it's available.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To m
On Mar 13, 2009, at 11:59 AM, Joshua D. Drake wrote:
Wait, actually a good BBU RAID controller will disable the cache on
the
drives. So everything that is cached is already on the controller vs.
the drives itself.
Or am I missing something?
Maybe I'm missing something, but a BBU controller
Hi,
The video is now available for download! You can find it at:
http://blog.thebuild.com/sfpug/sfpug-unison-20090311.mov
Thanks,
-- Christophe
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
On Mar 17, 2009, at 9:57 PM, Joshua D. Drake wrote:
It is also on Vimeo:
http://www.vimeo.com/3732938
Joshua D. Drake
Thanks!
-
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
What I've done in the past in this situation is to create a separate
field with the text normalized to whatever the search form is (all
lower case, accents stripped, etc.), and then index and search that
from the application.
Although I've not tried it, a functional index that did the same
On Mar 18, 2009, at 11:24 AM, Alvaro Herrera wrote:
Hmm, if to_ascii() doesn't work, that's something worth some research.
Maybe the encoding config is broken, for example.
The docs say to_ascii() only works with LATIN1, LATIN2, LATIN9, and
WIN1250; maybe convert('string', 'UTF-8', 'SQL_ASCI
On Mar 23, 2009, at 1:41 PM, Jeremy Harris wrote:
Because equality is not well-defined for "real" values?
That was my first thought, too, but why would two identical real
literals evaluate to different bit patterns?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To m
On Apr 11, 2009, at 10:15 AM, li...@mgreg.com wrote:
So, how does needing to connect to a database before querying about
existing databases make any sense?
Well, you have to connect to the database server, no matter what, in
order to check on the existence of a database (unless you are doin
Greetings,
The video from the April 8, 2009 SFPUG meeting, "PostgreSQL in the
Cloud," is now available for viewing or download from the
media.postgresql.org server:
http://media.postgresql.org/sfpug/sfpug-cloud-20090408.mov
Thanks to Josh Berkus for his organizational talents, and Dirk
On Apr 13, 2009, at 1:59 PM, Ivan Sergio Borgonovo wrote:
wget says it is a 1Gb file.
Is there anything smaller?
Since I have the master right here, I'll be happy to reencode it to a
smaller size (250mb is probably the reasonable lower limit before the
video quality reaches the point that
On Apr 13, 2009, at 2:54 PM, Joshua D. Drake wrote:
Yes Vimeo can download and I will have it up soon.
Thank you! My work here is done. :)
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-gene
On Apr 21, 2009, at 12:28 PM, Peter Eisentraut wrote:
Yes, but if you are asking that question, you probably really want
to use
TRUNCATE.
The advantage of DROP TABLE being, of course, that DROP TABLE is
transactionally-safe, while TRUNCATE is not.
--
Sent via pgsql-general mailing list (
On Apr 21, 2009, at 1:20 PM, Tom Lane wrote:
They're both going to drop data that
might conceivably be visible in the snapshot of some concurrent
transaction that hasn't yet touched the table (else it would have
lock)
but might wish to do so later.
Unless I'm deeply misunderstanding somethi
On Apr 21, 2009, at 1:36 PM, Tom Lane wrote:
I was thinking of MVCC semantics, which is a different issue.
Indeed so, my error. This is a bit of a drift off-topic, but
rereading the docs, I'm now having trouble visualizing the real-world
effect of the non-MVCC-safeness of TRUNCATE. A tra
On Apr 21, 2009, at 2:15 PM, Jeff Davis wrote:
In Session1, the serializable transaction sees an empty version of
bar,
even though it had tuples in at the time Session1 got its serializable
snapshot.
Indeed so, and I understand that part. But since Session1 didn't try
to access 'bar', it
On Apr 27, 2009, at 7:00 AM, Robert Pepersack wrote:
My agency has a contractor that created a PostgreSQL database that
he calls "object-oriented". I noticed that the contractor has more
than one value in a column separated by commas. In the relational
world, this obviously violates first
On May 6, 2009, at 10:47 AM, Gauthier, Dave wrote:
Is there a way to read an XML file into a postgres DB? I’m thinking
that it will create and relate whatever tables are necessary to
reflect whatever’s implied by the XML file structure.
There's no built-in functionality that does what you
On May 8, 2009, at 9:51 AM, Gauthier, Dave wrote:
This gets rid of the header and footer OK. But there is still a
blank line as the first line in stdout. Also, each record has a
preceding space before the column value.
Is there a way to do what I want?
sed?
On May 8, 2009, at 11:25 AM, John R Pierce wrote:
you read your tables by column, rather than by row??
SQL queries are inherently row oriented, the fundamental unit of
storage is a 'tuple', which is a representation of a row of a table.
I believe what is referring to is the disk storage orga
Greetings,
The video from the May 12, 2009 SFPUG meeting, "BIRT & PostgreSQL," is
now available for viewing or download from the media.postgresql.org
server:
http://media.postgresql.org/sfpug/sfpug-birt-20090512.mov
Thanks,
-- Xof
--
Sent via pgsql-general mailing list (pgsql-general@po
On May 23, 2009, at 9:13 AM, Daniel Verite wrote:
I don't know why this query returns false:
SELECT '20040506 070809.01'::timestamp(6) - '20010203
040506.007000'::timestamp(6) = '1188 day 3 hour 3 minute 3 second 3
millisecond'::interval;
If I just subtract the two timestamps, its result is
On May 23, 2009, at 10:44 AM, Havasvölgyi Ottó wrote:
Thanks.
I tested the standard Win32 distribution of 8.3.6.
The same happens on 8.2. But on 8.0 it works.
When I don't use milliseconds, then it works.
Will 8.4 work fine on Win32 again?
If the issue is using floating point timestamps, th
On May 24, 2009, at 8:58 AM, Craig Ringer wrote:
There isn't currently any REINDEX CONCURRENTLY
option, but people seem to have a few workarounds that do the job if
you
really do need to rebuild an index on a live, active table.
It's pretty straight-forward to do:
CREATE INDEX CONCURRENTLY
On May 27, 2009, at 3:25 PM, Greg Smith wrote:
Interesting and an extremely common request. I just added an item
to the Vacuum section of the TODO list while you were listing issues
and potential solutions here: "Provide more information in order to
improve user-side estimates of dead spa
ck, which will cause an index update.
The important thing to remember is that the process you are describing (in
which indexes are not updated unless a column involved in the index changes) is
an optimization, Heap-Only Tuples. It's a very common optimization, but it's
not guaranteed.
application to
have a LIMIT > 45 in order to prevent the performance issue, but am I sure
that this threshold will always be the same ?
2) Is it possible for a specific query to force the planner on choosing a
given index or preventing it from choosing one ?
What kind of other options do I have to solve this performance issue ?
Thanks in advance for any help,
Regards,
--
Christophe Escobar
o lock
a tuple when another process has done an explicit LOCK ACCESS EXCLUSIVE?
--
-- Christophe Pettus
x...@thebuild.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
message implies there is such a thing as
an AccessExclusiveLock on a tuple, which is new to me. I wasn't able to
produce this message experimentally doing various combinations of UPDATE
statements and SELECT FOR UPDATEs, or even with explicit LOCK ACCESS EXCLUSIVE
MODE, thus the questi
,,"psql"
Note that it's waiting for a ShareLock, not an AccessExclusiveLock, thus my
question.
Just to clarify, my very specific question is about "AccessExclusiveLock".
--
-- Christophe Pettus
x...@thebuild.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
from time to time.
Great, thank you!
--
-- Christophe Pettus
x...@thebuild.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ity resolve things? What confidentiality promises
are made?
--
-- Christophe Pettus
x...@thebuild.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
y suggest that we table the discussion of the CoC text at this
point, let the high passions moderate a bit, and talk about the process. That
is the detail in which the devils will live.
--
-- Christophe Pettus
x...@thebuild.com
--
Sent via pgsql-general mailing list (pgsql-general@postgres
t, and decide on a full package,
rather than continuing this process here in -general.
--
-- Christophe Pettus
x...@thebuild.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
he development of this
> feature, nobody is asking you to.
Participation does not need to be limited to copy-editing. Of all the ways to
develop a community CoC, we're engaged in just about the worst possible one
right now.
--
-- Christophe Pettus
x...@thebuild.com
--
Sent via pgsql-g
sion has gotten so out of
control (basically, people are being told to shut up left and right), that I
don't see a consensus is possible right now.
--
-- Christophe Pettus
x...@thebuild.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
hout actually checking its validity.
--
-- Christophe Pettus
x...@thebuild.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Jan 24, 2016, at 8:17 PM, Christophe Pettus wrote:
> 2. Use the NOT VALID option on ALTER TABLE ... ADD constraint, which allows
> the addition of a constraint without actually checking its validity.
And note that you might miss some potential planner optimizations this way, as
the p
On Jan 24, 2016, at 9:01 PM, Charles Clavadetscher
wrote:
> What is the point of having a check constraint that is not checked?
Well, it *is* checked going into the future; it's just not checked at the time
the constraint is added. Ultimately, you do want to fix the data, but this
makes it
Is there a standard way of handling this situation?
--
-- Christophe Pettus
x...@thebuild.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
We have a database (PostgreSQL 9.3.10) which is reporting this error on a TOAST
table on a VACUUM. Is there a canonical way of repairing this? The table is
*huge*, so a VACUUM FULL or pg_dump / pg_restore is probably not going to work.
--
-- Christophe Pettus
x...@thebuild.com
--
Sent
On May 24, 2016, at 1:16 PM, Gavin Flower wrote:
> What does 'GCC' stand for?
Gulf Cooperative Council. :)
https://en.wikipedia.org/wiki/Gulf_Cooperation_Council
--
-- Christophe Pettus
x...@thebuild.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql
erious an issue.
1. Are you using connection pooling?
2. What's the application server environment?
--
-- Christophe Pettus
x...@thebuild.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
every record.
Or did you mean 'statecode' to be a column in a different table, on which
you're joining?
--
-- Christophe Pettus
x...@thebuild.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
I've missed it...
--
-- Christophe Pettus
x...@thebuild.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Jan 23, 2015, at 7:40 AM, Tim Smith wrote:
> re: (a)
>
>> see the documentation pertaining to 'jsonb indexing', to wit:
>>
>> -- Find documents in which the key "company" has value "Magnafone"
>> SELECT jdoc->'guid', jdoc->'name' FROM api WHERE jdoc @> '{"company":
>> "Magnafone"}';
>
> No
; is not quite the same thing.
--
-- Christophe Pettus
x...@thebuild.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
e?
Thanks!
--
-- Christophe Pettus
x...@thebuild.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
reated [...]
Thanks! I suppose my question then is: Besides slot creation, when is
pg_decode_startup called?
--
-- Christophe Pettus
x...@thebuild.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ACT(dow FROM day) BETWEEN 1 AND 5;
count
---
82
(1 row)
In cases where you have more complex calendars (like lists of bank holidays),
you could join against a table of them, or use a function that determines
whether or not a particular day is holiday or not.
--
-- Christophe Pettus
x...@t
1 - 100 of 236 matches
Mail list logo
