Hi Scott,
Thank you for your comment.
> > Is there any plan to support BLOB and CLOB in future releases?
> >
> Looking at the spec, and postgresql's implementation, I can't
> see much reason you couldn't just use a domain to declare that
> a bytea is a blob and varchar is a clob.
That sounds
[EMAIL PROTECTED] (Sean Murphy) writes:
> My present need is for email notification; if there's a pg function or
> module that would handle this (I haven't turned up anything in my
> searches, but maybe I'm using the wrong search terms in the wrong
> places) I'd be OK for now, but I'd rather have t
On 6/20/07, Joshua D. Drake <[EMAIL PROTECTED]> wrote:
Just so there is no confusion. These WILL NOT be in 8.3:
http://developer.postgresql.org/index.php/Todo:PatchStatus
Apologies. I didn't know they had been put on hold.
Alexander.
---(end of broadcast)-
Andrew Kelly wrote:
On Mon, 2007-06-18 at 13:02 -0400, Jonah H. Harris wrote:
On 6/18/07, Andreas Kostyrka <[EMAIL PROTECTED]> wrote:
As a cynic, I might ask, what Oracle is fearing?
As a realist, I might ask, how many times do we have to answer this
type of anti-commercial-data
Sergei Shelukhin wrote:
This is just an example isolating the problem.
Actual queries contain more tables and more joins and return
reasonable amount of data.
Performance of big indices however is appalling, with planner always
reverting to seqscan with default settings.
I tried to pre-filter th
Alexander Staubo wrote:
On 6/20/07, Christan Josefsson <[EMAIL PROTECTED]> wrote:
Anyone using these patchese on production systems?
If these are the same patches that were made for Bizgres, then they
are bound to be in use in some current production systems of that
version of PostgreSQL.
If
"Alexander Staubo" <[EMAIL PROTECTED]> writes:
> On 6/20/07, Christan Josefsson <[EMAIL PROTECTED]> wrote:
>> If there's any PgSQL developer reading this - when can on-disk bitmap
>> indexes be expected to be included in stable PostgreSQL versions?
> It's scheduled for inclusion in 8.3,
Not any m
On 6/20/07, Christan Josefsson <[EMAIL PROTECTED]> wrote:
Anyone using these patchese on production systems?
If these are the same patches that were made for Bizgres, then they
are bound to be in use in some current production systems of that
version of PostgreSQL.
If there's any PgSQL develo
Christan Josefsson wrote:
Hi!
I'm working on building a PostgreSQL based data warehouse, and I'm thus
very interested in any experiences and usage of the PostgreSQL bitmap
index patches (which I've found on pgsql-patches).
Anyone using these patchese on production systems?
Anyone know if t
Andrew Sullivan <[EMAIL PROTECTED]> writes:
> On Wed, Jun 20, 2007 at 12:55:23PM -0700, Steve Atkins wrote:
>> Another approach, and one that can be more robust in the case
>> of external failures, is to have the trigger put the message it wants
>> to send into a queue table and have an external pr
Sergei Shelukhin wrote:
This is my first (and, by the love of the God, last) project w/pgsql
and everything but the simplest selects is so slow I want to cry.
This is especially bad with vacuum analyze - it takes several hours
for a database of mere 15 Gb on a fast double-core server w/2Gb of RAM
Hi!
I'm working on building a PostgreSQL based data warehouse, and I'm thus very
interested in any experiences and usage of the PostgreSQL bitmap index
patches (which I've found on pgsql-patches).
Anyone using these patchese on production systems?
Anyone know if the patches run on latest stable
EBIHARA, Yuichiro wrote:
Hi,
I'm developing a software that supports several RDBMSs including PostgreSQL.
The software needs an ability to handle large objects and now it uses 'bytea'
datatype for binary
data and 'text' for text data.
But for portability, I'd rather use BLOB and CLOB defined
On Wed, Jun 20, 2007 at 12:55:23PM -0700, Steve Atkins wrote:
>
> Another approach, and one that can be more robust in the case
> of external failures, is to have the trigger put the message it wants
> to send into a queue table and have an external process that
> monitors the table (via polling o
Maybe this is a well duh kind of question, or maybe there's no
straightforward way to do it, but is there any way that I could have a
pg function initiate a process on the host system?
Specifically I'd like to script an email to send off on an insert
trigger, but the ability to initiate system pr
On Jun 20, 2007, at 12:07 PM, Sean Murphy wrote:
Maybe this is a well duh kind of question, or maybe there's no
straightforward way to do it, but is there any way that I could have a
pg function initiate a process on the host system?
You can use pl/perlu or any of the other untrusted language
[EMAIL PROTECTED] wrote:
However, with this new Postgres site, I don't have access to my temp
tables after I've traversed another pg_connect. So PHP is either
creating a new connection, or giving me another session, not the one
which I created my tables in.
You wouldn't expect to be given back
If you can use tcl based pl function, the this might help you here -->
http://sourceforge.net/projects/pgmail/
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 6/20/07, Joshua D. Drake <[EMAIL PROTECTED]> wrote:
Sean Murphy wrote:
> Maybe this is a well duh kind of question, or maybe there
[EMAIL PROTECTED] wrote:
This seems to be a problem with PHP, or at least my set up.
I'm writing pages in basically the same way. Each page has an include
at the top that gets you a database session. The function, either
pg_connect() or mysql_connect(), is supposed to either create a new
connect
Sean Murphy wrote:
Maybe this is a well duh kind of question, or maybe there's no
straightforward way to do it, but is there any way that I could have a
pg function initiate a process on the host system?
Yeah you can use any of the untrusted pl languages for that.
Specifically I'd like to sc
PFC wrote:
The chunk to be allocated is not the same size, so to set the
increment value will not help.
I'm sometimes not that subtle, so I'd just use a BIGINT sequence.
Think about the largest chunk you'll ever get (probably less than 2^30
rows, yes ?), set this sequence increment to t
Maybe this is a well duh kind of question, or maybe there's no
straightforward way to do it, but is there any way that I could have a
pg function initiate a process on the host system?
Specifically I'd like to script an email to send off on an insert
trigger, but the ability to initiate system pro
On 6/20/07, Richard Broersma Jr <[EMAIL PROTECTED]> wrote:
--- "Joshua D. Drake" <[EMAIL PROTECTED]> wrote:
> The value of a surrogate key is easy retrieval and really has nothing to
> do with normalization or proper modeling.
>
> I often add a surrogate key, even when one is not required just s
Hi Guyz,
I need some help in an inheritance issue .
The scenario is as follows :
THE SAMPLE DDL:
CREATE TABLE account_login
(
account_id int4 NOT NULL,
account_login_time timestamptz NOT NULL DEFAULT now(),
ip_address varchar(32) NOT NULL,
originating_source varchar(32) NOT NULL DEFAUL
Michael Glaesemann wrote:
On Jun 20, 2007, at 11:28 , Joshua D. Drake wrote:
Richard Broersma Jr wrote:
I've often wondered about this. Since PostgreSQL allows FOREIGN KEYS
to be referenced from UNIQUE
(non-primary) natural keys, couldn't the schema be designed so that
every table has a su
On Jun 20, 2007, at 11:28 , Joshua D. Drake wrote:
Richard Broersma Jr wrote:
I've often wondered about this. Since PostgreSQL allows FOREIGN
KEYS to be referenced from UNIQUE
(non-primary) natural keys, couldn't the schema be designed so
that every table has a surrogate
PRIMARY KEY and y
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
(First of all sorry for cross-posting but I feel this is a matter that
interests all recipients)
Thread on pgadmin support:
http://www.pgadmin.org/archives/pgadmin-support/2007-06/msg00046.php
Hello Dave,
This behavior (trying to show the entire geom
Richard Broersma Jr wrote:
--- "Joshua D. Drake" <[EMAIL PROTECTED]> wrote:
The value of a surrogate key is easy retrieval and really has nothing to
do with normalization or proper modeling.
I often add a surrogate key, even when one is not required just so I
don't have to worry about have a
--- "Joshua D. Drake" <[EMAIL PROTECTED]> wrote:
> The value of a surrogate key is easy retrieval and really has nothing to
> do with normalization or proper modeling.
>
> I often add a surrogate key, even when one is not required just so I
> don't have to worry about have a 4 element where cla
On Wed, 20 Jun 2007, Martijn van Oosterhout wrote:
While true in this simple case, it can quickly become more complicated if
your relationship starts gaining attributes. For example, if you add start
and stop dates, so the (player,club) combination is not unique anymore. If
you track invoices, g
Martijn van Oosterhout wrote:
On Wed, Jun 20, 2007 at 08:39:23AM -0700, Rich Shepard wrote:
Also, the reason for a third, M-M, table is to relate multiple players and
multiple clubs. If you think of the logic involved, your third table has
only one row for each player-club combination. Therefo
On Wed, Jun 20, 2007 at 08:39:23AM -0700, Rich Shepard wrote:
> Also, the reason for a third, M-M, table is to relate multiple players and
> multiple clubs. If you think of the logic involved, your third table has
> only one row for each player-club combination. Therefore, each row is unique
> by
On Wed, 20 Jun 2007, brian wrote:
The former uses a primary key across both columns to enforce a unique
constraint. In the latter, you have a seperate ID column, which does not
enforce that constraint. And you have to ask yourself if you'll ever be
referencing that ID column for anything at all.
Magnus , folks
The only caveat i found in winxp64 is with psqlODBC
my application dont work very well on it into xp64
platform, the work around was change odbc profile in
favor of dns file , with dns file my application
return to work, ok.
BTW i using linux server without problems, but my
c
Naz Gassiep wrote:
OK so which is the "correct" way to do it?
E.g., Say I have a table with users, and a table with clubs, and a table
that links them. Each user can be in more than one club and each club
has more than one member. Standard M:M relationship. Which link table is
the "right" way to
Bob Pawley napisał(a):
Thanks
Does one version of ODBC work for all versions of Excel and Postgresql.
I am wanting to transfer one or two tables from Excel and manipulate the
information in Postgresql then transfer the results back to Excel as a
single table.
I am using Excel 2000 and Pos
OK so which is the "correct" way to do it?
E.g., Say I have a table with users, and a table with clubs, and a table
that links them. Each user can be in more than one club and each club
has more than one member. Standard M:M relationship. Which link table is
the "right" way to do it?
This:
CREAT
On 6/20/07, Robin Ericsson <[EMAIL PROTECTED]> wrote:
`-mcpu=' is deprecated. Use `-mtune=' or '-march=' instead.
Ok solved. This is what the configure-script barfs on. Hacking the
spec-file to change this flag removes this problem.
--
regards,
Robin
---(
On Jun 20, 5:55 am, David Abrahams <[EMAIL PROTECTED]> wrote:
> The problem is, psql is complaining:
>
> ERROR: wrong record type supplied in RETURN NEXT
Try:
... RETURNS SETOF RECORD ...
---(end of broadcast)---
TIP 1: if posting/reading throu
Would it help at all to run a ktrace?
Or are the logs I have supplied enough?
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
thats cool,
thanks.
2007/6/19, Tom Lane <[EMAIL PROTECTED]>:
"Rhys Stewart" <[EMAIL PROTECTED]> writes:
> Is regex searching not functioning (as i expect it to?)
~ expects the pattern on the right, not the left. So it's taking your
array entries as patterns, which don't match the data 'Trans
Hello,
I'm trying to build a set of plpgsql functions in order to ease
partitioning by date, let's say
one table per day for a total of 30 days.
I have plpgsql functions to create the partition tables (having a
date suffix) and to manage
a retention period, however I still need to solve a pro
Andrew Maclean wrote:
> I got no answer so I am trying again.
>
> In a nutshell, if I have a recrusive relationship as outlined below, how
> do I implement a rule for the adjustments table that prevents the entry
> of an Id into the Ref column if the id exists in the Id column and vice
> versa?
>
[EMAIL PROTECTED] wrote:
[EMAIL PROTECTED] writes:
My database has shutdown several times in the last couple days. I have
no
idea why. I am running centos and I have not rebooted the server or
made
any configuration changes.
Oh, I forgot. You do have plenty of swap space compared to RAM, yes
On Wed, Jun 20, 2007 at 04:31:40PM +0900, EBIHARA, Yuichiro wrote:
> Magnus,
>
> Thank you for your quick reply.
>
> > > Can I get a PostgreSQL Installer for Windows x64(EM64T)?
> > > That for 32bit Windows is available at
> > > http://www.postgresql.org/ftp/win32/ but I need x64 native version.
Michael Glaesemann wrote:
INSERT INTO accounts_receivable_receipts (accounts_receivable_id,
receipt_id)
VALUES (2, 1), (4, 3), (6, 1), (5, 3);
I have not done much accounting-style design, and I don't think this is
really the best way to set these up (for example, I think it's a bit odd
to ma
Magnus,
Thank you for your quick reply.
> > Can I get a PostgreSQL Installer for Windows x64(EM64T)?
> > That for 32bit Windows is available at
> > http://www.postgresql.org/ftp/win32/ but I need x64 native version.
>
> There is no such thing. PostgreSQL 64-bit is currently only
> supported on
My Question:
How can I do "OLD.columnName != NEW.columnName" if I don't know what the
columnNames are at Compile Time?
I have the columnName in a variable.
I suggest you use plpython. In this case you'll be able to do it.
TD['old'][colNameVar] != TD['new'][colNameVar]
--
Regards,
Sergey Konop
On Wednesday 20 June 2007 03:09, Bob Pawley wrote:
> Thanks
>
> Does one version of ODBC work for all versions of Excel and Postgresql.
>
> I am wanting to transfer one or two tables from Excel and manipulate the
> information in Postgresql then transfer the results back to Excel as a
> single tabl
On Wed, Jun 20, 2007 at 10:17:10AM +0900, EBIHARA, Yuichiro wrote:
> Hi,
>
> Can I get a PostgreSQL Installer for Windows x64(EM64T)?
> That for 32bit Windows is available at http://www.postgresql.org/ftp/win32/
> but I need x64 native
> version.
There is no such thing. PostgreSQL 64-bit is curr
50 matches
Mail list logo
