8 More Discussions You Might Find Interesting
1. High Performance Computing
I am managing a linux cluster which has been build on Platform Cluster Manager PCM 1.2.1) from IBM Platform Computing. Unfortunately somebody deteled data files of postgresql from /var/lib directory. I somehow managed to start the postmaster service again, but all the administrative commands of... (2 Replies)
Discussion started by: ahsanpmd
2 Replies
2. Shell Programming and Scripting
I have 7 functions those need to be executed as command line inputs, I tried with below code it’s not executing function. If I run the ./script 2 then fun2 should execute , how to initiate that function I tried case and if else also, how to initiate function from command line
if
then... (8 Replies)
Discussion started by: saku
8 Replies
3. Solaris
Hi all,
I want to install two postgreql 8.3.5 instances on same servers. already one instalce is running on default port and i need it to be installed on another port.. How ever i achived installing the second instance.. but the problem is if i create a new user using createuser in the newly... (3 Replies)
Discussion started by: phani4u
3 Replies
4. UNIX and Linux Applications
I am trying to run vacuumdb script. but it exits with an error:
"ld.so.1: vacuumdb:fatal libpq.so.5 open failed no such file or directory"
same error is with some other pstgre commands.
please, help.
thanks.
edit: it seems I need to set LD_LIBRARY_PATH properly. but how to add to it?... (0 Replies)
Discussion started by: orange47
0 Replies
5. Solaris
I need to find out if a version of PostgreSQL installed in SPARC Solaris is > 7.2
please tell me how to do it.
thanks. (4 Replies)
Discussion started by: orange47
4 Replies
6. UNIX for Dummies Questions & Answers
I am first year year student .. and i need help
i tried to work with PostgreSQL but when i open the terminal, i face problem in how to reach to PostgreSQL . always i get message it says that " can not find server " .
so what shall i do please .....:( (9 Replies)
Discussion started by: barlom
9 Replies
7. Programming
Hi guys.
I was was designing a simple database in postgresql. I wrote a perl function in postgresql and execute it. suddenly i saw that it is running in an infinite loop. After i stopped executing of the query, i saw that CPU is in 90%+ load. I looked at process list and there it was. postgresql... (1 Reply)
Discussion started by: majid.merkava
1 Replies
8. Programming
Hi,
In the course of my script i have to compare SYSDATE with the 15th of the current month:
if it is greater than i should set a variable date to 15th of the next month
if less than i should set it to the 15th of the current month.
In other words the question is how to set a date variable... (2 Replies)
Discussion started by: fmina
2 Replies
SQL::Translator::Producer::SQLServer(3pm) User Contributed Perl Documentation SQL::Translator::Producer::SQLServer(3pm)
NAME
SQL::Translator::Producer::SQLServer - MS SQLServer producer for SQL::Translator
SYNOPSIS
use SQL::Translator;
my $t = SQL::Translator->new( parser => '...', producer => 'SQLServer' );
$t->translate;
DESCRIPTION
This is currently a thin wrapper around the nextgen SQL::Translator::Generator::DDL::SQLServer DDL maker.
Extra Attributes
field.list
List of values for an enum field.
TODO
* !! Write some tests !!
* Reserved words list needs updating to SQLServer.
* Triggers, Procedures and Views DO NOT WORK
# Text of view is already a 'create view' statement so no need to
# be fancy
foreach ( $schema->get_views ) {
my $name = $_->name();
$output .= "
";
$output .= "--
-- View: $name
--
" unless $no_comments;
my $text = $_->sql();
$text =~ s/
//g;
$output .= "$text
GO
";
}
# Text of procedure already has the 'create procedure' stuff
# so there is no need to do anything fancy. However, we should
# think about doing fancy stuff with granting permissions and
# so on.
foreach ( $schema->get_procedures ) {
my $name = $_->name();
$output .= "
";
$output .= "--
-- Procedure: $name
--
" unless $no_comments;
my $text = $_->sql();
$text =~ s/
//g;
$output .= "$text
GO
";
}
SEE ALSO
SQL::Translator
AUTHORS
See the included AUTHORS file: http://search.cpan.org/dist/SQL-Translator/AUTHORS <http://search.cpan.org/dist/SQL-Translator/AUTHORS>
COPYRIGHT
Copyright (c) 2012 the SQL::Translator "AUTHORS" as listed above.
LICENSE
This code is free software and may be distributed under the same terms as Perl itself.
perl v5.14.2 2012-05-10 SQL::Translator::Producer::SQLServer(3pm)