Re: [GENERAL] Thoughts on a Isolation/Security problem

> > Date: Tue, 18 Apr 2006 13:44:34 +0300 (EEST) > > From: Achilleus Mantzios <[EMAIL PROTECTED]> > > To: pgsql-sql@postgresql.org, , > > > > Cc: pgsql-jdbc@postgresql.org > > Subject: Thoughts on a Isolation/Security problem. > > Message-ID: > > <

Re: [GENERAL] [SQL] Thoughts on a Isolation/Security problem.

y , Organization, where you can > have company1, org1, org2 etc., this can also be applied in the same pattern > as stated above. Thanx for your thoughts, but this would require touching 173 tables + 2,594 SQL statements in a sum of 324 programs (which sum into 125,085 lines of code) >

Re: [GENERAL] [JDBC] Thoughts on a Isolation/Security problem.

O Markus Schaber έγραψε στις Apr 18, 2006 : > Hi, Achilleus, > > Achilleus Mantzios wrote: > > > Now i am thinking of restructuring the whole architecture as: > > - Create one EAR app for every mgmt company > > - Create one DB USER for every mgmg company > &

[GENERAL] Thoughts on a Isolation/Security problem.

Hi, i have run into the following problem. Let me describe the context first. When i joined the company(ies) i work for (a group of Shipping Mgmt/ Owenship/Agent companies), the only thing i was told when i started designing the DB/Apps was just one company. So i built everything into one single

Re: [GENERAL] Kernel 2.4->2.6 upgrade results in PANIC: could not locate a

Problem solved. The sysadmins yesterday forgot to mention to me that they didnt mount correctly all the file systems (including the one of pg_xlog). Sorry for the noise :-) O Achilleus Mantzios έγραψε στις Apr 14, 2006 : > > Hi, we have happily been running postgresql 7.4.x (currently

[GENERAL] Kernel 2.4->2.6 upgrade results in PANIC: could not locate a valid checkpoint record

Hi, we have happily been running postgresql 7.4.x (currently 7.4.12) on a debian linux with kernel 2.4.x for some years without any issues. Yesterday after switching to 2.6.16 we experienced the following problem upon pgsql startup: LOG: could not open file "/var/lib/pgsql/data/pg_xlog/0069

Re: [GENERAL] [SQL] Flight numbers data

O Josh Rovero έγραψε στις Mar 29, 2006 : > We built an operational flight tracking and weather system that uses > Postgresql, > http://www.sonalysts.com/wXstation > > One data feed (FAA ASDI) uses both aircraft registration > numbers (tail numbers) and airline-assigned flight numbers. Typicall

Re: [GENERAL] [SQL] Flight numbers data

O Scott Marlowe έγραψε στις Mar 29, 2006 : > On Wed, 2006-03-29 at 02:17, Achilleus Mantzios wrote: > > Hi, i am in the process of writing an application about > > tickets, flights, etc, and i am thinking of getting the primitive > > data ready at the begining and doing it th

[GENERAL] Flight numbers data

Hi, i am in the process of writing an application about tickets, flights, etc, and i am thinking of getting the primitive data ready at the begining and doing it the right way, (e.g. the user will just select a flight number and doesnt have to enter the airports, airport coordinates, countries, ai

[GENERAL] Proposed dbmirror change

hi again i made one mod to dbmirror. 1) I implemented a mechanism to exclude attributes (columns) from dbmirror'ed tables. I added one table CREATE TABLE dbmirror_exclude_attributes ( tblname character varying(100) NOT NULL, attnames text[] NOT NULL ); ALTER TABLE ONLY dbmirror_exclu

Re: [GENERAL] DBMirror.pl performance change

Peter, It is much more convinient for you to make a test, (just change the last function in DBmirror.pl), than for me (grab whitebeam, compile for FreeBSD, etc...) Of course you would need to use the original .conf format than the one you are using now. It would be interesting to see some number

[GENERAL] DBMirror.pl performance change

I discovered a problem in DBMirror.pl, performance wise. pending.c stores data in a way very similar to the PgSQL input "\" escaped format. When the field is of type bytea, and the source of data is binary, then this produces 2 additional backslashes for every unprintable char. The performance

Re: [GENERAL] [SQL] How to add 1 hour in a date or time stamp?

O Dinesh Pandey έγραψε στις Apr 18, 2005 : > > > How to add 1 hour in a date or time stamp? # SELECT now() + '1 hour'::interval; > > Regards > Dinesh Pandey > > > > -- > > > > > > -- -Achilleus ---

Re: [GENERAL] [SQL] Get current trasanction id

O Marek Lewczuk έγραψε στις Dec 27, 2004 : > Hello, > is there any way to get current transaction id using plpgsql or sql ? Maybe write a C function which calls GetCurrentTransactionId(). > > Thanks in advance for any help. > > ML > > > > ---(end of broadcast)--

[GENERAL] Conditional row grained + FK dependency oriented lazy replication

Thanx. -- Achilleus Mantzios S/W Engineer IT dept Dynacom Tankers Mngmt Nikis 4, Glyfada Athens 16610 Greece tel:+30-10-8981112 fax:+30-10-8981877 email: achill ( at ) matrix ( dot ) gatewaynet ( dot ) com mantzios ( at ) softlab ( dot ) ece ( dot ) ntua ( dot