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
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
Dmitry Koterov wrote:
Hello.
Is there a GUI utility to visually edit Postgres DATA (not a database
schema!), which allows at least:
- insert/update rows using screen windowed forms (possibly ugly
auto-generated forms, but - still forms)
- insert foreign key references by selecting them from a
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
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
Dann Corbit wrote:
How much disk space do you have?
I guess that you are running out of space.
During the link, watch the available disk space.
Hi Dan,
Thanks for the reply :-)
I actually got it working.Now the only problem is it still has a
dependency for
MSVCR90.DLL
Does
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
Hiroshi Saito wrote:
Hi.
It is very strange
I checked that it was ready in VC9 again.
http://winpg.jp/~saito/pg_work/WIN32_BUILD_INF/LOG_LIBPQ_WIN32MAK.txt
Furthermore, even psql was checked.
http://winpg.jp/~saito/pg_work/WIN32_BUILD_INF/psql_win32_pg83.mak
Please move psql_win32_pg83
. 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
Hi,
We have been running into issues where the 8.3.x versions of libpq.dll
will not load in certain
versions of windows and WINE(does not load at all on wine).
It seems to be hit and miss on Windows XP, mostly seems to affect SP3
and some SP2 installs of XP.
I have only been able to get
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
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
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
or messing something up with the
environment vars where it can't find the directory.
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
Magnus Hagander wrote:
Tony Caduto wrote:
I will follow up with the client and have him check if that directory
is missing.
I think he may have used the Postbooks win32 installer to install his
server, so it might be that their installer is messed up and not
creating the directory properly
:-)
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
mean something like this:
CREATE OR REPLACE FUNCTION public.test()
RETURNS timestamp AS
$BODY$
DECLARE
mydate_var timestamp;
BEGIN
--store the current timestamp in a variable
mydate_var = now();
RETURN mydate_var;
END;
$BODY$
LANGUAGE 'plpgsql' VOLATILE;
Later,
Tony Caduto
AM Software
http
Dave Page wrote:
You can avoid this by building your own libpq.dll using mingw/msys if
you like - that will work just fine with a VC++ built server.
Hi Dave,
Just some thoughts on the whole libpq.dll thing.
It would be really nice from a client distribution view of things to
have a
paul rivers wrote:
Going from 8.2.4 and 8.2.6 to 8.3.0 has been painless for me.
However, unlike the blogger you cite, I read the directions before,
not after, attempting it.
The blogger has a point about pg_dump and restore, it could be much
better, for example
the backup process could
Magnus Hagander wrote:
For the case of upgrading, it wouldn't work. But there are certainly
other cases where it would help. Say from your central pgadmin console
administering 10 servers from 3 different major release trees :-(
It can be done with commandline pg_dump, but it means you have
The Corelab product does not support SSL connections. I looked at it,
but I needed SSL, so I am sticking with Npgsql.
Other than the fact it does not have SSL, it looks very nice and
includes a dump component, not sure if that is fully managed or just a
wrapper around pg_dump.exe.
Later,
Tony
This may apply to Unix versions as well but I have not tried.
Anyway, I am using C# to create a GUI front end to pg_dump and I am
using the PGPASSWORD environment variable to set the password like this:
System.Environment.SetEnvironmentVariable(PGPASSWORD, myargs.password);
This works fine
http://digg.com/programming/PostgreSQL_8_3_has_been_released
I dugg it :-)
Later,
Tony
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do
At the bottom of that Register article I saw this article:
http://www.regdeveloper.co.uk/2008/01/24/stonebraker_dewitt_mapreduce/
In which it says:
Ingres inventor and Postgres architect Mike Stonebraker
So this Stonebraker guy is the Postgres Architect?
Interesting stuff on the Register :-)
providers run some form of Unix where M$ cannot play at all.
So in conclusion I would not pay attention to this article, it was
written by someone who really does not know what they are talking about.
Later,
Tony Caduto
AM Software Design
Home of Lightning Admin for PostgreSQL and MySQL
I submitted this to digg.
http://digg.com/software/PostgreSQL_8_2_vs_Firebird_1_5_for_Enterprise_Use
Needless to say PGSQL has a lot more yes entries :-)
Please give it a digg if you want.
Thanks,
Tony
---(end of broadcast)---
TIP 5: don't
out Lightning Admin. We have a version for both that
have the same look and feel and could make the transition easier.
You can also ask questions at our forums:
http://www.amsoftwaredesign.com/smf regarding moving from MySQL to
PostgreSQL.
Tony Caduto
http://www.amsoftwaredesign.com
Home
Hi,
Just running some queries that have worked from 7.4 through 8.2 and they
don't seem to work on 8.3.
select case when a.attnum = any(conkey) then true else false end from
pg_constraint where contype = 'p' and conrelid = c.oid
This one is puking on a.attnum = any(conkey)
returns the
I dont' have a c/c++ compiler on my PCs as I am a Delphi guy.
Anyone have it compiled for win32 and willing to share?
Actually I do have CodeGear C++, but it's unlikely to work with that.
Thanks,
Tony
---(end of broadcast)---
TIP 6: explain
Tom Lane wrote:
That's no doubt got something to do with it, but I think Tony is mighty
confused about exactly what is failing. pg_constraint.conkey is not
text, for instance; it's smallint[] and so the quoted bit should still
work just fine. I'd suggest trying the query in some client that
Hi,
Someone asked me a question about PostgreSQL on the Delphi newsgroups
and I was not sure how to answer them:
Do you know if using PostgreSQL a query or connection can have a
priority set, so it can run quicker than other queries?
For example, in a POS system the reporting queries should
Alvaro Herrera wrote:
Tom Lane wrote:
Tony Caduto [EMAIL PROTECTED] writes:
case when cast(a.attnum as text) IN( select array_to_string(conkey,',')
from pg_constraint where
Surely that's the worst bit of SQL code I've seen in awhile.
Wow, you really are lucky
functions are included by default in
8.3, but how do you install for 8.2?
Thanks,
Tony Caduto
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Tom Lane wrote:
Tony Caduto [EMAIL PROTECTED] writes:
As I understand it the debugger functions are included by default in
8.3,
That's incorrect.
regards, tom lane
Ok, thanks for the info.
Back in Sept the debugger was advertised as a feature of 8.3, so
a feature included in
the system code instead of being an add-on option.
Clustering code from Skype for load balancing and spreading queries to a
large database across several PostgreSQL systems.
Now you know what I am talking about :-)
Later,
Tony Caduto
---(end
Joshua D. Drake wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, 14 Nov 2007 12:49:37 -0600
Tony Caduto [EMAIL PROTECTED] wrote:
Here ya go:
http://www.informationweek.com/news/showArticle.jhtml?articleID=201803375
I see nothing incorrect in that article.
Sincerely
of anything debugger related in the 8.3 beta release
notes either.
Kind of seems like its not really a feature to me, but what do I know :-)
The article is very misleading with regards to the debugger.
Later,
Tony Caduto
---(end of broadcast)---
TIP
Hi,
Is there any documentation for developers on how to use the new debugger
in 8.3?
Specifically on how it works and general guidelines on integration into
3rd party GUI applications.
thanks,
Tony
---(end of broadcast)---
TIP 3: Have you
Stephen Ince wrote:
Postgres can't be embedded or serverless. Firebird has the embedded
feature. Most of the databases have this capability (hsqldb,
derby,oracle,mysql, firebird, and db2). Derby and hsqldb are the only
free embedded databases for commercial use.
A lot of Firebird users
Hi,
I think there might be a bug in the built in function pg_get_viewdef.
Basically if you have a function in your view SQL like this:
replace(address1, '\r', '')
pg_get_viewdef is returning the view definition with the \r replaced by
it's ASCII code which causes this:
replace(address1, '
Hi,
Someone mentioned we should put this in the PostgreSQL wiki.
Do you guys think that would be beneficial? If so, I don't mind the
work on the list I have done so far going on the wiki.
It would make it a lot easier to add other DBs to the mix.
Later,
Tony
---(end
Greg Smith wrote:
This is a really good comparision, focusing on features that I think
people understand rather than so much on technical trivia. Someone
else mentioned moving it onto the Wiki. Questions that pop into my head:
-Tony, would be you be comfortable with your work being
Dave Page wrote:
Couple of corrections Tony:
- You don't necessarily need to stop the postmaster to take a filesystem
backup -
http://www.postgresql.org/docs/8.2/interactive/continuous-archiving.html#BACKUP-BASE-BACKUP.
Obviously that assumes logs will be replayed during recovery.
- The native
Dave Page wrote:
Tony Caduto wrote:
Other than that I would say PG kicks butt.
You're just realising that? :-)
Ah, I new that around 2004 :-) I just have to convince Delphi users of
that :-)
Later,
Tony
---(end of broadcast
Check it out here:
http://www.amsoftwaredesign.com/pg_vs_fb
When comparing in the grid the only major advantage FB has is probably
BLOB support.
PG only suppports 1 gb while FB supports 32gb. Bytea is pretty slow as
well when compared to the FB BLOB support.
The other area is Character
Hi,
I was just wondering if anyone could help me out by taking a look to see
if I missed any important features.
http://www.amsoftwaredesign.com/pg_vs_fb
This comparison is going to be for the benefit of Delphi users. The
Delphi community is heavily biased to Firebird.
Please post any
Dmitry Koterov wrote:
One difference in SQL syntax is that FireBird could join stored
procedures like this:
SELECT b.*
FROM
get_ids() a
LEFT JOIN get_data(a.ID http://a.ID) ON 1=1
(where a.ID http://a.ID parameter is passed from the previous set as
a next procedure parameter), but
support if you are using anything other than InnoDB.
With that said you can increase your insert performance by simply using
a transaction and committing every 1000 rows or so.
If you do this you will see a huge performance increase.
hope that helps.
Tony Caduto
AM Software Design
http
.
Might also help to let us know exactly how you are timing this stuff.
Are you connecting remotely via PSQL or are you connecting via SSH and
running psql or mysql that way?
Later,
Tony Caduto
AM Software Design
http://www.amsoftwaredesign.com
Home of PG Lightning Admin for PostgreSQL
a admin tool developers perspective the ability to reorder columns
without manually copying to a new table and all that is pretty exiting :-)
Tony Caduto
AM Software Design
http://www.amsoftwaredesign.com
---(end of broadcast)---
TIP 5: don't forget
applet.
Later,
Tony Caduto
AM Software Design
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
, but should work just fine with 8.2.
This program is AS IS..with no support from AM Software.
Inno Setup is available from here for free:
http://www.jrsoftware.org/isinfo.php
I can't remember exactly, but I think this one comes in at around 8mb.
--
Tony Caduto
AM Software Design
Home
if the service is running and a red one
if it is not, then have a few right click options
to start/stop/restart the service.
I was thinking the same thing awhile back, but forgot about it.
Later,
--
Tony Caduto
AM Software Design
http://www.amsoftwaredesign.com
Home of PG Lightning Admin
Admin does anyway(work via WINE) and they program their
products with Delphi as well, so I think it would work fine.
Just one word of advice about WINE, make sure you have the core MS true
type fonts installed or the win32 apps will look funny, especially when
using editors.
Later,
--
Tony
) to design the forms.
Netbeans IDE
There are probably many more
--
Tony Caduto
AM Software Design
http://www.amsoftwaredesign.com
Home of PG Lightning Admin for Postgresql
Your best option for Postgresql Administration
---(end of broadcast
admin of any database to come up to
speed in a very short time as long as they were interested in doing so.
--
Tony Caduto
AM Software Design
http://www.amsoftwaredesign.com
Home of PG Lightning Admin for Postgresql
Your best bet for Postgresql Administration
---(end
if you really need
to do that :-) It also has full support for pointers etc so you can
pretty much get the performance of C or C++ all in the same package.
Using Delphi for database applications is like being in Paradise all the
time :-)
Later,
--
Tony Caduto
AM Software Design
http
where bla = bla;');
myquery.open;
While not myquery.eof do
begin
if myquery.fieldbyname('somefield').asstring = 'something' then
//signal your device.
myquery.next;
end;
I guess that is the best I can come up without knowing more.
Later,
--
Tony Caduto
AM
.
Later,
--
Tony Caduto
AM Software Design
http://www.amsoftwaredesign.com
Home of PG Lightning Admin for Postgresql
Your best bet for Postgresql Administration
---(end of broadcast)---
TIP 6: explain analyze is your friend
a oversight? Seems it should be a simple matter to add some
logic that says IF version = 8.2 THEN use grant on seq else don't use it.
Bruce told me just the opposite of what you said in the above message.
Thanks,
--
Tony Caduto
AM Software Design
http://www.amsoftwaredesign.com
Home of PG
I apologize in advance.
Thanks,
--
Tony Caduto
AM Software Design
http://www.amsoftwaredesign.com
Home of PG Lightning Admin for Postgresql
Your best bet for Postgresql Administration
---(end of broadcast)---
TIP 4: Have you searched our list
of code project :-) (make
pg_dump more backwards compatible to at least 8.0)
Later,
--
Tony Caduto
AM Software Design
http://www.amsoftwaredesign.com
Home of PG Lightning Admin for Postgresql
Your best bet for Postgresql Administration
---(end of broadcast
.
--
Tony Caduto
AM Software Design
http://www.amsoftwaredesign.com
Home of PG Lightning Admin for Postgresql
Your best bet for Postgresql Administration
---(end of broadcast)---
TIP 6: explain analyze is your friend
Bruce Momjian wrote:
Tony Caduto wrote:
Hi,
I did a quick search and didn't see anything on this, if I missed it
sorry in advance.
Anyway, I was doing a restore of a 8.1 database(on a 8.1 server) using
the 8.2 pg_restore and it was throwing errors when it was trying to
restore
Hi,
I did a quick search and didn't see anything on this, if I missed it
sorry in advance.
Anyway, I was doing a restore of a 8.1 database(on a 8.1 server) using
the 8.2 pg_restore and it was throwing errors when it was trying to
restore the permissions on the sequences.
basically the
Magnus Hagander wrote:
Are we sure we want to do this? (Sorry, didn't notice this thread last
time)
The default on *all* windows versions since NT 4.0 (which is when the
directory we use was added) will put this file in a protected directory.
Is there truly such a thing on a windows PC? All
http://developersoven.blogspot.com/
--
Tony Caduto
AM Software Design
Home of Lightning Admin for PostgreSQL and MySQL
http://www.amsoftwaredesign.com
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
is.
--
Tony Caduto
AM Software Design
Home of Lightning Admin for PostgreSQL and MySQL
http://www.amsoftwaredesign.com
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
=true
Take a peek and add a comment (if you want to) that nicely suggests
PostgreSQL support.
I know there are not a lot of Delphi developers on this list, but the
more stuff that supports PostgreSQL the better right?
Later
--
Tony Caduto
AM Software Design
Home of Lightning Admin for PostgreSQL
storage
code which is not that difficult to do anyway.
If you guys are at all interested in doing the right thing you will take
this very seriously and find a way to fix it.
I know you think I am being a pain, but I am just sticking to my guns on
what I KNOW is right.
Later,
--
Tony Caduto
AM
temp tables and it is limited to
one stored proc language.
If need a embedded database Firebird is a good choice, however if you
want a serious database that can compete
with Oracle or M$ SQL server then look no further than PostgreSQL :-)
--
Tony Caduto
AM Software Design
http
and reinstalled and the same behavior prevailed.
I know a new connect GRANT was enabled in 8.2, but I though that was in
addition to the first checks done in pg_hba.conf.
Maybe I am doing something wrong, but it sure doesn't seem that way.
Like I said it might be a bug.
--
Tony Caduto
AM
for a password or anything, and the localhost entry in
pg_hba.conf is also set for md5.
--
Tony Caduto
AM Software Design
http://www.amsoftwaredesign.com
Home of PG Lightning Admin for Postgresql
Your best bet for Postgresql Administration
---(end of broadcast
, I will do reboot
and see if that clears it up.
--
Tony Caduto
AM Software Design
http://www.amsoftwaredesign.com
Home of PG Lightning Admin for Postgresql
Your best bet for Postgresql Administration
---(end of broadcast)---
TIP 4: Have you
.
Anyone have any ideas on why this is happening?
--
Tony Caduto
AM Software Design
http://www.amsoftwaredesign.com
Home of PG Lightning Admin for Postgresql
Your best bet for Postgresql Administration
---(end of broadcast)---
TIP 6: explain
some 3rd party application I was testing created the file when
it took my server login information. I would have found out about it
right away if it's use would have been written to the log.
Thanks everyone for you help.
--
Tony Caduto
AM Software Design
http://www.amsoftwaredesign.com
Home of PG
like the way the pgpass file affected all the apps that
used libpq, it could be considered a security risk.
--
Tony Caduto
AM Software Design
http://www.amsoftwaredesign.com
Home of PG Lightning Admin for Postgresql
Your best bet for Postgresql Administration
---(end
that for the pg_restore/pg_dump so you don't have to
pipe the password?
Why don't you just store the password in a file in the same directory as
the pgAdmin executable? That way it would not affect other
applications.
Later,
--
Tony Caduto
AM Software Design
http://www.amsoftwaredesign.com
Home of PG Lightning
what I have to say, but sometimes you
can be very stubborn and one way or the highway!!!
Later,
--
Tony Caduto
AM Software Design
http://www.amsoftwaredesign.com
Home of PG Lightning Admin for Postgresql
Your best bet for Postgresql Administration
---(end of broadcast
Dblink is nice, but should it really be needed for databases on the same
physical server?
What would be cool is to allow a double dot notation i.e.
database1..schema1.table1
Just a idea. Comments?
--
Tony
---(end of broadcast)---
TIP 9: In
Peter Eisentraut wrote:
This has been discussed about ten thousand times, and the answer is
still no.
Why? Seems to me if it was discussed that much it must be a very sought
after feature.
How come it's not on the TO Do list for the future at least?
Is it because of some limitation of
Ron Johnson wrote:
be separate databases because they're clearly related data.
Just because they are related, doesn't mean that it's always wise to
lump it all in the same database. Mainly for scalability and
performance reasons.
I would tend to agree, there are numerous times being
Mark Walker wrote:
It's sort of a matter of taste, but there are lots of people who like
to keep there logic on the server or at least within sql statements,
so there's probably a good sized market that your not reaching if you
ignore it.
That is a good point, I and many developers I know
David Fetter wrote:
That being said, I think it is a dumb feature. If you have data in
one database, that requires access to another database within the
same cluster. You designed your database incorrectly and should be
using schemas.
I would have to disagree, it's a feature that has
Does anyone know what the default fillfactor is for index types other
than btree?
I found in the docs that the default for btree is 90, but can't seem to
find what it is for the other index types.
Thanks in advance,
Tony
---(end of
Hi,
I was just wondering if a 32bit client connected to a 64bit server,
would it be possible for the 64bit server to return a OID that was over
4 billion to the 32 bit
client and possibly cause a range error if the OID value was used in a
unsigned 32-bit integer var?
Thanks,
--
Tony
.
--
Tony Caduto
AM Software Design
http://www.amsoftwaredesign.com
Home of PG Lightning Admin for Postgresql
Your best bet for Postgresql Administration
---(end of broadcast)---
TIP 6: explain analyze is your friend
and everything is stored in a Postgresql
or MySQL database.
I recently converted my website to it and could not be more happy :-)
--
Tony Caduto
AM Software Design
http://www.amsoftwaredesign.com
Home of PG Lightning Admin for Postgresql
Your best bet for Postgresql Administration
1 - 100 of 410 matches
Mail list logo