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
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
--
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
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 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 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 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 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
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).
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
"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
>> 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
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
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
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
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
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
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
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
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
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 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 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
--- 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.
> >
>
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
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
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
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:
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
--- 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
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
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
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
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
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
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
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
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
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
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
40 matches
Mail list logo
