Pryzby wrote:
> On Fri, Nov 03, 2017 at 01:43:32AM +, tao tony wrote:
>> I had an asynchronous steaming replication HA cluster.Each node had 64G
>> memory.pg is 9.6.2 and deployed on centos 6.
>>
>> Last month the database was killed by OS kernel for OOM,the checkp
hi dears,
I had an asynchronous steaming replication HA cluster.Each node had 64G
memory.pg is 9.6.2 and deployed on centos 6.
Last month the database was killed by OS kernel for OOM,the checkpoint process
was killed.
I noticed checkpoint process occupied memory for more than 20GB,and it
hi guys,
I met a query performance issue in postgresql 9.6.2 with multiple tables
joined.
there were 2 slow queries,and the reasons were the same:the optimizer
generate a bad explain which using nest loop.
attached is the query and its explain.all tables are small and the
indexes were only
Bill Moran <wmo...@potentialtech.com> wrote:
>
> There's a well-written article I saw recently that directly addresses
> your question ... I'm too lazy to find it, but google will probably
> turn it up for you.
This? http://renesd.blogspot.co.uk/2017/02/is-postgresql-good
already exist for regular
tables, and since materialized views are implemented as tables (or
table-like substances) it seems reasonable that materialized views
should support check constraints and the query optimization that comes
with them.
-Tony
--
Sent via pgsql-general mailing list
not feasible to update them in their entirety?
Thanks.
-Tony
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
rows will never match based on
the conditions that created the view.
Are either of these things that could be supported in the future? If
not, is there a better way to get the behavior I want, where I can
partition materialized views based on a date range?
Thanks.
-Tony
--
Sent via pgsql
? Or can use the latest, which
appears to be 9.5 on 16.04?
Thanks in advance,
Tony
Since 1982, Starpoint Solutions has been a trusted source of human capital and
solutions. We are committed to our clients, employees, environment, community
and social concerns. We foster an inclusive culture based
ou’re still asking me that question.
The Postgres community is also a great "feature", maybe the question we should
be asking is - "why isn't it documented yet?”? I don’t see a CoC as an end in
itself, it’s merely an artefact of a community that is as proud of it’s
workings as it’
Thank you very much, this is working perfectly. I copied a couple over and the
server applied them, and is waiting for the next set.
Tony
From: Melvin Davidson [mailto:melvin6...@gmail.com]
Sent: Monday, December 07, 2015 8:59 AM
To: Tony Nelson
Cc: Andreas Kretschmer; pgsql-general
> -Original Message-
> Tony Nelson <tnel...@starpoint.com> wrote:
>
> > 2015-12-07 08:24:50 EST FATAL: requested WAL segment
> > 00010089002C has already been removed
> >
> >
> >
> > Can I simply copy the file from my arc
en removed
Can I simply copy the file from my archive directory back to the WAL directory?
Thanks in advance
Tony Nelson
Since 1982, Starpoint Solutions has been a trusted source of human capital and
solutions. We are committed to our clients, employees, e
On 16 April 2014 18:48, Dev Kumkar devdas.kum...@gmail.com wrote:
We embed certain binaries and libssl.so.1.0.0 gets shipped along with
pre-build in-house database with product.
1.0.0 isn't affected.
Cheers,
Tony
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org
On 16 April 2014 21:27, Boszormenyi Zoltan zbos...@pr.hu wrote:
2014-04-16 12:40 keltezéssel, Tony Theodore írta:
1.0.0 isn't affected.
The package version and the soversion are only loosely related.
E.g .the upstream OpenSSL 1.0.0 and 1.0.1 series both ship soversion 1.0.0.
Good point
you're looking for.
(Full disclosure: I am the author of this software)
Nice! I really like the idea of undo.
Do you plan to support primary keys other than single column integers?
Cheers,
Tony
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
) and
I’d like to use the same calculations regardless of where it sits in the
hierarchy.
Cheers,
Tony
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
. Test carefully.
I’ll give it a try - I might stick to using plain or inherited tables for the
main storage and then experiment with composite types for functions and other
aggregate tables that are used internally.
Cheers,
Tony
--
Sent via pgsql-general mailing list (pgsql-general
, so I’ll stick
with explicit joins.
Thanks,
Tony
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
) references products
);
be a correct use of composite types? I rarely need to see the columns
separately, so having to write “(product).product_id” won’t happen much in
practice.
Thanks,
Tony
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription
standardised on 4-6 digit
numeric identifiers. I do feel sorry for people who have to do data entry in
poorly designed apps, but it's also easier these days to pre-populate data and
use an ajax hybrid search/select box to seriously minimise the number of
keystrokes.
Cheers,
Tony
--
Sent via
,
Tony
On 09/10/2013, at 11:03 PM, Tony Theodore tony.theod...@gmail.com wrote:
On 09/10/2013, at 8:39 PM, raghu ram raghuchenn...@gmail.com wrote:
ETL Tools for PostgreSQL::
Definition: An ETL process data to load into the database from a flat file
A. Extract
B. Transform
C. Load
/zone-of-misunderstanding-48608
Cheers,
Tony
. Thanks!
I believe PERFORM is a PL/pgSQL construct, not an SQL one. You'd need to
execute it inside a function.
Cheers,
Tony
On 05/16/2013 07:13 AM, Ioana Danes wrote:
Hi Jeff,
Yes stop/start of the application server does close all the
connections to the database.
Lately I did restart postgres too everytime that happened. It did
happen in the past, last year sometime when I tried just to close the
app and it was
On 03/06/2013 07:16 PM, François Beausoleil wrote:
Le 2013-03-06 à 21:42, Tony Dare a écrit :
I'm taking an standard deviation of a population and subtracting it from the
average of the same population and rounding the result. Sometimes that result
is negative and rounding it returns
I'm taking an standard deviation of a population and subtracting it from
the average of the same population and rounding the result. Sometimes
that result is negative and rounding it returns (or shows up as) a
negative zero (-0) in a SELECT.
basically:
SELECT
client_name, avg(rpt_cnt),
model_configurations mc on left(crm.customer_class, 6) =
left(mc.sap_code,6)
customer_class sounds like a fairly generic sort of field, so you'd expect
many matches. Truncating the fields is likely to make this even less specific,
returning more results.
Cheers,
Tony
--
Sent via pgsql-general
- you're just not setting a specific enough filter.
Cheers,
Tony
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
as val FROM table_a a, table_b b
WHERE … AND …)
SELECT * FROM filtered WHERE filtered.val=…
It evaluates the the first SELECT once, then applies the second SELECT to the
first in memory (at least that's the way I think about them).
Cheers,
Tony
[1] http://www.postgresql.org/docs/9.2/static/queries
.
Thanks
Tony
P.S. Today I did some stress tests on my PostgreSQL staging server: a) insert
2 billions records into the test table, b) full scan the table. here are some
test results:
Facts:
Number of records: 2 billions records inserted today
Full table scan: about 16.76 minutes to scan 2
I have not defined my default tablespace:
show default_tablespace ;
default_tablespace
However, I have tables with null tablespaces values in pg_tables:
pg_dw=# select * from pg_tables where tablename = 'source_prev';
schemaname | tablename | tableowner |
Awesome! We had about 200G worth of tables on our mount point that held
all our WAL datawhoops! Thanks for the below query.
One last question, can I define a default tablespace per schema? I
haven't found anything by searching around.
Thanks.
Tony
On Fri, 2011-12-16 at 00:23 +0530
of each object takes, is there an option that exists
where I can collect this information in the log file?
Thanks.
Tony
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
When I issue:
pg_dump newdb /DUMPDIR/newdb.dmp -n dev -T corgi -w -v -F c 2
/DUMPDIR/newdb.log
I get a dump of the entire dev schema. My goal is to dump the dev
schema minus the corgi table. How can I adjust my script to perform
this function?
Thanks.
--
Sent via pgsql-general mailing
I'm using 9.0.3. I've tried several permutations of this script and
still I get a dump of the entire schema. The corgi table is still
included when I need it excluded.
On Thu, 2011-11-03 at 12:02 -0700, Adrian Klaver wrote:
On Thursday, November 03, 2011 8:16:42 am Tony Capobianco wrote
BINGO!
Thanks everyone. That did the trick!
On Thu, 2011-11-03 at 12:56 -0700, Ioana Danes wrote:
pg_dump newdb /DUMPDIR/newdb.dmp -n dev -T corgi -w -v -F c 2
/DUMPDIR/newdb.log
Try: -T dev.corgi instead of -T corgi
--
Sent via pgsql-general mailing list
I'm running pgloader 2.3.2 and Postgres 9. Is there an upgraded version
of pgloader on the PgFoundry site?
On Mon, 2011-08-15 at 20:34 +0200, Dimitri Fontaine wrote:
Tony Capobianco tcapobia...@prospectiv.com writes:
Has anyone experienced the behavior of pgloader hanging when the .conf
.
will add that, though no idea why it's null
Regards,
Radoslaw Smogura
(mobile)
--
From: Tony Wang
Sent: 15 lipca 2011 03:51
To: Scott Marlowe
Cc: PostgreSQL
Subject: Re: [GENERAL] Weird problem that enormous locks
On Fri, Jul 15
On Fri, Jul 15, 2011 at 18:50, Radosław Smogura rsmog...@softperience.euwrote:
On Fri, 15 Jul 2011 18:36:19 +0800, Tony Wang wrote:
Weird that I receive your each message twice.
On Fri, Jul 15, 2011 at 15:33, Radoslaw Smogura wrote:
Simple and obvious question right now do You call
On Fri, Jul 15, 2011 at 18:52, Radosław Smogura rsmog...@softperience.euwrote:
On Fri, 15 Jul 2011 18:36:19 +0800, Tony Wang wrote:
Weird that I receive your each message twice.
Once message You get from mailing list, one because You are (B)CC.
gmail should be clever enough handling
On Fri, Jul 15, 2011 at 19:47, Radosław Smogura rsmog...@softperience.euwrote:
On Fri, 15 Jul 2011 19:07:45 +0800, Tony Wang wrote:
On Fri, Jul 15, 2011 at 18:50, Radosław Smogura wrote:
On Fri, 15 Jul 2011 18:36:19 +0800, Tony Wang wrote:
Weird that I receive your each message twice
On Fri, Jul 15, 2011 at 18:44, Scott Marlowe scott.marl...@gmail.comwrote:
On Fri, Jul 15, 2011 at 4:36 AM, Tony Wang www...@gmail.com wrote:
Weird that I receive your each message twice.
On Fri, Jul 15, 2011 at 15:33, Radoslaw Smogura
rsmog...@softperience.eu
wrote:
Simple
the way why we think about having 9.x server.
Regards,
Radoslaw Smogura
(mobile)
--
From: Tony Wang
Sent: 14 lipca 2011 07:00
To: John R Pierce
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Weird problem that enormous locks
On Fri, Jul 15, 2011 at 01:13, Scott Marlowe scott.marl...@gmail.comwrote:
On Wed, Jul 13, 2011 at 9:47 PM, Tony Wang www...@gmail.com wrote:
On Thu, Jul 14, 2011 at 10:35, John R Pierce pie...@hogranch.com
wrote:
It's a game server, and the queries are updating users' money, as normal
On Fri, Jul 15, 2011 at 08:22, Scott Marlowe scott.marl...@gmail.comwrote:
On Thu, Jul 14, 2011 at 6:01 PM, Tony Wang www...@gmail.com wrote:
On Fri, Jul 15, 2011 at 01:13, Scott Marlowe scott.marl...@gmail.com
wrote:
On Wed, Jul 13, 2011 at 9:47 PM, Tony Wang www...@gmail.com wrote
On Fri, Jul 15, 2011 at 10:05, Scott Marlowe scott.marl...@gmail.comwrote:
On Thu, Jul 14, 2011 at 7:51 PM, Tony Wang www...@gmail.com wrote:
On Fri, Jul 15, 2011 at 08:22, Scott Marlowe scott.marl...@gmail.com
wrote:
On Thu, Jul 14, 2011 at 6:01 PM, Tony Wang www...@gmail.com wrote
On Fri, Jul 15, 2011 at 10:42, Scott Marlowe scott.marl...@gmail.comwrote:
On Thu, Jul 14, 2011 at 8:28 PM, Tony Wang www...@gmail.com wrote:
On Fri, Jul 15, 2011 at 10:05, Scott Marlowe scott.marl...@gmail.com
wrote:
On Thu, Jul 14, 2011 at 7:51 PM, Tony Wang www...@gmail.com wrote
On Fri, Jul 15, 2011 at 12:38, John R Pierce pie...@hogranch.com wrote:
On 07/14/11 7:58 PM, Tony Wang wrote:
There were 2519 RowExclusiveLock and 85 ExclusiveLock
how could 800 max_connections have 2519 row locks ? do you update multiple
different rows in the same transaction?
the row
I think logs may help. Have you checked that?
2011/7/13 Andrus kobrule...@hot.ee
Sometimes per week server stops randomly responding for approx 5 minutes.
User should wait for 5 minutes before server responds.
Other users can work normally at same time.
Monday this happens at 12:16
I
Could I consider it a hardware problem, or postgresql running too long which
causes problems? (It ran about half a month, however, it ran much longer
than that without problems)
On Wed, Jul 13, 2011 at 00:52, Tony Wang www...@gmail.com wrote:
Hi,
The configuration information is listed
On Thu, Jul 14, 2011 at 10:01, John R Pierce pie...@hogranch.com wrote:
On 07/13/11 6:55 PM, Tony Wang wrote:
Could I consider it a hardware problem, or postgresql running too long
which causes problems? (It ran about half a month, however, it ran much
longer than that without problems)
i
On Thu, Jul 14, 2011 at 10:35, John R Pierce pie...@hogranch.com wrote:
On 07/13/11 7:16 PM, Tony Wang wrote:
On Thu, Jul 14, 2011 at 10:01, John R Pierce pie...@hogranch.commailto:
pie...@hogranch.com wrote:
On 07/13/11 6:55 PM, Tony Wang wrote:
Could I consider it a hardware
On Thu, Jul 14, 2011 at 12:35, John R Pierce pie...@hogranch.com wrote:
On 07/13/11 8:47 PM, Tony Wang wrote:
It's a game server, and the queries are updating users' money, as normal.
The sql is like UPDATE player SET money = money + 100 where id = 12345.
The locks were RowExclusiveLock
Postgresql configuration:
max_connection = 800
shared_buffers = 2000MB
effective_cache_size = 14000MB
autovacuum = off
--
BR,
Tony Wang
On Wed, Jul 13, 2011 at 08:40, Craig Ringer cr...@postnewspapers.com.auwrote:
On 13/07/2011 12:52 AM, Tony Wang wrote:
Have any one experienced that, or any suggestion on researching/debugging?
Capture the contents of pg_catalog.pg_stat_activity whenever your cron
job notices high lock
Has anyone experienced the behavior of pgloader hanging when the .conf
file has an incorrect filename?
When I execute with the correct filename, everything works just fine.
However, when I use an incorrect filename, I get the below:
PG_DB pgloader -c hangs.pgload.conf -v
pgloader INFO
On 11/15/2010 5:53 PM, Lee Hachadoorian wrote:
If anyone's interested, I've started accessing the postgres list through
gmane.org (along with several other mailing lists I subscribe to). It's
gives you the choice of reading the list as a threaded archive, a blog,
or through an NNTP newsreader or
On 10/23/10 11:01 AM, Craig Ringer wrote:
Yep. As for not explicitly mentioning lower roles when granting a
higher role (ie admin isn't also a user) - role inheritance.
I knew about role inheritance, I just didn't know about the
pg_has_role() function for determining if a user has a role.
Hi Dmitriy,
On 10/21/10 4:21 PM, Dmitriy Igrishin wrote:
IMO, you are trying to reinvent the wheel. Although, you may do it just for
fun. :-)
Surely I am, but I think it made sense at the time. It doesn't make as
much sense now that I need to audit every insert/update/delete in the
database.
.
Thanks.
-Tony
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hi,
Just looking around 9.0 and noticed pg_database is missing the
datconfig field which stored default session info for the database.
Where is this stored now? I looked in the release notes, but no mention
of datconfig.
Thanks,
Tony
--
Sent via pgsql-general mailing list (pgsql-general
Coming from 25 years of programming applications based on dBASE and FoxPro
tables, I have a question about how to deal with a programming task.
I have a situation where I receive a file with transactions that have a
unique key from a vendor. These transactions should only be imported into
my
I am in the process of moving a FoxPro based system to PostgreSQL.
We have several tables that have memo fields which contain carriage
returns and line feeds that I need to preserve. I thought if I converted
these into the appropriate \r and \n codes that they would be imported as
carriage
Hi,
I would like a setup with the following:
Three users - one, called OWNER, that owns the tables and can drop,
alter and change data in the tables; another called USER that can edit
data in the tables created by the owner but cannot create new tables or
drop any tables and a third user
Thanks Tom,
I think I'm still doing something wrong.
As a superuser I run:
#revoke create on schema public from public;
REVOKE
As the read only user straight after running the above:
create table barney2(col1 integer);
CREATE TABLE
\d barney2
Table public.barney2
Column | Type |
Hi Tom,
Thanks for your help and the hint (off-line) to use the \dn+ command.
You've hit the nail on the head sir!
\dn+
WARNING: nonstandard use of \\ in a string literal at character 281
HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
FUNCTION formatting around it.
Hope this is useful to others.
Tony Wasson
dump-all-functions.pl
Description: Binary data
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
, these
tools are not too useful.
Lightning Admin has a form view when editing data and shows text fields
as multi line in the form view and in the data grid itself.
Later,
Tony
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
,
but it appears to be there. Does anyone else know what sort of
installation/configuration error could cause a failure like this?
Thanks.
-Tony
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
,
but it appears to be there. Does anyone else know what sort of
installation/configuration error could cause a failure like this?
Thanks.
-Tony
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hi all,
I have a 8.3 cluster running under VM. It seems fine for most activities
(a bit slow but error free) but if the developer issues a delete
statement it consistently kills the database.
If the database is running in archive mode then it kills the archiver,
else it kills the client
as well.
Later,
Tony Caduto
AM Software Design
htpp://www.amsoftwaredesign.com
Home of Lightning Admin for PostgreSQL
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
of the reason why I
eventually dumped it and moved to PostgreSQL.
Hope that helps you out some.
Tony Caduto
AM Software Design
Home of Lightning Admin for PostgreSQL
http://www.amsoftwaredesign.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription
/UsersGuide.html
You can scale PostgreSQL and Python web apps really well with that as
long as you are
not using CGI. I use Pylons combined with mod_wsgi, but you can use it
with mod_python as well.
Tony Caduto
AM Software Design
Home of Lightning Admin for PostgreSQL
http://www.amsoftwaredesign.com
Bill Todd wrote:
Where can I find documentation for the system tables? I have not found
anything in the 8.3.1 documentation. Thanks.
Bill
Hi Bill,
Good to see a Delphi guy here :-)
http://www.postgresql.org/docs/8.3/interactive/catalogs.html
Later,
Tony Caduto
AM Software Design
http
Hi,
does anyone know if you can do multiple
-T or -t (restore named trigger, restore name table) switches?
In the docs for pg_restore it does not specify if it will accept more
than one, but in the pg_dump docs the -n and -t switches allow multiples.
Thanks,
tony
--
Sent via pgsql-general
and when we asked the developer
about this his reply was
There is a known bug in PostGre regarding the number of columns that can
be imported.
Is this a fact and where can I find more information on this?
Please would you comment on this ?
Many thanks
Regards
Tony Linden
Hi,
I am trying to compile my own copy of libpq.dll using bcc32.exe, the
docs say it is possible, but I get a error when it tries to compile dirent.c
Has anyone been able to do this?
C:\postgresql-8.3.5\src\interfaces\libpqmake -N -DCFG=Release /f bcc32.mak
MAKE Version 5.3 Copyright (c)
Hi,
Trying to get a libpq.dll that only has SSL deps using these instructions:
http://www.postgresql.org/docs/8.3/interactive/install-win32-libpq.html
It compiles a bit then dies at:
C:\postgresql-8.3.5\src\interfaces\libpqnmake /f win32.mak
Microsoft (R) Program Maintenance Utility Version
anyone know if this can be done with mingw so I can eliminate the
MSVCR90.DLL dependency?
I have it installed but that is even more foreign to me than VS :-)
(mostly use borland CodeGear tools)
Thanks,
Tony
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes
Dann Corbit wrote:
Change from /MD to /MT and it will not use the runtime DLL.
Look under: Properties - Configuration Properties - C/C++ - Code
Generation - Runtime Library
Hi Dann,
I changed that in the win32.mak file and now it gives this error:
link.exe
the lastest openSSL, though
I did have to comment out one little line.
Thanks,
Tony
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
. The current libpq.dll won't work on wine because of
the VC++ runtime.
I would like to maintain these for future PostgreSQL releases and if
anyone is interested in helping or has a suggestion on where to host
them permanently please let me know.
Later,
Tony Caduto
AM Software Design
http
Glyn Astill wrote:
Pretty sure I've used most 8.3.x versions here on both sp2 and 3.
How have you chacked you have all the dependencies? (I like depends.exe)
http://www.dependencywalker.com/
hmm, the problem seems to be that MSVCR71.DLL has a problem with some
versions of
around this by installing a much older
version of libpq.dll.
And I did have all the dependencies installed along with the DLL, it
just plain refuses to load. I also check that there were no
rouge copies of the files in system32.
Thanks,
Tony
--
Sent via pgsql-general mailing list (pgsql
and I use Slony to replicate my production
DB into two more boxes simultaneously.
Thanks,
Tony Fernandez
and I use Slony to replicate my production
DB into two more boxes simultaneously.
Thanks,
Tony Fernandez
Thanks Joao,
That is what I have done, but wanted to see if there was any other known
potential risks.
The fact about including an extra backup to go back if ever needed was
underestimated, so I will consider it but not in my live servers.
Regards,
Tony Fernandez
-Original Message
making the change.
Later,
Tony Caduto
AM Software Design
http://www.amsoftwaredesign.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
argument in the WHERE comes from the user logged
in data. So if the user is not logged in, no fields are returned.
I suspect your app will need to to run the query and compare that
against the user(s) currently logged in.
Hope this helps!
Tony Wasson
--
Sent via pgsql-general mailing list
is wrong and MySQL is right.
--
Tony Marston
http://www.tonymarston.net
http://www.radicore.org
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
to the server that is not
in quotes. It's a lot easier to read without the uppercase.
Later,
Tony Caduto
AM Software Design
Home of Lightning Admin for PostgreSQL
http://www.amsoftwaredesign.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
David Fetter wrote:
What they want to have is a huge entity they can blame when everything
goes wrong. They're not interested in the actual response times or
even in the much more important time-to-fix because once they've
blamed Oracle, they know the responsibility is no longer on their
(built with
Delphi)
If you are using the win32 version there is a option at the end of the
installer script to install the debugger part. On 8.2 or 8.3 you will
need to install it yourself.
Please see: http://pgfoundry.org/projects/edb-debugger/
Hope that helps.
Tony Caduto
AM Software Design
test_func(varchar)
RETURNS void AS
$BODY$
DECLARE
IN_ARRAY text[] ;
ACCOUNTNUMBER_INvarchar;
BEGIN
IN_ARRAY = string_to_array($1,'~^~'); --use a unique delimiter
ACCOUNTNUMBER_IN = IN_ARRAY[1];
return;
END
$BODY$
LANGUAGE 'plpgsql' VOLATILE;
Later,
Tony Caduto
AM Software Design
Home
/debugger_client_announce
Tony Caduto
AM Software Design
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
) it won't take down whatever admin tool
you are
using. Oh, and it's FREE.
http://www.amsoftwaredesign.com/debugger_client_announce
Check it out works great on win32 and built with a native compiler with
a high performance memory manager.
Tony Caduto
AM Software
http://www.amsoftwaredesign.com
Magnus Hagander wrote:
You know, kinda like PostgreSQL vs Oracle Express ;)
Well, not quite the same since LA Debugger Client is not crippled in
some way Like Oracle or MS SQL Express :-)
It's just plain old freeware.
Later,
Tony
--
Sent via pgsql-general mailing list (pgsql-general
missing some info from the client like what user he is running as and
what his pg_hba.conf looks like.
If anyone has seen this before please let me know.
Thanks,
Tony Caduto
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
1 - 100 of 609 matches
Mail list logo