Hello,
I am wondering if you are considenring supporting MDX syntax in PostgreSQL?
Regards, Rikardo Tinauer
--
___
Rikardo Tinauer
EBA, Agencija za elektronsko poslovanje d.o.o.
Teslova ulica 30
SI-1000 Ljubljana
e-mail: [EMAIL PROTECTED]
internet: www
THanks for quick reply
this is what i get now
Index Scan using ipt on ipdb2 (cost=0.00..74265.76 rows=989636
width=118) (actual time=0.216..2379.608 rows=1 loops=1)
Index Cond: (3229285376::bigint <= ipto)
Filter: (3229285376::bigint >= ipfrom)
Total runtime: 2379.666 ms
(4 rows)
de
On 28 Dec 2005, Randal L. Schwartz wrote:
>> Well, in my case the situation is further complicated by the fact that
>> adding a column to the view should be done automatically from a trigger
>> function. I wanted some kind of matrix view that had a column for every
>> row in a certain table. And w
I have one customer running a point of sale system using PostgreSQL and
SQL-Ledger with a fairly heavy set of modifications in SQL-Ledger. Feel
free to contact me off-list if you need any pointers. SQL-Ledger can be
found at http://www.sql-ledger.org. An unofficial wiki with lots of
developer d
Pamela wrote:
Sure so long as they decide to go with this solution. It would be greatly
appreciated. Have you looked at Ruby which is quite helpful when dealing
with PHP Perl CGI and C/C++. I haven't a lot of programming experience, my
degree is in BA Adv Mgmt and Financial Acctg and Diploma
On Fri, 30 Dec 2005, Michael Fuhr wrote:
> On Fri, Dec 30, 2005 at 02:38:48PM -0800, CSN wrote:
> > I'm still confused what the problem was.
>
> I think the problem is related to having multiple foreign key
> constraints with ON DELETE SET NULL referencing the same target.
> The triggers that enfo
On Fri, Dec 30, 2005 at 02:38:48PM -0800, CSN wrote:
> I'm still confused what the problem was.
I think the problem is related to having multiple foreign key
constraints with ON DELETE SET NULL referencing the same target.
The triggers that enforce those constraints are fired one at a time
with a
Hi.
I have a big problem. I dropped wrong table. I do have very recent dump,
but I would need to read wal (write ahead log) files somehow, to see
last 60 entries that were made. Then I can enter them manually.
Is there any way to make wal files more readable? Or is there something
else that I
Ubence Quevedo schrieb:
> What would be the correct way to set up a dynamic
> variable? I did some further research on my question
> below, and I still don't have a definite answer to
> whether or not use \set or SET. I did read at
> http://www.commandprompt.com/ppbook/x19832 about using
> variab
On 12/30/05, Scott Marlowe <[EMAIL PROTECTED]> wrote:
>
>
> On 12/30/05, Raymond O'Donnell <[EMAIL PROTECTED]> wrote:
>
> QUOTE:
> I used it once (2004) because it supported Postgres. It got hacked in
> under a month. I admit that this was a one off but having searched
> around the Internet for
--- Michael Fuhr <[EMAIL PROTECTED]> wrote:
> On Fri, Dec 30, 2005 at 12:09:12PM -0800, CSN wrote:
> > ERROR: insert or update on table "types" violates
> > foreign key constraint "$1"
> > DETAIL: Key (page_template_id)=(8) is not present
> in
> > table "templates".
> > CONTEXT: SQL statement
CSN <[EMAIL PROTECTED]> writes:
> I have three columns, and one of them can be null. I'd
> like to create a unique constraint across all three
> columns and allow only one null value. e.g.
UNIQUE won't do that for you, but you could brute force it with a
unique constraint plus a check constraint a
you could also use a big number to if the column is a int/int8/float/numeric.
Jim
-- Original Message ---
From: "Jim Buttafuoco" <[EMAIL PROTECTED]>
To: Bruno Wolff III <[EMAIL PROTECTED]>, CSN <[EMAIL PROTECTED]>
Cc: "pgsql-general@postgresql.org"
Sent: Fri, 30 Dec 2005 17:02:
try something like this
jim=# create table a (a text,b text, c text);
CREATE TABLE
jim=# create unique index a_idx on a(a,b,(coalesce(c,'*** NULL IS HERE ***')));
CREATE INDEX
jim=# insert into a values ('a','b','c');
INSERT 413272154 1
jim=# insert into a values ('a','b',null);
INSERT 41327215
On Fri, Dec 30, 2005 at 12:09:12PM -0800, CSN wrote:
> ERROR: insert or update on table "types" violates
> foreign key constraint "$1"
> DETAIL: Key (page_template_id)=(8) is not present in
> table "templates".
> CONTEXT: SQL statement "UPDATE ONLY "public"."types"
> SET "item_template_id" = NUL
What would be the correct way to set up a dynamic
variable? I did some further research on my question
below, and I still don't have a definite answer to
whether or not use \set or SET. I did read at
http://www.commandprompt.com/ppbook/x19832 about using
variables in a Function, but that seems li
--- Bruno Wolff III <[EMAIL PROTECTED]> wrote:
> On Fri, Dec 30, 2005 at 13:30:40 -0800,
> CSN <[EMAIL PROTECTED]> wrote:
> > I have three columns, and one of them can be null.
> I'd
> > like to create a unique constraint across all
> three
> > columns and allow only one null value. e.g.
> >
>
On Fri, Dec 30, 2005 at 13:30:40 -0800,
CSN <[EMAIL PROTECTED]> wrote:
> I have three columns, and one of them can be null. I'd
> like to create a unique constraint across all three
> columns and allow only one null value. e.g.
>
> a|b|c
> abc|123|null
> abc|123|null # not allowed
> abc|456|null
I have three columns, and one of them can be null. I'd
like to create a unique constraint across all three
columns and allow only one null value. e.g.
a|b|c
abc|123|null
abc|123|null # not allowed
abc|456|null
abc|456|987
abc|456|876
def|456|null
def|456|null # not allowed
Currently, the 'not all
On Friday 30 December 2005 13:03, Scott Marlowe wrote:
> On 12/30/05, Raymond O'Donnell <[EMAIL PROTECTED]> wrote:
>
> QUOTE:
> and they have a
> tendency to ignore certain exploits in any releases that are not
> current.
> UNQUOTE:
>
> That's hardly fair. PostgreSQL also ignores security issues o
I tried to delete a row from 'sites' and get this
rather complex error:
SQL error:
ERROR: insert or update on table "types" violates
foreign key constraint "$1"
DETAIL: Key (page_template_id)=(8) is not present in
table "templates".
CONTEXT: SQL statement "UPDATE ONLY "public"."types"
SET "ite
I am writing an application in Visual
Foxpro 9 (running on Windows 2000) but I get errors when VFP9 tries
to write data to my Postgresql server (Linux Redhat 9). I know the syntax
on the insert statement is good because I can run the statement in pgAdmin
and the row is created without problems. I
Thank you gentlemen, this will keep me busy for a while.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of James Cradock
Sent: Friday, December 30, 2005 1:05 PM
To: Jonel Rienton
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Data types
Try pg_ty
Try pg_type. typname should give you what you're looking for.
On Dec 30, 2005, at 1:57 PM, Jonel Rienton wrote:
Hi guys,
Does Postgres store all the possible column datatypes somewhere in its
system tables? Like int8, int4, character varying, etc. I'm trying
to write
another GUI client tha
On Fri, Dec 30, 2005 at 12:57:57PM -0600, Jonel Rienton wrote:
> Does Postgres store all the possible column datatypes somewhere in its
> system tables? Like int8, int4, character varying, etc. I'm trying to write
> another GUI client that can list all the database objects in Postgres.
See "Syste
Hi guys,
Does Postgres store all the possible column datatypes somewhere in its
system tables? Like int8, int4, character varying, etc. I'm trying to write
another GUI client that can list all the database objects in Postgres.
Thanks.
Regards,
Jonel
--
I know not english well, but I know 9 co
Jeff Trout wrote:
This isn't terribly clear in the documentation.
But it seems, in 8.0.3 and 8.1.1 that you cannot use a column alias in
an order by if you are using an expression (ie order by
my_column_alias <> 0 asc). If you use a plain asc/desc order by then
it is fine (ie order by my_col
Title: RE: [GENERAL] Forum Software
On 12/30/05, Raymond O'Donnell <[EMAIL PROTECTED]> wrote:
QUOTE:
I used it once (2004) because it supported Postgres. It got hacked in
under a month. I admit that this was a one off but having searched
around the Internet for various bulletin board softwar
>> What would people recommendation be for Bulleting Board software. I am
after something that uses PostgreSQL and has similar features of
PHPBB. I don't want to use PHPBB due to its complete lack of anything
resembling security.
I'm not familiar enough with PHBB to assess how it compares, b
"Ken Winter" <[EMAIL PROTECTED]> writes:
> My question is: Why didn't the chunk of "gen_sequences" code that consults
> pg_catalog find a record of "e_mail_address_invisible_id_seq", and thereby
> refrain from trying to create it again?
I added a few "raise notice" commands to your function, and g
Tom ~
Good idea. The grisly details are as follows.
Here is the DDL script (generated from PowerDesigner 10.1.0.1134):
/*==*/
/* DBMS name: PostgreSQL 7.3 */
/* Created o
This isn't terribly clear in the documentation.
But it seems, in 8.0.3 and 8.1.1 that you cannot use a column alias
in an order by if you are using an expression (ie order by
my_column_alias <> 0 asc). If you use a plain asc/desc order by then
it is fine (ie order by my_column_alias asc).
On Dec 30, 2005, at 4:36 AM, Harry Jackson wrote:
What would people recommendation be for Bulleting Board software. I am
after something that uses PostgreSQL and has similar features of
PHPBB. I don't want to use PHPBB due to its complete lack of anything
resembling security.
I'm not familiar
On Fri, Dec 30, 2005 at 12:02:59PM +0300, Ilja Golshtein wrote:
> Hello!
>
> I'm developing application uses PG as backend.
> A recent stress test found out a serious trouble. Briefly,
> libpq does not return control after COMMIT, while
> commit actually happened Ok.
Hmm, sounds like a race condi
On Fri, Dec 30, 2005 at 06:21:28PM +0530, surabhi.ahuja wrote:
> I am working with PostgerSQL 8.0.0.
> where can i find the startup scripts for the same.
Well, it's been in contrib/strat-scripts since 8.0.0 so you should find
it there.
> One more thing,
> I could not understand this:
> number of
On 12/30/05, Raymond O'Donnell <[EMAIL PROTECTED]> wrote:
> On 30 Dec 2005 at 9:36, Harry Jackson wrote:
>
> > PHPBB. I don't want to use PHPBB due to its complete lack of anything
> > resembling security.
>
> Just curious - where do you get your info re PHPBB's "complete lack
> of anythng resembli
On 30 Dec 2005 at 12:15, Raymond O'Donnell wrote:
> its godd & bad points.
Whoops!..you know what I meant
-
Raymond O'Donnell http://www.galwaycathedral.org/recitals
[EMAIL PROTECTED] Galway Cathedr
On 30 Dec 2005 at 9:36, Harry Jackson wrote:
> PHPBB. I don't want to use PHPBB due to its complete lack of anything
> resembling security.
Just curious - where do you get your info re PHPBB's "complete lack
of anythng resembling security"? I've been considering using that
software, and would l
What would people recommendation be for Bulleting Board software. I am
after something that uses PostgreSQL and has similar features of
PHPBB. I don't want to use PHPBB due to its complete lack of anything
resembling security.
--
Harry
http://www.hjackson.org
http://www.uklug.co.uk
--
Hello!
I'm developing application uses PG as backend.
A recent stress test found out a serious trouble. Briefly,
libpq does not return control after COMMIT, while
commit actually happened Ok.
It is not quite reproducible: the test hangs during commiting
different transactions. If I terminate PG s
40 matches
Mail list logo
