Hi,
I have a table with 10 rows, and about 50 columns. Not much need for
indexing. When I execute a select * command, it can take 18ms to run
the query, but 1300ms for the data retrieval time for example...
What controls this data retrieval timing? It seems like my query
executes fast, but the bo
Hi,
I remember at one time when I opened the functions node of the public
shema for a database, it was empty, save for the function I added to
the system.
At this time I am seeing a list of included functions from template1
or something in addition to ones I add.
Is there a way to hide the built
Hi,
When using pgAdmin 1.2.0 to setup a new type, the option for a numeric
type offers a choice of length and precision. Postgresql defines
numeric as having scale and precision. Assuming length is synonymous
with scale, the precision is a locked field.
If I want to specify a type numeric using p
Hi,
I have a couple of postgresql servers running and they work great. I
develop with pgAdmin using SSH and pageant, putty and tunneling. I
have one problem server
though and I am looking for help.
One server is firewalled, and I configured the firewall (Smoothwall)
to port forward port 5432. My
