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 figure out which was the last written
to DB (this is assuming
On Mon, Jan 08, 2007 at 09:22:05 +0100,
Andy Dale [EMAIL PROTECTED] 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
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 try and delete stuff from the other DB's on their
hi,
i'm trying to register/install postgres ODBC driver on windowsME.
i've copied driver from winXP machine. this is one .dll file.
i would like to get it on the list in ODBC manager.
how can i register this file as ODBC driver on winME machine?
thanks
---(end of
am Mon, dem 08.01.2007, um 10:54:39 +0100 mailte riki folgendes:
hi,
i'm trying to register/install postgres ODBC driver on windowsME.
i've copied driver from winXP machine. this is one .dll file.
i would like to get it on the list in ODBC manager.
how can i register this file as ODBC
2007/1/6, Maurice Aubrey [EMAIL PROTECTED]:
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
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
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
Hello everybody,
In Oracle i use the command connect by prior and i need to use it in
PostgreSQL, what is the sintax?
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
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:
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).
It does
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
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
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.
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
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
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:
---
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 insert; it
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
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 Fusion
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
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
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 i
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 common that
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 work
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.
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
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 figure out
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 try
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
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 need to
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
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
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
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
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
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
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
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
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.
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 possible
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
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
that
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 will just
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 ~
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.ThanksGet your FREE, LinuxWaves.com Email Now! -- http://www.LinuxWaves.comJoin Linux Discussions! -- http://Community.LinuxWaves.com
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 queue.
That
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
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
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
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
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:
There is
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 enabling
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.com
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
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 heard
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. You can
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:
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
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.
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
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
--- 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 options offered.
--- 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.
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
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
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: [GENERAL] is
--- 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 it
wasn't.
2
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
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
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
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
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
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.
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
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
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
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]
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
should
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 unique rows, all
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
I want 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:
INT BOOLEAN INT BOOLEAN
I
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 insert
into a
[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 tables above that
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.
copy from
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 things
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,
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
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
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)
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
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
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
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
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
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
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 thereby
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
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 [EMAIL
1 - 100 of 106 matches
Mail list logo