I am new to the databasing market, and am currently working on a complex
database that relies heavily on dynamically created tables for data storage. My
partner and I have therefore been trying to find a front end utility that can
handle using tables with names that aren't known at compile time.
Considering using the firefox SQL extension combined with XUL to create a web
application to access a database in PostGreSQL, wondering if anyone has
attempted this, and how it turned out?
Matthew Story
---(end of broadcast)---
TIP 9: the planner
I'm using v. 7.4.2, and am encountering a problem with serial types. On an
insert into a table that results in failure for any number of reasone (mostly
violation of contraints) I've found that the Sequence for the column of type
serial will still bump the value up once. This can be seen when en
My mistake, in the future i will consult the FAQ first, though i'm a bit
surprised i missed it in the documentation. Much thanks for the help. By
generic uses i guess i meant the uses one might have for creating a sequence as
an independant object in the database, and not the sequence in a table,
We're looking into building a front end for our database in python.
The database in question is an educational database, that generates
new tables for each teacher, class and student. Was wondering if
anyone had any recommendations for similar projects to look at,
resources, and general informat
I've looked into pshycho pg, it appears to be the best option, my later question
now remains, what documentation or examples would be useful in developing a
completely proprietary front end written in python. Any help finding useful
examples or documentation would be greatly appreciated.
thanks,
- Forwarded message from Matthew Story <[EMAIL PROTECTED]> -
Date: Sun, 9 Jan 2005 12:40:36 -0600
From: Matthew Story <[EMAIL PROTECTED]>
Reply-To: Matthew Story <[EMAIL PROTECTED]>
Subject: Re: [GENERAL] PYTHON, ODBC
To: Pierre-Frédéric Caillaud <[EMAIL PROTECTED]>
we won
I need to know the day of the week for a schedule rotation algorithm i'm working
on. Initially i was going to use the function for day of the year and week of
the year to find the first day of the year, but it seems like it would be easier
to use the postgres, dmy format and then parse the strin
I've searched the documentation for a simple way to delete a single value from
an array, i've come up with a complecated way to do it, but was wondering if
there was some simple command to remove a single value from an array, where the
position of the value in the array is unknown.
thanks,
matt
I need a way to link every user name to a unique ID held in a table in the
database. I've tried several ways of doing this but all of which are not secure
enough. It's essential that no one be able to view the user names, though the
unique identifyers will be viewable to all users on the public
The system administrator will need to be able to see it, and will need remote
access to it.
The security requirements are extremely high, the standard in this case is set
by the state, so encryption will be a must.
the table itself will need to be accessed by triggers, so the encryption plus
the
I have a table that gets a column added to it for every insert on another table.
the general form of these columns are g_c_i_avg where i is the unique
identifyer for the insert that caused the column to be added. I need to use this
column to calculate a new value for another column in the same t
Does it have to be linux? I've never had as much success with PostGresql on
linux as i have on FreeBSD 5.3
matt
Quoting David Garamond <[EMAIL PROTECTED]>:
> Joshua D. Drake wrote:
> > Well that isnt exactly true. EXT3 is a bolt on to EXT2 which was always
> > there. Reiser is also a long time
Unless I'm grossly misunderstanding the problem i think that a trigger written
in PL/pgsql would work fine. Something like this:
CREATE TABLE foo (
foo_id SERIAL primary key,
foo TEXT);
CREATE TABLE bar (
foo_id INTEGER references foo,
bar_id SERIAL primary key,
bar DOUBLE PRECISION NOT NULL);
I personally use 3 seperate triggers on most occasions, depending on how
different the action for each seperate action is, it's just easier for me and my
people to logically distinguish the functions that way, but the example in the
7.4 documentation for triggers is given using the form that i wrot
I'm writing a 2 dimensional array INTEGER[3][] that holds data that i need to
parse through to check for zeros. The user will insert into this array one row
at a time, when i insert the first row into this array it works fine but when i
check array_dims it gives me [1:3] not the [1:3][1:1] that
16 matches
Mail list logo
