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 inste
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
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 parse&rewrite (not very general ofcourse :-)) but I would
like to know whether there is any code written for this purp
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 val
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 orac
[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
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 on
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.
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
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
> >
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 are
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 (-1
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
[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 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
-
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 g
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.
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, 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 in
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 SQ
"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,
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 a
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 i
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 alw
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 times
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 that
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 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. It
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 co
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 trig
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
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 d
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:
# selec
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
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 bein
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
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
src/include/
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 datab
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 I
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
04-83
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 w
41 matches
Mail list logo
