PostgreSQL sequences in Rails
39 comments Latest by Anthony Davis Jersey Fri, 30 Dec 2011 08:53:26 GMT
Rails doesn’t support legacy or custom named sequences at the moment. (as far as I am aware). It’s kind of tricky to have it detect the SEQUENCE name automatically (every time).
$sql = $db->prepare("SELECT seq.relname::text
FROM pg_class src, pg_class seq, pg_namespace, pg_attribute,
pg_depend
WHERE
pg_depend.refobjsubid = pg_attribute.attnum AND
pg_depend.refobjid = src.oid AND
seq.oid = pg_depend.objid AND
src.relnamespace = pg_namespace.oid AND
pg_attribute.attrelid = src.oid AND
pg_namespace.nspname = ? AND
src.relname = ? AND
pg_attribute.attname = ?");
I used this to mimmick the mysql_insert_id function in PHP for PostgreSQL… ( pg_insert_id )
Well, with Rails, I thought that I would build a similar patch, as the current code just assumes the value would be {column}_id_seq.
After hours of playing around and thinking that I figured it all out ... I decided to run a quick test with a non standard sequence name… like this one:
testingdb=# \d legacy.foobar
Table "legacy.foobar"
Column | Type | Modifiers
-----------+-----------------------+------------------------------------------------------------
foobar_id | integer | not null default nextval('legacy.old_sequence_name'::text)
name | character varying(40) |
Indexes:
"foobar_pkey" PRIMARY KEY, btree (foobar_id)
testingdb=# INSERT INTO legacy.foobar (name) VALUES ('abc')
testingdb-# ;
INSERT 17514 1
testingdb=# SELECT * FROM legacy.foobar ;
foobar_id | name
-----------+------
106 | abc
(1 row)
My patch wouldn’t figure that out because the sequence was not created by SERIAL. So, my patch started to feel lame and a total waste of time, because I thought that it was fixing a problem.. that works pretty much as effectively as assuming it is _seq.. but without needing to run a SQL query to determine that. We all (should) know that the field will be named like that when working with SERIAL. So, my patch didn’t buy us anything.
However, Active Record still doesn’t support those funky sequence names. So, I found this ticket #1273.
Their approach was very similar to what caused me to use my long SQL query in the first place because this was suggested to me well over a year ago and I found it to not work in the following situation.
If I have two seperate schemas with the same table name in each like so:
=# \d legacy.people
Table "legacy.people"
Column | Type | Modifiers
-----------+-----------------------+---------------------------------------------------------------
people_id | integer | not null default nextval('legacy.people_people_id_seq'::text)
name | character varying(50) |
Indexes:
"people_pkey" PRIMARY KEY, btree (people_id)
=# \d foo.people
Table "foo.people"
Column | Type | Modifiers
-----------+-----------------------+------------------------------------------------------------
people_id | integer | not null default nextval('foo.people_people_id_seq'::text)
name | character varying(50) |
Indexes:
"people_pkey" PRIMARY KEY, btree (people_id)
That patch will not work because you can’t call the following query:
# SELECT adsrc FROM pg_attrdef WHERE adrelid = (SELECT oid FROM pg_class WHERE relname = 'people');
ERROR: more than one row returned by a subquery used as an expression
... because there are two tables with the same name! (fun, huh?)
Mine would work… but why bother with that huge query? So, I took my ticket out of [PATCH] and decided that I thought it would be best to just assume that sequences are generated with SERIAL ( link ) by default in AR.
Okay, so what can we do about custom SEQUENCE names?
Well, I am proposing the following (and mentioned this in the ticket #2016)...
class LegacyTable < ActiveRecord::Base
def self.table_name() "legacy.foobar" end
# new option for this
set_primary_key "foobar_id", :sequence => "legacy.old_sequence_name"
end
(or something along those lines)
With this, I can work around these legacy database scenarios with a quick option. Thoughts/opinions?
I decided to post this on my blog as well, because I do know that there are a few skeptical PostgreSQL people out there who read my blog… I want you to know that I am looking out for you. ;-)
I am sick and tired.. and going to sleep now.
Enjoying the content? Be sure to subscribe to my RSS feed.
I have got the same problem.
I want to use hibernate generated databases and from web ruby.
I ‘ve got no idea to influence the sequences. Have You got an idea (meanwhile) ??
Erhard
Me too… I have a view instead a table (for postgres, both are relations). How can I do? There aren’t sequences for a view. And if I try to create the sequence, postgres say something like “PGError: ERROR: currval of sequence “table_id_seq” is not yet defined in this session”. Thanks…
eduludi,
Use nextval instead on currval should work.
Ben
Thanks, but this don’t is useful to me. I ‘m using nextval. I never used curval (i check out my functions, views, tables, etc.).
stop using ActiveRecord would help… not joking!
writing skill and ability to make reader to read the while thing to the end. I would like to read more of your blogs and I recently came across your blog and have been reading along. I want to express my admiration of your to share my thoughts with you.
This is a good piece of writing mate for this particular topic. I was wondering if I could use this write-up on my website, I will link it back to your website though. If this is a problem please let me know and I will take it down right away.
TYU TYU
TYU TYU TYU
er te
tr ytr
I ‘ve got no idea to influence the sequences. Have You got an idea (meanwhile) ??
Thanks for the very helpful information.. I dont know much about this.! And im glad for your help..
Thanks for this very useful info you have provided us. I will bookmark this for future reference and refer it to my friends. More power to your blog.
replica blancpain watches replica hugo boss watches replica magico watches replica breguet watches replica breitling watches replica officina del tempo watches
replica blancpain watches replica hugo boss watches replica magico watches replica breguet watches replica breitling watches replica officina del tempo watches
http://www.uggaustraliafashionboots.com/ugg-argyle-knit-5879-boots-c-14.html > ugg 5879
Air Jordan Retro 23,Air Jordan Retro 23
Air Jordan 9.5,Air Jordan 9.5
Air Jordan 15,Air Jordan 15
Air Jordan 6 rings,Air Jordan 6 rings
Air Jordan 19,Air Jordan 19
Air Jordan Retro 2,Air Jordan Retro 2
Air Jordan Retro 6,Air Jordan Retro 6
Air Jordan 5 Retro Shoes,Air Jordan 5 Retro Shoes
Nike 977 Shoes For Sale,Nike 977 Shoes For Sale
News jordans For Sale,News jordans For Sale
air jordan dmp retro defining moments,air jordan dmp retro defining moments
air jordan fusion,air jordan fusion
air jordan fusion 3,air jordan fusion 3
air jordan force 4,air jordan force 4
air jordan force 5,air jordan force 5
Nike boot For Sale,Nike boot For Sale
We are a professional exporter and wholesaler of brand fashion products,Herve Leger Boatneck Red Dress Herve Leger Bandage Double Shoulder Purple Dress Herve Leger Bandage One Shoulder Off-white Dress Herve Leger Bronze Beaded Dress Herve Leger Bandage Mini Red Skirt，All products have good quality,fast and safe delivery without shipping fee. Our primary goal is to meet our clients’ requirement and establish mutually pleasant business relationships with you.If you are interested, please do not hesitate to contact us.
We are a professional exporter and wholesaler of brand fashion products,Coach Poppy Signature Sateen Pocket HOBO 14570 Apricot Coach Poppy Signature Spotlight Tote 13843 Apricot Coach Poppy Signature Spotlight Tote 13843 Black Coach Poppy Signature Spotlight Tote 13843 Blue Coach Poppy Signature Spotlight Tote 13843 Brown，All products have good quality,fast and safe delivery without shipping fee. Our primary goal is to meet our clients’ requirement and establish mutually pleasant business relationships with you.If you are interested, please do not hesitate to contact us.
our clients’ requirement and establish mutually pleasant business relationships with you.If you are interested, please do not hesitate to contact us.
fake dior handbags | fake Yves Saint Laurent handbags | replica hermes | replica bally handbags | fake Movado Watches | fake IWC Watches
LOS ANGELES – A man mbt clearance accused of breaking into the home of celebrity socialite Paris Hilton armed with knives pleaded not guilty Friday to a mbt walking shoes charge of attempted burglary, officials mbt anti shoes said.Nathan Lee Parada, 31, of Redlands, California, could face up to six years in prison if convicted.Police said they do not mbt shop know if Parada specifically targeted Hilton’s home or if the burglary was random.Hilton, 29, awoke in the early morning hours of Tuesday mbt Aug. 24, to someone banging on her windows. She called police, and they arrested Parada.Hilton is a member of the family that founded the Hilton chain of hotels, and she mbt shoes discontinued has frequently appeared in films and on television.Parada is due back in court on Sept. 15.
|Gucci garment bag with single 211123 FCIGG 8588 |Gucci medium carry-on duffel 206501 FCIEG 9643 |Gucci medium carry-on duffel 206501 BEG1G 1415 |Gucci medium flat messenger 189662 FAT4K 4071 |Gucci medium messenger bag 181092 FTAKG 8405 |Gucci medium messenger bag 181092 F4F5R 1060 |Gucci medium messenger bag 181092 F4F5R 9791 |Gucci medium messenger bag 181092 FT0NG 4061 |Gucci medium messenger bag 201446 FCIGG 8588 |Gucci medium messenger bag 181092 FTQ2G 8065 |Gucci messenger bag with 211107 FCIGG 8588 |Gucci messenger diaper bag 211131 BEG5G 4764 |Gucci messenger diaper bag 211131 BEG5G 6867 |Gucci shoulder bag with 201447 FP1JG 8528 |Gucci shoulder bag with zip 211110 FCIGX 8588 |Gucci small collapsible carry-on 153240 FT0NG 4061 |Gucci small messenger bag 189749 FTAKG 8405 |Gucci small messenger bag 189749 FTARG 9699 |Gucci small messenger bag 189749 F4F5R 9791 |Gucci small messenger bag 189749 FT0NG 4061 |Gucci belt bag with double 28566R F4FOR 9791 |Gucci belt bag with double 28566R F40JR 8588
thtcsk p su knx
Ed hardy brand has been listed since there are many people’s attention, and I began in Australia where frantic search ed hardy australia. See ed hardy clothing since I was fascinated, and his various types to meet all tastes.ed hardy online sales brand there are many, such as ed hardy bags, ed hardy shirts, ed hardy shoes, ed hardy jeans, ed hardy case, ed hardy hoodies, ed hardy iphone and so on. ed hardy shop look forward to your arrival.
Socket, also known as power sockets, 水晶工艺品 水晶礼品 电镀电源 电解电源 高频整流器 保险柜 switches and sockets, refers to one or more circuit wiring can be inserted into the seat, 文件柜 集成吊顶 购物袋 点断袋 塑料袋 连卷袋 it can be inserted through a variety of wiring, 超声波清洗设备 超声波清洗机 高频开关电源 仿古木雕 弹簧 碟形弹簧 easy to connect to other circuits. Power outlet to provide power for household appliances electrical equipment 导游扩音器 便携式扩音器 无线扩音器 腰挂式扩音器 迷你扩音器 interface is also used frequently in residential electrical design electrical accessories, 调直机 机械密封 机械密封件 木雕 东阳木雕 补校 it has 10 people living close relationship. 卫生巾厂家 People move into new home, 高复 龙泉刀剑 武士刀 日本刀 竹筷机械 竹签机械 it was generally too small to reflect the number of electrical outlets, use very inconvenient, N95口罩 活性炭口罩 纱布口罩 无纺布口罩 resulting in private households pull the power cord and installation of random access socket wiring boards, often caused by physical shock and electrical fire, 电镀电源 高频开关电源 电泳电源 特种电源 无油轴承 自润滑轴承 brought to the personal and property safety significant risks. 腹腔镜 浴室柜 磁钢 磁铁 倒立式拉丝机 直进式拉丝机 水箱式拉丝机 调直机厂 Therefore, the power outlet is also the evaluation of the design of an important basis for residential electrical design.
jordan 3 air force 1 shoes nike air max 90 shoes air jordans discount air jordans baby air jordans new jordan releases 2009 women air force jordans jordan xi jordan 8 kids jordan shoes
our clients’ requirement and establish mutually pleasant business relationships with you.If you are interested, please do not hesitate to contact us.
Hey, MR Robby Thank you very much! I learned from you too much, if we have opportunities, I hope you can be my teacher. Thank you!
Free Video Converter, Free HD Video Converter, Free MP4 Video Converter, Free AVI Video Converter, Free MPEG Video Converter, Free iPhone Video Converter, Free iPod Video Converter, Free Apple Video Converter, Free PSP Video Converter , Free BlackBerry Video Converter, Free Zune Video Converter, Free 3GP Video Converter, Free Flash Video Converter, Free FLV Video Converter, Free Nokia Video Converter, Free SWF Video Converter, Video Converter, HD Video Converter , MP4 Video Converter , AVI Video Converter , MPEG Video Converter, iPhone Video Converter , iPod Video Converter, Apple Video Converter, PSP Video Converter, BlackBerry Video Converter, Zune Video Converter, 3GP Video Converter, Nokia Video Converter , Flash Video Converter, SWF Video Converter, YouTube to Video Converter, Video to YouTube Converter, Free YouTube to MP3 Converter, Video to Audio Converter, Free Video to Audio Converter , Convert AVI to FLV, Convert AVI to SWF, Free FLV to MOV Converter, Free FLV to MP4 Converter, Free MP4 to FLV Converter, Convert AVI to HD Video, Convert FLV to MP4, Convert Video to iPod Video Format, Free 3GP to FLV Converter, Free FLV to 3GP Converter, HD Video Editing Software , Free AVI to MP4, Free FLV to 3GP, Free FLV to AVI, Free AVI to FLV, Free AVI to 3GP Converter, Converting FLV to MP4, Free MP4 to FLV, Free AVI to BlackBerry, Free AVI to Nokia, Free AVI to FLV, Free AVI to iPod , Free AVI to iPhone, Free Video to PSP, Free YouTube to MP3 Converter, 3GP to AVI Video Converter, Free WMV Video Converter, free 3gp video converter, Free MPEG Video Converter, Convert MP4 into MP3, FLV Video Converter, Convert Video to SWF, Convert Video to BlackBerry , Free Apple Video Converter, Free AVI Video Converter, Free FLV Video Converter, Free MP4 Video Converter, HD Video Convertor, Free 3GP Video Convertor, Powerful Free Video Converter, 3GP Video Format Converter, Free iPod Video Converter, Free iPhone Video Converter, Video Format Converters, Convert Video to Zune, Converting MPEG to MP4, Converting FLV to MP3, Extract Audio Software, How to Convert WMV to MPEG, Convert Video to FLV Format, Convert MOV to MPEG, Convert YouTube Video to 3GP, convert Video to MOV, Convert Video to Nokia, Free Zune Video Converter, Free Nokia Video Software, Free MP4 Video Converter Software, Free Nokia Video Converter, Free AVI Converting Software, BlackBerry Video Converting Software, Converting MP4 to MPEG, Free FLV Converting Software, Free iPhone Video Software, Free MP4 Converting Software, Free Video Converting Software, PSP Video Converting Software, iPhone Video Converting Software, Convert AVI Files to WMV, Free Zune Video Converting Software, PSP Video Converter, How to Convert Video to MP4, Extracting Audio, Free SWF Video Converter, Free HD Video Converter, Free Flash Video Software, Convert Flash to Video, Free Video Conversion Software
http://entmind.com/pub/benedetto/ http://www.patchblogs.de/blog/storgas_blog http://www.netblogg.se/genschutz/ http://www.kolspot.com/user/benedetto/blogs http://we.loveadoptplay.org/pg/blog/dewayne http://www.newzealandfriends.com/blogs/posts/ovgren http://storga321.piczo.com/?cr=3
Dear Startup Business and Established block Manufacturer, if you want to make more concrete block, pavers, slabs, retaining wall units there is only one thing standing in your way – finding the right Block machineand Brick machine, which will produce the quantity and quality of products you want. You can increase your production and your profits when you discover which Brick making machine , Brick making machine and Block making machine are the right one for your business. But how do you choose the right Concrete mixing plant for your business? The first step is to understand the market and business you are in and where it is headed in production and innovation. But then what? There are so many choices for finding the best Block machine, it can be overwhelming. Your options include either taking the risk and research some of the systems you can find or lower you risk and work with a company and trusted partner to lower your risk in getting the correct machinery system to get you up and running without frustration and losing valuable time. And that’s where we come in.
thankssssss
“We have two concrete deals right now. One of them is the one with the Venezuelan government, cannondale jersey , cannondale jerseys , cannondale cycling jersey , cannondale cycling jerseys ,
“We have not signed anything yet, but we hope to close the deal very soon. It could be any day now. For me it doesn’t matter which deal we end up taking. orbea jersey , orbea jerseys , orbea cycling jersey , orbea cycling jerseys , The Venezuelan one is a very interesting project with the government and the other one is with a good, serious company that we know very well. We will see.”
AAAThis Original Module is the line going into the clothing brand platform for electronic business enterprise, Wireless Interface CDMA Protocol Original Module no doubt a big blow. Line under the brand 30 years of development in the process of CDMA Protocol Original Module accumulation,
This is really useful and interesting information for me.
This is really useful and interesting information for me.
Joe Montana Jersey Ronnie Lott Jersey Jerry Rice Jersey Patrick Willis Jersey Frank Gore Jersey Deion Sanders Jersey Brian Westbrook Jersey Vernon Davis Jersey Steve Young Jersey Taylor Mays Jersey Michael Crabtree Jersey Justin Smith Jersey Isaac Sopoaga Jersey Colin Kaepernick Jersey Anthony Davis Jersey Alex Smith Jersey Y.A. Tittle Jersey Delanie Walker Jersey Roger Craig Jersey Mike Iupati Jersey Nate Clements Jersey Nate Davis Jersey Aldon Smith Jersey