What does it mean when you drop a database and then recreate with the
same name and all the objects are still there. I want to wipe out the db
and put back from pg_restore. After I re-create the db, all the old
tables are back before I run pg_restore.
--
Robert
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddres sHere" to ma*******@postg resql.org) 5 3769
Robert Fitzpatrick <ro****@webtent .com> writes: What does it mean when you drop a database and then recreate with the same name and all the objects are still there. I want to wipe out the db and put back from pg_restore. After I re-create the db, all the old tables are back before I run pg_restore.
Check the 'template1' database to see if the tables got put in there
by mistake at some point.
-Doug
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postg resql.org
On Thu, 2004-11-11 at 14:03, Doug McNaught wrote: Robert Fitzpatrick <ro****@webtent .com> writes:
What does it mean when you drop a database and then recreate with the same name and all the objects are still there. I want to wipe out the db and put back from pg_restore. After I re-create the db, all the old tables are back before I run pg_restore.
Check the 'template1' database to see if the tables got put in there by mistake at some point.
Yeah, I was just starting to realize that these objects that keep coming
back are in the template1 as well.....any reason why I shouldn't drop
the template1 and re-create like any other?
--
Robert
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddres sHere" to ma*******@postg resql.org)
On Thu, Nov 11, 2004 at 14:17:45 -0500,
Robert Fitzpatrick <ro****@webtent .com> wrote: On Thu, 2004-11-11 at 14:03, Doug McNaught wrote: Robert Fitzpatrick <ro****@webtent .com> writes:
What does it mean when you drop a database and then recreate with the same name and all the objects are still there. I want to wipe out the db and put back from pg_restore. After I re-create the db, all the old tables are back before I run pg_restore.
Check the 'template1' database to see if the tables got put in there by mistake at some point.
Yeah, I was just starting to realize that these objects that keep coming back are in the template1 as well.....any reason why I shouldn't drop the template1 and re-create like any other?
I think you need to use the -T option if you do this to have a copy made
of template0 instead of the default of template1.
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Robert Fitzpatrick <ro****@webtent .com> writes: Yeah, I was just starting to realize that these objects that keep coming back are in the template1 as well.....any reason why I shouldn't drop the template1 and re-create like any other?
You can do that but you'll have to do:
CREATE DATABASE template1 WITH template = 'template0'
--
greg
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
Greg Stark <gs*****@mit.ed u> writes: Robert Fitzpatrick <ro****@webtent .com> writes: Yeah, I was just starting to realize that these objects that keep coming back are in the template1 as well.....any reason why I shouldn't drop the template1 and re-create like any other?
You can do that but you'll have to do: CREATE DATABASE template1 WITH template = 'template0'
Also there are several safety interlocks you'll have to defeat, IIRC.
It's not rocket science but I'd recommend consulting the writeup on
techdocs.postgr esql.org about the exact process for recreating
template1.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postg resql.org This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Jim Bo |
last post by:
Hi,
I have a drop down menu that is being populated by a query to the access
database
---- Code ---
Skill needed
<SELECT size="1" NAME="SkillType" VALUE="SkillType">
<OPTION>
<%=SkillType%>
|
by: Angie H. |
last post by:
Anyone know how to create a drop down menu where the user can enter text
also?
If they do not want to choose an answer from the drop down menu, the
users can just enter their own answers in the drop down box. Anyone
know if this is possible?
Thankx!
Angie
|
by: Manzoorul Hassan |
last post by:
I just Installed MySQL v4.1.14 and had created a Database (from a
script). But I would like to redo the Database portion of it but am not
able to drop the Database. If I do a "show database;" I still see the
database. But when I look in the data directory, it is not there. Below
is my attempt the create / drop the DB:
mysql> create database testlink;
ERROR 1007 (HY000): Can't create database 'testlink'; database exists
mysql> drop...
|
by: Vigneshwar Pilli via DotNetMonster.com |
last post by:
string connectionString1 = "server=(local); user=sa;password=sa;
database=sonic";
System.Data.SqlClient.SqlConnection dbConnection1 = new
System.Data.SqlClient.SqlConnection(connectionString1);
System.Data.SqlClient.SqlCommand dbCommand1 = new
System.Data.SqlClient.SqlCommand();
|
by: Lee Harr |
last post by:
Is there any way to forcibly disconnect all users from a
database, or else force the drop of the database even
though others are still connected?
I have a report I run where I first drop the old report db
then create it anew, read in a recent dump file and then
run a bunch of queries to build up the reports.
Every once in a while my automated script fails because
some other system which should have disconnected
| |
by: ameshkin |
last post by:
Hi,
I've been working on a drag drop system and something happened when I
tried to switch the code from a working model to one with another
database. The drag drop still works, but the informatin in the
database is still not updating. I kind of got aggravated and could not
figure out the problem with my 4 months of PHP experience.
If anyone would like to look over the code, then go tot his URL and get
in touch with me if interested!
|
by: petermichaux |
last post by:
Hi,
I am trying to put together the last major pieces of my project's
puzzle. This is more website/client-side architecture than
JavaScript syntax but I hope this is a good place to ask. I'm a little
stumped with which direction to take and advice would be greatly
appreciated. I think this is a generally interesting problem but I
haven't seen a post this long here before :S
I have developed half of the admin interface for an e-commerce
|
by: callawayglfr |
last post by:
I am building a database in access where I have a drop down box that
relates to a text box, that part I have working but when someone
selects information from the first drop down I need it to limit the
second drop down to just the related information. Explaining this is
obviously challeging. So I'll try to draw a picture:
(drop down 1) Select number --- once selected description is populated
in text box
(drop down 2) based on first...
|
by: flymo |
last post by:
Hello All,
I have been asked to build a simple database that will operate and
track a liquid dispensing device. The machine is run in a multi-bus
drop (coin operated basis) but I need to make it run on a barcode
scanner basis. I have no idea if this is even possible (or if there
are examples that have already been done) I have never set up a
barcode scanner before and certainly never had to interface with a
machine like this.
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| | |