ll roll-back the changes.
--
Regards,
Richard Broersma Jr.
nf/elephant-roads-a-tour-of-postgres-forks
--
Regards,
Richard Broersma Jr.
> --
> Álvaro Herrerahttp://www.2ndQuadrant.com/
> PostgreSQL Development, 24x7 Support, Training & Services
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
Regards,
Richard Broersma Jr.
renamed columns,
> etc.
>
> Thanks in advance for your precious help,
>
> --
> Lionel
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
Regards,
Richard Broersma Jr.
. If I'm correct that this feature is
> not currently present, would adding it be a reasonable feature request? How
> would I go about making a feature request? (My apologies if there is a
> how-to on feature requests somewhere; my searching didn't turn it up.)
>
> Thank you.
>
--
Regards,
Richard Broersma Jr.
Yours,
> Laurenz Albe
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
Regards,
Richard Broersma Jr.
141 | B-0307
74 | B-0423
(10 rows)
--
Regards,
Richard Broersma Jr.
Okay, should the 9.2 beta announcement and press releases be amended
to show this link rather than the ones posted?
On Wed, May 16, 2012 at 10:40 AM, Guillaume Lelarge
wrote:
> On Wed, 2012-05-16 at 10:28 -0700, Richard Broersma wrote:
>> I've seen the following statement made
e any results:
http://www.postgresql.org/download/
or
http://www.postgresql.org/download/windows/
or
http://www.enterprisedb.com/products-services-training/pgdownload#windows
Are we waiting for a refresh on the download page?
--
Regards,
Richard Broersma Jr.
--
Sent via pgsql-general mailing list (pgsql-genera
ook at Btree_gist index:
http://www.postgresql.org/docs/9.1/static/btree-gist.html
I think this is the part that your missing.
--
Regards,
Richard Broersma Jr.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ic.pref_scores
DROP CONSTRAINT pref_scores_gid_fkey,
ADD CONSTRAINT pref_scores_gid_fkey
FOREIGN KEY (gid)
REFERENCES pref_games(gid)
ON DELETE CASCADE;
--
Regards,
Richard Broersma Jr.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
her term I don't
> recall but found nothing.
My pg.dump files show nulls as:
\N
--
Regards,
Richard Broersma Jr.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Fri, Nov 18, 2011 at 12:13 PM, John R Pierce wrote:
> where field ~ '^(jo|mo|do|fo)'
Don't forget to add the l as the end:
where field ~ '^(jo|mo|do|fo)l'
--
Regards,
Richard Broersma Jr.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.
and views *can* change
between major releases while the information_schema is expected to be
more stable between major releases.
Applications that depend upon the information_schema rather than
pg_catalog are less likely to break when the PostgreSQL server is
upgraded.
--
Regards,
Richard Broersma Jr
lation supported by PostgreSQL is READ
COMMITTED which is the default transaction isolation level:
http://www.postgresql.org/docs/9.1/interactive/sql-set-transaction.html
--
Regards,
Richard Broersma Jr.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
the altered
error messages. But remember that catching errors and throwing them
will have a performance penalty.
http://www.postgresql.org/docs/9.1/interactive/plpgsql-control-structures.html#PLPGSQL-ERROR-TRAPPING
--
Regards,
Richard Broersma Jr.
--
Sent via pgsql-general mailing list (pgsql-genera
ow the developer to specify any
desired message.
--
Regards,
Richard Broersma Jr.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Thu, Oct 27, 2011 at 9:18 AM, Gauthier, Dave wrote:
> I need to be able to select all records with a col value that matches any of
> a list of regexp. Sort of like...
>
> select a,b,c from foo where d ~ ('^xyz','blah','shrug$');
WHERE d ~ '^xyz|
TRANSACTION;
DROP VIEW someView ...;
ALTER TABLE DROP COLUMN someColumn1, DROP COLUMN someColumn2;
CREATE VIEW someView AS ...;
COMMIT; --Wait for pre-existing locks to complete and hope your client
app doesn't break.
--
Regards,
Richard Broersma Jr.
--
Sent via pgsql-general mai
wrote:
> On Tue, 27 Sep 2011, Richard Broersma wrote:
>
>> ODBC handles this by converting these to a text representation that Open
>> Office can handle.
>
> Richard,
>
> Progress has been made. I built and installed unixODBC from
> slackbuilds.org and now the hangu
7;d recommend using JDBC ODBC driver for PostgreSQL. Open Office via
direct JDBC has a hard time with some PostgreSQL data-types. ODBC
handles this by converting these to a text representation that Open
Office can handle.
--
Regards,
Richard Broersma Jr.
--
Sent via pgsql-general mailing list (pgs
ind in the manual
after 5 minutes of reading.
1) alter the tables/schema/... to be owned by a role that all of these
users belong to:
http://www.postgresql.org/docs/8.4/interactive/sql-altertable.html
2) grant the table/schema to the role:
http://www.postgresql.org/docs/8.4/interactive/privileges.htm
ent?
I'm confused. Do you want to UPDATE the affected records to GW-22. Or
do you want to ALTER the table to add a column constraint to prevent
malformed site_id's in the future?
--
Regards,
Richard Broersma Jr.
--
Sent via pgsql-general mailing list (pgsql-general@postgr
be able to get an index scan if you include a few more criteria:
AND site_id BETWEEN 'GW-22' AND 'GW-23'
Also WHERE site_id '^GW-22' may use and index scan also.
--
Regards,
Richard Broersma Jr.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org
e table's user_id column.
So:
ALTER TABLE "my table"
ADD CONSTRAINT "my table_Users_user_id_fkey"
FOREIGN KEY (user_id)
REFERENCES "Users" (user_id) ON UPDATE CASCADE ON DELETE SET NULL,
ALTER COLUMN user_id DROP NOT NULL;
--
Regards,
Richard Broersma Jr.
-
On Wed, Aug 24, 2011 at 10:14 AM, Merlin Moncure wrote:
> this is IMO not a feature, but a bug.
Would the feature I'm requesting be a bug or is it the current
behavior that would be considered a bug?
--
Regards,
Richard Broersma Jr.
--
Sent via pgsql-general mailing list (pgsql
pport@postgresql.org/msg11482.html
--
Regards,
Richard Broersma Jr.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
attend the PostgreSQL booth as the
Expo for Saturday and Sunday - February 25th through 26th. Send me an email
if your interested.
--
Regards,
Richard Broersma Jr.
community
locals!
If your interested, please reply with an email "off-list."
--
Regards,
Richard Broersma Jr.
P.S.
Also if your in town on Friday, be sure to check out PgDay on Friday
February 25th.
https://sites.google.com/site/pgdayla/
Is there much of a likelihood for the release of an Alpha 3 one-click installer?
--
Regards,
Richard Broersma Jr.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
l
http://www.postgresql.org/docs/9.0/interactive/sql-createrole.html
>... with `id` < 1616.
This cannot be done using ordinary DDL.
--
Regards,
Richard Broersma Jr.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/ma
Oops, your right, I miss-read your post. Sorry.
--
Regards,
Richard Broersma Jr.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
|
> Indexes:
> "EXCL_double_combi" EXCLUDE USING btree (imm_least(subject_id,
> object_id) WITH =, imm_greatest(subject_id, object_id) WITH =)
I see. Since exclusion constraints is a rather new feature, psql may
need some tweaking to report these constraints as constraints
--
efinition of your constraint.
--
Regards,
Richard Broersma Jr.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
able:
http://www.postgresql.org/docs/9.0/interactive/sql-createtrigger.html
--
Regards,
Richard Broersma Jr.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
oesn't
support sub-selects in a tables check constraints:
http://www.postgresql.org/docs/9.0/interactive/sql-createtable.html
--
Regards,
Richard Broersma Jr.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
it is based on timestamps rather than dates:
http://temporal.projects.postgresql.org/
--
Regards,
Richard Broersma Jr.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
you need. pgbouncer is the smallest and most
> lightweight pooler available.
Also, Pgbouncer is the only connection-pooler that work on MS-Windows
that is released for production use.
--
Regards,
Richard Broersma Jr.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To mak
sions of Oracle and Postgresql. :)
--
Regards,
Richard Broersma Jr.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Nov 18, 2010, at 1:31 PM, "Joshua D. Drake" wrote:
> On Thu, 2010-11-18 at 16:18 -0500, andrew wrote:
>> hi all,
>> I've just read that pgadmin team was hired by some company and the
>> project will be closed... It was a post from 2009.
>> I'm just curious what's the story behind that. Did a
ALTER TABLE foo
DROP CONSTRAINT your_constraint,
ADD CONSTRAINT your_constraint FOREIGN KEY ...
ON UPDATE CASCADE ON DELETE RESTRICT;
--
Regards,
Richard Broersma Jr.
Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug
--
Sent via pgsql-ge
(NULLIF( fair, FALSE)) as fair,
COUNT(NULLIF( fair, TRUE)) as "not fair",
COUNT(NULLIF( nice, FALSE)) as nice,
COUNT(NULLIF( nice, TRUE)) as "not nice",
from public.pref_rep;
--
Regards,
Richard Broersma Jr.
Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://
seem so
> bad.
The google mailing lists also have this bidirectional feature.
--
Regards,
Richard Broersma Jr.
Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to y
ou have to use a physical column name or an
expression.
--
Regards,
Richard Broersma Jr.
Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://ww
postgresql's INTEGER to access's [yes/no] datatype.
Life is so much better now because.
--
Regards,
Richard Broersma Jr.
Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make cha
terest.
The following link contains hundreds of comments that you may be
interested in, some that address issues that are much more interesting
and well established:
http://search.postgresql.org/search?q=mysql+performance&m=1&l=NULL&d=365&s=r&p=1
--
Regards,
Richard Broersma
nstallers!
--
Regards,
Richard Broersma Jr.
Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
I'm interested in playing with some of the features in the Alpha 2.
Is there an ETA for the release for the one-click installer?
--
Regards,
Richard Broersma Jr.
Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug
--
Sent via pgsql-general mailing list (
ogle.com/site/ankurpshah2/joe-celkos-sql-puzzles-and-answers-s.pdf
--
Regards,
Richard Broersma Jr.
Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscripti
Regards,
Richard Broersma Jr.
Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Mon, Nov 1, 2010 at 9:52 AM, Richard Broersma
wrote:
> On Mon, Nov 1, 2010 at 9:47 AM, Carlos Mennens
> wrote:
>
>> Sadly I blindly upgraded my database w/o doing a dump / restore so can
>> anyone tell me if I am dead in the water or is there a way I can
>> recover
ent to proceed.
--
Regards,
Richard Broersma Jr.
Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ull Name
*E-mail
*Cell Phone
*Title of Talk
*Description of Talk
*Notes for Committee
For more information visit: https://sites.google.com/site/pgdayla/
--
Regards,
Richard Broersma Jr.
Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug
--
What happens when you issue this query
directly from PSQL, does the query run much faster.
--
Regards,
Richard Broersma Jr.
Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make c
ute AS a
INNER JOIN pg_catalog.pg_class c
ON C.oid = a.attrelid
WHERE c.relname ~ '^(mytable)$' AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum;
--
Regards,
Richard Broersma Jr.
Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug
--
S
MySQL does this also.
In PostgreSQL you can issue a periodic cluster command on the primary
key. But as mentioned it is a bad practice to rely on the physical
ordering of the table.
--
Regards,
Richard Broersma Jr.
Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresq
found.
> postgres=# \d
try:
select current_database();
--
Regards,
Richard Broersma Jr.
Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
\dn
tables/views:
db => \d
other useful commands:
db => \?
--
Regards,
Richard Broersma Jr.
Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscriptio
rg/docs/9.0/static/functions-info.html
Note that there is a slight distinction between current_user and session_user.
postgres=> select user, current_user, session_user;
current_user | current_user | session_user
--+--+--
broersr | broersr | broersr
#x27;newpass');
You'd want to use "ALTER USER"
http://www.postgresql.org/docs/8.4/interactive/sql-alteruser.html
So:
ALTER USER carlos WITH ENCRYPTED PASSWORD 'password';
--
Regards,
Richard Broersma Jr.
Visit the Los Angeles PostgreSQL Users Group (LAPUG)
htt
ull.
Perhaps the easiest was to help such users is to make the column(s) in
question NOT NULL DEFAULT ''.
--
Regards,
Richard Broersma Jr.
Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug
--
Sent via pgsql-general mailing list (pgsql-general
umn ~ E'MyRegEx' ) IS UNKNOWN
might work.
--
Regards,
Richard Broersma Jr.
Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
reSQL is so secure that some people cannot
figure out how to log in. :)
--
Regards,
Richard Broersma Jr.
Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscri
g/wiki/Converting_from_other_Databases_to_PostgreSQL#IBM_DB2
--
Regards,
Richard Broersma Jr.
Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgres
I'd like to propose the following items be added to the todo list:
(Any thoughts?)
1) Modify composite types to allow ALTER DOMAIN(s) to ADD CONSTRAINT.
2) Allow a since ALTER DOMAIN issue multiple ADD and DROP commands in
a single statement.
On Thu, Jun 3, 2010 at 9:12 AM, Richard Bro
ot alter type "tag_function" because column "tags"."tag" uses it
broersr=> rollback;
ROLLBACK
--
Regards,
Richard Broersma Jr.
Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
uot;::VARCHAR AS lawntype
FROM green
UNION ALL
SELECT flaech, "fairway"::VARCHAR AS lawntype
FROM fairway;
Then you'd execute the following query:
SELECT lawntype, sum(flaech)/1 AS "HA"
FROM Lawns
GROUP BY lawntype;
--
Regards,
Richard Broersma Jr.
Visit t
e perceptive clients using
optimistic locking.
However, as Marko mentioned, they probably wont. :(
--
Regards,
Richard Broersma Jr.
Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make chang
get this
result is:
SELECT ROW( my_table.* ) FROM my_table;
http://www.postgresql.org/docs/9.0/static/sql-expressions.html#SQL-SYNTAX-ROW-CONSTRUCTORS
--
Regards,
Richard Broersma Jr.
Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug
--
Sent via pgsql-gene
ncorrectly displayed
row_counts on update-able views.
--
Regards,
Richard Broersma Jr.
Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.post
On Sat, May 29, 2010 at 8:21 PM, Richard Broersma
wrote:
> The following email was my first discovery that these kinds of
> update-able view were not get-along well with client side optimistic
> locking.
>
> http://archives.postgresql.org/pgsql-odbc/2006-12/msg00029.php
Actually t
ments were in fact processed, so the
refreshed row in the view appears to have an non-atomic update even
though the client rolls back the transaction.
The following email was my first discovery that these kinds of
update-able view were not get-along well with client side optimistic
locking.
http:
alies that can occur from the view point client side optimistic
locking where the virtual row appears to be inconsistently updated.
--
Regards,
Richard Broersma Jr.
Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug
--
Sent via pgsql-general mailing list (
yet, but possible in 9.1 this can be done using write-able CTEs if
they are accepted.
http://pgexperts.com/document.html?id=38
--
Regards,
Richard Broersma Jr.
Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug
--
Sent via pgsql-general mailing list (pgsq
ade to be deferrable.
http://www.postgresql.org/docs/8.4/interactive/sql-createconstraint.html
--
Regards,
Richard Broersma Jr.
Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make change
rts/manage?hl=en&gl=us&source=alertsmail&cd=CaigIeWKJt8&cad=:s1:f1:v0:>your
alerts.
--
Regards,
Richard Broersma Jr.
Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug
s in the \dD
command. However, I see that the right answers can be found in the
domain_constraints information_schema.
--
Regards,
Richard Broersma Jr.
Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug
--
Sent via pgsql-general mailing list (pgsql-general@post
pkey" PRIMARY KEY, btree (area_code, process_code,
loop_nbr, tag_seq)
Check constraints:
"valid_area_codes" CHECK (area_code >= 0 AND area_code <= )
"valid_loop_nbrs" CHECK (loop_nbr >= 0 AND loop_nbr <= )
"valid_process_codes" CHECK (
t; find this.
> Thanks,
Here is an excellent presentation put together by Josh Berkus. It
doesn't give you all the specifics but it certainly points you in the
right direction.
http://www.pgexperts.com/document.html?id=3
--
Regards,
Richard Broersma Jr.
Visit the Los Angeles PostgreSQ
ed or denied. Very important to
>
>
This is the closed thing I've seen outside of scanning the postgresql logs.
http://www.depesz.com/index.php/2007/09/21/what-fields-are-usually-changed-when-updateing/
--
Regards,
Richard Broersma Jr.
Visit the Los Angeles PostgreSQL U
On Wed, May 12, 2010 at 10:55 AM, Thomas Kellerer wrote:
> Richard Broersma wrote on 12.05.2010 17:45:
>
>> I'm considering using the windows version PostgreSQL in the following
>> conditions:
>> at least 10 years of up time (with periodic power failures<= 1 a yea
Is there any
concern for loss of data if a file rewrite is interrupted by a power
failure? When using postgres there are some protections provided to
reduce this kind of data loss.
However, I do agree that tabular/xml data would stand the test of time.
--
Regards,
Richard Broersma Jr.
Visit
e, I used the windows version of PostgreSQL daily for 4 years.
I've only experienced one crash with version 8.4.0. Since the
update, I've yet to see any additional crashes.
--
Regards,
Richard Broersma Jr.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
gresql.org/docs/8.4/interactive/app-pgresetxlog.html
--
Regards,
Richard Broersma Jr.
Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www
onsistent copy:
http://www.postgresql.org/docs/8.4/interactive/backup-file.html
If you have a consistent copy, you might need to point PostgreSQL to
work from the copied data directory.
http://www.postgresql.org/docs/8.4/interactive/server-start.html
--
Regards,
Richard Broersma
e rows. So,
for some people, there are times when even surrogate keys cannot be
relied upon as a PK.
--
Regards,
Richard Broersma Jr.
Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To
ndix.html
http://www.postgresql.org/docs/9.0/static/functions.html
http://www.postgresql.org/docs/9.0/static/reference.html
--
Regards,
Richard Broersma Jr.
Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug
--
Sent via pgsql-general mailing list
e to the truncated data values. I've also seen
this with null valued boolean fields.
Part of the solution would be configure the ODBC driver to use
PostgreSQL's xmin for optimistic locking. Of-course this doesn't fix
MS-Accesses inability to handle the ranges of many of PG data-t
onid);
Does an index help a sort operation in PostgreSQL?
--
Regards,
Richard Broersma Jr.
Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www
an achieve continuous booth coverage between the times:
Saturday 10:00 am to 6:00 pm and Sunday 10:00 am to 5:30 pm.
If interested, please contact me off list so that we can make arrangements.
--
Regards,
Richard Broersma Jr.
Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql
Are Writable CTE queries defined by the SQL standard, or are they and extension?
--
Regards,
Richard Broersma Jr.
Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
sense for certain types of mappings.
> FKs don't generate their own values, they reference values in a PK or
> unique field somewhere else really.
Good catch. :) I've been sticking my foot in my mouth all day with
typos like this.
--
Regards,
Richard Broersma Jr.
Visit the L
key to be defined as serial. A
serial foreign key would be nonsensical since foreign keys should be
be generating their own values.
--
Regards,
Richard Broersma Jr.
Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug
--
Sent via pgsql-general mailin
r work for you?
http://www.postgresql.org/docs/8.4/static/functions-array.html#ARRAY-OPERATORS-TABLE
--
Regards,
Richard Broersma Jr.
Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To
elect countertest(24);
countertest
-
1
(1 row)
http://www.postgresql.org/docs/8.4/interactive/xfunc-sql.html
--
Regards,
Richard Broersma Jr.
Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug
--
Sent via pgsql-general mailing list (pg
e/internals.html
--
Regards,
Richard Broersma Jr.
Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
hours of China it becomes the Master.
Of course the person how constructed this system mentioned it was
woefully challenging. In his case, not only was the slony
configuration difficult but also finding and keeping stable
communication path-ways between China and the US.
--
Regards,
Richard Br
pgrade on 8.4. This *should* eliminate to future
need to dump and reload for future upgrades.
--
Regards,
Richard Broersma Jr.
Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make c
o the
> infrastructure guys responsible so they check double-check for any
> problems.
They responded promptly with a fix. Thanks for directing it to them.
--
Regards,
Richard Broersma Jr.
Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug
--
Se
On Mon, Dec 14, 2009 at 9:10 AM, Dave Page wrote:
>> It currently shows the binaries for 8.4.1.
> Did you try a reload?
Yes, It shows 8.4.2. Actually the page refreshed two minutes after I
sent the email.
--
Regards,
Richard Broersma Jr.
Visit the Los Angeles PostgreSQL Users Gro
1 - 100 of 540 matches
Mail list logo
