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 checkpoint
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 wa
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 c
Bill Moran 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-enough.html
Tony.
--
f.a
ce check constraints 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-
vior so that
materialized views are more useful when the amount of data increases and
it's 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
r could know about the underlying query that created the
materialized view to infer that certain 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,
g 9.1? 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
stion.
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’s output.
Regards,
To
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 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 archive directory back to the WA
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 21:27, Boszormenyi Zoltan 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
On 16 April 2014 18:48, Dev Kumkar 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)
To make chan
'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 c
ly reflects the foreign key definition, 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
an add
> attributes on the fly without rebuilding the index. 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,
be things like brand/category/sku) 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
oduct) 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
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 pg
On 09/10/2013, at 11:03 PM, Tony Theodore wrote:
> On 09/10/2013, at 8:39 PM, raghu ram wrote:
>>
>> ETL Tools for PostgreSQL::
>>
>> Definition: An ETL process data to load into the database from a flat file
>>
>> A. Extract
>> B. Transform
>
s it handles dependencies (think foreign key ordering with schema
introspection) and parallel loading in a very intuitive way.
Cheers,
Tony
e's a handy blog post from Josh Berkus about timestamps:
http://it.toolbox.com/blogs/database-soup/zone-of-misunderstanding-48608
Cheers,
Tony
; Is the FAQ out of date or was this feature removed? I'm using 9.2.1. 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 n
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 return
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),
std
- the join condition is
the same.
You're not actually getting a cross join, that would be many more records than
9million - 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
onditions. In this case:
inner join 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 res
all) result?
Have you looked at the WITH clause [1,2]:
WITH filtered as (SELECT table_a.id, b.value 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 lea
deployment.
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 minut
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
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 | tab
ong the dump 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
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 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 Cap
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 l
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 writes:
> > Has anyone experienced the behavior of pgloader hanging when the .conf
> > f
On Fri, Jul 15, 2011 at 18:44, Scott Marlowe wrote:
> On Fri, Jul 15, 2011 at 4:36 AM, Tony Wang wrote:
> > Weird that I receive your each message twice.
> > On Fri, Jul 15, 2011 at 15:33, Radoslaw Smogura <
> rsmog...@softperience.eu>
> > wrote:
> >>
>
On Fri, Jul 15, 2011 at 19:47, Radosław Smogura wrote:
> 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:
>>>
>>> We
On Fri, Jul 15, 2011 at 18:52, Radosław Smogura wrote:
> 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 h
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 15:33, Radoslaw Smogura wrote:
>>
>>
>> Simple and obvious q
d 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 pro
On Fri, Jul 15, 2011 at 12:38, John R Pierce 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 sa
On Fri, Jul 15, 2011 at 10:42, Scott Marlowe wrote:
> On Thu, Jul 14, 2011 at 8:28 PM, Tony Wang wrote:
> > On Fri, Jul 15, 2011 at 10:05, Scott Marlowe
> > wrote:
> >>
> >> On Thu, Jul 14, 2011 at 7:51 PM, Tony Wang wrote:
> >> > On Fri, Jul 15,
On Fri, Jul 15, 2011 at 10:05, Scott Marlowe wrote:
> On Thu, Jul 14, 2011 at 7:51 PM, Tony Wang wrote:
> > On Fri, Jul 15, 2011 at 08:22, Scott Marlowe
> > wrote:
> >>
> >> On Thu, Jul 14, 2011 at 6:01 PM, Tony Wang wrote:
> >> > On Fri, Jul 15,
On Fri, Jul 15, 2011 at 08:22, Scott Marlowe wrote:
> On Thu, Jul 14, 2011 at 6:01 PM, Tony Wang wrote:
> > On Fri, Jul 15, 2011 at 01:13, Scott Marlowe
> > wrote:
> >>
> >> On Wed, Jul 13, 2011 at 9:47 PM, Tony Wang wrote:
> >> > On Thu, Jul 1
On Fri, Jul 15, 2011 at 01:13, Scott Marlowe wrote:
> On Wed, Jul 13, 2011 at 9:47 PM, Tony Wang wrote:
> > On Thu, Jul 14, 2011 at 10:35, John R Pierce
> wrote:
> > It's a game server, and the queries are updating users' money, as normal.
> > The sql is lik
t's
> 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
> Su
On Thu, Jul 14, 2011 at 12:35, John R Pierce 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".
>> T
On Thu, Jul 14, 2011 at 10:35, John R Pierce wrote:
> On 07/13/11 7:16 PM, Tony Wang wrote:
>
> 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
On Thu, Jul 14, 2011 at 10:01, John R Pierce 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
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 wrote:
> Hi,
>
> The configuration information is listed at the end
I think logs may help. Have you checked that?
2011/7/13 Andrus
> 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 havent noticed
On Wed, Jul 13, 2011 at 08:40, Craig Ringer wrote:
> 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 hig
IO drive
Memory: 32G
Postgresql configuration:
max_connection = 800
shared_buffers = 2000MB
effective_cache_size = 14000MB
autovacuum = off
--
BR,
Tony Wang
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 Log
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 rol
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.
ny suggestions here? I feel like there's got to
be a way to do this, but I can't find anything relevant in the list
archives.
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 syste
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 returns
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'\\'.
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 | Modif
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 called
t will put them
in public/foo.sql with CREATE OR REPLACE 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
talled,
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
talled,
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 sess
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
/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
appens fairly often and it's part 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@postgre
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
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
ainst 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
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 @C:\DOCUME~1\20659\L
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 to
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\libpq>nmake /f win32.mak
Microsoft (R) Program Maintenance Utility Version 9
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\libpq>make -N -DCFG=Release /f bcc32.mak
MAKE Version 5.3 Copyright (c) 19
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 Kernel32.DLL,
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
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
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
o you 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
roduct')
LEFT OUTER JOIN orders ON (items.order_id = orders.id AND paid = 1)
LEFT OUTER JOIN users ON (orders.user_id = users.id AND name = 'thomas')
> Moreover, the "name" argument in the WHERE comes from the user logged
> in data. So if the user is not logg
Postgresql 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
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
shoulde
wercase everything you send 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@post
t_announce (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 Softw
E FUNCTION 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
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-ge
ssue and if it
does crash or hang (not likely) 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 performanc
twaredesign.com/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
a mystery :-)
I did report the issue on the PostBooks sourceforge project forum.
Later,
Tony Caduto
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
1 - 100 of 624 matches
Mail list logo
