/dumpfile | git fast-import
git reset --hard
cd ..
---
Regards,
Khee Chin.
On Wed, Aug 18, 2010 at 11:14 PM, Alvaro Herrera wrote:
> Excerpts from Michael Haggerty's message of miƩ ago 18 05:01:29 -0400 2010:
>
> > cvs2git doesn't currently have this option. I'
CREATE TABLE
testdb=> \d foo3;
Table "public.foo3"
Column | Type | Modifiers
+-+---
id | integer | not null
Indexes:
"foo3_pkey" PRIMARY KEY, btree (id)
testdb=>
Regards,
Khee Chin.
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
Happy birthday Tom, from the sunny island of Singapore. :-)
Regards,
Khee Chin.
On Fri, Sep 18, 2009 at 7:04 PM, Hans-Juergen Schoenig -- PostgreSQL
wrote:
> Tom,
>
> On behalf of the entire PostgreSQL team here in Austria I want to wish you a
> happy birthday.
> We hope tha
Definition
-+--+--
pg_expression_1 | text | md5(a::text)
pg_expression_2 | text | md5(a || b)
btree, for table "public.foo"
postgres=#
--
Regards,
Khee Chin.
index.patch
Description: Binary data
--
Sent via pgsql-hackers mailing list (pgsql-ha
List of relations
Schema | Name | Type | Owner | Table | Method |
Definition
+-+---+--+---++---
public | idx_foo_bt_fooi | index | postgres | foo | btree |
md5((a)::text), md5((a || b))
(1 row)
postgres=#
Regards,
Kh
Updated with an additional line in the comments for get_indexdef
* if colno == -999, we only want the name of the variables that
make up the index
Apologies for leaving this out in my earlier post.
Regards,
Khee Chin.
index.patch
Description: Binary data
--
Sent via pgsql-hackers
s "Expression"
FROM pg_catalog.pg_class c
LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_catalog.pg_index i ON i.indexrelid = c.oid
LEFT JOIN pg_catalog.pg_class c2 ON i.indrelid = c2.oid
LEFT JOIN pg_catalog.pg_am am ON am.oid = c.relam
WHERE c.relkind IN ('i','s',
>
> Please add it to wiki.postgresql.org/wiki/CommitFestInProgress
>
Submitted under http://wiki.postgresql.org/wiki/CommitFest_2009-First#Clients
Regards,
Khee Chin.
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscript
| Table | Method
> +---+---+++
> public | test_id_idx | index | postgresql | table1 | btree
> public | test_name_idx | index | postgresql | table1 | hash
> (2 rows)
Attached is a simple patch which adds the above mentioned functionality to psql.
Regards,
Khee C
used by
pg_dumpall on tables created with a fill-factor in 8.3.
After some debugging in reloptions.c, I've realised that the issue is
caused by fillfactor not having a validnsps in transformRelOptions.
Adding an additional condition "&& (validnsps))" at line 595 or 612
appe
10 matches
Mail list logo