search for: setval

Displaying 11 results from an estimated 11 matches for "setval".

Did you mean: retval
2006 Jun 15
8
postgresql sequence and migrations
...ting. at migration #4, I have 28 records in my roles tables and I can manually reset the roles_id_seq but it stands to reason that since I am doing everything else in the migration, I might as well reset the sequence there too. so I tried this in my migration file... execute ''SELECT setval ( "roles_id_seq", 0 );'' and it crashed with... -- execute("SELECT setval ( \"roles_id_seq\", 0 );") rake aborted! PGError: ERROR: column "roles_id_seq" does not exist : SELECT setval ( "roles_id_seq", 0 ); How do I accomplish this insid...
2004 Dec 20
1
Fw: pbx.c:1279 pbx_extension_helper: No application 'SetVal' for extension (c819, 1, 1)
I have added a sip user in sip.conf. user name is 819,context is c819. and I have added the follows rows in extension.conf. like [c819] exten => 1,1,Answer exten => 1,2,SetVal(voicemail=${exten}) exten => 1,3,Dial(SIP/${voicemail}) It appear a error message(pbx.c:1279 pbx_extension_helper: No application 'SetVal' for extension (c819, 1, 2)) when i dial 1 from 819. The version of asterisk is 1.0.3 Please help me. Thank a lot. Bill Chen --------------...
2006 Apr 30
16
postgresql duplicate key violates unique constraint
I have a weird problem with creating a new record when using PostgreSQL. From inside script/console ... >> entity = Entity.new >> entity.first_name = "Foo" >> entity.last_name = "bar" >> entity.save Throws an exception due to the following SQL error: duplicate key violates unique constraint. The application was working fine before and suddenly
2013 Mar 12
8
Heroku db id Starting with 1000
Hello All, How do I change the heroku database( already existed ) table id to start from say 1000? I tried with a fresh database on local & it works with this:- *execute "ALTER users orders AUTO_INCREMENT = 1000"* Thanks, Avinash -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To unsubscribe from
2010 Feb 05
13
[PATCH 01/14] hivexsh: Document some peculiarities of the "cd" command.
--- hivex/hivexsh.pod | 9 ++++++++- 1 files changed, 8 insertions(+), 1 deletions(-) diff --git a/hivex/hivexsh.pod b/hivex/hivexsh.pod index 277e3ae..9336798 100644 --- a/hivex/hivexsh.pod +++ b/hivex/hivexsh.pod @@ -100,7 +100,14 @@ or even: Path elements (node names) are matched case insensitively, and characters like space, C<*>, and C<?> have I<no> special
2006 May 06
1
IPsec with racoon2
...2.20.36.55 172.20.36.52" ifconfig_gif0="inet 192.168.4.1 192.168.1.1 netmask 0xffffffff" static_routes="vpn" route_vpn="-net 192.168.1.0/24 192.168.1.1" Without IPsec running, I can ping the remote interfaces 192.168.[14].1 both ways My racoon2.conf looks like: setval { PSKDIR "/usr/local/etc/racoon2/psk"; CERTDIR "/usr/local/etc/racoon2/cert"; }; # interface info interface { ike { MY_IPV4%lnc0; }; spmd { unix "/var/run/racoon/spmif"; }; spmd_p...
2010 Aug 10
1
semget() failed
...= 0) { return(ENOSYS); } (*semaphore) = semget(IPC_PRIVATE, 1, IPC_CREAT | IPC_EXCL | SEM_R | SEM_A); if ((*semaphore) == -1) { // Always true with OS/2 (libc 0.6.3) return(EINVAL); } argument.val = valeur; ios = semctl((*semaphore), 0, SETVAL, argument); return(ios); } Any explanation ? Thanks in advance, JKB
2005 Aug 23
0
Fixtures: pluraly bitten
...ble_names) table_names.flatten.each do |table| table_class = Inflector.classify(table.to_s) if Object.const_defined?(table_class) pk = eval("#{table_class}::primary_key") if pk == ''id'' connection.execute( "SELECT setval(''#{table.to_s}_id_seq'', (SELECT MAX(id) FROM #{table.to_s}), true)", ''Setting Sequence'' ) end end end end The smelly line in there is Inflector.classify(table.to_s) which simply auto-singularizes and camel cas...
2005 Dec 22
2
nonstandard postgresql sequence names
...e test I get this: Loaded suite test/unit/sponsor_test Started EWARNING: there is no transaction in progress E Finished in 0.831961 seconds. 1) Error: test_truth(SponsorTest): ActiveRecord::StatementInvalid: PGError: ERROR: relation "sponsor_sponsor_key_seq" does not exist : SELECT setval(''sponsor_sponsor_key_seq'', (SELECT COALESCE(MAX(sponsor_key), 0)+1 FROM sponsor), false) [...] It looks like the code in fixture.rb hardcodes an assumption about sequence names. Any way that could be parameterized? -- Posted via http://www.ruby-forum.com/.
2011 Jun 28
13
[PATCH hivex 02/14] maint: remove unnecessary test-before-free
From: Jim Meyering <meyering at redhat.com> * lib/hivex.c (hivex_node_set_value): Remove unnecessary test-before-free. --- lib/hivex.c | 3 +-- 1 files changed, 1 insertions(+), 2 deletions(-) diff --git a/lib/hivex.c b/lib/hivex.c index d042f4f..a72fa77 100644 --- a/lib/hivex.c +++ b/lib/hivex.c @@ -2748,8 +2748,7 @@ hivex_node_set_value (hive_h *h, hive_node_h node, leave_partial:
2013 Jul 31
29
[PATCH 0/9] tools: remove or disable old/useless/unused/unmainted stuff
depends on "autoconf: regenerate configure scripts with 4.4 version" This series removes some of the really old deadwood from the tools build and makes some other things which are on their way out configurable at build time with a default depending on how far down the slope I judge them to be. * nuke in tree copy of libaio * nuke obsolete tools: xsview, miniterm, lomount & sv *