Maybe move this to the mysql mailing list ;)
On Mon, Jan 4, 2010 at 11:38 AM, Joshua D. Drake wrote:
> On Mon, 2010-01-04 at 12:36 -0500, Bill Moran wrote:
> > In response to Alvaro Herrera :
> >
> > > Chris Browne wrote:
> > > > dcor...@connx.com ("Dann Corbit") writes:
> > > > > (Commercial use
one table
definition and will need to use a view instead? Sorry if my question is too
concise - I can provide sample code if necessary.
Postgres 8.4.2 on Windows.
Mark Watson
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
variable set to the folder where the PostgreSQL data sits. Running the
pg_ctl status command from the command prompt returns "pg_ctl: no server
running". Ideas why pg_ctl doesn't know about the running services?
Mark
Same result.
On Mon, Mar 29, 2010 at 1:51 PM, Raymond O'Donnell wrote:
> On 29/03/2010 18:38, Mark Vantzelfde wrote:
> > I am running 8.4 on a Windows Vista system. The software was installed
> using
> > the auto-install process. PostgreSQL starts successfully as a servic
Could it be that pg_ctl uses some sort of unix cmd like ps to try to
determine with the postgres processes are running? Using ps from a windows
command prompt does not show the postgres processes started as services.
Mark
On Mon, Mar 29, 2010 at 1:54 PM, Mark Vantzelfde wrote:
> Same res
h a
> query but I am surprised that postgres doesn't start using the disk at
> some point to reduce memory usage. Could it be that postgres tries
> to keep temp tables in memory?
> On Tue, Oct 18, 2011 at 3:56 AM, Craig Ringer wrote:
>> On 10/18/2011 02:52 PM, Mark Prie
g the disk at
some point to reduce memory usage. Could it be that postgres tries
to keep temp tables in memory?
On Tue, Oct 18, 2011 at 3:56 AM, Craig Ringer wrote:
> On 10/18/2011 02:52 PM, Mark Priest wrote:
>>
>> I am getting an Out of Memory error in my server connection p
ay be coming in under a
different encoding. An e acute is a valid character in 1252 encoding.
However, if the source computer is using, for example, code page 850, an e
acute is hex(82) whereas the equivalent in 1252 is hex(e9). UTF-8 "doesn't
like" hex(82).
HTH,
Mark
--
Sent
have attempted still results in
these "zero" date values in the csv file.
I am thinking of run the csv files through a filter to change the "00-00-00
00:00:00" to an empty value.
Is there a way for postgres to handle this?
- Mark
--
Sent via pgsql-general mailing list (pgsql-ge
less, using SED may be the
way to go as there are two tables that contain a bit over 3,000,000 rows each.
- Mark
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Sat, 17 Mar 2012 10:46:00 -0500, dennis jenkins
wrote:
Aleksey, a suggestion: The vast majority of the postgresql wire
protocol compresses well. If your WAN link is not already compressed,
construct a compressed SSH tunnel for the postgresql TCP port in the
WAN link. I've done this when
hi
I want to install madlib into a postgresql9.1.3 installation.
i am trying to:
a) make python2.7
b) configure postgresql to point at the python2.7 working directory, and
c) install postgresql9.1.3 (using python2.7)
no success to date.
to date my steps have been:
1. configure/make python2.7 (
ECT COALESCE(mid,0) AS mid, COALESCE(id_group,0) AS id_group
FROM users
WHERE username = 'test'
UNION
SELECT 0, 0
WHERE NOT EXISTS (SELECT 1 FROM users WHERE username = 'test');
--
Mark
http://www.lambic.co.uk
signature.asc
Description: Digital signature
ECT COALESCE(mid,0) AS mid, COALESCE(id_group,0) AS id_group
FROM users
WHERE username = 'test'
UNION
SELECT 0, 0
WHERE NOT EXISTS (SELECT 1 FROM users WHERE username = 'test');
--
Mark
http://www.lambic.co.uk
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hi,
I'm trying to drop a role that is no longer being used. However the role
has 4 dependencies which are all pg_toast tables. How can I change the
owner of those pg_toast tables so I can drop the role?
--
Mark
http://www.lambic.co.uk
signature.asc
Description: Digital signature
On Thu, Jan 29, 2009 at 10:46:08AM -0500, Tom Lane wrote:
> Mark Styles writes:
> > I'm trying to drop a role that is no longer being used. However the role
> > has 4 dependencies which are all pg_toast tables. How can I change the
> > owner of those pg_toast tables so I
On Thu, Jan 29, 2009 at 12:29:07PM -0500, Tom Lane wrote:
> Mark Styles writes:
> > On Thu, Jan 29, 2009 at 10:46:08AM -0500, Tom Lane wrote:
> >> I guess the interesting question to me is what happened to the tables
> >> those toast tables are/were attached to
On Thu, Jan 29, 2009 at 02:11:37PM -0500, Tom Lane wrote:
> Mark Styles writes:
> > Thanks, I managed to clear out the offending dependencies. relowner was
> > actually set correctly, but the pg_shdepend records were wrong.
>
> Hmm ... what actually was in the pg_shdepen
Postgres perfect in your world or does it do some
> things which rub you the wrong way?
>
> Feel free to respond on-list or if you prefer in personal emails. I do intend
> to use the ideas you give in my presentation so mark anything you wouldn't be
> happy to see in a slide at a
select * from foo;
a
--
\x09
\x09
\t
(3 rows)
Time: 0.239 ms
dev=>
-Mark
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
f the receiving application requires
it in a different format.
-Mark
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ack prepared $master_transaction_id
|);
}
}
-Mark
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ing out of temp space in your tmp
partition [supposition, I've run into something like this before, but
not specifically with Postgres].
-Mark
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
's stable enough to
> announce to the world.
Nice, how about doing the same for http://identi.ca? Support the open
source alternatives...
--
Mark
http://www.lambic.co.uk
signature.asc
Description: Digital signature
On Thu, Mar 05, 2009 at 09:44:58AM -0500, Douglas J Hunley wrote:
> On Wednesday 04 March 2009 15:39:36 Mark Styles wrote:
> > On Tue, Mar 03, 2009 at 09:38:39PM -0500, Douglas J Hunley wrote:
> > > I really wanted to let everyone know that I've created @PGSQL_Announce on
&g
cessing the
database at the time I'm writing these tests.
Any help on this would be greatly appreciated.
Mark
--
E: mark.man...@gmail.com
W: www.compoundtheory.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
be completely random, and I'm got no idea what is going on.
Thanks in advance.
Mark
On Sun, Mar 8, 2009 at 11:39 AM, Mark Mandel wrote:
> All,
>
> I seem to have a weird one here.
>
> I'm using Hibernate on my application to generate my DDL for postGres
> whenev
ransaction'...
I am using JDBC connection pooling, but I was sure I was closing them
when I was done.
Mark
On Mon, Mar 9, 2009 at 8:29 AM, Scott Marlowe wrote:
> On Sun, Mar 8, 2009 at 2:54 PM, Mark Mandel wrote:
>> Just a note on this -
>>
>> I have tried it on both 8.2
Omg... i think this one was all on me
What I thought was closing the connection at the end of my
processing... doesn't look like it was.
Pretty sure this has fixed it. Will let you know.
Mark
On Mon, Mar 9, 2009 at 9:52 AM, Mark Mandel wrote:
> Thanks for this -
>
> I&#
Well, there was an issue there, in that I wasn't closing my
connection, but I'm still getting the same log as I did before.
It seems to be when Hibernate lazy loads some data. The lazy loading
seems to happen within the session (connection), but the transaction
doesn't get closed
Final words -
If you use PostGres and Hibernate, * everything * has to be in a
transaction, ALWAYS.
That and remember to close your sessions.
Thanks for listening to my rambling.
Mark
On Mon, Mar 9, 2009 at 10:31 AM, Mark Mandel wrote:
> Well, there was an issue there, in that I was
e=0.003..0.003 rows=0
loops=1)"
"-> Seq Scan on f_quote_client
(cost=0.00..1.02 rows=2 width=4) (actual time=0.006..0.010 rows=2 loops=1)"
" -> Seq Scan on f_quote_client (cost=0.00..1.02
rows=2 width=4) (actual t
d is only half way through.
What am I doing wrong?
--
mARK bLOORE
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ysql-4.1.11.00 1.41 1.34 1.16 0.93 1.03 1.01 1.00 0.94 0.86 0.80
pg-7.4.1 0.65 1.27 1.90 2.48 2.45 2.50 2.48 2.51 2.49 2.39 2.38
-Mark
---(end of broadcast)---
TIP 8: explain analyze is your friend
On Mon, Mar 14, 2005 at 06:04:01PM -0500, Chris Browne wrote:
> [EMAIL PROTECTED] (Mark Rae) writes:
>> Clients 1 2 3 4 6 812163264
>> 128
>> --
>&g
y be spread throughout the physical memory.
Perhaps one of the developers could comment on how difficult
it would be to change the shared buffer handling to use multiple
segments. As I'd definitely be willing to give it a go.
-Mark
---(end of broadcast)--
On Tue, Mar 15, 2005 at 06:46:50PM -0500, Bruce Momjian wrote:
> Mark Rae wrote:
> > Also, while on the subject of scaling. I had the opportunity
> > to try postgres on a 16CPU Altix and couldn't get it to scale
> > more than about 4x, whereas Oracle got up to about 12x
the machine.
-Mark
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
nd disk.
As the database is so small (8GB), relative to the machine, the data will
be on average 2 hops away. This gives an average of 72% of the speed of
local memory, based on previous measurements of speed vs hops.
So getting 63% of the theoretical maximum database throughput i
3.83 7.55 10.98 14.10 20.27 26.47 34.50 37.88
38.45 38.12
So, it didn't make any difference for the Opteron, but the two
Itanium machines were 5% and 7% faster respectively.
-Mark
---(end of broadcast)---
TIP 5: Have you c
the
coherency being handled in hardware.
So it looks like all that might be needed is to replace the
shmget calls in src/backend/port with the equivalent SGI functions.
-Mark
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
Hi,
I'm interested in deploying PostgreSQL in a production application but
I'd like to know if the following features are available:
- dblinks
- partition tables
If they are not, are they planned for a (near) future release?
Thanks,
Mark
---(end of
Hi,
Does anyone have a Solaris 10 smf script that they'd like to share for
controlling postgreSQL startup, shutdown, etc.?
Mark
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "
Greetings,
Thanks Dann, Arthur, Mike, Jeffrey, and Bruno. You've given me a
quick solution and a whole lot to chew on. I never would have come up
with anything as creative.
Thanks again,
Mark
> -Original Message-
> From: Mark Fox [mailto:[EMAIL PROTECTED]
> Sent: We
onships
parent child
-- -
/foo/foo/bar
/foo/bar/foo/bar/baz
/foo/bar/foo/bar/bot
Is this a reasonable thing to do in a trigger? Does anybody
have a pl/sql snippet to do this?
Many TIA,
Mark
--
Mark Harrison
Pixar Animation Studios
---(end of broadcast)
How do I install the headers and libraries for extending
postgreSql? They are not installed by the windows installer (see the following
post: http://archives.postgresql.org/pgsql-hackers-win32/2005-03/msg00169.php ).
Regards,
Mark Miller
f how many events occur on the days of a particular month.
What I do now is create a temporary table, fill it with the
appropriate days, and then do a cross join and summation to generate
what I need. This works, but seems messy to me.
Mark
---(end of broadcast)-
in a given month. I'm now thinking that I might be able to
come up with something using an IN clause and using EXTRACT, but
haven't figured it out yet.
Mark
On Wed, 30 Mar 2005 15:16:19 -0800, Dann Corbit <[EMAIL PROTECTED]> wrote:
> The online documentation has a search
I am trying to write an unaccent function because I
need to do some queries comparing data that has accents and data that does not.
The encoding on my DB is Unicode, so far I have found
an unaccent() function by looking in the mail archives it looks like the
following:
CREATE FUNCTI
-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Peter Eisentraut
Sent: May 6, 2005 2:12 AM
To: Mark Borins
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Unicode and unaccent()
Mark Borins wrote:
> My problem is that the values like \342 are for LATIN1 type encodi
, postgres general newsgroup, what
database modelling tools do you use? Open source or commercial it doesn’t
matter to me.
Thank you,
Mark
generating change scripts, etc.
From: Matthew Terenzio [mailto:[EMAIL PROTECTED]
Sent: May 9, 2005 5:48 PM
To: Mark Borins
Subject: Re: [GENERAL] Data Modelling Tools
these are among some popular tools, the second being web based.
http://www.pgadmin.org/
http
If the original paper was published in 1984, then it's been more than 20
years. Any potential patents would already have expired, no?
-- Mark Lewis
On Tue, 2005-05-10 at 14:35, Mischa Sandberg wrote:
> Quoting "Jim C. Nasby" <[EMAIL PROTECTED]>:
>
> > W
I am creating a system where I have a trigger on
three different tables. There is a particular Boolean field in each of
these tables that when it is set in table it should be set the same in the
other two.
So I figured I could put a trigger on each table that
when the Boolean field was
Thank you for the response.
While the TIMESTAMP solution is a good idea.
I was wondering if anyone knew of a SQL like instruction that could be
called.
Like:
UPDATE table SET WHERE NO TRIGGERS
Or something like that, however, I realize I may just be dreaming.
Mark
That looks like a good solution.
And that way it won't cascade.
Thanks
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Richard Huxton
Sent: May 11, 2005 11:53 AM
To: Mark Borins
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Disabling Tri
:[EMAIL PROTECTED] On Behalf Of Hrishikesh Deshmukh
Sent: May 9, 2005 6:54 PM
To: Mark Borins
Cc: pgsql-general@postgresql.org; [EMAIL PROTECTED]
Subject: Re: [GENERAL] Data Modelling Tools
This is my favits just awesome...
http://www.sqlmanager.net/
On 5/9/05, Mark Borins <[EMAIL PROTEC
anks in advance
Mark
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
method get involved.
As opposed to people with science degrees but poor understanding
of business methods? :-)
Cheers,
Mark
--
Mark Harrison
Pixar Animation Studios
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister comma
Scott Marlowe wrote:
On Thu, 2005-05-19 at 15:10, Mark Harrison wrote:
Sadly, lots of people in positions of power still want scape goats,
rather than proven results.
No, it could be that the OP's organization is looking for some proof
of postgresql's results.
That's a bit
ybase, oracle,
mysql, and postgresql?
Many TIA!
Mark
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
and then expand the SRF by creating some other rows
with the blanks as needed and "return next" those as well.
Thanks!
Mark
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
execute:
select * from view_bluecard where job_id = 1130;
I get the proper set of records. But, I want to add to them in the SRF
as I explained above. Thus, I don't think I can do it with just a view
(even using a union within the view as I don't know how many blanks the
user willl want).
Regards,
Mark
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
AAARRRGGGHHH... Now I understand you, Josh. Sorry.
You are correct.
Thanks!
Mark
On Jun 1, 2005, at 4:39 PM, Joshua D. Drake wrote:
[EMAIL PROTECTED] wrote:
Hello!
I have a view that I'm putting into a report in my application. I'd
like to get several blank lines returned by t
bitrarily deep children in a btree type
stored in column "c". It doesn't make sense to have a really wide table to
represent the tree for multiple reasons, mostly involving data duplication in
the leftward columns but also because you can't know ahead of time how wide to
ma
Tom Lane wrote:
Alvaro Herrera <[EMAIL PROTECTED]> writes:
On Tue, Jun 28, 2005 at 07:38:43PM -0700, Mark Dilger wrote:
If, for a given row, the value of c is, say, approximately 2^30 bytes
large, then I would expect it to be divided up into 8K chunks in an
external table, and I sho
is such a thing possible?
TIA!
Mark
--
Mark Harrison
Pixar Animation Studios
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
r, I'm not sure one way or the other if Intel IS doing this.
I think its more a case of AMD now having solid evidence to back
up the claims.
This discovery, and that fact that you could get round it by
toggling some flags, was being discussed on various HPC mailing
lists around about the
On Tue, Jul 12, 2005 at 03:11:35PM -0500, Scott Marlowe wrote:
> On Tue, 2005-07-12 at 15:06, Mark Rae wrote:
> > I think its more a case of AMD now having solid evidence to back
> > up the claims.
>
> Wow! That's pretty fascinating. So, is the evidence pretty
> o
Hi,
Change it to a "BEFORE UPDATE" trigger, and set NEW.updated_date := now();
Otherwise each update produces another update produces another update....
-Mark.
[EMAIL PROTECTED] wrote:
Can anybody help me creating a trigger on update trigger with update
statement as below.
Th
Hi,
Does anyone have a Solaris 10 SMF script for managing a postgres install?
Mark
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
shaps going from 7.2 to 7.4 last backup, although
frightening, I overcame them with some fiddling.
Thanks in advance,
Mark-- ___Roses are #FFViolets are #FF,All my baseAre belong to you.
Hello,
You can use the information_schema.* tables, which are part of the SQL
standard (and thus not proprietary).
-Mark.
Walsh, Richard (Richard) wrote:
Hi,
I have a problem in that I need to drop non-existent tables in a DDL
script. This is in order that the script can re-build a
ackups are not going to work across major releases so justinstalling 8.0 with your old cluster won't work.You'll need to do a pg_dump of your old setup and then restore on yournew cluster.Hope this helps,
On Wed, Jul 27, 2005 at 12:27:41AM -0400, Mark Mikulec wrote:> Hi there,>>
So, I've got pg running on a linux box, and I'm informed that a
windows box should be able to access this through ODBC, about
which I am woefully uninformed.
Can somebody loan me a clue as to what I should do to make
this happen?
Many TIA!
Mark
--
Mark Harrison
Pixar Animati
to go from there.
The assumption here is that the SQL is coming in on a script via the
programmatic interface. Slurp in a bunch of SQL commands and then fire
them at the database.
Perhaps it is just easier to 'dropdb' then 'createdb' and go from there.
Many thanks,
--
-mar
thoughts on how to get my config up
and working across the network?
TIA,
--
-mark. (probertm at acm dot org)
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
Hi ..
On Tue, 2005-08-23 at 14:45 -0700, Mark Probert wrote:
>
> SO, the db is up and running locally but I can't get to it from the
> network.
>
With a friend's help, I worked out that I need to edit two files:
postgresql.conf (listen_address = '*')
pg_
uite useful to be able to do something like
COMMENT ON USER jbloggs IS 'Joe Bloggs <[EMAIL PROTECTED]>'
-Mark
---(end of broadcast)---
TIP 6: explain analyze is your friend
ions had problems were they would allocate memory to
the wrong bank of memory when using dual core CPUs. So you
would find only about a 20% improvement over a single core.
With the newer kernels you should find that a dual core will
be giving you about 80% increase over a single core.
-Mark
-
On Wed, Oct 19, 2005 at 09:55:18AM -0700, William Yu wrote:
> Mark Rae wrote:
> >With the newer kernels you should find that a dual core will
> >be giving you about 80% increase over a single core.
>
> I'm not experiencing this problem right now because I have NU
n. So there doesn't appear to be any implementation
problems that would stop you from reaching the theoretical table limits.
-Mark
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
NIQUE will create implicit index "tv_workspace_name_key" for
table "tv_workspace"
NOTICE: CREATE TABLE / UNIQUE will create implicit index "tv_workspace_p4client_key" for
table "tv_workspace"
TIA!
Mark
--
Mark Harrison
Pixar Animation Studios
Hi,I get this error when accessing the postgresl database -- any ideas? What should I look at?
I can query all of the other tables in the database, just not the email_queue table. Weird!
Thanks in advance,
Mark# psql --versionpsql (PostgreSQL) 7.3.2
contains support for command-line editing
mp/restore? The latter would be hard since pg_dump also fails on this same table and pg_dump doesn't seem to have an 'ignore table' option.
MarkOn 10/6/06, Richard Huxton <dev@archonet.com> wrote:
Mark Greenbank wrote:> # psql --version> psql (PostgreSQL) 7.3.2May I be the
FATAL: unsupported frontend protocol
FATAL: The database system is starting upLOG: database system is readyThe worrying bit (at least to my uneducated eye) is the line:
LOG: ReadRecord: record with zero length at D/72C79AD4Thanks,MarkOn 10/6/06,
Mark Greenbank <[EMAIL PROTECTED]> wrote:
Hi Ric
Hi Doug,Are there any pointers as to how to fix corrupted data? Is seems like that might be the problem as I'm seeing a zero-length read in the log file (see my previous email).Thanks again,Mark
On 10/6/06, Douglas McNaught <[EMAIL PROTECTED]> wrote:
"Mark Greenbank" <[EMAI
sername for the
report itself.
Is there a way within the SQL of the request to get a query to
execute as a specific user? In effect changing the user in the
middle of a connection?
Thanks!
Mark
---(end of broadcast)---
TIP 1: if posting/reading
Bingo! Thanks! I'm not sure how I missed that one...
Mark
On Nov 19, 2006, at 2:12 PM, John DeSoi wrote:
On Nov 19, 2006, at 11:10 AM, Mark Lubratt wrote:
I'm working on a report (using jasperreports) for an application
I've written accessing PG 8.1.4. The view I'm
_fact;
Table "public.daily_area_fact"
Column | Type | Modifiers
---+-+---
time_id | integer | not null
ccid | integer | not null
area_id | integer | not null
uu_id | integer | not null
geo_id| integer | not null
imps | integer |
n this database, then yes, table scans are going to be huge, thus
why it's taking so long, plus dedupping on unique user id :)
and you're right, i should put this on the performance mailing list... see you
there :)
thanks guys.
____
Mark Jensen
- Or
http://www.postgresql.org/files/documentation/books/aw_pgsql/node210.html
just a simple command to copy data to and from tables/files.
Mark Jensen
- Original Message
From: Andrus <[EMAIL PROTECTED]>
To: pgsql-general@postgresql.org
Sent: Wed
o a
SELECT FOR UPDATE where ... limit 1, generate thumbnail,
delete the record and commit.
Comments and suggestions welcome,
Mark
--
Mark Harrison
Pixar Animation Studios
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, plea
ow I can limit
the disk space that PostgreSQL uses to say 5GB. I have not looked in to
pg_autovacuum yet, but from what I have read about it it does not seem
to be the answer to this problem. Has anyone else had to do such a
thing before? Does anyone have any ideas on how to do this be
I want to make a client application that logs onto a postgresql server
with an individual postgresql user role for each user. This is as
opposed to having one user role for the entire app, storing that
password on the local client, and using the client app to do
authentication against a a tabl
OK, let me think. In my situation, I'm writing an accounting app. A
typical situation would be a standard user would be able to update data
in a timesheet while an administrator would be able to approve the time
sheet. If I gave the standard user access to the timesheet header
table, they wo
What is the delimiter between id and created_at? I believe they're
supposed to be tabs with \t used for tabs inside a field. The data you
give here is all whitespaces.
Mason Hale wrote:
I've done a bit more digging into this, here's what I've found --
The text db dump file is much too big
Does the developer offer any hard evidence for his statement? I mean
like benchmark tests and a side by side list of features?
My impression is that Mysql is set up very narrowly for a typical ISP
offering LAMP and not much else. Once you start going into corporate
installations on private s
It's interesting that this is yet another issue of where exactly you
want to place your business logic. Do you do it as much as you can on
your sql server or do you bias it towards your client application. It's
obvious that you can do cross database linking in your application
layer, but if y
201 - 300 of 633 matches
Mail list logo
