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
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 like
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
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 resembling
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 condition.
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
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
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 got this:
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,
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
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
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
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
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
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 on older
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
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.
a|b|c
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
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 = NULL WHERE
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
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 pgsql-general@postgresql.org
Sent: Fri,
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 along
--- 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 UPDATE ONLY
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 various
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
variables
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 enforce
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
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 whenever
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)
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:
37 matches
Mail list logo