easy resetting - Search results in mailing lists
Mailing lists >> pgsql-novice >> Thread >> Search in thread (2)
2019-08-05 14:02:51 | Re: How do I upgrade psql from version 7 to be 10 in Windows 10 (Karen Goh)
easy for a non-programmer, and there will be no end to the questions you will have, and rightfully so. It is simple for an experienced programmer, but they will need a clear and concise
Mailing lists >> pgsql-novice >> Thread >> Search in thread (3)
2019-07-29 00:26:52 | Re: How do I upgrade psql from version 7 to be 10 in Windows 10 (Karen Goh)
setting the permission to All in Windows 10. Now, I tried to follow this article : https:///blog/2014/12/24/postgress-pg_upgrade-on-windows-the-documentation-misses-a-lot/ But, I am getting denial of access using my postgres user password. And it seems that
Mailing lists >> pgsql-novice >> Thread
2015-06-15 12:30:20 | Re: Update taking forever (Bianca Stephani)
setting one of them with a select count and the other with the result of a recursive sql (defined before the update, not at each row). -- Bianca Stephani. *"Killing time before time kill us""Panic
Mailing lists >> pgsql-novice >> Thread
2014-04-14 21:23:15 | Re: Images stored in bytea datatype (Alan Hodgson)
easy for reading, although pay attention to the PostgreSQL server setting for bytea_output - most
Mailing lists >> pgsql-novice >> Thread
2014-04-02 14:53:22 | Re: Logging behavior not changing on reload (Tom Lane)
settings WHERE name like 'log%'; to see where it says it got the active values of these variables from. It's especially easy
Mailing lists >> pgsql-novice >> Thread
2013-02-26 17:19:45 | Re: PostgreSQL Query Speed Issues (Joseph Pravato)
easiest solution is to turn auto-commit on and hope that you never seriously screw up data. But, we are not going to do that. Did I miss anything, maybe a setting
Mailing lists >> pgsql-novice >> Thread
2012-12-21 09:55:12 | RESOLVED: varchar comparison and trim() (ta@lavabit.com)
easy and transparent. Both char and varchar columns are actually meant to store human-readable text where no trailing space has any significance. Its highly unlikely this change would interfere with any other software
Mailing lists >> pgsql-novice >> Thread
2012-12-19 18:14:31 | varchar comparison and trim() (ta@lavabit.com)
easiest way to make PG perform string comparison consistently across all string types? By 'consistent' I refer to this trailing space handling: (possibly it's standard but I find it somewhat inconvenient) select 'aa'::char
Mailing lists >> pgsql-novice >> Thread
2011-11-04 17:35:25 | How do I perform a Union with the result of a function returning SETOF (rox)
setting: point.id = template.id; point.fk_id = template.fk_Id; point.loc = constructed geometry; point.status = template.status; RETURN next POINT; END LOOP; RETURN; END; I have a query that I want
Mailing lists >> pgsql-novice >> Thread
2011-09-09 12:23:59 | Re: replication set-up (ScientificWare-Luigi D'Angelo)
easier to use against setting up .conf files and triggers I'll try pgpool Thank
Mailing lists >> pgsql-novice >> Thread
2011-01-05 04:12:18 | Re: decimal seperator (Susanne Ebrecht)
easy to implement lc_numeric. One simple example what already could get a problem with comma using: INSERT into t VALUES (3,5); What shall be inserted? Two integers
Mailing lists >> pgsql-novice >> Thread
2010-06-08 12:35:45 | Re: The Two Towers (Jon Jensen)
settings as enable_nestloop on demand to see if you get a better result (e.g. SET enable_nestloop TO OFF). Of course, it's a double-edged sword and it's far easier
Mailing lists >> pgsql-novice >> Thread
2010-05-22 08:45:41 | Re: GPS positions (Nathaniel Trellice)
easier (planar Euclidean geometry applies--eg Pythagoras) But, for now, let's assume you are storing positions as Lat/Lon. Computing distance: As has been said, you can't really use Pythagoras to compute the distance
Mailing lists >> pgsql-novice >> Thread
2009-11-06 04:53:35 | Table design for basic user management (Thomas Løcke)
settings. *Log stuff like last login and visits. For some parts of the application, further information is necessary. This will be fetched from one or more 'user_data' tables only when necessary. I haven
Mailing lists >> pgsql-novice >> Thread
2009-07-31 02:17:16 | Re: Synchronizing the schema of two PostgreSQL databases (Jason Stelzel)
settings listed here in the documentation should let you find the correct level for your particular situation. http:///docs/8.3/interactive/runtime-config-logging.html From there, it should just be a matter of parsing the log and extracting the desired