ibe for me.
My copy is in the mail.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
hose names everywhere you care about them.
I imagine you'd have to use a psql client compiled from the same altered
codebase to have anything work.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ght mask a problem and prevent you from finding out
about it until it is much worse.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
://www.microsoft.com/download/en/details.aspx?id=11310
--
Craig Ringer
POST Newspapers
276 Onslow Rd, Shenton Park
Ph: 08 9381 3088 Fax: 08 9388 2258
ABN: 50 008 917 717
http://www.postnewspapers.com.au/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes
HEN what kind of computer should I get?"
Great hardware for one workload can be crappy hardware for another workload.
Greg knows about Poker Tracker, so he's probably going to be much more
able to guestimate what you need without sufficient information. Follow
his advice when in doubt.
&
anges, which Pg never
writes through elog, you won't be able to get them via that mechanism.
--
Craig Ringer
POST Newspapers
276 Onslow Rd, Shenton Park
Ph: 08 9381 3088 Fax: 08 9388 2258
ABN: 50 008 917 717
http://www.postnewspapers.com.au/
--
Sent via pgsql-general mailing list (pgs
pp's memory, and again
that's beyond the vast majority of users.
Personally, I'd probably use both of the above approaches, but I'm kind
of paranoid.
--
Craig Ringer
POST Newspapers
276 Onslow Rd, Shenton Park
Ph: 08 9381 3088 Fax: 08 9388 2258
ABN: 50 008 917 717
http:
on-standard log system getting
accepted, which is why you should implement the syslog udp and/or tcp
protocols if you're going to roll your own.
For a specification of the syslog network protocols, see these RFCs:
Syslog over UDP
http://tools.ietf.org/html/rfc5426
Syslog over TCP
http://www.ietf.org/rfc/rfc3195.txt
--
Craig Ringer
On 25/07/11 13:11, Adarsh Sharma wrote:
> I restore globedatabase from a .sql file on yesterday morning.I insert
> some new data in that database.
> In the evening, by mistake I issued a *drop database globedatabase* command.
Did you make a copy of the database files as soon as you realized what
estored into it - probably immediately
destroying your deleted data - then kept on using the database for
another month.
If you're willing to spend a lot of money you might be able to recover
some of it using hard-drive level overwritten data forensics, but I
rather doubt it.
--
Craig Ri
irect is a no-brainer.
--
Craig Ringer
POST Newspapers
276 Onslow Rd, Shenton Park
Ph: 08 9381 3088 Fax: 08 9388 2258
ABN: 50 008 917 717
http://www.postnewspapers.com.au/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscrip
t;dmesg" or in the kernel log files? Perhaps
related to I/O errors or file system errors? Was there a recent fsck on
the file system, a recent reboot of the server, or recent power
loss/interruption?
--
Craig Ringer
POST Newspapers
276 Onslow Rd, Shenton Park
Ph: 08 9381 3088 Fa
capture_cash_info
# relaunch pg using your distro's init script or using pg_ctl,
# depending on how you usually do it
false || scream_for_help
fi
}
DATADIR=/var/lib/postgresql/8.4/main/
PID=$DATADIR/postmaster.pid
if ! test -e "$PID"
then
try_to_recover stopped
elif ! kill -0
es freed too
many pages?
Personally, I'd recommend moving to 8.4 or above, where you no longer
need worry about the free space map at all.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
a version
that will've been tested against current Pg versions.
--
Craig Ringer
POST Newspapers
276 Onslow Rd, Shenton Park
Ph: 08 9381 3088 Fax: 08 9388 2258
ABN: 50 008 917 717
http://www.postnewspapers.com.au/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To
haven't tested this, but there's no reason it shouldn't work, as UNC
paths are resolved at the file system level and apps shouldn't notice them.
--
Craig Ringer
POST Newspapers
276 Onslow Rd, Shenton Park
Ph: 08 9381 3088 Fax: 08 9388 2258
ABN: 50 008 917 717
http://www.
blic you could possibly ask
anyone interested in the bug to contact you off-list instead of
attaching/linking to the test case.
--
Craig Ringer
POST Newspapers
276 Onslow Rd, Shenton Park
Ph: 08 9381 3088 Fax: 08 9388 2258
ABN: 50 008 917 717
http://www.postnewspapers.com.au/
--
Sent vi
he standard Windows admin
commands (sc.exe etc) or GUI tools.
It'd be nice if the Pg installer prompted for an account domain or at
least took an optional cmdline param for it.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make chan
tgresql.conf, re-run your test, and see what the server receives.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
dk.html
I struggle to see any connection between Arduino and PostgreSQL, though.
They're very different kinds of free/open source, as software "is" its
specification and can be distributed at no cost, but you can't just
download a hardware device and use it.
--
Craig Ringer
--
*might* be able to do is find sponsorship for hosting or find
someone who'll grant you free hosting for your project because they
think that particular project is worthwhile and important. That'll
depend a great deal on what you're trying to host and what the likely
load will be.
On 7/08/2011 11:43 PM, Ivan Sergio Borgonovo wrote:
On Sun, 07 Aug 2011 20:41:27 +0800
Craig Ringer wrote:
By the way, one of the reasons you're not finding much free
hosting for PostgreSQL is that it takes a fair bit of work to run
Pg multi-tenanted. Your additional requirement for Jav
The only time "kill -9" should be a data corruption issue is if you kill the
postMASTER (not just a backend) then remove the postmaster.pid file from the
datadir and relaunch the postmaster without first making sure the worker
backends are all shut down.
You need to load the shotgun, aim it carefu
esses like this where two DLLs with the
same name aren't quite compatible. Yay!
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
he function you posted and see
if I can reproduce the crash on my Win7 box.
In the mean time, if you want you can try to collect some more
information about the crash according to these instructions:
http://wiki.postgresql.org/wiki/Getting_a_stack_trace_of_a_running_PostgreSQL_backend_on_W
.csv'
You are not using psql. "\copy" is a psql command. I don't think it's
supported by PgAdmin III, though I could be wrong.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
t
does not already exist in the final destination table.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
.
Yeah... I'd favour an EXISTS test or a join.
INSERT INTO maintable (cols)
SELECT cols FROM staging WHERE NOT EXISTS (SELECT
1 FROM maintable WHERE maintable.idcol = staging.idcol);
... as the NOT IN(...) test can have less than lovely behavior for large
key sets.
--
Craig Ringer
--
een any recent movement
on stored procedure support. Most people use functions where practical,
and where that's not enough they use dblink or use clients outside the
database.
--
Craig Ringe
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
SQL 8.3.15 .
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
suited among its
peers to act as a application server platform.
Actually, I'd say Oracle's really solid Java support, in-db timers, and
autonomous transactions makes it rather better suited.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to
compiler isn't looking in the proper directory.
Use --without-readline to disable readline support.
if --without-readline,configure runs OK
how can i configure pg with readline?
You'll find that there's a -dev or -devel package for readline that you
need to install.
--
Craig
o_reporting_problems#Things_you_need_to_mention_in_problem_reports
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
single
timeline where every event happens (or doesn't happen) in the same order
as it would've without the fork.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
:-) and they can control read access as well as
write access.
Further control for writes can be applied using triggers that RAISE
EXCEPTION when they don't like something.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to
what you want to do so we can
help you in more detail?
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
attempt, then send
you the pcap log. That should give you more information about what's
actually happening.
Check for possible SELinux involvement if the Java client is on Linux.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to
your backups - you
actually did, and found a problem that would've been a critical issue if
the backup were actually needed.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
s you can use
to tweak that permissible sync delay.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ortant usernames/passwords etc. Search the logs for any
queries that mention the RadAcctId column (use "grep -i" or some other
case-insensitive search) and see if any other queries might be modifying it.
Also, you mentioned the use of dblink. Where does it come into play?
--
Crai
nd process).
Scott,
Ah so. User 'postgres' is in the same group ('users') as I am, so I need
to change the perms on the data directory to 775 to give postgres write
access.
Yeah, or use the client/server copy protocol via psql's \copy command.
--
Craig Ringer
--
Sent
a
certain idle time, or you can use a connection pool. Connection pools
may be inside the client (for example, in Java EE application servers)
or between the client and the server using tools like pgbouncer and
PgPool-II.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general
lists, or just a linear scan? Would it be worth sorting longer IN list
results so each iteration could do a binary search of the list?
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
nore them. They are "leaks" only in the sense that a static variable
is a leak, ie not at all.
If you see that the program grows if you run it many times in a loop,
and you get more and more leak records for every loop, *THEN* there
might be a problem.
--
Craig Ringer
--
Sent via pgs
can't immediately find the info.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
to do periodic checks for input,
so it'd suffer from some of the same issues as the current approach.
Any other ideas? There is no PQterminate, unforunately.
statement_timeout is not feasible, as the statement might legitimately
run for a very long time.
A real fix requires backend enhan
table_to_xml functions.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
while the server is stopped.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
#x27;s good to get the
report, but ... what do you do about it? They don't have a faulty file,
a reproducible test case, any or any good prospects for working on
creating a test case.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To
he codebase, nor the enthusiasm
for it. I don't need the feature and don't even use SR, I just know some
others would benefit from it and have seen requests for selective
replication here before.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.or
ind,
maybe? Anyway, it's *not* recursively changing the permissions on your HDD.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
to test, anyway?
--
Craig Ringer
On 15/09/2011 6:13 PM, salah jubeh wrote:
Hello Craig,
I would like to test the software requirement specification . There
are some tools such as pgTAP but I am not sure about it..
Please reply to the mailing list, not just to me directly.
If you're testing against a spec, you pro
it's messing with
permissions too.
I wonder if it's to do with ACL inheritance? Maybe one of the
inheritance control flags like "NP" is needed. I don't know enough about
NT permissions to say, but inheritance would be my suspect.
--
Craig Ringer
--
Sent via pgsql-gene
ql.80%29.aspx
It sounds like they probably use a materialized view, possibly stored as
an index-oriented table. That'd be a cool thing to support, but if done
that way would require TWO new major features PostgreSQL doesn't have.
--
Craig Ringer
--
Sent via pgsql-genera
DBC
driver and/or enable query logging on the server).
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
mplify this.
I haven't looked into them. Personally for simpler databases I'd
probably just hack something together using an appropriate scripting
language and COPY (SELECT...).
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes t
terns in, or do you only have a
few important columns you need to retrieve most of the time, plus a lot
of less-used data?
--
Craig Ringer
r from starving your Pg instance of read bandwidth?
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
es from older versions of the contrib modules. It can do that, but
only if appropriate upgrade scripts are written for the older versions
of the modules.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.post
used to learn from the
experience of those who went before.
Exactly what do you find frustrating with the mat views you're using?
What's wrong with them? What's right with them? How are you trying to
use them? What problem are you attempting to solve with them? How do you
*wan
;t
know if Postgres has this problem, but it seems to me the engine
should be able to tell me what the minimum date will be since the
trigger is running AFTER the rows are updated, and then commit
everything at once.
Correct. An AFTER trigger in PostgreSQL will see the transaction's local
view of th
to make a "portable format
database" an option that could be chosen at initdb time. Again, though,
I doubt anyone's particularly interested in doing the required work, and
it's not clear a patch would be accepted because of the increased
maintenance and testing bur
On 22/09/2011 5:47 PM, Rajesh Kumar Mallah wrote:
Dear Craig ,
The other end of the iSCSI shall have all the goodies like the raid controller
with a WBC with BBU. There can even be multiple raid cards for multiple
servers and disksets. I am even planning for NICs having TOE features .
The
On 09/28/2011 01:01 AM, David North wrote:
testdb=# select * from problem_table;
ERROR: invalid memory alloc request size 2003676411
What Pg version are you using?
On which platform?
32-bit or 64-bit OS? If 64-bit, with a 32-bit or 64-bit build of PostgreSQL?
--
Craig Ringer
--
Sent via
used by my
application and I am looking for a way to identify them.
Look at the pg_catalog.pg_stat* tables
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ing to several Pg
lists, but intermingling mysql and Pg mailing list replies is just going
to get messy. PLEASE DO NOT POST MESSAGES TO MORE THAN ONE MAILING LIST
IN THE SAME MESSAGE.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 29/09/2011 9:13 PM, Marti Raudsepp wrote:
How does decimal store the number internally,
Numeric is stored as binary-coded decimal. This isn't fast.
I'd say using a bigint is a no-brainer unless you think there's a chance
you might exceed the maximum size for a 64-bit inte
onnection or if something
else happens.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
rly,
amazingly, stunningly slow.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ge your data. These functions would have to use their own
separate data; they could **NOT** safely use existing postgresql data
files in any way.
--
Craig Ringer
obably be to get the source code of
the sample implementation made by one of the authors of the papers
you're interested in. I don't know if that'll be possible, but I'm sure
it'd help a lot if you could do it.
Thank you very very much.
Best wishes.
--
for some historical but possibly still useful information.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Service packs
*endless* possible group policy configurations
... so it's not too surprising to see hard-to-reproduce weirdness
popping up.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.post
m
your program.
I'm not aware of a LINQ backend for PostgreSQL, alas.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
g_dump backup on a separate Pg instance and if it looked
OK I'd re-initdb then reload from the dump.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
n ETL tool like Talend, look into
pg_bulkload, or write some perl/python script to do it.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
; the more people know about it and how
awesome it is, the better.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
,
providing as much detail as you can to assist in identifying why the
issue arose.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
lled and configured. It's just like template1, but
has the PostGIS support functions and schema already installed. It
should be created as part of the regular install and configuration
process for PostGIS, AFAIK.
I don't use PostGIS or MacOS, so I can't help much with that side...
--
Craig Ringer
Can you reproduce this on a non-EC2 system?
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ns-window.html
Using the first_value or last_value window functions with an ordering
clause to select the greatest timestamp within each window frame.
http://www.postgresql.org/docs/9.0/static/functions-window.html#FUNCTIONS-WINDOW-TABLE
--
Craig Ringer
--
Sent via pgsql-general mailing lis
lled the pgcrypto contrib module in your 9.0 database(s)?
--
Craig Ringer
PostgreSQL. Have a look at the list here:
http://www.postgresql.org/support/professional_support
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
They shouldn't!
If blocking writes causes a server failure that persists once writes
have been unblocked, that's a bug IMO. You might have a bit of a backlog
of writes to clear, but after that all should be well, and if it isn't
then something needs fixing.
--
Craig Ringer
--
Sent v
On 11/10/11 12:48, John R Pierce wrote:
> On 10/10/11 7:44 PM, Craig Ringer wrote:
>> If blocking writes causes a server failure that persists once writes
>> have been unblocked, that's a bug IMO. You might have a bit of a backlog
>> of writes to clear, but after that all
On 11/10/11 12:55, Adarsh Sharma wrote:
> Thanks Craig, but I solved the issue by the below query :-
>
> Here is the query for that :-
>
> select bb_id,lat,lon,speed,dt_stamp from demo_table
> inner join
> (select bb_id as did, max(dt_stamp) as ts
> from demo_table grou
x27;t dump as
much MySQL-specific stuff, and use "--no-create-db --no-create-info" to
suppress the schema definitions. Then edit out any remaining
MySQL-specific stuff and feed it into psql.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
ll add covering indexes
- yay!), column-oriented storage, or other features that're pretty basic
to OLAP workloads.
Have you looked at Greenplum?
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresq
ries of WAL segments, rather than all the
churn in-between. This would be great for storing longer PITR histories
(but more coarsely) and being able to do faster restores. Unfortunately
given how scattered writes are I doubt it'd actually be possible or any
faster if it was.
SQL-level dif
s, then do
all its work in one go at the end.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
you're running as doesn't have permission to disable those.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Have I missed something blindingly obvious in the docs and never noticed
it in a couple of years of using Pg, or is there no way to get Pg to log
and report this data at the moment?
--
Craig Ringer
POST Newspapers
276 Onslow Rd, Shenton Park
Ph: 08 9381 3088 Fax: 08 9388 2258
ABN: 50 008 917 7
On 05/14/2012 12:12 PM, Pham Ngoc Hai wrote:
I'm running PostgreSQL 9.1.3 on x86_64-unknown-linux-gnu, compiled by
gcc (GCC) 4.4.6 20110731 (Red Hat 4.4.6-3), 64-bit
on CentOS release 6.2 (Final)
Recently we encountered postmaster segfault, what the core dump gives
me is:
Did you ever see any
made a lot of things way
simpler than they are in UTF-8 and was well and truly worth the storage
bloat IMO. Pity Unicode had to grow again and break the assumption.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
uot;
entries for non-PostgreSQL parts of the call path. The stack trace might
be useless, but might not be too.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
7;d propose having psql cache the first error (ie:non-zero SQLSTATE
response) it gets in memory, and emit that when it exists, eg:
The first error was: ERROR: role "postgres" already exists
... in response to the command: CREATE ROLE postgres;"
Anway, I hope my rant/critique/whine is helpful.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
d
more issues.
It's my intention to break that down into specific problem areas and
points, I just thought it was worth getting a few initial impressions too.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www
no agreement has been reached on the
correct approach and nobody has stepped up to implement it.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
d Windows recently:
http://blog.ringerc.id.au/2012/05/postgresql-usability-pgadmin-iii-and-pg.html
and would be interested in your comments/experiences because more
knowledge will help produce a better UI if I ever get the time to have a
go at addressing some of this, or if someone else does.
--
Craig Ringer
801 - 900 of 1923 matches
Mail list logo
