Uuups... That's what I feared of. I was a bit hasty and nervous after
I've discovered, that the old schema doesn't work. Sory for that.
An yet, the original question remain. After I've change the TRIGGER to
"FOR EACH ROW", I get:
---
database=# C
"woger151" <[EMAIL PROTECTED]> writes:
I assume it's harmless to drop the database named "postgres" (named after
the DB superuser)?
You might want to recreate it afterwards, since various tools expect it
to be there (for instance createdb, createuser, "psql -l" will all fail
by default if it is
"woger151" <[EMAIL PROTECTED]> writes:
> I assume it's harmless to drop the database named "postgres" (named after
> the DB superuser)?
You might want to recreate it afterwards, since various tools expect it
to be there (for instance createdb, createuser, "psql -l" will all fail
by default if it
I assume it's harmless to drop the database named "postgres" (named after
the DB superuser)?
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
8.0.x has the problem that VACUUM FULL on a table does not reclaim space
from the indexes, and I have to issue a separate REINDEX command. Has
this been fixed in later versions?
---(end of broadcast)---
TIP 5: don't forget to increase your free s
Tom Lane <[EMAIL PROTECTED]> wrote: John Sales writes:
> By doing this, I'm hoping that the query optimizer is smart enough to see
> that if a query comes in and requests only the six columns (that are in the
> narrower table) that PostgreSQL won't have to load the wider table into the
> buffer
Bill Moran wrote:
> In response to "Vijayaram Boopalan - TLS , Chennai" <[EMAIL PROTECTED]>:
> >
> > I do not kb=3Dnow how to take differential=
> > database backup in postgre 8.1.5.
>
> What on Earth is wrong with your MUA?
For some reason I thought that was hilarious. :-)
--
Bruce Momjian
Joris Dobbelsteen wrote:
> Why not collect some information from live databases and perform some
> analysis on it?
We already capture and utilize operational data from databases: for each
table, how many tuples there are, how many tuples have been inserted,
deleted, updated. We already analyse it
John Sales <[EMAIL PROTECTED]> writes:
> By doing this, I'm hoping that the query optimizer is smart enough to see
> that if a query comes in and requests only the six columns (that are in the
> narrower table) that PostgreSQL won't have to load the wider table into the
> buffer pool, and thereb
On Jan 8, 2007, at 9:20 PM, Matthew Terenzio wrote:
On Jan 8, 2007, at 9:13 PM, Matthew Terenzio wrote:
On Jan 8, 2007, at 8:55 PM, Michael Glaesemann wrote:
On Jan 8, 2007, at 19:20 , Matthew Terenzio wrote:
Is it true that you can't use COPY FROM to fill a table with a
SERIAL type co
On Jan 8, 2007, at 9:13 PM, Matthew Terenzio wrote:
On Jan 8, 2007, at 8:55 PM, Michael Glaesemann wrote:
On Jan 8, 2007, at 19:20 , Matthew Terenzio wrote:
Is it true that you can't use COPY FROM to fill a table with a
SERIAL type column?
Or rather, how does one approach that situation
On Jan 8, 2007, at 8:55 PM, Michael Glaesemann wrote:
On Jan 8, 2007, at 19:20 , Matthew Terenzio wrote:
Is it true that you can't use COPY FROM to fill a table with a SERIAL
type column?
Or rather, how does one approach that situation most effectively?
Could you give an example of what
Jeanna Geier wrote:
Hello List!
I have a question regarding SELECT INTO...
Can it be used with Views? I have a View that is populated (~35,000 rows)
that I want to create a Table from the data in it
So, would I be able to copy the data from the View to the Table using the
SELECT INTO com
Is it true that you can't use COPY FROM to fill a table with a SERIAL
type column?
Or rather, how does one approach that situation most effectively?
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
On 1/9/07, Jeanna Geier <[EMAIL PROTECTED]> wrote:
Hello List!
I have a question regarding SELECT INTO...
Can it be used with Views? I have a View that is populated (~35,000 rows)
that I want to create a Table from the data in it
So, would I be able to copy the data from the View to the
Why not collect some information from live databases and perform some
analysis on it?
Possible values required for (to be defined) vacuum heuristic,
Human classification of tables,
Updates/Transactions done (per table/db),
Growth of tables and indexes,
(all with respect to time I believe)
Collect
Suppose I have a table - lets say it was developed by someone with little or no
understanding of database design - and it has 230 columns.
Now, it turns out that 99% of the time only about 8 colums are required, but
all 230 columns are populated. However, legacy applications (which are run
nig
> My point is: if I need to be 100% sure that what is referenced on the database
> is accessible all the time when the reference is, then I need to have this on
> the database
Not necessarily. It does take carefully controlling access, with a good deal
of thought and error-checking on the part of
Hello List!
I have a question regarding SELECT INTO...
Can it be used with Views? I have a View that is populated (~35,000 rows)
that I want to create a Table from the data in it
So, would I be able to copy the data from the View to the Table using the
SELECT INTO command?
Thanks much,
-J
Jeremy Haile wrote:
>> Note that things will go faster if you do your initial data load using
>> "copy from stdin" for the initial bulk data load. individual inserts in
>> postgresql are quite costly compared to mysql. It's the transactional
>> overhead. by grouping them together you can make
> Note that things will go faster if you do your initial data load using
> "copy from stdin" for the initial bulk data load. individual inserts in
> postgresql are quite costly compared to mysql. It's the transactional
> overhead. by grouping them together you can make things much faster.
> cop
[EMAIL PROTECTED] (Csaba Nagy) writes:
> On Sun, 2006-12-24 at 03:03, Christopher Browne wrote:
> [snip]
>> Seems to me that you could get ~80% of the way by having the simplest
>> "2 queue" implementation, where tables with size < some threshold get
>> thrown at the "little table" queue, and table
On Mon, 2007-01-08 at 15:59, George Nychis wrote:
> Scott Marlowe wrote:
> > On Mon, 2007-01-08 at 15:52, George Nychis wrote:
> >> Scott Marlowe wrote:
> >>> On Mon, 2007-01-08 at 14:58, George Nychis wrote:
> Hi,
>
> I have approximately 2 billion data entries that I would like to
Scott Marlowe wrote:
> On Mon, 2007-01-08 at 15:52, George Nychis wrote:
>> Scott Marlowe wrote:
>>> On Mon, 2007-01-08 at 14:58, George Nychis wrote:
Hi,
I have approximately 2 billion data entries that I would like to insert
into a database.
Each entry consists of:
>>>
On Mon, 2007-01-08 at 15:52, George Nychis wrote:
> Scott Marlowe wrote:
> > On Mon, 2007-01-08 at 14:58, George Nychis wrote:
> >> Hi,
> >>
> >> I have approximately 2 billion data entries that I would like to insert
> >> into a database.
> >> Each entry consists of:
> >> INT BOOLEAN INT BOOLEAN
Scott Marlowe wrote:
> On Mon, 2007-01-08 at 14:58, George Nychis wrote:
>> Hi,
>>
>> I have approximately 2 billion data entries that I would like to insert into
>> a database.
>> Each entry consists of:
>> INT BOOLEAN INT BOOLEAN
>>
>> I want to populate a table such that it only contains the
On Mon, 2007-01-08 at 14:58, George Nychis wrote:
> Hi,
>
> I have approximately 2 billion data entries that I would like to insert into
> a database.
> Each entry consists of:
> INT BOOLEAN INT BOOLEAN
>
> I want to populate a table such that it only contains the unique rows, all
> other data
On 8 Jan 2007 at 23:15, Shoaib Mir wrote:
> It does install both the Slony binaries and scripts.
Grand - thanks for confirming.
Ray.
--
Raymond O'Donnell
Director of Music, Galway Cathedral, Galway, Ireland
[EMAIL PROTECTED]
Hi,
I have approximately 2 billion data entries that I would like to insert into a
database.
Each entry consists of:
INT BOOLEAN INT BOOLEAN
I want to populate a table such that it only contains the unique rows, all
other data
should be thrown out. I would say a significant amount of the inser
Try a 180-day Win2k3 trial to see if the issue persists. Realistically,
though, if you can't afford the proprietary software don't develop with
it.
If it's a Windows XP bug (or "feature") then it's not anything we can
help with since PG is working correctly.
--
Brandon Aiken
CS/IT Systems Engine
On Mon, 2007-01-08 at 15:19, Curran Schiefelbein wrote:
> If this is not the right list for this problem, could someone please
> point me to the right area?
according to this page:
http://www.postgresql.org/community/lists/
"Current win32 development issues should be raised on -hackers. Cygwin
If this is not the right list for this problem, could someone please
point me to the right area?
Curran Schiefelbein wrote:
Hi,
I'm trying to compile postgres-8.2.0 from source on WinXP-SP2, for use
with libpqxx.
At first I was able to compile in cygwin with ./configure followed by
make. How
Jeanna Geier wrote:
Hello List!
OK, so I'm new to SQL and Postgres and am working on taking over this DB
work, and ran across a command that I'm not sure of and am wondering if you
can help me with... Probably a basic SQL question, but thought more than one
person on here would be able to poin
Brandon Aiken wrote:
If you are suffering from this particular error, you will see an entry
in the event log. Look for an error from Tcpip with an ID of 4226. The
message will say "TCP/IP has reached the security limit imposed on the
number of concurrent (incomplete) TCP connect attempts.". If
If you are suffering from this particular error, you will see an entry
in the event log. Look for an error from Tcpip with an ID of 4226. The
message will say "TCP/IP has reached the security limit imposed on the
number of concurrent (incomplete) TCP connect attempts.". If you do not
see this me
Hello List!
OK, so I'm new to SQL and Postgres and am working on taking over this DB
work, and ran across a command that I'm not sure of and am wondering if you
can help me with... Probably a basic SQL question, but thought more than one
person on here would be able to point me in the right dire
Shelby Cain wrote:
I'm just throwing this out here... but the usual suspects for strange
connection issues like these would be a software firewall or antivirus
(especially AV software that has anti-worm features).
Also, Windows XP Pro isn't really viable as a server OS as Microsoft has
intent
> --- Original Message ---
> From: "Jeffrey Melloy" <[EMAIL PROTECTED]>
> To: "Dave Page" <[EMAIL PROTECTED]>
> Sent: 1/8/07, 8:18:02 PM
> Subject: Re: [GENERAL] is there a tracking trace tool like the "SQL Analizer
>
> How long has that been available for OS X? Last time I looked at it
How long has that been available for OS X? Last time I looked at it it
wasn't.
On 1/8/07, Dave Page <[EMAIL PROTECTED]> wrote:
> --- Original Message ---
> From: "Ian Harding" <[EMAIL PROTECTED]>
> To: "Jeffrey Melloy" <[EMAIL PROTECTED]>
> Sent: 1/8/07, 7:06:31 PM
> Subject: Re: [GE
I've been using a product called HappyFish, which does reverse
engineering on Postgres and has proven to be a great DB development
tool. While it's not free, it is very low cost and you can easily get a
full-featured evaluation version to try out. I've been running it
through its paces with a pre
I'm just throwing this out here... but the usual suspects for strange
connection issues like these would be a software firewall or antivirus
(especially AV software that has anti-worm features).
Also, Windows XP Pro isn't really viable as a server OS as Microsoft has
intentionally limited certa
> --- Original Message ---
> From: "Ian Harding" <[EMAIL PROTECTED]>
> To: "Jeffrey Melloy" <[EMAIL PROTECTED]>
> Sent: 1/8/07, 7:06:31 PM
> Subject: Re: [GENERAL] is there a tracking trace tool like the "SQL Analizer"
> in MS sqlserver.?
>
> I thought that was called SQL Profiler.
>
>
> --- Original Message ---
> From: "Raymond O'Donnell" <[EMAIL PROTECTED]>
> To: pgsql-general@postgresql.org
> Sent: 1/8/07, 5:57:59 PM
> Subject: [GENERAL] Slony in Windows installer?
>
> Hello all,
>
> When installing PostgreSQL via the Windows installer, Slony-I is one
> of the opt
On Sat, Jan 06, 2007 at 11:14:42AM +1100, pakt sardines wrote:
>
>Hi all,
> We're currently developing some large-scale software with the
> intention of selling it (online and off-the-shelf). The version in
> development uses Postgres to store stuff in a number of large
> databases. Ignoring
Ian,
Query Analyzer is EXPLAIN with a GUI.
Anyway, I have not heard of such a thing for PostgreSQL,
On my installation of PostgreSQL from the stock windows installer
there was installed PgAdmin, which has quite a GUI for EXPLAIN.
The query plan is displayed very nice and I find it easier to
u
> > In Oracle i use the command "connect by prior" and i need to use it in
> > PostgreSQL, what is the sintax?
>
> I was unable to find pg-hier in a quick cruise through PgFoundry.
Try http://gppl.moonbone.ru/
The patch is not yet fixed to 8.2.0. 8.1.2 looks to be the latest.
I am running postgres on Windows XP and have been for quite a while as
the database engine for our application.
On an ODBC connection the following error has started happening. The gap
in activity is normal for our application. but the connection failing is
a first we have this application liv
pakt sardines wrote:
> ...the big issue for us is
> that the data in the databases has significant intellectual property
> value. It has taken literally years of work to collect the data. We do
> not want the users of the commercial product to be able to fire up
> postgres and type something like
On 1/8/07, Joshua D. Drake <[EMAIL PROTECTED]> wrote:
On Mon, 2007-01-08 at 12:56 -0600, Jeffrey Melloy wrote:
>
>
> On 1/8/07, Jeffrey Melloy <[EMAIL PROTECTED]> wrote:
> Not exactly. SQL Analyzer also includes live monitoring of
> whatever queries are coming into the database.
Whoops, you're right.
On 1/8/07, Ian Harding <[EMAIL PROTECTED]> wrote:
I thought that was called SQL Profiler.
http://msdn2.microsoft.com/en-us/library/ms181091.aspx
Query Analyzer is EXPLAIN with a GUI.
http://msdn2.microsoft.com/en-gb/library/aa178423(SQL.80).aspx
Anyway, I have not hear
I thought that was called SQL Profiler.
http://msdn2.microsoft.com/en-us/library/ms181091.aspx
Query Analyzer is EXPLAIN with a GUI.
http://msdn2.microsoft.com/en-gb/library/aa178423(SQL.80).aspx
Anyway, I have not heard of such a thing for PostgreSQL, although I am
sure the basic information
guillermo arias wrote:
is there a tracking trace tool in postgre? like the "SQL Analizer" in
MS sqlserver.
I have downloaded the PGAdmin III and i have not found any tool like this.
Thanks
Get your FREE, LinuxWaves.co
On Mon, 2007-01-08 at 12:56 -0600, Jeffrey Melloy wrote:
>
>
> On 1/8/07, Jeffrey Melloy <[EMAIL PROTECTED]> wrote:
> Not exactly. SQL Analyzer also includes live monitoring of
> whatever queries are coming into the database. You can
> achieve something similar by enabli
On 1/8/07, Jeffrey Melloy <[EMAIL PROTECTED]> wrote:
Not exactly. SQL Analyzer also includes live monitoring of whatever
queries are coming into the database. You can achieve something similar by
enabling query logging in the settings.
On 1/8/07, Ian Harding <[EMAIL PROTECTED]> wrote:
>
> The
Leandro Repolho wrote:
Hello everybody,
In Oracle i use the command "connect by prior" and i need to use it in
PostgreSQL, what is the sintax?
The last time I saw this discussed, Tom Lane referred to a "pg-hier"
modification but said this: "Beware that it makes an
incompatible change in rule r
There is no GUI tool that I know of, but there is EXPLAIN which gives
the same information.
- Ian
On 1/8/07, guillermo arias <[EMAIL PROTECTED]> wrote:
is there a tracking trace tool in postgre? like the "SQL Analizer" in MS
sqlserver.
I have downloaded the PGAdmin III and i have not found any
It does install both the Slony binaries and scripts.
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 1/8/07, Raymond O'Donnell <[EMAIL PROTECTED]> wrote:
Hello all,
When installing PostgreSQL via the Windows installer, Slony-I is one
of the options offered. Does it install the
Hello all,
When installing PostgreSQL via the Windows installer, Slony-I is one
of the options offered. Does it install the the Slony binaries, or
just the SQL scripts/functions that Slony uses?
Thanks,
Ray.
--
Raymond O'Do
On Sun, 2006-12-24 at 03:03, Christopher Browne wrote:
[snip]
> Seems to me that you could get ~80% of the way by having the simplest
> "2 queue" implementation, where tables with size < some threshold get
> thrown at the "little table" queue, and tables above that size go to
> the "big table" queu
is there a tracking trace tool in postgre? like the "SQL Analizer" in MS sqlserver.I have downloaded the PGAdmin III and i have not found any tool like this.Thanks Get your FREE, LinuxWaves.com Email Now! --> http://www.LinuxWaves.comJoin Linux Discussions! --> http://Community.LinuxWaves.com
Thanks,
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Andreas
Kretschmer
Sent: Monday, January 08, 2007 11:19 AM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Sorting
Ragnar <[EMAIL PROTECTED]> schrieb:
> > test=*# select w, case when w ~ '^
Ragnar <[EMAIL PROTECTED]> schrieb:
> > test=*# select w, case when w ~ '^[0-9]*$' then w::int else 1 end from
> > foo order by 2,1;
>
> possible improvements:
> a) w ~ '^[0-9]+$'
> b) use NULL instead of 1
Thanks, right.
Andreas
--
Really, I'm not out to destroy Microsoft. That w
On mán, 2007-01-08 at 17:59 +0100, A. Kretschmer wrote:
> am Mon, dem 08.01.2007, um 10:21:38 -0600 mailte Bart McFarling folgendes:
> > I have a column that is a varchar(6) I need to sort it by the rows that are
> > integers 1st then the character ones or vice versa, I just need the values
> > t
Take a look at contrib/tablefunc there is a function called connectby()
that should do what you're looking for.
Otherwise roll your own...
http://archives.postgresql.org/pgsql-sql/2003-10/msg00374.php
John
Thomas Kellerer wrote:
On 08.01.2007 17:24 Scott Marlowe wrote:
On Mon, 2007-01-08 at
"Thomas F. O'Connell" <[EMAIL PROTECTED]> writes:
> On Jan 8, 2007, at 10:32 AM, Erik Jones wrote:
>> One question regarding my previous thread about the 8.2 client
>> tools. We have yet to have time (personal as well as usage pattern
>> constraints) to dump our schema to analyze it for any po
am Mon, dem 08.01.2007, um 10:21:38 -0600 mailte Bart McFarling folgendes:
> I have a column that is a varchar(6) I need to sort it by the rows that are
> integers 1st then the character ones or vice versa, I just need the values
> that
> can be converted to integer to sort by their numeric value
Ah, I'd been looking at the following from Ch. 23.5 Backup and Restore
and was hoping it would go in both directions:
"It is recommended that you use the pg_dump and pg_dumpall programs from
the newer version of PostgreSQL, to take advantage of any enhancements
that may have been made in these
On several occasions I have thought that each row in a table should have a
SYSTEM COLUMN which gave the timestamp of the last update of that row. This
could get a bit expensive on space and in some cases might be redundant with
(or have a slightly different value from) a user-maintained timestamp
On Jan 8, 2007, at 10:32 AM, Erik Jones wrote:
Erik Jones <[EMAIL PROTECTED]> writes:
One question regarding my previous thread about the 8.2 client
tools. We have yet to have time (personal as well as usage pattern
constraints) to dump our schema to analyze it for any possible
discrepe
I have a column that is a varchar(6) I need to sort it by the rows that
are integers 1st then the character ones or vice versa, I just need the
values that can be converted to integer to sort by their numeric value.
i.e
1, 2, 3, 4, 5, 10, 11, A, B, C
instead of
1, 10, 11, 2, 3, 4, 5, A, B, C
An
Hi,
I am still not so certain about adding a timestamp column to each table, as
within a few months the table will be quite big. My current thinking is to
have a trigger per table that overwrties a single value in a single utility
table after every write, this will be far quicker to select when
Scott Marlowe wrote:
On Mon, 2007-01-08 at 03:26, Andy Dale wrote:
Ok.
The SQL Proxy i am using (HA-JDBC) has some limitations with regard to
getting it's "cluster" back into sync. If ha-jdbc uses the wrong DB
(one that has been out of action for a while) as the starting point
for the clust
Tom Lane wrote:
Erik Jones <[EMAIL PROTECTED]> writes:
Before migrating to 8.2, even during peak times, unless queries were
seriously stacking (not completing in a timely manner), we'd see at most
50 - 100 queries active at any given time (we did have
stats_command_string = on). Since the
On 08.01.2007 17:24 Scott Marlowe wrote:
On Mon, 2007-01-08 at 07:38, Leandro Repolho wrote:
Hello everybody,
In Oracle i use the command "connect by prior" and i need to use it in
PostgreSQL, what is the sintax?
What does connect by prior do? Reuse a connection from one db to
another? I don
It is used for Hierarchical queries in Oracle :)
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 1/8/07, Scott Marlowe <[EMAIL PROTECTED]> wrote:
On Mon, 2007-01-08 at 07:38, Leandro Repolho wrote:
> Hello everybody,
> In Oracle i use the command "connect by prior" and i nee
On Mon, 2007-01-08 at 07:38, Leandro Repolho wrote:
> Hello everybody,
> In Oracle i use the command "connect by prior" and i need to use it in
> PostgreSQL, what is the sintax?
What does connect by prior do? Reuse a connection from one db to
another? I don't think there's anything like that in
On Mon, 2007-01-08 at 03:26, Andy Dale wrote:
> Ok.
>
> The SQL Proxy i am using (HA-JDBC) has some limitations with regard to
> getting it's "cluster" back into sync. If ha-jdbc uses the wrong DB
> (one that has been out of action for a while) as the starting point
> for the cluster it will then
On Mon, 2007-01-08 at 02:22, Andy Dale wrote:
> Hi,
>
> Sorry for the slight delay in my response.
>
> I am using 3 PostgreSQL databases and writing to them using an SQL
> proxy. These databases have a high write volume. On rebooting all 3
> servers for OS/Software updates, i would like to figu
sangeetha k.s wrote:
> hello,
>
> postgresql uses bitmap indexing for indexing in databases.
> *Is there any technique used*
> * used to compress the bitmap indices in postgresql*,like oracle that uses
> Byte Aligned bitmap compression to compress bitmaps.
Postgres does not support
I have jotted down some notes on performing a hot backup (which is what Bill
is referring you to), and I included a script called pg_hotbackup that
automates the relatively simple tasks required to take a snapshot of the
cluster data directory.
http://www.postgresqlforums.com/forums/viewtopic.php
thank you Tom!
that did the trick!
I'm still in the dark why my test data type didn't exhibit the
problem, but I'm certainly a much happier camper now.
Eric.
At 05:40 PM 05/01/2007, Tom Lane wrote:
Eric Davies <[EMAIL PROTECTED]> writes:
> Some of my custom server functions/data types that wo
Bill Moran wrote:
> In response to "Vijayaram Boopalan - TLS , Chennai" <[EMAIL PROTECTED]>:
> >
> > I do not kb=3Dnow how to take differential=
> > database backup in postgre 8.1.5.
>
> What on Earth is wrong with your MUA?
This:
X-MimeOLE: Produced By Microsoft Exchange V6.5
It's fairly commo
There is no default support but you can always use connectby() function from
the tablefunc contrib module
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 1/8/07, Leandro Repolho <[EMAIL PROTECTED]> wrote:
Hello everybody,
In Oracle i use the command "connect by prior" and
It does allow you to sort on both columns.
SELECT DISTINCT ON (path) path, comment_id, created, title
FROM bewertungen.tblcomments ORDER BY path, created
Thank you very much. Works perfect! :-)
---(end of broadcast)---
TIP 3: Have you
pakt sardines wrote:
Hi all,
We're currently developing some large-scale software with the
intention of selling it (online and off-the-shelf). The version in
development uses Postgres to store stuff in a number of large databases.
Ignoring potential licensing issues for now, the big iss
In response to "Vijayaram Boopalan - TLS , Chennai" <[EMAIL PROTECTED]>:
>
> I do not kb=3Dnow how to take differential=
> database backup in postgre 8.1.5.
What on Earth is wrong with your MUA?
See:
http://www.postgresql.org/docs/8.1/interactive/backup-online.html
--
Bill Moran
Collaborative F
Clodoaldo wrote:
But the main factor to push me in the file system direction is the
HTTP cache management. I want the internet web clients and proxies to
cache the images. The Apache web server has it ready and easy. If
the images where to be stored in the DB I would have to handle the
HTTP cac
Rafal Pietrak <[EMAIL PROTECTED]> writes:
> Hi All!
>
> I have some old piece of code, that worked two years ago (Postgres
> version 7.2, I think), but doesn't work within Postgres 8.1.4 now.
>
> The story is, that I have a trigger on a table (business day
> statistics), that is fired before ins
Title: Postgres Differential backup
Hi,
I do not kb=now how to take differential database backup in postgre 8.1.5.
Please help.
B. VijayaRam
Chennai.
DISCLAIMER:
---
T
Clodoaldo wrote:
But the main factor to push me in the file system direction is the
HTTP cache management. I want the internet web clients and proxies to
cache the images. The Apache web server has it ready and easy. If
the images where to be stored in the DB I would have to handle the
HTTP cac
>>>apache has very good page and image caching. You could take advantage
>>>of that using this technique.
> I wonder why this HTTP cache headers argument didn't surface in this
> heated debate.
I did other up this argument by the way.
Andrew
Clodoaldo wrote:
2007/1/5, Jorge Godoy <[EMAIL PR
hello,
postgresql uses bitmap indexing for indexing in databases.
*Is there any technique used*
* used to compress the bitmap indices in postgresql*,like oracle that uses
Byte Aligned bitmap compression to compress bitmaps.
regards,
sangeetha.
Sorry about the typo in the title, of course I don't want to reverse
any engineering schemas. :)
I ended up using Squirrel SQL. (A tool I haven't used in a long time
and almost forgot about.)
http://squirrel-sql.sourceforge.net/
The diagraming part is not supersmart, but good enough for my purpos
Hi all,
We're currently developing some large-scale software with the intention
of selling it (online and off-the-shelf). The version in development uses
Postgres to store stuff in a number of large databases.
Ignoring potential licensing issues for now, the big issue for us is that
the data
Nico Grubert <[EMAIL PROTECTED]> writes:
> My first try was this SQL query:
>
> SELECT DISTINCT ON (path) path, comment_id, created, title
> FROM bewertungen.tblcomments
>
> This does not allow me to append "ORDER BY created" since I can only sort on
> path because of DISTINCT ON (path).
I
Hi,
On Mon, 2007-01-08 at 05:36 -0800, Ravi Malghan wrote:
> I want to create a simple web interface that lists table data, select
> entries to add/delete/change table data from a table in postgres
> database. Whatz the best and easiest way to do this?
You can use phpPgAdmin: http://www.phpPgAdmi
Hi there,
I have a problem sorting a SQL result if I use DISTINCT ON.
I have a table "tblcomment" with these columns:
id (serial)
path (varchar)
created (timestamp)
title (varchar)
These records are in the table "tblcomment":
id pathcreated title
--
Hello everybody,
In Oracle i use the command "connect by prior" and i need to use it in
PostgreSQL, what is the sintax?
Hi: I want to create a simple web interface that lists table data, select
entries to add/delete/change table data from a table in postgres database.
Whatz the best and easiest way to do this? Wondering if there are any modules
or code out there already.
TIA
Ravi
___
Hi All!
I have some old piece of code, that worked two years ago (Postgres
version 7.2, I think), but doesn't work within Postgres 8.1.4 now.
The story is, that I have a trigger on a table (business day
statistics), that is fired before insert; it updates another table
(detailed transaction log),
1 - 100 of 106 matches
Mail list logo
