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
to create what
pgAdmin 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 van Twisk
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
size of 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 p...@rvt.dds.nl:
Hey All,
I am wondering
for this...
Kind Regards,
Ries van Twisk
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 Twisk
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
@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
regards, Ries van Twisk
-
Ries van Twisk
tags: Freelance TYPO3 Glassfish
Programador.
regards, Ries van Twisk
-
Ries van Twisk
tags: Freelance TYPO3 Glassfish JasperReports JasperETL Flex Blaze-DS
WebORB PostgreSQL DB-Architect
email: r
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 !
regards, Ries van Twisk
-
Ries van Twisk
tags: Freelance TYPO3 Glassfish JasperReports JasperETL Flex Blaze-DS
WebORB PostgreSQL DB-Architect
email: r...@vantwisk.nl
web: http://www.rvantwisk.nl/
skype
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
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
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 into t
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
unconsciously)
favor
PostgreSQL in my remarks.
--
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
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,
you
can do WAL shipping.
Thanks for your help:
dd
regards, Ries van Twisk
-
Ries van Twisk
tags: Freelance TYPO3 Glassfish JasperReports JasperETL Flex Blaze
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
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
creativesru...@gmail.com 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.
on port
5432??
regards, Ries van Twisk
-
Ries van Twisk
tags: Freelance TYPO3 Glassfish JasperReports JasperETL Flex Blaze-DS
WebORB PostgreSQL DB-Architect
email: [EMAIL
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, but I
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)
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
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.
Q: Why is top
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
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
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
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
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 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 trying
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
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
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 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
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