On 1 Nov 2004 at 20:45, Glen Eustace wrote:
When I tried to reload the production database dump, I got a series of
errors relating to functions. I repeated the exercise but this time did
a \df prior to trying to load the database. In the public schema for the
newly created admin database
I would check the template1 database to see if you had the functions
defined there as well.
Any functions/structures/data... in template1 will be moved to the new
database. Then when you try to restore the old one it will conflict.
Thank You
Sim Zacks
IT Manager
CompuLab
04-829-0145 - Office
Hi All,
I hope this is the correct mailing list for this question. But neither
postgresql.org nor google could help me out on this subject.
I did find one disturbing topic on the mailing list archives
(http://archives.postgresql.org/pgsql-admin/2000-05/msg00032.php), but
since it was quite old
All the same, there is only one identifier type.
It got bigger recently, but it's either 31 or 63 characters... Look
through the documentation.
On Fri, Oct 29, 2004 at 01:49:23PM +0200, Fred BROUARD - SQLpro wrote:
Did you know what is the maximum character length for a name of :
a database
On Mon, 1 Nov 2004 10:20:14 +0100, Martijn van Oosterhout
[EMAIL PROTECTED] wrote:
All the same, there is only one identifier type.
It got bigger recently, but it's either 31 or 63 characters... Look
through the documentation.
It's been 63 characters since 7.2 or 7.3. See
Hi Randall,
On Sun, Oct 31, 2004 at 11:25:46PM -0600, Randall Smith wrote:
1. Set up stored proc on oracle that records a INSERT, UPDATE, DELETE
SQL action taken on a table into a log table.
2. Program reads the log table on oracle and issues the same SQL command
on the postgres db. In the
The Postgres manual says:
The AT TIME ZONE construct allows conversions of time stamps to
different time zones.
I'd guess most people would think what's meant here is something like
unit conversion, and that the timestamp value stays the same (much
like 2 feet becomes 24 inches when it's being
Sorry, hit Sent too early...
David Garamond wrote:
The Postgres manual says:
The AT TIME ZONE construct allows conversions of time stamps to
different time zones.
I'd guess most people would think what's meant here is something like
unit conversion, and that the timestamp value stays the same
You misunderstand the TIMESTAMP WITH TIMEZONE type, it doesn't store
the timezone you gave it, it's just a point in time. Saying AT TIMEZONE
just converts it to a TIMESTAMP WITHOUT TIMEZONE with the local time it
was in the timezone you gave it. So you are complaring different
things. See:
#
Martijn van Oosterhout wrote:
You misunderstand the TIMESTAMP WITH TIMEZONE type, it doesn't store
the timezone you gave it, it's just a point in time. Saying AT TIMEZONE
just converts it to a TIMESTAMP WITHOUT TIMEZONE with the local time it
was in the timezone you gave it. So you are complaring
hi,
what do u do if the DB become big and u have to spread
it into two or more computers.
Links and Docs are ok too ?
For example what if u do if u want to split the DB on two servers (at desing stage),
but
u have common data such as user info,address etc... if u decide to do it that way
u need
On Fri, Oct 29, 2004 at 11:18:48PM +0200, stig erikson wrote:
i would like to log every single query coming in to the database into a
table. i would like the log to include the entire query and execution
time and execution cost, and if possible the user that executed the query.
A trigger
Hi everyone,
When importing a bunch of data ( 85000 rows) I get an error I can't
explain. The table into which I'm importing has a unique clause on
(code, bedrijf). The rows in the source-table are unique in this
aspect, yet when I do the import I get this ERROR: duplicate key
violates unique
I don't see the big difference between what Marco is suggesting and user
threads -- or to be more precise, I think user threads and event-based
programming are just two sides of the same coin. A user thread just
represents the state of a computation -- say, a register context and
some stack.
On Mon, Nov 01, 2004 at 04:13:43PM +0100, Joolz wrote:
When importing a bunch of data ( 85000 rows) I get an error I can't
explain. The table into which I'm importing has a unique clause on
(code, bedrijf). The rows in the source-table are unique in this
aspect, yet when I do the import I
raptor wrote:
hi,
what do u do if the DB become big and u have to spread
it into two or more computers.
Links and Docs are ok too ?
For example what if u do if u want to split the DB on two servers (at desing stage),
but
u have common data such as user info,address etc... if u decide to do it
David Garamond [EMAIL PROTECTED] writes:
So the question remains, does AT TIME ZONE already do
what it's supposed to do (according to SQL standard, that is)
It does not really. By my reading of SQL99, the result should always be
timestamptz, and the behavior when the input is already
On Mon, Nov 01, 2004 at 11:00:10AM -0500, Tom Lane wrote:
David Garamond [EMAIL PROTECTED] writes:
So the question remains, does AT TIME ZONE already do
what it's supposed to do (according to SQL standard, that is)
It does not really. By my reading of SQL99, the result should always be
Martijn van Oosterhout [EMAIL PROTECTED] writes:
On Mon, Nov 01, 2004 at 11:00:10AM -0500, Tom Lane wrote:
It does not really. By my reading of SQL99, the result should always be
timestamptz, and the behavior when the input is already timestamptz
should be that the new timezone spec is
On Sun, Oct 31, 2004 at 05:55:23PM -0500, Tom Lane wrote:
[...]
I'm inclined to think that rejecting impossible or ambiguous input
without a zone is reasonable (and it would go along with the changes
we made in 7.4 to tighten up datetime field order assumptions).
But I don't want to take away
Joolz [EMAIL PROTECTED] writes:
Is there a bug in the UNIQUE behaviour?
No known bugs, anyway. I'm inclined to guess that your target table has
slightly different datatypes than the source, and that results in equal
values for some reason (such as fractional values being rounded to
integer, or
Hi,
First I'm trying to move a MySQL database to Postgres. I have to emulate a
MySQL sql statement - ''Describe tablename' which in general is '\d
tablename' from psql. If I use '-E' my 7.3.x provides three sql statements
and by 7.4.x produces four statements. But what I want is a single
On Mon, Nov 01, 2004 at 01:57:38PM -0300, Vinko Vrsalovic wrote:
On Sun, Oct 31, 2004 at 05:55:23PM -0500, Tom Lane wrote:
One point here is that timestamp-to-timestamptz datatype conversion will
be affected by whatever we choose. While it's easy to say reject it
for data coming into a
On Mon, Nov 01, 2004 at 07:08:39PM +0100, Martijn van Oosterhout wrote:
For the parsing integer issue it may have worked, but this is another
kettle of fish. I don't think you can do this as a simple switch, it
would have to set during the initdb and not allowed to be changed
afterwards. I
On Mon, 2004-11-01 at 21:14, Sim Zacks wrote:
I would check the template1 database to see if you had the functions
defined there as well.
Any functions/structures/data... in template1 will be moved to the new
database. Then when you try to restore the old one it will conflict.
Thanks you.
Is there any way to determine the last time statistics were analyzed on
a given table?
--
Jim C. Nasby, Database Consultant [EMAIL PROTECTED]
Give your computer some brain candy! www.distributed.net Team #1828
Windows: Where do you want to go today?
Linux: Where do you want to go
I couldn't agree more!.. I've been watching the list every day just to
see what is going to be said next
Good stuff!
- Greg
BTW, I think this thread is really interesting -- certainly more
informative than a rehash of the usual processes vs. threads debate.
-Neil
[EMAIL PROTECTED] (Tino Wildenhain) writes:
Am Sa, den 30.10.2004 schrieb Russell Smith um 8:02:
On Thu, 28 Oct 2004 04:14 am, Eric wrote:
Is there something to interface postgreSQL with QMail to store mails in
pgsql instead of using mbox or maildir?
Or maybe it's not a good idea to do
On Mon, 1 Nov 2004 09:59:44 -0800, John Fabiani [EMAIL PROTECTED] wrote:
Hi,
First I'm trying to move a MySQL database to Postgres. I have to emulate a
MySQL sql statement - ''Describe tablename' which in general is '\d
tablename' from psql. If I use '-E' my 7.3.x provides three sql
Use a numeric type if you need more precision.
template1=# create domain BIGINT_UNSIGNED numeric(20,0) check (value =
0 and value '18446744073709551616'::numeric(20,0));
CREATE DOMAIN
template1=# create table foobar (i BIGINT_UNSIGNED);
CREATE TABLE
template1=# insert into foobar (i) values
Hi all,
I am using an Access client linked to a PG 7.4 server via ODBC.
I have a stored proc on the server that inserts rows into a
table.particular table, accomplished via an INSERT
within the body of the stored proc. The procedure does not explicitly
commit this data, as no transactions
On Monday 01 November 2004 16:13, Ian Barwick wrote:
On Mon, 1 Nov 2004 09:59:44 -0800, John Fabiani [EMAIL PROTECTED] wrote:
Hi,
First I'm trying to move a MySQL database to Postgres. I have to emulate
a MySQL sql statement - ''Describe tablename' which in general is '\d
tablename'
What is the conventional wisdom about routine reindexing with 7.4.6 and 8.0?
Is it still considered an important maintenance task? If so, how
frequently is it needed?
Ed
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Ed L. wrote:
What is the conventional wisdom about routine reindexing with 7.4.6 and 8.0?
Is it still considered an important maintenance task? If so, how
frequently is it needed?
7.4 at least handles a lot of the reindex issues at vacuum time.
I assume 8 does the same.
Sincerely,
Joshua D.
I have figured out the problem. When I do a BEGIN; and then a SELECT an
AccessShareLock is obtained on the table, and then not released until the
transaction is over. Then the vacuum comes in and tries to acquire an
exclusive lock, and in the process blocks any readers who are trying to
SELECT
[EMAIL PROTECTED] writes:
So why isn't the AccessShareLock dropped as soon as the SELECT is over?
In general, locks are held till transaction commit. See any basic
database text for the reasons why this is a good idea.
regards, tom lane
---(end
Thanks Joachim,
The mirror only has to go from oracle to pgsql and the schema/tables
never change. I'm going to take a look at dbmirror. Thanks for the advice.
Randall
Joachim Wieland wrote:
Hi Randall,
On Sun, Oct 31, 2004 at 11:25:46PM -0600, Randall Smith wrote:
1. Set up stored proc on
Tom Lane zei:
Joolz [EMAIL PROTECTED] writes:
Is there a bug in the UNIQUE behaviour?
No known bugs, anyway. I'm inclined to guess that your target table
has
slightly different datatypes than the source, and that results in
equal
values for some reason (such as fractional values being
Hi!
I want to parse a query (SFW) and create new
queries: one for each table referenced, if that possible.
I've written a function for this in the Query
struct level after parserewrite (not very general ofcourse :-)) but I would
like to know whether there is any code written for this
After the stored procedure is run, call requery on the form that was
updated.
We are in the middle of moving Access implementations to PostGreSQL.
I'd be happy to trade war stories, if you'd like.
Thank You
Sim Zacks
IT Manager
CompuLab
04-829-0145 - Office
04-832-5251 - Fax
Am Di, den 02.11.2004 schrieb Chris Browne um 0:05:
[EMAIL PROTECTED] (Tino Wildenhain) writes:
Am Sa, den 30.10.2004 schrieb Russell Smith um 8:02:
On Thu, 28 Oct 2004 04:14 am, Eric wrote:
Is there something to interface postgreSQL with QMail to store mails in
pgsql instead of using
41 matches
Mail list logo