michaelb
Last Activity: Nov 26 '07, 08:26 PM
Joined: Nov 5 '06
Location: Boston, USA
-
This looks safe, unless you have a shell alias that associates some dot-numeric string with a malicious command. -
Sorry, but your question does not make sense.
I have to assume what you really meant is a file with specified size. If this is the case, look at the mkfile command.Leave a comment:
-
Then, you should start here...Leave a comment:
-
Not sure if this is lightweight enough, but check out tomcatLeave a comment:
-
Start with create function man page, and also read this thread - it has other links you may need to look at.Leave a comment:
-
Hi, hlnet,
you need to look at the Postgresql manual. These links will show you how to write functions in SQL and plpgsql.
If you have problems and your code is not working as expected post it here and we'll help you.
Good luck!
SQL Functions
http://www.postgresql.org/docs/8.1/s...ment-tips.html
http://www.postgresql.org/docs/8.1/s...larations.html
...Leave a comment:
-
A similar question was discussed in this thread
Take a look, you may find the answer.Leave a comment:
-
If you want to have a copy of your database on the same server you can use the createdb command at the OS prompt:
createdb -T old-db new-db
See these docs for more information:
http://www.postgresql.org/docs/8.1/s...-createdb.html
http://www.postgresql.org/docs/8.1/s...-createdb.html
If you want to migrate this db from one server to another you can use the pg_dump utility....Leave a comment:
-
I do not work with .NET, but I'd think you need to save the result of the first query, practically assign it to some variable or, object.
I'm sure .NET has an appropriate object for this, some kind of ResultSet.
And frankly it just seems wrong to string together two queries... what are you trying to achieve by doing this?Leave a comment:
-
michaelb replied to query the results of a table function applied to all the rows of a different tablein PostgreSQLDeprecated functions still work, but personally I would write a new function or SQL query for this.
The obscure syntax of mixing function call with a regular "select from" is not something I would normally use in the application.Leave a comment:
-
The message says it all, you have some other objects that depend on this column.
Open the psql session and run
\d+ invention
The output of this command can give you an idea on what's involved....Leave a comment:
-
Do you have an index on this field?Leave a comment:
-
psql is an interactive terminal to the PostgreSQL database.
When you type psql at the prompt you get a window, where you "talk" to the database. In addition to standard SQL queries (SELECT FROM ... , UPDATE ... , CREATE TABLE ..., etc, etc) you have many special commands you can use. They called meta-commands and they all begin with back-slash.
For example
\d - display all tables and views in my database
\d...Leave a comment:
-
No problem, you're very welcome!Leave a comment:
-
postgres=# is not a part of command, it is the psql prompt...
I still have a feeling that you were trying to pass the "\d" metacommand in your SQL query....Leave a comment:
-
Hi, hinet.
Please read the Posting Guidelines at the top of the Forum and make sure to use the CODE tags when appropriate in your future postings.
As for your question you apparently created your table with case sensitive name, as well as the fields on it.
Usually this brings no benefits, but a lot of hustles; now any time you refer to your table you need to use quotes:
[CODE=sql]
SELECT public."Master" ."ID",...Leave a comment:
-
Sagar, the 7.2 version is obsolete, it is very old, it is not supported, it is buggy... - you should consider upgrading to a later version.
As for your question Postgresql supports table partitioning, but then again - I don't think this feature is available with 7.2.
Follow these links for more information:
http://www.postgresql.org/docs/curre...titioning.html
http://www.postgresql. org/docs/cur...Leave a comment:
-
Welcome to the Forum, Kevin.
I think that when you say "sql" you actually mean MySQL database server.
Here are the things to remember:
SQL, as language, is defined by standards.
The original SQL standard was completed as a USA ANSI (American National Standards Institute) standard in 1986, and adopted as an ISO (International Standards Organization) standard in 1987. Expansions and revisions were...Leave a comment:
-
And by the way, the code snippet for createdb command you posted is incorrect:
>> createdb -U dbname username
The correct format is
createdb -U username dbname
so make sure you call it correctly. Try "createdb --help" for more info.Leave a comment:
-
Unless you set up your database access with the "trust" option this prompt is probably asking for your password, not the password for the username you passing to the createdb command.
Look at pg_hba.conf file, or simply run something like psql -l - would you be prompted for password?
If this is the case you can either change your access mode to trust instead of password, or put something like this in your batch...Leave a comment:
No activity results to display
Leave a comment: