I’m trying to connect ruby to postgres on ubuntu and the only link I
found that has the library is down. Does anyone have the postgres
library for ruby? Or direct me to it?
Yeah, I think this is an area that we need to address if we want to see
wider adoption of Postgres. I started out to wr
2009/6/2 björn lundin
>
> > CREATE TABLE "DataImport"
> > (
> > "DataImportID" serial NOT NULL PRIMARY KEY,
> > "Time" timestamp without time zone NOT NULL,
> > "ID_ABC" integer NOT NULL,
> > "ID_DEF" integer NOT NULL,
> > "ID_HIJ" integer NOT NULL,
> > etc
> > );
>
> Perhaps you want
Craig de Stigter writes:
> Does anyone have any idea why these numbers would be 4 times as big in
> Postgres 8.3.7 ?
It still doesn't make any sense to me that you're getting values larger
than the BLCKSZ. If you look into where that's coming from you might
get a clue what's up with the version
This query was giving us good-enough results on our old system. The
estimates don't have to be absolutely accurate, just ballpark figures.
Also we are estimating the size of zipped shapefiles, not textual
geometries.
Our tests show that such sizes are quite accurate for medium/large
datasets when
Mason Hale writes:
> I'm seeing some odd warning in my postgres (8.3.6) logs.
> 2009-06-01 20:01:59 UTC (10.11.199.136)LOG: process 7070 still
> waiting for ExclusiveLock on extension of relation 43911 of database
> 43623 after 1001.240 ms
Have you looked up the OIDs to see exactly which tables
Hello --
I'm seeing some odd warning in my postgres (8.3.6) logs.
2009-06-01 20:01:59 UTC (10.11.199.136)LOG: process 7070 still
waiting for ExclusiveLock on extension of relation 43911 of database
43623 after 1001.240 ms
2009-06-01 20:01:59 UTC (10.11.199.136)LOG: process 7070 acquired
Exclusi
Sven W writes:
> I have a volatile function (trigger) that gathers NEW.*, parses them, then
> inserts a
> subset of values into a different table.
> The table is set up as an inherited table where the parent table has a RULE :
> CREATE RULE myrule AS ON INSERT TO mytable WHERE ( myfield >= 100
I have a volatile function (trigger) that gathers NEW.*, parses them, then inserts a
subset of values into a different table.
The table is set up as an inherited table where the parent table has a RULE :
CREATE RULE myrule AS ON INSERT TO mytable WHERE ( myfield >= 100 and myfield < 200)
DO IN
Hello
I have a table that I'm trying to refactor and I'm by no means a SQL
expert (apologies if I'm posting to the wrong group). The table in
question has a column that allows NULLs. I want to move that column
into a separate table and set up a FK reference back to the original
table. My question
Pavel Stehule wrote:
2009/6/1 Grzegorz Jaśkiewicz :
That's one of things pg xml type lacks ... :/
yes - SQL/XML isn't completed yet
http://wiki.postgresql.org/wiki/XML_Support :(
I believe so some procedure like xml_to_table should be nice.
but plperlu code should be simple (as perl code sh
Hi Tom,
Thank you for pointing out the condition under which this occurs, I
had not made the connection that the check was only occurring when the
value in the other columns with foreign keys are null. I agree 100%
that a strict key equality check that is in general use in the
database should not r
On Mon, Jun 1, 2009 at 2:35 PM, Tom Lane wrote:
> Sava Chankov writes:
>> Is there a way to make RETURNING return all view columns?
>
> Something like
>
> CREATE RULE _insert AS ON INSERT TO j DO INSTEAD(
> INSERT INTO a (id,name) VALUES (NEW.id, NEW.name);
> INSERT INTO b (id,surname) VALUES (
2009/6/1 björn lundin :
>
>> CREATE TABLE "DataImport"
>> (
>> "DataImportID" serial NOT NULL PRIMARY KEY,
>> "Time" timestamp without time zone NOT NULL,
>> "ID_ABC" integer NOT NULL,
>> "ID_DEF" integer NOT NULL,
>> "ID_HIJ" integer NOT NULL,
>> etc
>> );
>
> Perhaps you want to not u
> CREATE TABLE "DataImport"
> (
> "DataImportID" serial NOT NULL PRIMARY KEY,
> "Time" timestamp without time zone NOT NULL,
> "ID_ABC" integer NOT NULL,
> "ID_DEF" integer NOT NULL,
> "ID_HIJ" integer NOT NULL,
> etc
> );
Perhaps you want to not use the "" around the table and column
Sava Chankov writes:
> Is there a way to make RETURNING return all view columns?
Something like
CREATE RULE _insert AS ON INSERT TO j DO INSTEAD(
INSERT INTO a (id,name) VALUES (NEW.id, NEW.name);
INSERT INTO b (id,surname) VALUES (NEW.id,NEW.surname)
RETURNING id, (SELECT name FROM a WH
I'd like to manually alter the statistics for a column, as for the column in
question the statistics are causing Postgres to do the wrong thing for my
purposes. (I.e., a Seq Scan, rather than an Index Scan.) If someone can
tell me how to achieve this, I would quite grateful.
Thanks!
|>ouglas
P.
I have a view that joins several tables and want to create unconditional
INSERT RETURNING rule for it. I succeeded by specifying the RETURNING clause
for the first INSERT in the rule, casting NULL for columns that are not
present in that table to the correct type:
CREATE TABLE a (id SERIAL PRIMARY
Tom Lane wrote:
> However, this is really just cosmetic, as the dump is set up like this:
>
> SET default_tablespace = whatever;
> CREATE TABLE whichever(...);
>
> If tablespace 'whatever' doesn't exist, you'll get an error on the SET
> but the CREATE will succeed anyway. (I guess this only wor
Justin Carrera wrote:
I will remember that for next time.
Thank you for the link.
I tried installing the gem but unsuccessful...
r...@codeho:/home/justin/Documents/ruby# gem install postgres --
--with-pgsql-include=/opt/PostgreSQL/8.3/include
--with-pgsql-lib=/opt/PostgreSQL/8.3/lib
Buildin
Luca Ferrari writes:
> is there a way to dump an entire database which has a specific table space
> without having in the sql file any reference to the tablespace? This can be
> useful when moving the database from one machine to another (that does not
> use
> the tablespace). Any way to achie
j-lists writes:
> I have an update statement that affects every row in a given table.
> For that table it changes the value in a single column, which itself
> has a foreign key constraint. The table has an additional 9 foreign
> keys, some of which reference large tables.
> My expectation would be
Justin Carrera wrote:
Hi,
I'm trying to connect ruby to postgres on ubuntu and the only link I
found that has the library is down.
Details of the link might have helped the other readers on this list.
The owner might not know.
Does anyone have the postgres
library for ruby? Or direct me
On Mon, 1 Jun 2009, Scara Maccai wrote:
"The Solaris ZFS file system is safe with disk write-cache enabled because it issues
its own disk cache flush commands"
Could someone explain?
There are discussion of this with more information at:
http://www.solarisinternals.com/wiki/index.php/ZFS_Evi
Hi,
I'm trying to connect ruby to postgres on ubuntu and the only link I found that
has the library is down. Does anyone have the postgres library for ruby? Or
direct me to it?
Thank you Tom for looking at this.
I would be pleased to help on testing the fix when available.
My plan is to store Informix INTERVALs (coming from the 4gl applications we
support) into PostgreSQL INTERVALs, and I have a bunch of tests for that...
I believe Informix INTERVALs (and related oper
one word, horizontal structure. you are trying to sort 1500 colums,
instead of creating 1500 rows per entry...
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Mon, Jun 01, 2009 at 06:53:30AM -0500, Chris Spotts wrote:
> I just finished doing something very close to this - not quite once per
> minute, but close. I started off with an array of integers and after about
> a month of it, I'm having to redesign my way out of it.
I've had to go the other w
I just finished doing something very close to this - not quite once per
minute, but close. I started off with an array of integers and after about
a month of it, I'm having to redesign my way out of it. It would have
worked fine, but you just have to be sure that simple searches is all you're
eve
On 2009-06-01, Scara Maccai wrote:
>
> "The Solaris ZFS file system is safe with disk write-cache enabled because it
> issues its own disk cache flush commands"
> Could someone explain?
this means ZFS cofigured as described is suitable for the postgres
data (and *log) directories
> would that
2009/6/1 Grzegorz Jaśkiewicz :
> That's one of things pg xml type lacks ... :/
yes - SQL/XML isn't completed yet
http://wiki.postgresql.org/wiki/XML_Support :(
I believe so some procedure like xml_to_table should be nice.
but plperlu code should be simple (as perl code should be :)) and fast
That's one of things pg xml type lacks ... :/
I just need that to get some real xml, and convert to table once, so I
should be fine with xpath, but ... heh. This is so ugly.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.post
Hello
you can use simple perl parser
an sample is on
http://www.postgres.cz/index.php/PL/Perlu_-_Untrusted_Perl#Generov.C3.A1n.C3.AD.2C_zpracov.C3.A1n.C3.AD_XML
code is in english and perl, description in czech, sorry
regards
Pavel Stehule
2009/6/1 Grzegorz Jaśkiewicz :
> xpath is fine, but no
On Mon, Jun 01, 2009 at 11:22:14AM +0100, Grzegorz Jaaakiewicz wrote:
> xpath is fine, but not when you have 10+ fields to extract ;)
I've got a few views pulling 10 to 15 values out of XML files and
it works OK, not amazing performance but for what I'm doing it's no
problem. Scaling beyond that
On 2009-05-28, Marcos Davi Reis wrote:
> --0016e6dbdf4d580089046afca05f
> Content-Type: text/plain; charset=ISO-8859-1
> Content-Transfer-Encoding: 7bit
>
> Hello All,
>
> I did install the pgsql 8.3.7 on Ubuntu 8.04 using apt-get, now i need to
> install pldebugger (edb-debugger) to write complex
xpath is fine, but not when you have 10+ fields to extract ;)
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Mon, Jun 01, 2009 at 10:53:08AM +0100, Grzegorz Jaaakiewicz wrote:
> is there any way currently to convert xml file in format like below,
> to a table ?
I've had good luck with the xpath support in PG[1] and some variant of
the "unnest" function that's in PG 8.4 (various versions[2] have been
p
On Sun, May 31, 2009 at 11:54:09PM +0800, Andrew Smith wrote:
> I'm a beginner when it comes to Postgresql, and have a table design question
> about a project I'm currently working on. I have 1500 data items that need
> to be copied every minute from an external system into my database. The
> ite
is there any way currently to convert xml file in format like below,
to a table ?
...
...
...
--
GJ
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www
On 2009-05-27, Gauthier, Dave wrote:
> --_000_482E80323A35A54498B8B70FF2B87980040AEFF544azsmsx504amrc_
> Content-Type: text/plain; charset="us-ascii"
> Content-Transfer-Encoding: quoted-printable
>
> What is the (is there a) grant command that I can use to create a super use=
> r without having to
John R Pierce wrote:
Luca Ferrari wrote:
Hi,
is there a way to dump an entire database which has a specific table
space without having in the sql file any reference to the tablespace?
This can be useful when moving the database from one machine to
another (that does not use the tablespace). A
"The Solaris ZFS file system is safe with disk write-cache enabled because it
issues its own disk cache flush commands"
Could someone explain?
would that mean that I checking the disk cache with "format -e" on Solaris is
not needed if I use ZFS
Thanks
--
Sent via pgsql-general maili
Luca Ferrari wrote:
Hi,
is there a way to dump an entire database which has a specific table space
without having in the sql file any reference to the tablespace? This can be
useful when moving the database from one machine to another (that does not use
the tablespace). Any way to achieve that
42 matches
Mail list logo
