Hi Stuart,
I have seen some form generators, but for some reason or the other
they always partially worked,
or never fit my dataset because more often then others they assume
very simple relations.
Nowdays I tend to use Adobe Flex for a lot of my work (there are some
form generators for
III shows in the SQL pane when you click on a table. MySQL
appears to have an equivalent which is SHOW CREATE table [tablename].
Thanks
Thom
Less clicking: Hotmail access on the new MSN homepage.
regards, Ries
On Sep 3, 2009, at 12:17 PM, Gauthier, Dave wrote:
In linux, given the linux based uid of the user, how might someone
implement column level update restrictions on a uid basis? For
example...
create table foo (strcol varchar(256), intcol integer);
Now, I want linux processes runing under
index size.
I thing so you can write own C function, that can check string
faster
than repeated LIKE
some like
SELECT * FROM tbl WHERE contains(datanumber, '12345','54321',)
regards
Pavel Stehule
2009/8/26 Ries van Twisk :
Hey All,
I am wondering if there is a common
n solution we
where wondering if there already common solutions for this...
Kind Regards,
Ries van Twisk
s any collateral effects? Any
suggestions?
Thanks!
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
regards, Ries van
On Jul 20, 2009, at 8:56 PM, Dennis Gearon wrote:
I once talked to a company that made a custome version of Postgres.
It split tables up on columns and also by rows, had some other
custome features. It was enormously faster from what I gathered.
I could of sworn it began with the letter
, +007(495)939-23-83
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
regards, Ries van Twisk
---------
bles Lopez.
Analista Programador.
regards, Ries van Twisk
---------
Ries van Twisk
tags: Freelance TYPO3 Glassfish JasperReports JasperETL Flex Blaze-DS
WebORB PostgreSQL DB
On May 6, 2009, at 4:16 PM, Eric Schwarzenbach wrote:
Gauthier, Dave wrote:
Is there a way to read an XML file into a postgres DB? I’m thinking
that it will create and relate whatever tables are necessary to
reflect whatever’s implied by the XML file structure.
Thanks for any pointers !
once you
know a bit more about PostgreSQL's internals.
Ries
Thanks for the replies,
Michael
regards, Ries van Twisk
-----
Ries van Twisk
tags: Freelance TYPO3 Glassfish Ja
On Apr 5, 2009, at 1:28 PM, Jennifer Trey wrote:
Hi, I am trying to create my DB schema on the server through my
development laptop.
I have installed Web Server 2008 and PostgreSQL. They are both
running. For some reason its not working.
Define : "it's"
Do I need to open some firewall
hey all,
I have a stored procedure that updates a couple of tables within my
database.
org.postgresql.util.PSQLException : ERROR: deadlock detected
Detail: Process 31580 waits for AccessExclusiveLock on relation
289553 of database 285107; blocked by process 16024.
Process 16024 waits for
Without knowing to much currently..
can you create one table with enough columns?
Then create a view to query the table and 'reflect' the changes and
correct column names.
Using rule you could also even simulate the update to the view and
update to the correct columns.
This so that you don't
On Mar 29, 2009, at 10:04 AM, Michael Black wrote:
First, I am relatively new to postgres, but have been using database
(design not administering) for about 20 years (you would think that
I could figure this out - lol). At an rate, I am trying to create
tables that have forgein keys via a
Deepak,
please don't cross-post the same question to 3 different lists.
The short answer is no, you cannot force PostgreSQL to load all
objects into memory.
However when you proper configure PostgreSQL most, if not all of your
data will be cached
by the OS and/or PostgreSQL shared memory
Deepak,
please don't cross-post the same question to 3 different lists.
The short answer is no, you cannot force PostgreSQL to load all
objects into memory.
However when you proper configure PostgreSQL most, if not all of your
data will be cached
by the OS and/or PostgreSQL shared memory
On Mar 23, 2009, at 2:54 PM, Jacek Becla wrote:
Hi,
Can someone explain why postgres complains in this case:
create table t(d real, check(d>=0.00603));
insert into t values (0.00603);
ERROR: new row for relation "t" violates check constraint "t_d_check"
thanks
Jacek
try this:
insert in
s the biggest
advantage.
IMO-YMMV.
P.S.
I'm a PostgreSQL fan and so I am likely to (perhaps unconsciously)
favor
PostgreSQL in my remarks.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
htt
On Mar 19, 2009, at 11:53 AM, ANKITBHATNAGAR wrote:
Hi
This happens when I import csv file via my app into postgres.
The csv file has some “hello” from microsoft word 2003.
In postgres it appears as �hello�
Could somebody help on this?
Check your encodings.
Ries
Ankit
--
Sent via p
Jessi,
should the function not look like this???
CREATE OR REPLACE VIEW test_view AS
SELECT
CASE
WHEN random() < .3 THEN '1'
WHEN random() < .5 THEN '2'
ELSE '3'
END AS test_value
FROM client;
On Feb 23, 2009, at 5:09 PM,
ou set your mind away from
restoring a DB by replacing a fileset. pg_dump/pg_restore are your
friends. If you do care about restoring a DB up to a point in time you
can do WAL shipping.
Thanks for your help:
dd
regards, Ries van Twisk
--
On Jan 20, 2009, at 11:27 PM, Együd Csaba wrote:
-Original Message-
From: Robert Treat [mailto:xzi...@users.sourceforge.net]
Sent: Wednesday, January 21, 2009 3:51 AM
To: pgsql-general@postgresql.org
Cc: David Fetter; Csaba Együd
Subject: Re: [GENERAL] Database schema & data synchronize
hey All,
(Resend from novice)
I if a problem that apparently I can insert a record into my table
with a constrain while in fact the reference doesn't exist:
On the table acc_ops.tbl_part_status I have the following constrain
added:
CONSTRAINT fk_tbl_part_status_2 FOREIGN KEY (part_num)
On Dec 18, 2008, at 10:19 PM, Star Liu wrote:
On Tue, Dec 16, 2008 at 2:02 PM, sai srujan
wrote:
Hi
This is srujan and I am beginner of postgresql 8.1 and
I have
just stopped using mysql and i would like to use the dump (.sql file)
created in it. I would like transfer the
On Nov 29, 2008, at 4:05 PM, ries van Twisk wrote:
On Nov 29, 2008, at 3:56 PM, Steve Henry wrote:
I am just getting started with PostgreSQL. I've installed
PostgreSQL 8.3.5-1 on a MacPro server running Leopard Server 105.5
I can connect to the database with PGAdmin on the server,
ght block incoming requests on port
5432??
regards, Ries van Twisk
---------
Ries van Twisk
tags: Freelance TYPO3 Glassfish JasperReports JasperETL Flex Blaze-DS
WebORB PostgreS
On Nov 21, 2008, at 5:26 PM, pw wrote:
Hello,
Is there a syntax for querying another database
from a trigger in the current database?
Thanks for any info,
P
Generally we would say DBLink or DBI-Link
Ries
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
T
On Nov 18, 2008, at 9:47 AM, Erwin Moller wrote:
Hi group,
Considering following (simplified) example:
CREATE TABLE tblnr1(
nr1id SERIAL PRIMARY KEY,
firstname TEXT
);
CREATE TABLE tblnr2(
nr2id SERIAL PRIMARY KEY,
nr1id INTEGER REFERENCES tblnr1(nr1id)
);
CREATE TABLE tblnr3(
nr3id SERIAL P
changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
regards, Ries van Twisk
-
A: Because it messes up the order in which people normally read text
EMAIL PROTECTED]
Does that mean a reply should go back to the sender :D Just
kidding
anyways.. I don't care anymore... I will do a reply all.
regards, Ries van Twisk
-
On Oct 23, 2008, at 12:25 PM, Collin Kidder wrote:
Bruce Momjian wrote:
Mikkel is right, every other well-organized mailing list I've ever
been on handles things the sensible way he suggests, but everybody
on his side who's been on lists here for a while already knows
this issue is a de
May be this function can help :
http://www.postgresql.org/docs/8.3/static/functions-srf.html
Ries
On Oct 15, 2008, at 1:44 PM, Mark Morgan Lloyd wrote:
Is there an easy way to assign a sequential number, possibly based
on an arbitrary minimum (typically 0 or 1) to each row of an ordered
res
On Oct 13, 2008, at 4:08 AM, admin wrote:
I am also evaluating Drupal + PostgreSQL at the moment. We are
building a local government website/intranet that doesn't need to be
lightning fast or handle millions of hits a day, but it does need to
be rock solid and potentially needs to manage c
On Oct 6, 2008, at 10:11 AM, Scott Marlowe wrote:
On Mon, Oct 6, 2008 at 8:40 AM, ries van Twisk <[EMAIL PROTECTED]> wrote:
On Oct 6, 2008, at 9:11 AM, Jeff Amiel wrote:
I performed a pg_dump on a database and created a new schema-only
database
to copy that data into.
However
On Oct 6, 2008, at 9:11 AM, Jeff Amiel wrote:
I performed a pg_dump on a database and created a new schema-only
database to copy that data into.
However trying to use psql -f to load the data in, I get a plethora
of syntax errors including the dreaded "invalid command \N".
I even tried
On Sep 25, 2008, at 4:59 PM, x asasaxax wrote:
Hi everyone,
I have this table:
create table cat(
cod integer,
cod_super integer,
constraint cod_super_fk Foreign Key(cod_super) references cat(cod),
constraint cod_pk Primary Key(cod)
);
insert into cat values(0, 1);
insert into cat val
Hey All,
anybody happen to know if there is a java class 'somewhere' to insert/
update a hstore field in PostgreSQL?
Ries
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Aug 21, 2008, at 2:23 PM, Peter Billen wrote:
Oops, my example was a bit incorrectly edited.
I wanted to say that the range of a serial datatype goes from 1 to 5
(incluse) and I insert five entries (not 10).
Peter
Peter Billen schreef:
Hi all,
I would like to ask a question about the
On Aug 13, 2008, at 4:25 PM, Ivan Sergio Borgonovo wrote:
I need to write an import function with enough isolation from apache
daemon.
Code has no input other than cvs files and a signal about when to
start the import.
The sql code that will be executed will be static.
I may end up writing a mi
On Aug 12, 2008, at 3:53 AM, Willy-Bas Loos wrote:
reproduced it on:
"PostgreSQL 8.3.3 on i486-pc-linux-gnu, compiled by GCC cc (GCC)
4.2.3 (Ubuntu 4.2.3-2ubuntu7)"
3 rows with index, 2 rows without.
can not reproduce it on:
- "PostgreSQL 8.1.10 on i486-pc-linux-gnu, compiled by GCC cc (GCC
On Aug 12, 2008, at 3:53 AM, Willy-Bas Loos wrote:
reproduced it on:
"PostgreSQL 8.3.3 on i486-pc-linux-gnu, compiled by GCC cc (GCC)
4.2.3 (Ubuntu 4.2.3-2ubuntu7)"
3 rows with index, 2 rows without.
can not reproduce it on:
- "PostgreSQL 8.1.10 on i486-pc-linux-gnu, compiled by GCC cc (GCC
42 matches
Mail list logo