, it will roll-back the changes.
--
Regards,
Richard Broersma Jr.
-forks
--
Regards,
Richard Broersma Jr.
/
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.
--
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.
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.
://www.postgresql.org/mailpref/pgsql-general
--
Regards,
Richard Broersma Jr.
-0307
74 | B-0423
(10 rows)
--
Regards,
Richard Broersma Jr.
/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-general@postgresql.org
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
guilla...@lelarge.info wrote:
On Wed, 2012-05-16 at 10:28 -0700, Richard Broersma wrote:
I've seen the following statement made
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
public.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
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 pie...@hogranch.com 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.org)
To make
tables 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
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
. 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-general@postgresql.org
of Isolation 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
,
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
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 (pgsql-general
...@appl-ecosys.com 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 hangup is identifying
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 mailing list
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.html
--
Regards,
Richard
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)
To make changes to your subscription
. 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@postgresql.org)
To make changes to your
:
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.
--
Sent via pgsql-general mailing list (pgsql-general
@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
On Wed, Aug 24, 2011 at 10:14 AM, Merlin Moncure mmonc...@gmail.com 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
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.
as 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
://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
://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
the definition 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
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
--
Regards,
Richard Broersma Jr.
--
Sent via pgsql
, 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
. 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 make changes
want
since 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
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
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 j...@commandprompt.com 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
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-general mailing
, 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://pugs.postgresql.org/lapug
--
Sent via pgsql-general mailing list (pgsql-general
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 your
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
/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 changes to your subscription:
http
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 (pgsql
installers!
--
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
losing interest.
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+performancem=1l=NULLd=365s=rp=1
--
Regards,
Richard Broersma Jr.
Visit
:
http://sites.google.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
--
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
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
On Mon, Nov 1, 2010 at 9:52 AM, Richard Broersma
richard.broer...@gmail.com wrote:
On Mon, Nov 1, 2010 at 9:47 AM, Carlos Mennens carlos.menn...@gmail.com
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
-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
--
Sent via pgsql
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 changes to your subscription:
http://www.postgresql.org
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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
know if 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
:
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
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)
http://pugs.postgresql.org/lapug
--
Sent via pgsql-general
)
--
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
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 subscription:
http
of the box, PostgreSQL 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
' ) 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
to a null.
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
/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
--
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'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 Broersma
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 the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug
--
Sent via pgsql-general mailing list (pgsql
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 changes to your subscription:
http://www.postgresql.org/mailpref
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-general mailing list (pgsql-general@postgresql.org
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.postgresql.org
?
Not 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
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 (pgsql
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://archives.postgresql.org/pgsql-odbc/2006-12/msg00029.php
--
Regards,
Richard Broersma Jr.
Visit
On Sat, May 29, 2010 at 8:21 PM, Richard Broersma
richard.broer...@gmail.com 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
be made 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
alerts.
--
Regards,
Richard Broersma Jr.
Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug
)
valid_loop_nbrs CHECK (loop_nbr = 0 AND loop_nbr = )
valid_process_codes CHECK (process_code::text ~ '^[A-Z]{2,4}$'::text)
valid_tag_seqs CHECK (tag_seq::text ~ '^(?:[A-Z])?$'::text)
Has OIDs: no
--
Regards,
Richard Broersma Jr.
Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http
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@postgresql.org)
To make changes
where i could
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
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)
To make changes to your
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 the Los Angeles
On Wed, May 12, 2010 at 10:55 AM, Thomas Kellerer spam_ea...@gmx.net 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 year)
I don't think you
and if it’s
granted 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 Users Group
/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 Jr.
Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http
://www.postgresql.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
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
-appendix.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 (pgsql
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-types.
--
Regards,
Richard
);
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
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.org/lapug
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
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 mailing list (pgsql-general
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 Los Angeles PostgreSQL Users
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 make
);
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 (pgsql-general
/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
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 Broersma Jr
to
preform an in-place upgrade 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
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
--
Sent via pgsql-general mailing list (pgsql-general
I might be bringing this up too soon, however the link to the 8.4.2
windows binaries needs to be updated:
http://www.enterprisedb.com/products/pgdownload.do#windows
It currently shows the binaries for 8.4.1.
--
Regards,
Richard Broersma Jr.
Visit the Los Angeles PostgreSQL Users Group (LAPUG
1 - 100 of 537 matches
Mail list logo